crash_reports
1 row where dcc_code = "[19, 21]" and "retrieved" is on date 2022-06-14
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-06-06
Time:
18:38
Address:
2282 COMMONWEALTH AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 states she was traveling west on Commonwealth Ave. after leaving the grocery store. She states she was feeling tired and must not have been paying attention. When she looked up she saw the grassy median and a telephone pole. She heard a pop and then swerved and MV1 rolled landing on its passenger side. Operator of MV1 was evaluated by medics and signed a patient refusal. It appears as if MV1 struck the curb with the left front tire, popping the tire and splitting the rim, also causing suspension damage. The vehicle then subsequently rolled onto its right side. Also possible striking the telephone pole. Eversource was notified to inspect pole. Todys up righted and towed MV1. NFD Engine 2 took care of the spill.
Keywords:
Fire
Dcc:
Inattention, Fatigue/Sleep
Report
url:
Image
url:
Latitude:
42.3465172
Longitude:
-71.2553181
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);