crash_reports
1 row where "date" is on date 2022-05-07, dcc contains "Unknown" 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:
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);