crash_reports
1 row where "datetime" is on date 2019-02-11, dcc = "["Reckless driving"]" and intersection = 1
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2019-02-11
Time:
17:27
Address:
ADAMS ST & WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
MV1 stated he "had his directional on, was trying to get into the right lane" however MV2 "wouldn't let me." MV1 further stated when he did get behind MV2 she "drove across all the lanes and would hit the gas & brake, so when i tried to pass her she slammed into my car, then pulled in front of me, slammed on the brakes so I'd hit her, however I don't think I did." The operator of MV1 further stated that the operator of MV2 then exited her car began filming him while shouting "you hit me, then drove off." MV2 is described as a "black ford or subaru sedan driven by a white female in her 20's, with blond hair & glasses." MV1 stated he was unable to get a license plate. A canvass of the area was conducted yielding negative results.
Keywords:
[]
Dcc:
Reckless driving
Report
url:
Image
url:
Latitude:
42.3548522
Longitude:
-71.1956673
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);