crash_reports
2 rows where keywords contains "Ice" and "retrieved" is on date 2022-02-23
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:
Case
number:
Date:
2022-02-13
Time:
18:56
Address:
241 COUNTRY CLUB RD
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 operator was travelling down hill on Countryside Rd when vehicle controls were lost and MV1 drove onto 241 Countryside Rd front lawn. Road conditions include snowing at the time of incident and slippery roads due to snow and ice. MV1 operator was able to remove vehicle from front lawn. no injuries reported. Homeowner, Richard Goldstone will speak with homeowners insurance about possible damage to lawn.
Keywords:
Ice, Snow
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3022406
Longitude:
-71.1892477
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);