crash_reports
1 row where "date" is on date 2019-12-17, dcc contains "Visibility obstructed" 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-12-17
Time:
05:08
Address:
38 COMMONWEALTH AVE
Speed
limit:
35
Violation
cited:
no
Narrative:
At approximately 0500HRs on Tuesday, December 17, 2019, I was dispatched to a 2 vehicle MVA in front of 38 Commonwealth Ave. Upon arrival, I spoke with the operator of MV1 (MA CON: S25585) who stated that he attempted to back up his vehicle (Westbound) and accidently struck MV2 because he was not able to see it in his mirror. Upon speaking to the operator of MV2 (MA CON: S13628), he stated he was traveling Eastbound as MV1 was backing up. He then stopped MV2 and when MV1 did not, he activated his horn which had no effect and MV1 backed into him. I observed MV1 to have no discernable damage. I observed MV2 to have sustained damage to its front bumper, grille, hood, passenger's side fender and both head lamps. MV1 had a single passenger who reports he did not witness event in question, as he was focused on eating at the time. No one involved reports any injuries. I cleared without incident.
Keywords:
Crash
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3392841
Longitude:
-71.1680599
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);