crash_reports
1 row where "datetime" is on date 2022-03-25, dcc contains "Failed to yield" and keywords contains "Fire"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-03-25
Time:
09:06
Address:
WASHINGTON ST & CHURCH ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On March 25th, 2022 at approximately 09:06 hours while assigned to N491 I along with NFD and Fallon ambulance responded to the intersection of Washington St @ Hovey St for a report of a MV crash with injuries. On my arrival I located both involved vehicles just west of Hovey St on Washington St at Church St. Vehicle #1 was Ma reg. 2AEK73, a black 2016 Honda Odyssey, operated by a Peter Yoo. He stated he was on Hovey St and was attempting to turn right onto Washington St(W/B) when he crashed into vehicle #2 in the intersection. He further stated he didn't see vehicle #2 coming prior to pulling out. Vehicle #2 was Ma. reg. 2AGX19, a gray 2010 Ford Edge, operated by a Yenissa Ortiz. She reported going W/B on Washington St when vehicle #1 came out from Hovey St in and crashed into her vehicle. Both vehicles were towed due to this accident.
Keywords:
Crash, Ems, Fire
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3558456
Longitude:
-71.1904222
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);