crash_reports
1 row where "datetime" is on date 2020-01-02 and keywords contains "Helmet"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-01-02
Time:
18:01
Address:
BEACON ST & WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The OP. of MV#1 states he was on the eastbound lane of Washington Street, waiting to make a left turn onto Beacon Street. When he saw there was a break in traffic, he made the left turn and did not see Bicycle#1 coming off the sidewalk, thus colliding with it. The OP. of Bicycle#1 states he was travelling westbound on Washington Street on the sidewalk. He states Washington Street westbound is too dangerous for him to ride on the roadway during rush hour traffic. As he was crossing Beacon Street, Washington Street westbound traffic still had a green light and that's when MV#1 collided into him while making a turn. The OP. of Bicycle#1 was wearing a helmet and had front and rear lights. He did not want me to take his bicycle so he brought it with him to the hospital to be picked up by a family member. Pictures were taken of the damage.
Keywords:
Bike, Helmet, Hospital, Pictures
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3300068
Longitude:
-71.2484874
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);