crash_reports
1 row where dcc contains "Speeding", dcc_code = "[2, 7]" 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:
2019-04-20
Time:
10:36
Address:
285 CRAFTS STREET
Speed
limit:
30
Violation
cited:
no
Narrative:
Mrs. Weiss stated that she was attempting to back out of her driveway at 285 Crafts Street when her vehicle accelerated for no reason "like a bat out of hell." The vehicle then crossed Crafts street at a high rate of speed, jumped the curb, crossed the large grass island, and only stopped when the vehicle crashed into a tree. Mrs. Weiss was uninjured and signed a patient refusal. The vehicle sustained moderate damage to the tires, undercarriage, and rear bumper and was towed from the scene by Todys. Photos were taken of the damaged city tree and were placed in the IT bureaus mailbox to be attached to this report. Based on the facts that Mrs. Weiss could not explain the reason for the cars acceleration, the distance the vehicle traveled without stopping, and the close proximity of the crash to an elementary and middle school I filed a request for Immediate Threat License Suspension/Revocation. All proper paperwork as well as a copy of this report were faxed to the Registry of Motor Vehicles.
Keywords:
Crash, Moderate, Pictures, School, Speed, Tree
Dcc:
Speeding, Too fast for conditions
Report
url:
Image
url:
Latitude:
42.358733
Longitude:
-71.2108289
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);