crash_reports
3 rows where "datetime" is on date 2020-12-09, intersection = 0 and "retrieved" is on date 2020-12-27
This data as json, CSV (advanced)
Suggested facets: speed_limit, dcc, dcc_code, retrieved, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-12-09
Time:
13:44
Address:
295 CALIFORNIA ST
Speed
limit:
35
Violation
cited:
no
Narrative:
Operator of Motor Vehicle #1 stated she was traveling Westbound on California Street and had her right turn signal on to take a right turn into the parking lot of the American Legion Nonantum Post 440. Operator of Motor Vehicle # 1 stated while she was taking the right turn she was struck in the front right side of her vehicle from vehicle #2 who was traveling behind her causing moderate damage. Operator of Motor Vehicle #2 stated she was traveling Westbound on California Street and vehicle #1 had her left blinker on so she thought she was taking a left turn and drove around on the right side to continue Westbound on California Street. Operator of Motor Vehicle#2 stated motor vehicle #1 quickly made a right turn into the parking lot and she did not have time to brake and struck motor vehicle #1. Motor vehicle #2 sustained moderate front end damage.
Keywords:
Moderate
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3657489
Longitude:
-71.1995279
Location:
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);