crash_reports
1 row where "datetime" is on date 2020-09-26, "retrieved" is on date 2020-10-20 and violation_cited = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-09-26
Time:
15:54
Address:
327 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Vehicle one was driving westbound on Washington St when he stated that he was looking at the buildings across from 327 Washington St. Vehicle one drifted into parked car, vehicle two. Vehicle two was parked and unoccupied in a parking spot in front of 327 Washington St. Vehicle two moved forward from the impact and struck vehicle three. It should be noted that vehicle two already had extensive damage to the front end of the vehicle prior to the crash holding the bumper intact with duck tape and clear tape. Vehicle three had minor damage to the rear end bumper. No injuries were reported on scene.
Keywords:
Crash, Severe
Dcc:
Inattention, Distracted
Report
url:
Image
url:
Latitude:
42.3569413
Longitude:
-71.1871127
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);