crash_reports
1 row where "datetime" is on date 2019-01-22 and keywords contains "Ice"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2019-01-22
Time:
16:15
Address:
BEACON ST & CRESCENT AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
On Tuesday January 22nd 2019 at approximately 1615 hours I responded to a two car motor vehicle accident at the intersection of Beacon Street and Crescent Ave, both are public ways in the City of Newton. At the time of the accident the current weather conditions were clear and dry with the road conditions extremely icy and snow covered. Upon arrival the medics were evaluating the operator of MV1 for slight back pain. The operator of MV1 signed a patient refusal and stated she was headed westbound on Beacon Street and stopped at the intersection of Crescent Ave, attempting to turn left. The operator of MV1 stated she came to a complete stop and had her left turn signal on waiting to turn onto Crescent Ave. She states MV2 then rear ended her and she pulled over the side of the road to wait for police assistance. MV1 was completely disabled with major rear end damage. MV1 was towed by Todys. The operator of MV2 stated he was traveling behind MV1 and attempted to stop behind MV1 but due to the icy road conditions, MV2 failed to stop and collided with MV1. The operator of MV2 refused medical attention and was able to drive MV2 from the scene.
Keywords:
Crash, Ice, Snow
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3303911
Longitude:
-71.1980873
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);