crash_reports
2 rows where "date" is on date 2022-05-23 and dcc contains "Inattention"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-05-23
Time:
14:57
Address:
COMMONWEALTH AVE & TEMPLE ST
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 5-23-22 AT APPROX. 1457HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT THE INTERSECTION OF TEMPLE AND COMM AVE. I SPOKE TO DRIVER #1. DRIVER STATES SHE WAS STOPPED AT THE STOP SIGN AT TEMPLE AND COMM. PREPARING TO CROSS OVER COMM TO CONTINUE SOUTH ON TEMPLE ST. AS SHE HEADED INTO THE TRAFFIC LANE SHE WAS HIT BY VEHICLE #2. DRIVER OF VEHICLE #2 STATES HE WAS TRAVELING W--BOUND ON COMM. AVE. HE STATES VEHICLE #1 ENTERED THE TRAFFIC LANE ABRUPTLY AND HE WAS UNABLE TO AVOID HITTING HER. VEHICLE #1 HAD FROTE END AND LEFT QTR. PANEL DAMAGE AS WELL AS A BENT LEFT TIRE AND A LEFT REAR BRAKE LIGHT DAMAGE. VEHICLE #2 HAD FRONT RIGHT QTR. PANEL DAMAGE. DRIVER OF VEHICLE #1 WAS TRANSPORTED BY MEDICS TO NEWTON WELLESLEY HOSPITAL FOR POSSIBLE INJURY. DRIVER OF VEHICLE #2 REPORTED NO INJURY. VEHICLE #1 WAS TOWED BY TODYS. VEHICLE #2 WAS RECOMMENDED BY TODYS TO BE TOWED BUT THE DRIVER PREFERRED TO DRIVE IT HOME HIMSELF. ALL PARTIES WERE ADVISED TO CONTACT THEIR INSURANCE COMPANIES. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Crash, Hospital
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3392936
Longitude:
-71.233645
Location:
Case
number:
Date:
2022-05-23
Time:
16:28
Address:
LORING ST & WARD ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On May 23, 2022 at approximately 16:28 hours I responded to the area of Ward St at Loring St for a two car motor vehicle crash. Upon arrival, all parties were on scene and out of their vehicles. It was determined that MV1 was backing out of the driveway of 31 Loring St, which is on Ward St and backed into MV2, which was parked facing westbound in the eastbound lane. There was visible damage on MV1's Rear Passenger side bumper and visible damage on MV2's passenger side. It should be noted that the passenger side mirror had existing damage prior to the crash. I spoke with the owner of MV2, who was aware of the crash and I advised her that her vehicle was parked facing the wrong direction. I informed the involved both parties that a crash report would be on file and how to obtain it.
Keywords:
Crash
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.33816
Longitude:
-71.1919792
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);

