crash_reports
1 row where date = "2019-04-23" and keywords contains "Rain"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2019-04-23
Time:
08:54
Address:
0 CYPRESS ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Operator 1 states she was stopped in traffic Northbound on Cypress St when she was struck from behind by vehicle 2. Vehicle 2 states he was stopped in traffic on Cypress St behind vehicle 1. Vehicle 2 was struck from behind by vehicle 3 which pushed vehicle 2 into vehicle 1. Operator 3 states she was traveling Northbound on Cypress St approaching other vehicles stopped in traffic. Operator 3 started to apply her brakes; however, due to the rain and wet roadway her vehicle started to slide as if she had no brakes.Vehicle 3 slid into vehicle 2 and vehicle 2 struck vehicle 1. Vehicles 2 and 3 sustained moderate damage and vehicle 1 sustained minor damage. Operator 2 was transported to Newton-Wellesley Hospital with neck pain.
Keywords:
Hospital, Moderate, Rain
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.32497
Longitude:
-71.19169
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);