crash_reports
3 rows where "datetime" is on date 2020-07-23 and keywords contains "Crash"
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, hit_run, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-07-23
Time:
12:13
Address:
HAMMOND ST & HAMMONDSWOOD RD
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of Motor Vehicle #1 stated that she was traveling Westbound on Hammond Street and all of a sudden a vehicle crossed in front of her and did not have time to stop. Operator of Motor Vehicle #1 stated she attempted to swerve right to avoid impact. Motor Vehicle # 1 sustained heavy front end damage. Operator of Motor Vehicle #2 stated that she was traveling Northbound on Hammondswood Road and stopped at the stop sign at the intersection of (Hammondswood Road & Hammond Street). Operator of Motor Vehicle # 2 stated that she looked both ways and then proceeded to drive forward and was then struck by Motor Vehicle #1 in what appeared to be traveling at a high rate of speed. Motor Vehicle #2 sustained major passengers side damage. Both parties sustained minor injuries and both parties signed medical refusal forms.
Keywords:
Crash, Speed
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3351954
Longitude:
-71.1775586
Location:
Case
number:
Date:
2020-07-23
Time:
13:39
Address:
ADAMS AVE & SHERIDAN ST
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 7-23-20 AT APPROX. 1339HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT HIT AND RUN. UPON ARRIVAL AT THE INTERSECTION OF SHERIDAN AND ADAMS AVE. I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES HE WAS TRAVELING W-BOUND ON ADAMS AVE APPROACHING SHERIDAN. DRIVER STATES VEHICLE #2 CAME E-BOUND OB ADAMS AVE. PASSED OVER SHERIDAN AND CLIPPED VEHICLE #1 DRIVER SIDE REAR VIEW MIRROR. DRIVER SHOWED ME THE SCRATCH THAT WAS LEFT ON THE VEHICLE MIRROR. DRIVER STATES VEHICLE #2 WAS A BLACK F-150. HE WAS UNABLE TO GET A PLATE NUMBER FOR THE TRUCK. DRIVER REPORTS NO INJURY. ADVISED TO CONTACT HIS INSURANCE COMPANY. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.358025
Longitude:
-71.233201
Location:
Case
number:
Date:
2020-07-23
Time:
16:50
Address:
1221 CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
At approximately 1650HRs on Thursday, July 23, 2020, I was dispatched to the area of 1221 Centre St. for a report of a three car motor vehicle crash. Upon speaking with the operator of MV 1 (MA Pass:376Y90), he stated he was traveling NB on Centre St. during a heavy downpour and in stop-and-go traffic conditions. He stated due to the impaired visibility caused by the weather, he was unable to see MV2. When he was able to see how close they were, he applied his breaks, but MV1 continued forward on the wet pavement and made contact with the rear of MV2. Upon Speaking with the operator of MV2 (MA Pass:1GWR81), she stated she was traveling NB on Centre St., when the rear of her vehicle was contacted by MV1. This caused her vehicle to continue forward on the wet pavement, despite appliying her brakes, and make contact with the rear of MV3. Upon speaking with the operator of MV3 (MA Pass: 5DB384), she stated she was traveling NB on Centre St., when the rear of her vehicle was contacted by MV2. Everyone involved then pulled to the side of the road to wait for police assistance. Upon my arrival, I noted that the road was wet, due to a heavy downpour which had just occurred. I also noted that there was a decent amount of traffic using the road, which is typical for this area at that time of day and would likely be exacerbated by the poor weather conditions. All parties involved reported that they were not injured and I assisted them in gathering each others pertinent information, so they could begin the process with their respective insurance companies. I noted the following damage: MV 1 sustained minor damage to its front bumper on the passenger's side, by and including its tow hook. MV 2 sustained minor damage to its lift gate on the driver's side and below its rear reflector on the same side. Additionally, MV2 sustained minor damage to its front bumper on the lower driver's side and the bumper cover access panel on the same side. MV 3 sustained minor damage to its lift gate on the passenger's side and to its rear bumper, just to the left and up from its tow hitch.
Keywords:
Crash, Impairment
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3310364
Longitude:
-71.19491
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);