crash_reports
3 rows where date = "2019-11-24" and "retrieved" is on date 2020-10-07
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, violation_cited, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-11-24
Time:
05:24
Address:
320 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 stated he got off the Mass Pike Eastbound at exit 17, and once at the top of the ramp, his GPS directed him to take a left onto Washington St. While responding to a separate call, I witnessed MV1 traveling the wrong direction (NE) in the area of 320 Washington St. (one way section of rotary). I activated my blue lights and pulled up to MV1, telling the operator the street was a one way and he needed to turn around. The operator stated he had room to turn around, at which point I blocked Washington St. While turning around, the trailer of MV1 struck a City of Newton concrete light pole and knocked it down. The concrete pole was taped and coned off, and Daigle was notified to respond. Photos were taken and submitted to the IT bureau.
Keywords:
Pictures
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.3563932
Longitude:
-71.1872752
Location:
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);