crash_reports
2 rows where "datetime" is on date 2020-12-09, keywords contains "Crash" and "retrieved" is on date 2020-12-27
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-12-09
Time:
12:43
Address:
849 BEACON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 12/09/2020 I responded to the area of 849 Beacon St for a motor vehicle crash involving a City of Newton owned motor vehicle. Beacon St is a public way in the City of Newton. Vehicle 1 was located across from 849 Beacon St in a parking stall located in the eastbound lane of Beacon St. Vehicle 2 a City of Newton owned motor vehicle was parked in a parking stall directly in front of Vehicle 1. Vehicle 1 then struck Vehicle 2 while attempting to pull into the eastbound travel lane. As a result of the impact Vehicle 1 sustained minor damage to the passenger side front bumper, Vehicle 2 sustained minor damage to the drivers side rear quarter panel. No injuries were reported on scene. No vehicle tows were required. Pictures were taken of the scene and submitted to the NPD IT Bureau.
Keywords:
Crash, Pictures
Dcc:
Lane departure
Report
url:
Image
url:
Latitude:
42.3303144
Longitude:
-71.1958386
Location:
Case
number:
Date:
2020-12-09
Time:
18:30
Address:
248 GROVE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Motor vehicle 1 (MV1) was pulling out of the driveway of 248 Grove St. in an attempt to turn left and travel southbound on Grove St., when it failed to yield to motor vehicle 2 (MV2), which was already traveling southbound on Grove St. MV1 then crashed into MV2, causing MV2 to go up over the curb, and come to rest on the sidewalk. As a result of the crash, MV1 sustained moderate front end damage, while MV2 sustained moderate drivers side damage.
Keywords:
Crash, Moderate
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3389274
Longitude:
-71.2509714
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);