crash_reports
2 rows where keywords contains "Crash" and "retrieved" is on date 2021-07-08
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-07-04
Time:
19:46
Address:
COMMONWEALTH AVE & GRANT AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 operator stated he was operating southbound on Grant Ave prior to Commonwealth Ave (both public ways ) and was attempting to travel straight through the intersection. MV1 operator stated MV3 (unknown white colored mini-van, driven by an unknown elderly white female) was operating northbound before Grant Ave, attempted to take a left onto Commonwealth Ave westbound. MV1 operator stated MV3 made the turn suddenly and did not yield the right of way to him, forcing him to swerve to avoid an accident with MV3. MV1 operator said because he had to swerve suddenly, the front end of his MV struck MV2 driver side which was stopped on Commonwealth Ave eastbound at Grant Ave. MV1 operator said MV3 was not struck and continued westbound on Commonwealth Ave. MV1 sustained heavy front end damage, and was towed by Tody's. MV1 operator reported no injuries at this time. MV2 operator stated she was stopped on Commonwealth Ave eastbound at Grant Ave. MV2 operator's story collaborated with MV1's story. MV2 operator said she witnessed MV3 suddenly cut off MV1 by taking a sharp left at the intersection, failing to yield the right of way to MV1. MV2 operator stated because MV1 had attempted to avoid a MVA with MV3, MV2's driver side was struck by MV1. MV2 sustained heavy driver side damage, and was towed by Todys. MV2 passenger was an infant that was checked by medics and appeared to be uninjured at this time, MV2 operator stated she struck her head on the driver side window and was transported to Newton-Wellesley Hospital for an evaluation. MV3 was unlocated at this time. Photos of the accident were taken and forwarded to the I.T. Bureau.
Keywords:
Crash, Hospital, Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.336511
Longitude:
-71.1856504
Location:
Case
number:
Date:
2021-07-07
Time:
07:12
Address:
2101 WASHINGTON ST
Speed
limit:
15
Violation
cited:
no
Narrative:
There was a medical emergency at 2101 Washington Street (Care One) so Fire, Medics, and Police were all parked by the front entrance. The OP. of MV#1 states that she was trying to park correctly in her spot. She backed out and her attention was drawn to an ambulance and didn't realize there was a second ambulance behind her. That's when she collided with MV#2. MV#2 is an unoccupied ambulance with its emergency lights on while medics were out assisting a patient. Medic J. Spratt was nearby and observed his truck shake and walked around and noticed MV#1 pulling away from the ambulance with damage to the corner of the vehicle. Pictures have been taken of both MV#1 and MV#2. Ambulance MV#2 has some old damage not related to this current accident. There doesn't appear to be any new damage to MV#2 from this current accident.
Keywords:
Crash, Ems, Fire, Pictures, Walk
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3303129
Longitude:
-71.2500201
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);