crash_reports
1 row where "datetime" is on date 2020-10-04, dcc contains "Reckless driving" and speed_limit = 30
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-10-04
Time:
10:43
Address:
363 CRAFTS ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On October 4th, 2020 at approximately 10:43 hours while assigned to N491 I responded to a report of a two car MV crash in the area of #353 Craft St. On my arrival I located the two involved vehicles, 1st, a black toyota rav4 and a blue mercedes 350. Operator of the black toyota, identified as Charlie Rodriguez reports driving S/B on Craft St when vehicle #2 who was behind him tailgating pulled around his vehicle then stopped in front of him causing him to crash into the rear of his vehicle. Operator of the blue mercedes, identified as Mario Santi reports driving S/B on Craft St and the cars in front of him were going to slow. He further reported that vehicle #1 stopped in front of him so he went around vehicle #1. Vehicle #1 then drove into his rear after he passed him.
Keywords:
Crash
Dcc:
Lane departure, Reckless driving
Report
url:
Image
url:
Latitude:
42.3599224
Longitude:
-71.214124
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);