crash_reports
2 rows where intersection = 0, keywords contains "Severe" and "retrieved" is on date 2021-12-03
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-11-20
Time:
20:12
Address:
919 WATERTOWN ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
MV1 operator stated he was operating westbound on Watertown St by Dunstan St (both public ways). MV1 operator struck (side swiped) both the driver side's of MV2 and MV3 which were parked in front of 915 Watertown St. MV1 operator struck the curb in front of 919 Watertown St and left the roadway. After MV1 left the road way it hit and destroyed a fire hydrant owned and maintained by the City of Newton. MV1 operator then hit the private wall of 919 Watertown St and it was it's final resting location. MV1 sustained extensive and complete front end and under carriage damage, it was towed by Todys. MV2 sustained minor damage and paint transfer, no tow required. MV3 sustained extensive driver side wheel well damage, which will privately towed at a later time. MV1 operator stated he struck his head and was not feeling well; he was transported to Newton-Wellesley Hospital by Newton Medics. MV2 and MV3 were not occupied. The City of Newton was notified in regards to the fire hydrant.
Keywords:
Fire, Hospital, Severe
Dcc:
Fatigue/Sleep
Report
url:
Image
url:
Latitude:
42.3508899
Longitude:
-71.2229649
Location:
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);