crash_reports
2 rows where "datetime" is on date 2022-01-06 and keywords contains "Ice"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-01-06
Time:
07:42
Address:
COMMONWEALTH AVE & CENTRE STREET
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 operator states she was stopped at the traffic light on Commonwealth Avenue when MV2 was on Centre Street turning right eastbound slid from the ice roadway into the front end of MV1. MV1 operator had no injuries and the vehicle sustained mild damage to the front of the vehicle. I spoke to Operator 2 on the phone. MV2 operator states he was turning right onto Commonwealth Avenue when his vehicle lost control because of the slick roadway. MV2 operator stated he was at fault. MV2 had very little damage to the front of the vehicle due to it being a larger vehicle. MV2 operator had no injuries. No tow was needed for either vehicles. Operator 2 shared information with operater 1, he left prior to our arrival.
Keywords:
Ice, Phone
Dcc:
Swerving
Report
url:
Image
url:
Latitude:
42.3365124
Longitude:
-71.1932597
Location:
Case
number:
Date:
2022-01-06
Time:
07:24
Address:
CENTRE ST & COMMONWEALTH AVENUE
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 Operator states she was traveling southbound on Centre Street when an orange Chevrolet Camaro rear ended her vehicle. MV2 did not stop for the accident and continued driving. The road ways were slick from ice. MV1 operator had no injures. I attempted to contact MV2 operator but was unsuccessful. Due to there being minimal to no damage to MV1 we will not be seeking charges for MV2 Operator for leaving the scene of property damage at this time. Traffic has been updated to follow up with this report. Traffic Bureau update (Officer Gaudet): I attempted to make contact with the registered owner of MV2, Mr. Jorge Ramirez S17331100, with a negative result. A "Hit and Run" inquiry was mailed to the address listed for Mr. Ramirez with the registry.
Keywords:
Crash, Ice
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3365124
Longitude:
-71.1932597
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);