crash_reports
4 rows where "datetime" is on date 2020-01-19 and keywords contains "Crash"
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, hit_run, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-01-19
Time:
08:14
Address:
EAST HIGH & PETTEE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Mv#1 operator was travelling on High St E/B and got blinded by the sun glare. #1 reached for his sunglasses on the visor, as a result veered to the right and struck Mv#2 that was legally parked on the side of High St. #2 operator was sitting in the driver's seat at time of collision. #1 passenger side front end struck #2 drivers side rear end. No injuries however #2 stated his back may have felt stiff from impact but refused an evaluation and said he has a history of back pain. #1 was towed by AAA. #2 was able to be driven away.
Keywords:
Crash, Glare, Solar
Dcc:
Glare
Report
url:
Image
url:
Latitude:
42.312838
Longitude:
-71.2217029
Location:
Case
number:
Date:
2020-01-19
Time:
10:33
Address:
13 EMERSON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Owner of vehicle 1 states he parked the vehicle sometime last evening in the driveway at the rear of his residence (6 unit resident/shared driveway) and when he came out this morning he saw that someone struck the front end of his vehicle. The lot was plowed last evening and was possibly hit by a plow. There was a transfer of yellow paint on the front of the vehicle. We attempted to reach the landlord for info on who plows the lot with negative results. The vehicles plate was missing and not found as a result of the accident.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3593499
Longitude:
-71.1884342
Location:
Case
number:
Date:
2020-01-19
Time:
07:33
Address:
CRAFTS ST & WALTHAM ST
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 1-19-2020 AT APPROX. 0733HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT THE INTERSECTION OF WALTHAM ST AND CRAFT ST. I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES SHE WAS TRAVELING S-BOUND ON WALTHAM HEADING ONTO CRAFT. SHE STATES AT THE INTERSECTION SHE SLID ON THE ICY SURFACE AND WAS UNABLE TO REGAIN CONTROL OF HER VEHICLE. HER VEHICLE SLIPPED INTO A UTILITY POLE ON THE ISLAND AT THE INTERSECTION OF CRAFT AND WALTHAM. I CHECKED THE AREA WHERE SHE STATED SHE BEGAN HER SLIDE AND IT WAS SLIPPERY FROM THE COMBINATION O F FALLING SNOW AND FREEZING TEMPERATURE. VEHICLE #1 HAD EXTENSIVE FRONT END DAMAGE, A FLAT RIGHT FRONT TIRE, AND AIRBAG DEPLOYMENT. VEHICLE #1 WAS TOWED BY TODYS. OPERATOR OF VEHICLE #1 REPORTED NO INJURIES AND SIGNED A PATIENT REFUSAL. DRIVER ADVISED TO CONTACT HER INSURANCE COMPANY. CLEARED AREA WITHOUT FURTHER INCIDENT.
Keywords:
Airbag, Crash, Ice, Severe, Snow
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3602838
Longitude:
-71.2220498
Location:
Case
number:
Date:
2020-01-19
Time:
17:33
Address:
260 NEEDHAM ST
Speed
limit:
5
Violation
cited:
no
Narrative:
Ms. Cooney states that she pulled into a parking space at Marshall's Department Store and when attempting to hit the brake she accidently hit the accelerator causing her vehicle to jump the curb, crash into the fence, and become stuck on top of a bush. The damage to the fence is estimated at approximately $1,000. Ms. Cooney reported no injuries and Tody's responded to the scene and removed the car from the berm. The vehicle did not sustain any apparent damage at this time and was driven from the scene. I provided the manager of Marshall's, Adriana Guara, with a copy of the crash report number and contacted the building's landlord, Dana, and updated him on how to obtain a copy of the crash report.
Keywords:
Bus, Crash
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3088013
Longitude:
-71.2144481
Location:
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "crash_reports" ( [case_number] TEXT PRIMARY KEY, [datetime] TEXT, [date] TEXT, [time] TEXT, [address] INTEGER, [street1] TEXT, [street2] TEXT, [intersection] INTEGER, [speed_limit] INTEGER, [hit_run] INTEGER, [violation_cited] INTEGER, [narrative] TEXT, [keywords] TEXT, [dcc] TEXT, [dcc_code] TEXT, [report_url] TEXT, [image_url] TEXT , [geocoded_address] TEXT, [latitude] TEXT, [longitude] TEXT, [manual_geocode] INTEGER, [retrieved] TEXT);