crash_reports
2 rows where keywords contains "Hospital" and "retrieved" is on date 2021-07-04
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-06-23
Time:
08:57
Address:
33 BROOKLINE ST
Speed
limit:
30
Violation
cited:
no
Narrative:
VEHICLE #1 WAS IN THE PROCESS OF PULLING OUT OF HIS DRIVEWAY, WHICH IS LOCATED AT 33 BROOKLINE ST. VEHICLE #2 WAS TRAVELING DOWN BROOKLINE ST, HEADING EASTBOUND. WHEN VEHICLE #2 PASSED BY VEHICLE #1 THE COLLISION OCCURRED. IT IS UNKNOWN AT THIS TIME WHETHER VEHICLE #1 STRUCK VEHICLE #2 OR VEHICLE #2 STRUCK VEHICLE #1. BOTH PARTIES DECLINED MEDICAL TREATMENT, VEHICLE #2 OPERATOR DID STATE THAT HE WAS A LITTLE SHAKEN UP, I ASKED IF HE WOULD LIKE TO BE SEEN BY AN AMBULANCE, HE DECLINED AND STATED THAT IF HE FELT THE NEED, HE WOULD DRIVE HIMSELF TO THE HOSPITAL AT A LATER TIME. VEHICLE OPERATOR #1 STATES THAT HE THOUGHT THE COAST WAS CLEAR AS HE WAS PULLING OUT, AND VEHICLE #2 WAS SPEEDING AS HE WAS HEADING DOWN BROOKLINE ST, VEHICLE OPERATOR #2 STATES THAT VEHICLE #1 CUT HIM OFF. I RECEIVED A CALL FROM THE HOMEOWNER TODAY (JUNE 24, 2021) A MR GUY MORRIS. HE STATED THAT HIS SON TYLER WAS INVOLVED IN THE ACCIDENT YESTERDAY. HE STATED THAT HE HAS HOME VIDEO SURVEILLANCE, AND THAT THE SURVEILLANCE CLEARLY SHOWS VEHICLE OPERATOR #2 DRIVING DOWN BROOKLINE ST AT A HIGH RATE OF SPEED AND NOT YIELDING TO VEHICLE #1 (HIS SON) WHO WAS PULLING OUT OF HIS DRIVEWAY. I ADVISED MR MORRIS TO FORWARD THIS VIDEO TO HIS INSURANCE COMPANY, ACCORDING TO MR MORRIS THIS VIDEO CLEARLY SHOWS VEHICLE #2 AT FAULT IN THIS ACCIDENT. HE HAS ALREADY TALKED TO HIS INSURANCE AGENT, AND IS IN THE PROCESS OF SENDING THEM THE COPY, WHICH SHOWS VEHICLE #2 FAILING TO YIELD.
Keywords:
Crash, Ems, Hospital, Speed
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.307265
Longitude:
-71.1711
Location:
Case
number:
Date:
2021-06-27
Time:
14:06
Address:
275 DUDLEY RD
Speed
limit:
25
Violation
cited:
yes
Narrative:
On 06/27/21 at approximately 14:06 I responded across from #295 Dudley Rd. for a single vehicle crash.When I arrived I witnessed Veh#1 was on its drivers side resting against pole #34. The operator was already out of the car sitting on the stone wall next to it. The Operator of veh #1 stated he was driving due North on Dudley Rd. driving the speed limit when he saw a jogger (witness #2) in his lane. He then swerved into the left lane when he saw an oncoming car. He then swerved back to the right and rolled his vehicle coming to rest beside Eversource Pole #34. The vehicle was towed by Tody's towing. The operators father showed up on scene before he signed a patient refusal to go to the hospital. Father stated he would take his son later by car to have his right forearm checked out because of airbag rash. Operator of veh #1 cited in hand Mass. #T2080856 for Ch 90/ Sec 17 Speeding estimated 50mph in a 25 Zone.
Keywords:
Airbag, Citation, Crash, Hospital, Speed
Dcc:
Too fast for conditions
Report
url:
Image
url:
Latitude:
42.3123404
Longitude:
-71.1818448
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);