crash_reports
4 rows where dcc = "["Lane departure"]", intersection = 0 and keywords contains "Fire"
This data as json, CSV (advanced)
Suggested facets: violation_cited, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-09-04
Time:
21:14
Address:
129 VALENTINE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 stated she was traveling southbound on Valentine Street when MV2 crossed over the double yellow lines and collided with her head on. Operator of MV1 stated she observed two parked cars in front of 129 Valentine Street and was unable to swerve out of the way to avoid the collision. Operator of MV2 stated she was traveling northbound on Valentine Street and could not see the double yellow lines and believes she may have crossed over them, when she saw MV1 and hit her head on. Operator of MV1 was evaluated by Cataldo Medics and signed a patient refusal. Both vehicles sustained heavy front end damage and were towed by David Donahue of Tody's Towing. Newton Fire was on scene and handled the spill from both vehicles.
Keywords:
Fire
Dcc:
Lane departure
Report
url:
Image
url:
Latitude:
42.3402727
Longitude:
-71.2180688
Location:
Case
number:
Date:
2020-03-16
Time:
13:41
Address:
127 COMMONWEALTH AVE
Speed
limit:
25
Violation
cited:
yes
Narrative:
On 3/16/20 I was dispatched to 127 Commonwealth Ave for a report of a MV(#1) crash into a fire hydrant. The operator left the scene and was shortly after identified as Mr Bai Lin Wu. Wu called NPD to report the crash once he arrived home. Ofc Ferguson took photos of the knocked over hydrant. City Water Dept was notified of the damage. I responded to Wu's residence. Wu stated he was travelling on the Commonwealth Ave W/B carriage road. Wu stated an unknown MV travelling behind him was trying to pass him on the left. Wu stated he turned to the right to allow the unknown MV to pass. Wu ran off the road to the right and struck the hydrant in front of #127 Comm Ave. Wu further stated he left because he was trying to get medication home as soon as possible to his ill wife. Wu's vehicle sustained moderate damage to the passenger side front end. Wu issued citation for CO Ch19/Sec75 failure to use care turning (went off road).
Keywords:
Citation, Crash, Fire, Moderate, Pictures
Dcc:
Lane departure
Report
url:
Image
url:
Latitude:
42.3381197
Longitude:
-71.1718426
Location:
Case
number:
Date:
2020-03-25
Time:
07:49
Address:
204 LAGRANGE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
OPER OF MV#1 STATED THAT HE WAS TRAVELLING EB ON LAGRANGE ST (#204), BELOW THE SPEED LIMIT, WHEN MV#2 APPROACHED WB, AND CROSSED THE DOUBLE YELLOW LINES. MV#2 THEN STRUCK THE DRIVER SIDE FRONT END OF MV#1. OPER OF MV#2 STATED THAT HE WAS TRAVELLING WB ON LAGRANGE ST, BELOW THE SPEED LIMIT, AND DOES NOT RECALL HOW THE ACCIDENT HAPPENED. PASSENGER OF MV#2 STATED THAT THEY WERE TRAVELLING EB ON LAGRANGE ST, WHEN THEIR VEHICLE SLIGHTLY DRIFTED OVER THE DOUBLE YELLOW LINES, AND STRUCK MV#1. PASSENGER #2 WAS TRAPPED IN THE FRONT PASSENGER SEAT AND WAS EXTRICATED BY NFD. BOTH VEHICLES TOWED BY TODYS WITH FRONT END DAMAGE. OFC GAUDET PHOTOGRAPHED THE SCENE.
Keywords:
Crash, Fire, Pictures, Speed
Dcc:
Lane departure
Report
url:
Image
url:
Latitude:
42.3035949
Longitude:
-71.1664677
Location:
Case
number:
Date:
2020-10-08
Time:
11:53
Address:
546 PARKER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
THE OPER OF MV#1 WAS TRAVELLING SB ON PARKER ST (#546), WHEN HE COLLIDED WITH THE REAR OF MV#2 ( PARKED LANDSCAPE TRAILER). ONLOOKERS, FIRE AND MEDICS, ATTENDED TO THE DRIVER PRIOR TO MY ARRIVAL. THE OPERATOR APPEARED TO BE HAVING SOME SORT OF MEDICAL EPISODE (SEIZURE LIKE) AFTER THE CRASH. IT IS UNKNOWN IF THE PARTY WAS HAVING THE MEDICAL EPISODE PRIOR TO THE CRASH. MV1 WAS TOWED WITH FRONT END/WHEEL DAMAGE. THE OPERATOR WAS TRANSPORTED TO THE HOSPITAL.
Keywords:
Crash, Fire, Hospital
Dcc:
Lane departure
Report
url:
Image
url:
Latitude:
42.3089195
Longitude:
-71.197509
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);