crash_reports
1 row where "date" is on date 2021-07-22, dcc_code = "[10]" and keywords contains "Crash"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-07-22
Time:
13:58
Address:
CENTRE ST & NEWTONVILLE AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
On Thursday 7/22/2021 at approx 1358hrs, while assigned to N494, I responded to the intersection of Newtonville Ave and Centre St in Newton for a 2 car MVA. Operator of MV1 states that he was traveling NB on Centre St and activated his right turn blinker to pull into the driveway of 570 Centre St where he was doing chimney work. He said as he began to turn, MV2 attempted to pass him on his right. They collided and MV1 sustained damage to the passenger side of his van near the front wheel. Operator of MV2 states he was traveling NB on Centre St when he observed MV1 in front of him stop near the middle of the intersection at Newtonville Ave and Centre St. He said he thought MV1 was taking a left turn so he attempted to pass him on the right. It should be noted that Centre St at this location has is only one lane both ways..There were no injuries due to this accident and neither was towed.
Keywords:
Crash
Dcc:
Reckless driving
Report
url:
Image
url:
Latitude:
42.3515559
Longitude:
-71.1861175
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);