crash_reports
2 rows where address = "111 NEEDHAM ST" and speed_limit = 10
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-03-08
Time:
11:54
Address:
111 NEEDHAM ST
Speed
limit:
10
Violation
cited:
no
Narrative:
MV1 stopped short to allow an unidentified MV back of of a parking space. He stopped behind MV2. MV2 did not see MV1 stop and backed into MV1.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3137685
Longitude:
-71.2121457
Location:
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:
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);