crash_reports
1 row where "datetime" is on date 2019-09-08 and keywords contains "Helmet"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2019-09-08
Time:
16:46
Address:
BRIDGE ST & CALIFORNIA ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Opr of V1 stated she was in the right turn lane on California Street waiting to turn right onto Bridge Street. Opr stated the green arrow signal came on and she started to turn. At this time, B1 cut in front of her to beat the light and made contact with the vehicle. V1 sustained light damage to the front right. V1 was not towed. Opr of B1 stated he was on California Street waiting to turn left onto Bridge Street. At this time, he stated he saw no cars moving, rode across the street, and tried to beat the light. B1 made contact with V1. Opr of B1 suffered minor injuries and was transported to NWH. Bike was put in the property room for safekeeping. I was unable to secure bike, but helmet, bike pump, and mirror were placed in locker number 8.
Keywords:
Helmet
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3651423
Longitude:
-71.2043931
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);