crash_reports
1 row where "datetime" is on date 2019-03-08, keywords contains "Bus" and "retrieved" is on date 2020-10-06
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2019-03-08
Time:
14:36
Address:
WALNUT ST & ELM RD
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV#1 stated she was travelling southbound on Walnut St at the intersection of Elm Rd when she let a vehicle out of Elm Rd to make a left turn. The operator of MV#1 stated she proceeded to move forward when a school bus directly behind that vehicle also made a left turn making contact with MV#1. The operator of MV#1 honked her horn to get the school bus's attention with negative results. MV#1 sustained minor damages to its driver's side front bumper and fog light. The damage to the school bus should be to its driver's side rear bumper. There were no reported injuries to the operator of MV#1. There were no reports of any contracted school bus operators reporting an accident. The operator of MV#1 stated there were witnesses at the accident scene but she did not get any of their information. The operator of MV#1 was advised to contact her insurance provider.
Keywords:
Bus, Crash, School
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3472639
Longitude:
-71.2065995
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);