crash_reports
1 row where "date" is on date 2019-09-04, dcc contains "Lane departure" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-09-04
Time:
21:14
Address:
129 VALENTINE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 stated she was traveling southbound on Valentine Street when MV2 crossed over the double yellow lines and collided with her head on. Operator of MV1 stated she observed two parked cars in front of 129 Valentine Street and was unable to swerve out of the way to avoid the collision. Operator of MV2 stated she was traveling northbound on Valentine Street and could not see the double yellow lines and believes she may have crossed over them, when she saw MV1 and hit her head on. Operator of MV1 was evaluated by Cataldo Medics and signed a patient refusal. Both vehicles sustained heavy front end damage and were towed by David Donahue of Tody's Towing. Newton Fire was on scene and handled the spill from both vehicles.
Keywords:
Fire
Dcc:
Lane departure
Report
url:
Image
url:
Latitude:
42.3402727
Longitude:
-71.2180688
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);