crash_reports
2 rows where keywords contains "Fire" and "retrieved" is on date 2021-07-24
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-07-17
Time:
11:42
Address:
31 KEEFE AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
On Saturday 7/7/2021 at approx 1142hrs, while assigned to N495, I responded to 39 Keefe Ave in Newton for a single car MVA. There I met the operator of MV1 show stated that he accidently struck a city fire hydrant with his company truck (Verizon). The hydrant itself did not appear damaged. However, it was dislodged from the side walk and no longer secured by its bolts. The Newton water dept was notified and responded.
Keywords:
Crash, Fire, Walk
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3107965
Longitude:
-71.2257474
Location:
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);