crash_reports
3 rows where intersection = 0, keywords contains "Fire" and "retrieved" is on date 2021-02-09
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-01-21
Time:
19:51
Address:
2240 COMMONWEALTH AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
On 1/21/21 at approximately 1950 hours, I responded to 2240 Commonwealth Ave for a car into a tree with entrapment. On arrival, I observed MA reg 457RC6 into a tree. Firefighters used jaws of life to gain access to the operator. Operator stated he was driving westbound and his windshield was fogging up and could not see. He stated that he saw the oncoming traffic and swerved and hit the tree. The operator suffered minor injuries and was transported to Mass General. The vehicle was towed by Todys.
Keywords:
Fire, Tree
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3469166
Longitude:
-71.2536165
Location:
Case
number:
Date:
2021-01-26
Time:
19:47
Address:
80 CHARLESBANK RD
Speed
limit:
25
Violation
cited:
no
Narrative:
On 1/26/2021, Newton Fire and Police were dispatched to Charlesbank Rd. and St. James St. for a single motor vehicle collision. Upon arrival, I observed Motor Vehicle #1 parked in the roadway with damage to its front end and under carriage. The operator stated; due to the snowy, wet, slippery conditions, her vehicle slid into the concrete median. The operator reported no injuries, however the vehicle was towed away from the scene by Tody's Towing Service.
Keywords:
Fire, Snow
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3585654
Longitude:
-71.1797224
Location:
Case
number:
Date:
2021-02-01
Time:
11:07
Address:
34 CRAFTS ST
Speed
limit:
15
Violation
cited:
no
Narrative:
On Friday, January 29, 2021, Mr. Jose Bonilla (S73276930) stated he was operating a 2016 Thomas School bus (MA: SB40311) owned by Eastern Bus Company at the intersection of Crafts Street and the driveway to 34 Crafts Street, Newton. Crafts Street is a public way maintained by the City of Newton. Mr. Bonilla stated he proceeded to take a right turn onto Crafts Street from the driveway and the passenger side of his vehicle made contact with a fire hydrant. The crash caused the hydrant to fall to the roadway. No injuries reported. City noticed of damage. Photos of damage were submitted to the IT Bureau.
Keywords:
Bus, Crash, Fire, Pictures, School
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3547176
Longitude:
-71.2009798
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);