crash_reports
2 rows where "datetime" is on date 2021-09-01 and "retrieved" is on date 2021-09-06
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-09-01
Time:
10:25
Address:
394 WATERTOWN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The owner of MV#1 stated her vehicle was parked in front of 394 Watertown St. when it was struck by MV#2. Her vehicle was parked and unoccupied. MV#2 sideswiped MV#1 and did not know they did and left prior to my arrival. They were notified and came back to the scene. There was damage to the D/S of MV#1 and no damage to MV#2. It was believed that it was the trailer of MV#2 caused the damage to MV#1. There were no injuries. MV#1 was towed by Tody's Towing.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3601845
Longitude:
-71.2019022
Location:
Case
number:
Date:
2021-09-01
Time:
12:12
Address:
110 PROSPECT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 9/1/21 Feeney Bros was working at a job site on the corner of Tennyson Rd and Prospect St with a paid detail officer. Cones and appropriate signage were in the area. The operator of MV#1 stated he parked his car,a 2019 Subaru Outback in front of 110 Prospect St and went to visit a nearby home. The operator of MV#2 stated he backed a Feeney Bros 2017 Ram 5599 truck out of Tennyson Rd and backed onto Prospect St where he hit MV#1. MV#1 sustained moderate damage to the rear drivers side of the vehicle. MV#2 sustained minor damage. All vehicles were able to be driven from the scene. No injuries reported.
Keywords:
Moderate
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3443336
Longitude:
-71.2315272
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);