crash_reports
1 row where "datetime" is on date 2019-02-21 and keywords contains "Rain"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-02-21
Time:
06:53
Address:
240 NAHANTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On Thursday 2/21/19 at approximately 0653 while assigned to marked unit N499 I was travelling westbound on Nahanton Street when I observed a motor vehicle pulled over to the right side of the road with its emergency flashers on. I pulled behind the vehicle and spoke with the operator, FINCH Robert L, who states that he was travelling Westbound on Nahanton Street and due to the weather conditions he lost control of his vehicle and slid into utility pole #14. There was very minimal damage done to the utility pole, however FINCH's car was disabled due to the collision. The weather conditions were poor as it was raining and there were several inches of snow on the ground from a storm that morning causing the roads to be slushy and slippery. FINCH was uninjured and stated that he had AAA on the way to tow his motor vehicle.
Keywords:
Rain, Snow
Dcc:
Too fast for conditions
Report
url:
Image
url:
Latitude:
42.297167
Longitude:
-71.1986149
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);