crash_reports
2 rows where dcc contains "Unknown", intersection = 0 and "retrieved" is on date 2021-12-09
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-12-02
Time:
17:31
Address:
1201 CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Vehicle #1 was traveling northbound on Centre St. at approximately 25 MPH when they witnessed someone enter the roadway on foot from between two parked cars and attempted to cross the road. Vehicle #1 stated they attempted to stop but was unable to do so and struck the person with the front left corner and windshield of the vehicle. The pedestrian and owner of Vehicle #2 stated he parked his vehicle on the right side of the road and exited the car. He stated he was walking towards the crosswalk and attempted to cross the street from the front of his vehicle. All he remembers is taking a few steps out into the road, being hit, and flying before hitting the ground. He was unaware where he was struck from. Vehicle #1 had moderate damage to the front and windshield and was towed by Tody's towing. Vehicle #2 was uninvolved in the crash and was parked at the time. The owner of Vehicle #2 and pedestrian struck was injured and transported by Medics to Brigham and Womens Hospital for injuries to his head, left arm, and left leg. Operator of Vehicle #1 stated he was uninjured and refused any medical treatment. It should be noted that the accident happened outside the crosswalk and the street lights above where the accident occurred were not working at the time of the crash making the roadway dark and visibility difficult. Photos of the accident were taken and saved on a memory card.
Keywords:
Crash, Crosswalk, Hospital, Moderate, Ped, Pictures, Walk
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3313524
Longitude:
-71.1946019
Location:
Case
number:
Date:
2021-12-03
Time:
09:39
Address:
211 SUMNER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Friday 12/3/2021 at approx 0939hrs, while assigned to N-496, I responded to the Newton Centre Post Office at 211 Sumner St for an MVA involving parked cars.There I met the operator of MV1, Wellington Alves, who states he his rear door swung open to his flat bed truck and struck MV2, MV3, and MV4 (all legally parked ). All owners were notified of the accident. MV2, MV3, and MV4 all suffered passenger side and rear damage to their vehicles.
Keywords:
Crash
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3308727
Longitude:
-71.1925198
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);