crash_reports
3 rows where "datetime" is on date 2022-06-08, intersection = 0 and "retrieved" is on date 2022-06-14
This data as json, CSV (advanced)
Suggested facets: hit_run, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-06-08
Time:
07:30
Address:
275 CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Oper # 1 stated she was trying to turn into parking lot at 275 Centre Street when she was struck by Veh # 2. Oper # 2 stated he was traveling straight ahead on Centre Street when Veh # 1 turned in front of him. He stated he couldn't stop in time and struck Veh #1. No injuries Oper # 1 was arranging a private tow.
Keywords:
[]
Dcc:
Improper turn, Unknown
Report
url:
Image
url:
Latitude:
42.358572
Longitude:
-71.185233
Location:
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);