crash_reports
2 rows where date = "2019-11-24" and dcc contains "Failed to yield"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-11-24
Time:
16:57
Address:
HAMMOND ST & HAMMONDSWOOD RD
Speed
limit:
25
Violation
cited:
yes
Narrative:
Motor vehicle 1 (MV1) was traveling eastbound on Hammond St. when motor vehicle 2 (MV2), pulled out of Hammondswood Rd. (southbound) and crashed into the front end of MV1. As a result of the crash both MV1 and MV2 sustained significant front end damage. The Cataldo medics responded to the scene, and all parties involved signed patient refusals.
Keywords:
Crash
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3351954
Longitude:
-71.1775586
Location:
Case
number:
Date:
2019-11-24
Time:
17:30
Address:
225 BOYLSTON ST
Speed
limit:
10
Violation
cited:
no
Narrative:
On Sunday 11/24/19 at approximately 1730 hours while working in marked unit n499 I was dispatched to the parking lot on the rt9 side of 225 Boylston Street (Bloomingdales) for a report of a minor motor vehicle crash. Upon arrival I spoke with the operator of motor vehicle 2, GIRARD Kathleen, who states that she was driving from the 2nd aisle of parking spots into the main travel lane to attempt to exit the mall. When she attempted to turn left she didnt see motor vehicle 1 already in the lane of traffic striking the side of the vehicle. After speaking with GIRARD I spoke with the operator of motor vehicle 1, SONG Guang min. SONG did not speak english, but he corroborated what GIRARD had stated by using a translation app on his cell phone. GIRARD had damage to the front of her vehicle and SONG had damage to the drivers side of his vehicle. Both vehicles were still operable and were driven from the scene. Neither party was injured
Keywords:
Crash, Phone, Solar
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3213504
Longitude:
-71.177129
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);