crash_reports
2 rows where longitude = "-71.217724" and street1 = "SOUTH EDDY ST"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-12-02
Time:
18:28
Address:
EDDY ST & WATERTOWN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Monday, December 2nd, 2019 at approximately 1828 hours I, Officer Newton, and Officer Brooks responded to a 3 car motor vehicle accident at Watertown St and Eddy St. The operator of vehicle 1 stated he was stopped at the stop sign on Eddy St southbound when he proceeded to pull out to cross Watertown St when Vehicle 2, traveling eastbound on Watertown St, hit their car causing them to also collide with vehicle 3. The operator of vehicle 2 stated she was driving eastbound on Watertown St. when vehicle 1 suddenly pulled out in front of her causing the collision. The operator of vehicle 3 stated she was at the stop sign on Eddy St northbound, opposite of vehicle 1's stop sign on Eddy St, when Vehicle 1 pulled out and caused vehicle 2 to hit vehicle 1 and vehicle 2 to hit her. All parties involved declined medical attention. All 3 vehicles were able to safely drive away from the scene.
Keywords:
Crash
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3526115
Longitude:
-71.217724
Location:
Case
number:
Date:
2021-02-10
Time:
08:38
Address:
EDDY ST & WATERTOWN ST
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 2-10-21 AT APPROX. 0838HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT THE INTERSECTION OF WATERTOWN ST AND EDDY ST. I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES HE WAS TRAVELING W-BOUND ON WATERTOWN ST. WHILE TRAVELING HE SAW VEHICLE #2 STOP AT THE STOP SIGN ON ELLIOT AVE ( OPPOSITE EDDY ST). AS HE CONTINUED TO TRAVEL HE STATES VEHICLE #2 ENTERED THE TRAFFIC LANE ABRUPTLY AND HE WAS UNABLE TO AVOID HITTING HER. OPERATOR OF VEHICLE #2 WAS TRANSPORTED ALONG WITH HER DAUGHTER TO NEWTON WELLESLEY HOSPITAL BY MEDIC2 FOR EVALUATION. VEHICLE #1 HAD FRONT END DAMAGE. VEHICLE #2 HAD EXTENSIVE LEFT SIDE DAMAGE AND SIDE AIRBAG DEPLOYMENT. BOTH VEHICLES WERE TOWED BY TODYS. OPERATOR OF VEHICLE #1 REPORTED NO INJURIES. PARTIES ADVISED TO CONTACT THEIR INSURANCE COMPANIES. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Airbag, Crash, Hospital, Severe
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3526115
Longitude:
-71.217724
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);