crash_reports
2 rows where "datetime" is on date 2020-01-19, intersection = 1 and keywords contains "Crash"
This data as json, CSV (advanced)
Suggested facets: 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:
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:
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);