crash_reports
1 row where dcc contains "Swerving", intersection = 0 and keywords contains "Severe"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-11-27
Time:
10:52
Address:
1061 WASHINGTON ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
ON 11-27-21 AT APPROX. 1052HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT 1049 WASHINGTON ST. I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES HE WAS TRAVELING W-BOUND ON WASHINGTON ST. HE STATES VEHICLE #2 PULLED IN FRONT OF HIM CUTTING HIM OFF AND IN AN EFFORT TO AVOID HITTING HER HE STRUCK A UTILITY POLE IN FRONT OF 1049 WASHINGTON ST. VEHICLE #2 STATES SHE WAS DRIVING E-BOUND ON WASHINGTON ST ATTEMPTING TO TURN LEFT ONTO EDDY ST. DRIVER STATES SHE SAW VEHICLE #1 APPROACHING BUT HE WAS FAR ENOUGH AWAY FOR HER TO TURN LEFT. DRIVER #2 STATES VEHICLE #1 SPED UP AS SHE WAS TURNING AND SWERVED LEFT AVOIDING HITTING HER AND WENT ACROSS THE E-BOUND LANE EVENTUALLY STOPPING WHEN HE CRASHED INTO THE UTILITY POLE IN FRONT OF 1049 WASHINGTON ST. VEHICLE #1 HAD EXTENSIVE FRONT END DAMAGE AND FRONT AIRBAG DEPLOYMENT. VEHICLE #2 HAD NO DAMAGE AND WAS NOT INVOLVED IN THE ACCIDENT. BOTH PARTIES REPORTED NO INJURIES. DRIVER #1 WAS EVALUATED BY MEDICS AND SIGNED A PATIENT REFUSAL. VEHICLE #1 WAS TOWED BY TODYS. ALL PARTIES ADVISED TO CONTACT THEIR INSURANCE COMPANIES. THE UTILITY POLE AT 1049 WASHINGTON ST WAS CUT IN HALF AS A RESULT OF THE CRASH. THE BOTTOM HALF WAS ON THE GROUND. THE TOP HALF WAS AIRBORNE AND HELD UP BY THE ATTACHED WIRES.EVERSOURCE ARRIVED ON SCENE TO FIX THE POLE. DRIVER OF VEHICLE #1 STATED HE DID NOT HAVE A LICENSE AND OFFERED ME A BRAZILIAN PASSPORT. I CITED THE DRIVER ( CITATION NUMBER# T2080809 ) FOR 90/10 UNLICENSED OPERATOR. DRIVER GIVEN CITATION IN HAND. I FILED FOR A CRIMINAL APPLICATION FOR THE OFFENSE. CLEARED WITHOUT FURTHER INCIDENT. WASHINGTON ST IS A PUBLIC WAY IN THE CITY OF NEWTON.
Keywords:
Airbag, Citation, Crash, Severe
Dcc:
Swerving
Report
url:
Image
url:
Latitude:
42.3503932
Longitude:
-71.2166301
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);