crash_reports
1 row where dcc contains "Followed too closely", latitude = "42.3549582" and "retrieved" is on date 2022-04-04
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-03-28
Time:
09:13
Address:
WASHINGTON ST & JACKSON RD
Speed
limit:
30
Violation
cited:
no
Narrative:
On March 28th, 2022 at approximately 09:13 hours while assigned to N491 I responded to the intersection of Washington St @ Jackson Rd for a reported MV crash. On my arrival I located both involved vehicle E/B on Washington St @ Jackson Rd. Vehicle #1 was a 2019 Black Tesla X SUV, Ma reg. EV502N, operated by Jeffrey Cook. He stated he had just stopped on Washington St E/B due to the vehicle in front of him stopping by Jackson Rd. His vehicle was then rear ended by vehicle #2. Vehicle #2 was a 2020 Black Chev. Silverado PU, Ma reg. 2NBN74, operated by David Haber. HE stated he was behind vehicle #1 on Washington St E/B when vehicle #1 suddenly stopped in front of him causing him to crash into the rear of the vehicle. Vehicle #1 sustained heavy rear end damage. Vehicle #2 sustained heavy front end damage. Neither vehicle required a tow and no reported injuries at this time.
Keywords:
Crash
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3549582
Longitude:
-71.1952442
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);