crash_reports
1 row where "datetime" is on date 2019-05-08 and speed_limit = 10
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2019-05-08
Time:
08:13
Address:
326 FULLER ST (REAR)
Speed
limit:
10
Violation
cited:
no
Narrative:
I responded to Brae Burn Country Club for a report of a past MVA involving a tractor trailer. I spoke to Tim Strano a manager for Brae Burn who stated that on Monday evening a truck and trailer struck the properties fence. The fence is described as a automatic gated security fence which opens and closes upon entry and departure. Strano provided me with the vehicles information which I proceeded to contact the owner and operator of the vehicle. I spoke to the owner/operator of Vehicle One who stated he received the wrong destination address and attempted to turn around in the rear of Woodland Train Station when he stuck the fence (Brae Burn CC Maintenance Area). He gave his contact information to one of the Brae Burn workers on scene and left the area. Both parties were given the crash information and were advised.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3360988
Longitude:
-71.2354486
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);