crash_reports
1 row where latitude = "42.3469722" and street1 = "30 SOUTH 2040 COMMONWEALTH AVE"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-06-28
Time:
21:16
Address:
2040 COMMONWEALTH AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
I responded to 2040 Commonwealth Ave for a report of two car MVA. I arrived on location and the two involved MV's pulled into the parking lot of the Star Market. V1; MA Reg 66LS55, 2016 Volvo/Stwag color gray, operated by Hamar, Benjamin MA OLNS70134803. V1 traveling southbound on Commonwealth Ave collided with V2. V2; MA Reg 294F30, 2020 Jeep/util color white, operated by Xerras, Madeline MA OLN SA0790468. V2 was attempting to exit the parking lot of the Star Market, turning left from the exit. V2 was inattentive and failed to yield to oncoming traffic. V2 sustained front end damage. V1 sustained front/right end damge to the passenger side of the vehicle. Neither vehicle had airbag deployment. Neither of the operators sustained injury as a result of the collision. V2 operator was issued MA Uniform citation T2081075; 89/9 Fail to Yield.
Keywords:
Airbag, Citation
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3469722
Longitude:
-71.2448227
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);