crash_reports
2 rows where "datetime" is on date 2022-02-04 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-02-04
Time:
09:05
Address:
DERBY ST & NOBLE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV#1 stated he was traveling west on Derby St when MV#2 entered his lane of travel from Noble St and crash occurred. The operator of MV#2 stated he was traveling south on Noble St approaching Derby St and was unable to stop due to the icy conditions. MV#2 then entered Derby St and crash occurred with MV#1. No tows and no injuries.
Keywords:
Crash, Ice
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.359678
Longitude:
-71.2335531
Location:
Case
number:
Date:
2022-02-04
Time:
13:58
Address:
176 COMMONWEALTH AVE & ________Feet N S E W of
Speed
limit:
Violation
cited:
no
Narrative:
On 02/05/22, while assigned to N496 I was dispatched to Comm Ave. @ Old Colony Rd for a two MV accident. Upon arrival I spoke with the operator of MV1 who stated he was driving Westbound on Comm Ave. He stated that MV2 which was driving Eastbound on Comm Ave lost control due to the icy road conditions. MV1 stated that MV2 lost control, hit a snow bank and swerved into his lane causing the accident. The operator of MV2 stated that he was driving eastbound on Comm ave when he lost control of the MV due to the icy conditions of the road. The operator of MV2 stated that he lost control and hit a snow bank which caused him to swerve into the westbound lane. Todys's arrived on scene and took possession of MV2. EMS arrived on scene and both parties refused medical attention.
Keywords:
Crash, Ems, Ice, Snow
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3368636
Longitude:
-71.1730305
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);