crash_reports
1 row where "date" is on date 2019-06-26, keywords contains "Fire" and speed_limit = 25
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-06-26
Time:
16:52
Address:
BLAKE ST & CABOT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 06/26/2019, while assigned to N494, I, Officer Conary, responded to Cabot Street at Blake Street for a motor vehicle accident involving a City of Newton vehicle, fire truck. Operator of MV1 stated that he was traveling Northbound on Blake Street taking a left turn onto Cabot Street. Cabot Street is under construction and there was barrels in the road which caused MV1 to go around them. MV1 was to close to MV2 while taking the turn and hit MV2. Operator of MV2 stated that she was stopped Eastbound on Cabot street, waiting to take a right turn onto Blake Street. When MV1 was turning, it was too close and struck her vehicle. All parties were offered and declined medical attention. MV2 had to be towed from scene. Pictures were taken and will be submitted to IT accordingly.
Keywords:
Crash, Fire, Pictures
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3482222
Longitude:
-71.198785
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);