crash_reports
2 rows where dcc contains "Speeding" 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:
2021-10-22
Time:
07:52
Address:
WASHINGTON ST & WALSINGHAM ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 10/22/2021, at approx 0752Hrs, while assigned to 497, I responded to 2071 Washington St for a report of a past hit and run with property damage. Upon arrival I observed the tire tracks leading from the right westbound lane leading over the curb , knocking over a chain link fence and post . There were tire ruts into the side yard of 2071 Washington St, an there was a End of Reduced Salt sign and post wedged into the ground of the homeowners side yard. I spoke with the property owner , Ali Shamser who stated at approx midnight he heard a loud bang, and looked out his window , saw nothing in the road but did not think to look down into his side yard. Ali's home is across the street from Newton Wellesley Hospital and next to Route 128 as well as on a very busy road so he is used to hearing crashes and sirens regularly. Ali stated at approx 0745Hrs when he left his home to take his children to school he noticed his damaged fence and yard. Ali has no cameras, across the street is Newton Wellesley Hospital and his neighbor adjacent on Walsingham St has his property surrounded by a 6 foot vinyl fence.
Keywords:
Bus, Crash, Hospital, School
Dcc:
Speeding, Reckless driving
Report
url:
Image
url:
Latitude:
42.3304958
Longitude:
-71.2480961
Location:
Case
number:
Date:
2022-06-19
Time:
22:14
Address:
107 NORTH ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
The operator of MV1 stated he was traveling on North Street, driving approximately 70 mph and a skunk ran across the street. The operator stated he swerved to avoid the skunk, hit the curb and lost control of the vehicle. He stated once the car rested against the garage to 105 North Street, he and the passenger got out of the vehicle. He stated the passenger told him to leave. The operator stated he walked down Farwell Street and after thinking about what happened he came back to the scene of the accident. The operator and passenger stated they were not injured. After speaking with the operator, I observed tire marks going South on North Street and followed them to the curb where I believe he struck which was located approximately 100 yards, in front of 129 North Street. From my observations, MV1 struck the curb located in front of 129 North Street. After striking the curb, MV1 spun sideways, continued traveling southbound, until the MV crossed into southbound lane, struck the curb and then the utility pole 14. After striking the curb the MV spun around facing north, struck the retaining wall, bushes and light pole, located in front of 107 North Street. After striking the light pole, the vehicle hit the garage door at 107 and 105 North Street, resting against 105 North Street. There was significant damage to the garage doors to 105 and 107 and damage to the support beam located between the residences. MV1 sustained major damage to the motor vehicle. Todys was notified for a tow. Photos were taken of all damage and submitted to IT
Keywords:
Bus, Crash, Pictures, Walk
Dcc:
Speeding, Reckless driving
Report
url:
Image
url:
Latitude:
Longitude:
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);