crash_reports
1 row where "datetime" is on date 2019-11-04 and keywords contains "Fire"
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:
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);