crash_reports
1 row where dcc_code = "[3]" and "retrieved" is on date 2021-08-19
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-08-05
Time:
09:14
Address:
JACKSON RD & PEARL ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Upon arrival, both operators were off to the side of Jackson Rd exchanging information. The operator of vehicle 1 did not make a statement of what occurred. The operator of vehicle 2 stated he had a green light and was traveling northbound on Pearl St when he crashed into vehicle 1 that was traveling westbound on Jackson Rd. I observed significant damage to Vehicle 1 on the left front tire, making it inoperable. I also observed front end damage to vehicle 2 but the vehicle was driveable. Both operators stated they had no injuries and declined medical attention. Operator 1 had his vehicle legally parked on Jackson Rd and stated he was going to call a private tow company. All streets involved are private ways in the city of Newton. A witness on scene,Nicole St. Amand, stated she was stopped at a red light on Pearl St. She stated she saw vehicle 1 traveling westbound on Pearl St and go through the red light at the intersection of Pearl St and Jackson Rd when Vehicle 1 collided with Vehicle 2.
Keywords:
Crash
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.359451
Longitude:
-71.194781
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);