crash_reports
3 rows where dcc contains "Inattention" and street1 = "30 WEST COMMONWEALTH AVE"
This data as json, CSV (advanced)
Suggested facets: street2, speed_limit, dcc, dcc_code, geocoded_address, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-02-14
Time:
08:15
Address:
COMMONWEALTH AVE & TEMPLE ST
Speed
limit:
35
Violation
cited:
no
Narrative:
Operator of vehicle #1 stated she was travelling Westbound on Commonwealth Ave when her vehicle was struck suddenly by vehicle #2. Operator of vehicle #1 Stated that he was travelling North bound and stopped at the stop sign at the intersection of Temple St. and Commonwealth Ave. Operator #1 entered the travel lane and struck vehicle #1. A passenger in vehicle #2 (Uber Vehicle) was transported to NWH by a family member prior to the arrival of EMS. Both vehicles were towed due to extensive damage.
Keywords:
Ems, Severe
Dcc:
Signs/Signals, Inattention
Report
url:
Image
url:
Latitude:
42.3392936
Longitude:
-71.233645
Location:
Case
number:
Date:
2021-10-01
Time:
07:45
Address:
COMMONWEALTH AVE & TEMPLE ST
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 10-1-21 AT APPROX. 0745HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT THE INTERSECTION OF COMMONWEALTH AVE AND TEMPLE ST. I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES HE WAS TRAVELING W-BOUND ON COMMONWEALTH AVE. HE SAW VEHICLE #2 STOPPED AT THE STOP SIGN AT THE CORNER OF TEMPLE AND COMM. HE STATES VEHICLE #2 ENTERED THE TRAFFIC LANE ABRUPTLY AND TRIED TO GO LEFT. VEHICLE #1 STATES HE SWERVED TO THE RIGHT TO AVOID HITTING VEHICLE #2 STRAIGHT ON BUT WAS UNABLE TO AVOID HITTING HIM ALTOGETHER. VEHICLE #2 STATES HE WAS STOPPED AT THE STOP SIGN AT TEMPLE AND COMM. HE STATES HE HEADED ONTO COMM AVE GOING E-BOUND. AT THIS TIME VEHICLE #1 CAME OVER THE HILL AT A HIGH RATE OF SPEED AND THAT WAS WHY HE WAS HIT BY VEHICLE #1. VEHICLE #1 HAD LEFT FRONT END DAMAGE. VEHICLE #2 HAD LEFT REAR SIDE DAMAGE. BOTH PARTIES REPORTED NO INJURIES. BOTH PARTIES ADVISED TO CONTACT THEIR INSURANCE COMPANIES. CLEARED WITHOUT FURTHER INCIDENT. NEITHER VEHICLE WAS TOWED.
Keywords:
Crash, Speed
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3392936
Longitude:
-71.233645
Location:
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:
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);