crash_reports
2 rows where "datetime" is on date 2019-11-04 and dcc_code = "[99]"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-11-04
Time:
07:40
Address:
300 WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Operator #1 stated he driving w/b on Washington St, in the area of #300, Crown Plaza Hotel on his left, in middle lane when vehicle #2(small box style school bus changed into his lane from the lane to his left causing the crash. Operator #1 had a dash cam video that recorded the crash. Operator #2 who was operating a City of Boston Transportation mini box style school bus, stated he was travelling w/b on Washington St near the Crown Plaza Hotel when he felt like something struck his bus.Operator reports never seeing vehicle #2 prior to the crash. Operator#2 also reports he never changed lanes and was always in the middle lane. Both vehicles had already moved from the crash site to further down the road in front of Honda village, #371 Washington St. Bus driver had one student passenger who resides in Boston but attends Newton North High. There were no vehicles towed and no reported injuries.
Keywords:
Bus, Crash, School
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3567319
Longitude:
-71.1859798
Location:
Case
number:
Date:
2019-11-04
Time:
15:36
Address:
210 NAHANTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
MV#1 stated while driving his truck and trailer Westbound on Nahanton St across from the golf course the right top side of the trailer struck a City of Newton tree. MV#1 stated after hearing and feeling the collision he immediately stopped his MV. The collision caused part of the tree to break off and fall on top of his truck as well as into the Eastbound lane. MV#1 sustained minor damage to the top passenger side of his trailer. MV#2 stated while traveling Eastbound on Nahanton St she witnessed MV#1 strike a tree on the top passenger side of his vehicle. MV#2 stated a tree branch then fell from the top of his MV into her Eastbound lane. The branches scratched the diver side of her vehicle while passing. MV#2 had scratch marks that was consistent to both operators statements. MV#2 sustained minor damage. Both parties stated the were not injured and refused medical attention at this time. Neither vehicle was towed from the scene due to minor damage. City of Newton Public works along with Newton Fire were able to safely remove the branches from the trailer as well as the road.
Keywords:
Fire, Tree
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.2969814
Longitude:
-71.1958963
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);