crash_reports
1 row where "date" is on date 2019-07-08, intersection = 0 and keywords contains "Ems"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-07-08
Time:
18:28
Address:
2014 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
OPMV#1 Was traveling Eastbound on Washington St when they were struck by the OPMV#2 exiting the NWH at 2014 Washington St. OPMV#1 Stated he was traveling straight on Washington St heading home and noticed a vehicle pulling out into his lane then stop. He slowed down to let them go but the vehicle didn't move so he proceeded to travel straight and the vehicle pulled out in front of him colliding with his vehicle. OPMV#2 Was traveling Northbound on the NWH exit/entrance roadway attempting to make a left turn onto Washington St traveling Eastbound when he was struck by the OPMV#1. OPMV#2 Stated he thought he could make a left turn until he was suddenly struck by the OPMV#1. Both vehicles were towed by Tody's Towing. EMS evaluated all parties with no injuries.
Keywords:
Ems
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3306338
Longitude:
-71.2464373
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);