crash_reports
2 rows where dcc contains "Over-steering" 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:
2019-03-18
Time:
08:57
Address:
700 CENTRE STREET
Speed
limit:
35
Violation
cited:
no
Narrative:
Operator of Vehicle #1 stated that he was traveling North on Centre Street. He passed through the intersection of Cabot and Centre street where he proceeded downhill on an icy road. Operator stated that he "fishtailed" and lost control of his vehicle before leaving the roadway and coming to rest in the shrubs and trees in the front yard of 700 Centre Street. At the time of this incident there is a reported water main break at the intersection of Centre street and Sargent street with City Water Crews addressing the issue. I observed a large collection of ice in the intersection and in the northbound lane of Centre street. No injuries were reported. Tody's was notified and removed the truck from the bushes. Operator #1 drove the vehicle away. I notified the home owner, Mr. Watkins of the damage. He estimated the damage to the landscaping to be approximately $2000.
Keywords:
Bus, Ice, Tree
Dcc:
Swerving, Over-steering
Report
url:
Image
url:
Latitude:
42.3476813
Longitude:
-71.1881338
Location:
Case
number:
Date:
2022-03-01
Time:
09:32
Address:
BRIDGE ST & WATERTOWN ST
Speed
limit:
30
Violation
cited:
no
Narrative:
The Operator of MV1(Ma Reg 4DKA19) was traveling SB on Bridge St approaching the stop sign at Watertown Street when his vehicle was struck head on. Operator of MV1 stated the operator of MV2 came into his lane of traffic when he turned onto Bridge Street. The Operator of MV2 (Ma reg 1CV892) stated he was traveling WB on Watertown Street when he turned right onto Bridge Street. Operator of MV2 stated he lost control of his vehicle do to ice on the roadway. This caused his vehicle to swerve into the oncoming lane striking MV1 head on. Both vehicle sustained minor damage and did not require a tow. Medic 2 arrived on scene to evaluate the operator of MV1 for possible minor injuries. Operator of MV1 signed a refusal and both parties drove away from the scene safely.
Keywords:
Ice
Dcc:
Over-steering
Report
url:
Image
url:
Latitude:
42.3604377
Longitude:
-71.2016878
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);