crash_reports
2 rows where dcc = "["Improper turn"]", intersection = 0 and "retrieved" is on date 2022-04-04
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-01-29
Time:
19:12
Address:
85 CHARLESBANK RD
Speed
limit:
25
Violation
cited:
no
Narrative:
MV Operator states he was traveling straight ahead when his Ford Transit slid out of control because of the severe snow storm. MV Operator slid into a small concrete median/island in the middle of the intersection. The Motor Vehicle's steering wheel air bag deployed when hitting the island. The MV Operator and the passenger did not suffer any injuries and denied medical attention. The Motor Vehicle sustained damage to the front center and was Towed by Tody's Service Inc as it was inoperable.
Keywords:
Severe, Snow
Dcc:
Improper turn
Report
url:
Image
url:
Latitude:
42.3588924
Longitude:
-71.180003
Location:
Case
number:
Date:
2022-03-17
Time:
21:23
Address:
305 WATERTOWN STREET
Speed
limit:
25
Violation
cited:
yes
Narrative:
Operator of MV1 states she was traveling straight ahead, eastbound on Watertown Street when MV2 attempted to make an illegal U-turn. Operator of MV1 states she then struck the front left of MV2. Operator of MV2 states he made an illegal U-turn on Watertown Street when MV1 struck the front left of his vehicle. MV1 sustained damage to the front right of the vehicle and MV2 sustained damage to the front left of the vehicle. MV1 and MV2 were both towed by Tody's Service Inc. Operator of MV1 had no injuries. Operator of MV2 was checked by medics on scene but denied medical attention. Operator of MV2 was mailed a citation for his illegal U-turn.
Keywords:
Citation
Dcc:
Improper turn
Report
url:
Image
url:
Latitude:
42.3612403
Longitude:
-71.198944
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);