crash_reports
2 rows where "datetime" is on date 2022-06-08, intersection = 0 and keywords contains "Airbag"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-06-08
Time:
19:37
Address:
457 WALNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 was traveling NORTHBOUND on Walnut St just passing Newton North High School when they stopped for pedestrians in the crosswalk at the intersection of Walnut St at Clyde St. MV2 traveling behind MV1 heading NORTHBOUND as well when they rear-ended MV1 not realizing that MV1 had stopped for pedestrians. MV1 sustained damage to its rear bumper and MV2 sustained heavy damage to its passenger front bumper and hood. No airbags deployed and no injuries reported. Tody's towed both vehicles.
Keywords:
Airbag, Crosswalk, Ped, School
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3451469
Longitude:
-71.2075289
Location:
Case
number:
Date:
2022-06-08
Time:
20:05
Address:
1321 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 and MV2 were traveling WESTBOUND on Washington St when the traffic light turned red and they stopped. MV3 was traveling WESTBOUND behind those vehicles when he looked down at his radio at the same time that they had stopped at the traffic light. Subsequently, MV3 did not stop in time to avoid the collision. MV3 rear-ended MV2 which pushed MV2 forward to hit MV1. MV1 drove away prior to my arrival and did not want to take part in the report as he did not have any damage to his vehicle. MV2 operator still obtained MV1's information because MV2 sustained damage in the front end due to the collision. MV2 sustained damage to its rear-end bumper as well as its front. MV3 sustained damage to its front bumper and hood. No airbags deployed and no injuries reported. No tows were necessary as all vehicles were operable from the scene.
Keywords:
Airbag
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3494467
Longitude:
-71.2276058
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);