crash_reports
5 rows where dcc = "["Swerving"]" and keywords contains "Ice"
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-01-30
Time:
08:41
Address:
BRIDGE ST & WATERTOWN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Oper of Veh #1 stated he was stopped for stop sign and was struck by vehicle #2. Oper of veh # 2 stated she was traveling SB on Bridge Street and tried to stop but unable to because of the icy conditions. Skidded into a left turn causing her rear end to hit Veh # 1. The road was a sheet of ice and there were multiple accidents in the area. Passenger of veh # 2 was checked by medics and mom signed a refusal.
Keywords:
Crash, Ice
Dcc:
Swerving
Report
url:
Image
url:
Latitude:
42.3604294
Longitude:
-71.20168
Location:
Case
number:
Date:
2019-02-02
Time:
00:14
Address:
PLEASANT ST & TYLER TER
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV#1 stated that she was driving west on Tyler Ter, approaching Pleasant St. Operator stated that she lost control of the vehicle when she hit a patch of ice. Operator stated that she then went across Pleasant St and struck the sidewalk, and came to rest in the driveway of 126 Pleasant St. Airbags deployed, medics were called to the scene, and all parties cleared with a patient refusal. MV#1 was towed by Todys.
Keywords:
Airbag, Ice
Dcc:
Swerving
Report
url:
Image
url:
Latitude:
42.331723
Longitude:
-71.199404
Location:
Case
number:
Date:
2019-03-11
Time:
08:18
Address:
300 BOYLSTON ST
Speed
limit:
15
Violation
cited:
no
Narrative:
WHILE PULLING INTO THE PARKING AREA OF #300 BOYLSTON ST, MV#1 SLID ON ICE AND STRUCK A PARKED MV#2 (REAR ). MV#2 WAS PARKED (OCCUPIED) IN FRONT OF #300 BOYLSTON ST, WHEN MV#1 SLID INTO THE REAR OF THE VEHICLE. MV#1 WAS TOWED WITH MODERATE FRONT END DAMAGE.
Keywords:
Ice, Moderate
Dcc:
Swerving
Report
url:
Image
url:
Latitude:
42.3185796
Longitude:
-71.179849
Location:
Case
number:
Date:
2021-02-07
Time:
15:21
Address:
140 HIGHLAND ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1, Mr. Marchand was driving Southbound on Highland St when a vehicle stopped abruptly in front of him to allow a vehicle to enter the travel lane exiting out of Ascenta Terrace. When the vehicle stopped abruptly in front of him, MV1 slammed on the brakes and did not hit the car in front of him, however he was rear-ended by a vehicle behind him, MV2. MV2, Mr. Calderon, was traveling Southbound on Highland St behind MV1 when he observed MV1 brake. He then immediately stepped on his brake and was not able to maneuver the vehicle in order to avoid the collision due to icey, slippery conditions on the road. MV2 sustained heavy front end damage. MV1 sustained minor damage to the rear he vehicle. No injuries were reported on scene. MV2 had to be towed by Tody's as it was disabled.
Keywords:
Ice
Dcc:
Swerving
Report
url:
Image
url:
Latitude:
42.3447474
Longitude:
-71.2247517
Location:
Case
number:
Date:
2022-01-06
Time:
07:42
Address:
COMMONWEALTH AVE & CENTRE STREET
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 operator states she was stopped at the traffic light on Commonwealth Avenue when MV2 was on Centre Street turning right eastbound slid from the ice roadway into the front end of MV1. MV1 operator had no injuries and the vehicle sustained mild damage to the front of the vehicle. I spoke to Operator 2 on the phone. MV2 operator states he was turning right onto Commonwealth Avenue when his vehicle lost control because of the slick roadway. MV2 operator stated he was at fault. MV2 had very little damage to the front of the vehicle due to it being a larger vehicle. MV2 operator had no injuries. No tow was needed for either vehicles. Operator 2 shared information with operater 1, he left prior to our arrival.
Keywords:
Ice, Phone
Dcc:
Swerving
Report
url:
Image
url:
Latitude:
42.3365124
Longitude:
-71.1932597
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);