crash_reports
1 row where "datetime" is on date 2022-02-13 and geocoded_address = "Commonwealth Avenue & Homer St, Newton, MA 02459, USA"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-02-13
Time:
17:46
Address:
COMMONWEALTH AVE & HOMER ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On Sunday 2/13/22 at approximately 1746 hours while assigned to marked unit n501 patrolling division n495, I was dispatched to the intersection of Commonwealth Ave and Homer St. for a report of a single car MVA into a traffic signal. Upon arrival I observed Ma Reg 9LL519 on the island facing eastbound in the intersection of Commonwealth Ave and Homer St. The vehicle hit and knocked the traffic signal off its base and landed in the eastbound lane of Homer Street. Operator, O'CONNOR James, states he was travelling Eastbound on Commonwealth Ave and attempted to turn right onto Homer Street. He was unable to pull out of the turn due to the snowy and icy conditions and slid into and knocked over the traffic signal. I was able to move the signal out of the lane of traffic and onto the center island and Dagle Electric was notified. Two pictures were taken and attached to this report. O'CONNOR's vehicle was inoperable and was towed by Tody's. At the time of the accident it was difficult to determine what the damage was. Most serious damage appears to be to the under carriage, rendering the vehicle inoperable.
Keywords:
Crash, Ice, Pictures, Severe, Snow, Solar
Dcc:
Too fast for conditions
Report
url:
Image
url:
Latitude:
42.3380258
Longitude:
-71.2115805
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);