crash_reports
1 row where "date" is on date 2019-02-12 and street1 = "WEST BOYLSTON ST"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-02-12
Time:
14:50
Address:
BOYLSTON ST & CHESTNUT ST
Speed
limit:
15
Violation
cited:
yes
Narrative:
MV1 was coming down the Rte 9 West off ramp to Chestnut St. Operator was traveling too fast for the snowy road conditions and failed to stop for the stop sign at the bottom of the ramp. A snow storm had started 2 hours prior to the accident and road conditions were slippery. MV1 struck MV2 broadside who was traveling north on Chestnut St with the right of way. MV1 struck MV2 hard enough that MV2 was pushed across the lane and into MV3 that was stopped at the stop sign southbound. According to the operator of MV2, MV1 was traveling "way too fast for conditions" over 30mph. Operator MV1 was cited for 89/9 failed to stop for stop sign and 90/17 speeding too fast for road conditions. Operator was also cited on Citation T1272992 for 90/23 operating after suspended license. Boylston St and Chestnut St are public ways in the city of Newton.
Keywords:
Citation, Crash, Snow, Speed
Dcc:
Signs/Signals, Too fast for conditions
Report
url:
Image
url:
Latitude:
42.3169482
Longitude:
-71.2257627
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);