crash_reports
2 rows where dcc = "["Improper turn"]", intersection = 0 and keywords contains "Speed"
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-13
Time:
19:33
Address:
2322 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Sunday June 13, 2021 at approximately 1933 hours I was dispatched to 2322 Washington for a two car MVA with no injuries. MV1 operator stated she was operating eastbound on Washington St (a public way) driving the speed limit. MV1 operator stated she observed MV2 on the westbound side of Washington St attempt to turn left into Starbucks (2322 Washington St). MV1 operator stated by the time she saw MV2 cut across in front of her and into her lane, it was too late and MV1 struck the passenger side of MV2. MV2 operator stated the same story. MV2 operator said she was also going the speed limit on Washington St westbound and attempted to turn left into Starbucks but misjudged MV1's speed, causing the MVA. MV1 sustained extensive total front end damage and was towed by Tody's. MV1 operator requested an evaluation by Newton Medics and was transported to Newton-Wellesley Hospital. MV2 sustained extensive and total passenger side damage and was towed by Tody's. MV2 operator reported no injuries.
Keywords:
Hospital, Severe, Solar, Speed
Dcc:
Improper turn
Report
url:
Image
url:
Latitude:
42.3254451
Longitude:
-71.2564178
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);