crash_reports
1 row where "datetime" is on date 2020-01-19, hit_run = 0 and speed_limit = 5
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-01-19
Time:
17:33
Address:
260 NEEDHAM ST
Speed
limit:
5
Violation
cited:
no
Narrative:
Ms. Cooney states that she pulled into a parking space at Marshall's Department Store and when attempting to hit the brake she accidently hit the accelerator causing her vehicle to jump the curb, crash into the fence, and become stuck on top of a bush. The damage to the fence is estimated at approximately $1,000. Ms. Cooney reported no injuries and Tody's responded to the scene and removed the car from the berm. The vehicle did not sustain any apparent damage at this time and was driven from the scene. I provided the manager of Marshall's, Adriana Guara, with a copy of the crash report number and contacted the building's landlord, Dana, and updated him on how to obtain a copy of the crash report.
Keywords:
Bus, Crash
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3088013
Longitude:
-71.2144481
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);