crash_reports
2 rows where "datetime" is on date 2019-09-13, dcc contains "Unknown" and keywords contains "Bus"
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:
Case
number:
Date:
2019-09-13
Time:
23:20
Address:
291 CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Rizza stated he waited for the crosswalk signal to turn on. When it finally turned on to walk (white walking person) he got on his bike to start peddling. At this time, he observed a black vehicle traveling southbound traveling towards him. Moments later, Rizza was struck by the vehicle. Rizza rolled over the vehicle and hit the pavement. Rizza stated the vehicle took off, but he was unsure where it went (Mass Pike, Newton Corner, or Washington Street). The medics looked at Rizza and he was alert and had a minor laceration to his head. Rizza's mother Domenica Rizza picked him up and brought him to NWH. I drove around the area and could not find a black Honda sedan with damage to the front of it. As of now, I do not have anymore information. This report is a hit and run. Traffic Update (Officer Gaudet): Myself and Officer Anderson have both canvassed the area of the crash for identifying physical evidence from the vehicle that fled the scene with a negative result. We have also reached out to local business's in an attempt to secure surveillance footage of the crash with a negative result. At this time we are unable to obtain any further information on the vehicle that left the scene of the crash.
Keywords:
Bus, Crash, Crosswalk, Walk
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3580212
Longitude:
-71.1850974
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);