crash_reports
2 rows where intersection = 0, keywords contains "Speed" and speed_limit = 15
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
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);