crash_reports
3 rows where "retrieved" is on date 2022-05-31 and speed_limit = 30
This data as json, CSV (advanced)
Suggested facets: intersection, hit_run, keywords, 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-24
Time:
17:36
Address:
400 CENTRE ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Operator of MV1 (MA reg BC7929) stated he was traveling EB on Centre Ave across from 400 Centre St when a vehicle in the far left lane attempted to enter his lane. Operator of MV1 stated the other vehicle sped up and upon entering his lane struck the front driver's side panel with the rear passenger side quarter panel. Operator of MV2 (MA reg 2ECX23) stated he was traveling EB on Centre Ave on the far left lane when attempted to enter in the lane to his immediate right. Operator of MV2 stated he noticed a space to safely enter the lane but when he attempted to enter the operator of MV1 sped up and struck his rear passenger side quarter panel. Both vehicles had minor damage mostly paint exchange. Both driver's stated they were not injured and did not require medical attention. Both vehicles were safely able to drive away from the scene.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3559661
Longitude:
-71.18448
Location:
Case
number:
Date:
2022-05-25
Time:
07:52
Address:
BEACON ST & WALNUT ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Operator of MV1 states he was traveling on Beacon Street somewhere in the area by Walnut Street when a green garbage truck (unknown make, model or registration plate) backed into his companies work truck and damaged the front windshield. Operator of MV1 states he doesn't think the operator of the garbage truck knew he struck MV1 and left the scene. Operator of MV1 will be contacting his employer for a private tow. No injuries.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3308369
Longitude:
-71.2070206
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);