crash_reports
1 row where "datetime" is on date 2020-02-14, dcc = "["Inattention", "Unknown"]" and "retrieved" is on date 2020-10-06
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-02-14
Time:
14:55
Address:
14 CLOVERDALE RD
Speed
limit:
25
Violation
cited:
no
Narrative:
Mv#1 operator stated he was travelling on Cloverdale Rd E/B. #1 stated he began veering to the far left to avoid a parked MV on the right side of the road. #1 stated he saw Mv#2 on Cloverdale Rd on the left side of the road but believed #2 was parked as well. #1 attempted to drive between the middle of those two MVs. As a result, #1 driver's side front end struck #2 driver's rear passenger side. #2 operator stated he was not parked but also travelling on Cloverdale Rd W/B. #2 stated he saw #1 veering into his lane of travel. #2 stated he started to brake and move to his right and was forced onto the grassy birm by #1 approaching from the wrong side when #2 was struck by #1. No injuries reported. #1 was towed by Tody's with heavy front end damage. #2 had moderate damage not including rim damage to the driver's side rear wheel which #2 was able to change the flat to a spare on scene and able to drive the MV away.
Keywords:
Moderate
Dcc:
Inattention, Unknown
Report
url:
Image
url:
Latitude:
42.3209143
Longitude:
-71.199644
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);