crash_reports
3 rows where keywords contains "Speed" and speed_limit = 15
This data as json, CSV (advanced)
Suggested facets: intersection, violation_cited, 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:
Case
number:
Date:
2020-09-12
Time:
14:54
Address:
300 NEEDHAM ST
Speed
limit:
15
Violation
cited:
no
Narrative:
The operator of veh #1 stated she was in the parking lot of #300 Needham St. and driving South bound when veh #2 drove around the corner due North at an excessive rate of speed and drove into her. Heavy damage to veh #1. The operator of veh #2 stated she was driving in the parking lot of #300 Needham St. when she struck veh #1 because she didn't see it. Heavy damage to veh #2 with its front airbag deployed. Both operator's were checked out by the Medics and signed patient refusals. Both vehicles were towed by Tody's towing. The operator of veh #2 was issued Mass. Citation #T2080848 in hand for Ch 89/ Sec 1-Failure to keep right.
Keywords:
Airbag, Citation, Speed
Dcc:
Improper turn
Report
url:
Image
url:
Latitude:
42.3077228
Longitude:
-71.2144721
Location:
Case
number:
Date:
2021-06-16
Time:
15:29
Address:
165 NEEDHAM ST
Speed
limit:
15
Violation
cited:
no
Narrative:
On Wednesday 6/16/21 at approximately 1529 Hours while assigned to marked unit n499 I was dispatched to the Stop & Shop Parking lot (165 Needham Street) for a report of a minor MVA. Upon arrival I spoke with the operator, (MATARESE Alexandria) of MV# 1(RI Reg AM60) who states she was attempting to back out of a parking space and didn't see MV#2 coming and backed into the side of the vehicle. MATARESE states vehicle#2 was travelling through the parking lot at a high rate of speed. Lastly, I spoke with the operator, (YASUI Lisa) of MV#2 (FL reg GTLG98) who stated she was travelling straight through the parking lot when MV#1 backed into the side of her vehicle. No injuries reported.
Keywords:
Speed
Dcc:
Speeding, Failed to yield
Report
url:
Image
url:
Latitude:
42.3121478
Longitude:
-71.2138224
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);