crash_reports
1 row where "datetime" is on date 2019-09-13, dcc = "["Failed to yield", "Unknown"]" and dcc contains "Unknown"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-09-13
Time:
16:32
Address:
CHERRY ST & HARRIS RD
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator #1 states he was traveling southbound on Cherry St when he observed vehicle #2 drive through the stop sign at the end of Harris Rd, resulting in a collision with the front end of his vehicle, vehicle #1. Operator #2 states she was traveling westbound on Harris Rd and did not see the stop sign as she approached Cherry St. She subsequently drove through the stop sign and made contact with vehicle #1. Her intention was to cross Cherry St and go down Cherry Place, which is directly across the street from Harris Rd. No injuries were reported. Vehicle #2 sustained damage to the right rear corner as well as the undercarriage and was towed by Tody's. Vehicle #1 was parked legally on Cherry St and the operator has his own tow coming, as the vehicle is a contracted Waltham school bus van. It should be noted that no students were on board the van at the time of the collision.
Keywords:
Bus, School
Dcc:
Failed to yield, Unknown
Report
url:
Image
url:
Latitude:
42.3560826
Longitude:
-71.2279862
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);