crash_reports
2 rows where keywords contains "Severe" and "retrieved" is on date 2021-02-19
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-02-01
Time:
07:53
Address:
41 BRIDGE ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On February 1st, 2021 at approximately 07:53 hours while assigned to N491 I responded to MV crash in front of #41 Bridge St. On my arrival I observed a large white box style truck crashed into a gray SUV both vehicles with extensive damage blocking the street completely. I first identified the operator of the box truck, Maurizio Didonna. The truck belonged to Russo's & Sons out of Pleasant St Watertown Ma. Mr Didonna reported driving S/B on Bridge St when he temporarily got distracted before crashing into a parked vehicle in front of #41 Bridge St. The owner of the parked vehicle was not on scene but a male construction worker who was building a new house at #41 Bridge St identified the vehicles owner as Jose Ramirez. He was able to make contact with him and informed him about the accident. Both vehicles were towed from the scene. One by Todys. Russo's & Sons truck was towed by Pro Tech out of Watertown. Mr Didonna had a minor injury but refused any medical treatment. Note:The parked SUV had a lot of construction equipment in the rear but was removed by the construction workers from the job site at #41 Bridge St. The parked car was affiliated with the construction site. The vehicles owner was notified to where his vehicle was being towed to. .
Keywords:
Crash, Distracted, Severe
Dcc:
Distracted
Report
url:
Image
url:
Latitude:
42.3638001
Longitude:
-71.2039138
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);