crash_reports
1 row where "datetime" is on date 2020-11-05, keywords contains "Bike" and "retrieved" is on date 2020-12-27
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-11-05
Time:
16:21
Address:
BEACON ST & CHESTNUT ST
Speed
limit:
30
Violation
cited:
no
Narrative:
MV1, operator:Oscar Benavidez was driving Eastbound on Beacon St and was attempting to turn right on to Chestnut St when he struck a bicyclist. MV1 stated "He was moving to the right side of the roadway to go around a vehicle that was making a left turn at Beacon and Chestnut. He didn't see a bicylist and heard something hit his car and that's when he stopped and observed a bicyclist on the ground". The bicyclist Jeffery Glassman complained about his right side being sore, but had no other visible injuries. He stated "he was riding his bike on Beacon St and about to be entering the intersection at Beacon and Chestnut when a vehicle pulled to the right and hit him" He signed the refusal on scene with EMS. No damage was done to MV1. Corrina Mieth witnessed the accident and stated "She observed the vehicle move over to the right side of the road and that's when the vehicle collided with the bicyclist". Pictures were taken of the scene.
Keywords:
Bike, Crash, Ems, Pictures
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3291075
Longitude:
-71.225906
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);