crash_reports
1 row where keywords = "["Pictures"]" and "retrieved" is on date 2021-09-30
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-09-26
Time:
15:07
Address:
ALBEMARLE RD & WATERTOWN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Opr of MV1 stated he was attempting to make a left hand turn on Albemarle Road. At this time, he did not see MV2 coming and made contact with it. MV1 sustained damage to the front end and was towed by Todys's. Opr of MV1 signed a refusal with the medics. Passenger of MV1 (Raymond) stated they were driving and thought they could make the turn. At this time, they struck MV2. Pass was not injured. Raymond assisted me with talking to Opr of MV2. Opr stated he was traveling on Watertown Street towards West Newton. While traveling straight MV1 drove in front of him and made contact with his vehicle. MV2 then turned and drove into the fence on the bridge of the brook. MV2 was towed by Todys's and Opr was not injured. Photos were taking at the scene and placed in the IT box to be attached due to the damage of City property.
Keywords:
Pictures
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.354018
Longitude:
-71.213976
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);