crash_reports
2 rows where intersection = 0, keywords contains "Pictures" and "retrieved" is on date 2022-04-21
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-04-07
Time:
12:39
Address:
111 NEEDHAM ST
Speed
limit:
10
Violation
cited:
no
Narrative:
At approximately 1239HRs on Thursday, 04/07/2022, I was dispatched to 111 Needham St. (McDonald's) for a report of a hit & run crash. Upon arrival, I spoke with the operator of MV1 (MA Pass: 49315), who stated that he was in the restaurant when an unidentified concerned citizen came in and showed them a picture of MV2, after it had struck MV1 and informed them that the operator of said vehicle left the scene without leaving their information. I observed that MV1 sustained damage to its driver's side rear quarter panel, just to the rear of the wheel well. The owner of MV2 (MA Passenger: 313FY9) could not be reached to ascertain their version of events. Newton Dispatched was able to find a phone number for the registered owner, left a message and at the time of writing this report, The Newton Police have not been contacted by them. Additionally, I went to the registered owner's address and no one would answer the door, nor the Ring Video Doorbell, which remotely connects those activating it, to the owner's phone.
Keywords:
Crash, Phone, Pictures
Dcc:
Reckless driving
Report
url:
Image
url:
Latitude:
42.3137683
Longitude:
-71.212198
Location:
Case
number:
Date:
2022-04-12
Time:
09:15
Address:
197 CALIFORNIA ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Tuesday April 12th 2022 at approximately 0915 hours I responded to the area of 197 California Street for a city of Newton fire truck that struck a fire hydrant while responding to an emergency. At the time of the accident the weather was cloudy and the road surface was dry. California Street is owned and maintained by the city of Newton. Upon arrival I spoke with the operator of Newton Fire Engine 1 identified as Joseph Frank. Joseph stated that while attempting to park the fire engine he struck the fire hydrant, causing the fire hydrant to be knocked over and inoperable. Minor damage to the front drivers side of the fire engine was photographed and submitted to the IT Bureau as well as the damaged fire hydrant. No injuries were reported. City of Newton was notified of the damaged hydrant.
Keywords:
Crash, Fire, Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3651092
Longitude:
-71.1963023
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);