crash_reports
1 row where keywords contains "Ice" and "retrieved" is on date 2021-02-15
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-02-07
Time:
15:21
Address:
140 HIGHLAND ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1, Mr. Marchand was driving Southbound on Highland St when a vehicle stopped abruptly in front of him to allow a vehicle to enter the travel lane exiting out of Ascenta Terrace. When the vehicle stopped abruptly in front of him, MV1 slammed on the brakes and did not hit the car in front of him, however he was rear-ended by a vehicle behind him, MV2. MV2, Mr. Calderon, was traveling Southbound on Highland St behind MV1 when he observed MV1 brake. He then immediately stepped on his brake and was not able to maneuver the vehicle in order to avoid the collision due to icey, slippery conditions on the road. MV2 sustained heavy front end damage. MV1 sustained minor damage to the rear he vehicle. No injuries were reported on scene. MV2 had to be towed by Tody's as it was disabled.
Keywords:
Ice
Dcc:
Swerving
Report
url:
Image
url:
Latitude:
42.3447474
Longitude:
-71.2247517
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);