crash_reports
2 rows where dcc contains "Unknown", keywords contains "Crash" and "retrieved" is on date 2022-05-16
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-05-07
Time:
08:03
Address:
HAZELHURST AVE & WALTHAM ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 5/7/22 I responded to the intersection of Waltham St and Hazelhurt Ave for reports of a single vehicle crash into a pole. On arrival I observed MA reg 454NM8 with front end damage, stationary by utitlity pole #3 in front of 88 Waltham St. The pole was snapped in half and there were several wires/a transformer down as a result. I spoke with the operator identified as Igor Gomelskiy DOB 8/10/55. Gomelskiy stated that he lost control of the vehicle as he was heading northbound on Waltham St. According to Gomelskiy, mechanical failure was a factor, as the front right wheel bearing has been giving him issues of late. Gomelskiy signed a patient refusal and Eversource was notified. I remained on scene until Detail Ofc. Harris arrived. Due to the precarious position of the top half of the snapped pole resting on wires above the crash scene, Tody's will hook the car after Eversource removes the hazard.
Keywords:
Crash
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3631723
Longitude:
-71.2255461
Location:
Case
number:
Date:
2022-05-14
Time:
12:52
Address:
1676 WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On Saturday 5/14/2022 at approx 1252hrs, while assigned to N-496, I responded to 1672 Washington St in Newton for a MVA hit & run. There I met the operator of MV1 who states that a gray vehicle had just struck his. He could not provide any additional information but said he will try to get footage of the accident from his dash cam. He sates he was traveling EB on washington St in the left lane when an emergency vehicle ( possibly police) traveling WB, came into his lane to get around stopped traffic. He said he then changed lanes and went in front of the car that was directly to his right but another car drove around that car from the bike lane and struck the passenger side of his. He said the gray vehicle continued EB on washington St. I observed sideswipe damage to MV1's passenger side doors.
Keywords:
Crash
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3410261
Longitude:
-71.2386571
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);