crash_reports
1 row where "datetime" is on date 2021-07-18, 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:
2021-07-18
Time:
13:47
Address:
FRANKLIN ST & WAVERLEY AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
On July 18th, 2021 at approximately 13:47 hours while working N491 I responded along with NFD and Fallon ambulance for a report of a MV crash at the intersection of Waverly Ave at Franklin St. On my arrival to the scene I located both involved vehicles that had both sustained heavy damage. The first vehicle was a white Tesla V SUV, Ma reg. 2NJJ97 operated by Raul Uppot. He reported first being stopped E/B on Franklin St at the intersection of Waverly Ave. He then proceeded to cross Waverly Ave to get to the other side of Franklin St when he was struck in the intersection by vehicle #2. Operator further stated he never saw vehicle #2 coming S/B on Waverly Ave. The second involved vehicle was a 2017 black subaru impreza, ma reg.7dt861, operated by a Isabel Hanna Wilker. She reported going S/B on Waverly Ave when vehicle #1 came out from Franklin St causing her to crash into that vehicle. Both vehicles were towed by Todys. All parties involved in this crash were evaluated by Fallon paramedics but all declined to be transported.
Keywords:
Crash, Ems, Fire
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3492419
Longitude:
-71.1804564
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);