crash_reports
1 row where "date" is on date 2021-02-23 and dcc = "["Wrong way"]"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-02-23
Time:
19:01
Address:
LOWELL AVE & OTIS ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 2/23/21 at 1900 hrs, Newton Police were dispatched to the intersection of; Lowell Ave. at Otis St. for a motor vehicle collision involving two vehicles. The operator of MV#1 stated they were attempting to turn eastbound onto Otis St. from Lowell Ave. when MV#2 began to pass MV#1 on the left. As MV#2 was passing MV#1, MV#2's passenger side collided with MV#1's front snow plow. Extensive damage was observed to MV#2's passenger side rear and front door, while also puncturing MV#2's passenger side rear tire. No damage was observed to MV#1. The operator of MV#2 stated he attempted to pass MV#1 on the left, as he believed MV#1 was going to turn right onto Otis St. No injuries were reported and MV#2 was towed from the scene by Tody's Towing Service, while MV#1 was driven from the scene.
Keywords:
Severe, Snow
Dcc:
Wrong way
Report
url:
Image
url:
Latitude:
42.3473475
Longitude:
-71.2108849
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);