crash_reports
3 rows where dcc = "[]", intersection = 0 and keywords contains "Severe"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2020-11-08
Time:
20:26
Address:
169 RIVER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator states that she was driving westbound on River St when she felt her vehicle hit something in the road. She did not see anything, but completely lost control of MA reg 1LFH86. The vehicle ended up hitting a utility pole and sustained heavy damage/airbag deployment. Upon inspecting the scene, a rotor was located on River St near Auburndale Ave. It appears that the vehicle's right front balljoint snapped and caused severe mechanical failure, in turn causing the operator to lose control. Medics documented a patient refusal and Tody's towed the vehicle to their lot. Eversource was notified to check the integrity of pole #25 in front of 169 River St.
Keywords:
Severe
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3539984
Longitude:
-71.2332224
Location:
Case
number:
Date:
2020-12-03
Time:
09:38
Address:
37 CRAFTS ST
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 12-3-20 AT APPROX. 0938HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT 37 CRAFTS ST. I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES HE WAS TRAVELING N-BOUND ON CRAFTS ST. WHILE TRAVELING HIS TRAILER ( VEHICLE #2 ) WAS HIT ON THE RIGHT SIDE BY VEHICLE #3 AS SHE WAS EXITING THE DRIVEWAY AT 29 CRAFTS ST. DRIVER OF VEHICLE #3 STATES SHE WAS STOPPED IN THE DRIVEWAY OF 29 CRAFTS ST. WAITING TO TURN LEFT AND ENTER THE TRAFFIC ON CRAFTS ST. DRIVER OF VEHICLE #3 STATES HER VISIBILITY WAS OBSTRUCTED BY A YELLOW BUS PARKED ON CRAFTS IN FRONT OF 29 CRAFTS ST. AS VEHICLE #3 ENTERED THE TRAFFIC LANE SHE HIT THE RIGHT SIDE OF VEHICLE #2. VEHICLE #1 HAD NO DAMAGE. VEHICLE #2 HAD A RIGHT SIDE FLAT TIRE AND POSSIBLE BROKEN AXLE. VEHICLE #2 WAS TOWED BY PERFECTION. VEHICLE #3 HAD EXTENSIVE FRONT END DAMAGE. VEHICLE #3 WAS OPERATIONAL AND DRIVER WAS TAKING IT TO A BODY SHOP. ALL PARTIES REPORTED NO INURIES. ALL PARTIES ADVISED TO CONTACT THEIR INSURANCE COMPANIES. CLEARED WITHOUT FURTHER INCIDENT
Keywords:
Bus, Crash, Severe
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3548919
Longitude:
-71.200433
Location:
Case
number:
Date:
2021-12-09
Time:
07:47
Address:
1321 WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
Operator of MV1 (MA commercial registration M64535) was stopped facing eastbound on Washington at the red light at the intersection with Highland Street. Operator of MV2 (RI registration 387084) approached the intersection behind MV1 and attempted to stop by due to the icy road conditions, was unable to come to a complete stop in time and slid on black ice into the rear of MV1. MV2 sustained extensive damage to the front end.
Keywords:
Ice, Severe
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3494467
Longitude:
-71.2276058
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);