crash_reports
3 rows where "datetime" is on date 2022-04-28
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-04-28
Time:
13:27
Address:
COMMONWEALTH AVE & WALNUT ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Oper # 1 stated she was rear ended while on Walnut St approaching Commonwealth ave. Oper #2 stated they had the green light and veh # 1 stopped for no reason. She couldn't stop in time and hit vehicle #1. No damage. some paint transfer. No tows, No citations. Oper and passenger of vehicle 1 transported to NWH by medics.
Keywords:
Citation
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3385598
Longitude:
-71.2069064
Location:
Case
number:
Date:
2022-04-28
Time:
15:42
Address:
821 BEACON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 and MV2 were stopped in traffic in front of 821 Beacon St when MV1 rear ended MV2. Operator of MV2 stated he was waiting in traffic when he was struck from behind by MV1. The operator of MV1 stated he thought the vehicle in front of him was moving forward and proceeded to accelerate and struck the vehicle in front of him. I asked him if he saw the brake lights of the vehicle in front of him which replied that he did not see the brake lights. Both vehicles were operable and were able to leave the scene. The back seat passenger of MV2 sustained minor injuries, which she stated she had not been wearing her seat belt and stated she was having neck and head pain from striking her head off the front seat. Fallon Ambulance Service responded and transported the injured passenger to Newton Wellesley Hospital to be evaluated.
Keywords:
Ems, Hospital
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3302058
Longitude:
-71.1950679
Location:
Case
number:
Date:
2022-04-28
Time:
18:57
Address:
WASHINGTON ST & CHERRY STREET
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of Vehicle #1 was stopped in heavy traffic on Cherry Street near the intersection with Washington Street. NPD Cruiser 502 was responding to an emergency with lights and sirens activated. Vehicle #1 was moving towards the shoulder of the road to yield to the emergency vehicle. Cruiser 502 struck the driver side rear panel and bumper. Operator #1 was not injured. Operator of Vehicle #2 was responding to an emergency with lights and sirens activated. While attempting to navigate through congested traffic, Vehicle #2 struck Vehicle #1. Vehicle #2 sustained damage to the passenger side doors. Operator of Vehicle #2 was not injured. Both vehicles were driven from the scene. Photographs taken and submitted to IT Bureau for filing.
Keywords:
Pictures
Dcc:
Over-steering, Inattention
Report
url:
Image
url:
Latitude:
42.3490417
Longitude:
-71.2281633
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);