crash_reports
3 rows where "datetime" is on date 2021-10-01 and keywords contains "Crash"
This data as json, CSV (advanced)
Suggested facets: intersection, hit_run, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
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:
2021-10-01
Time:
11:33
Address:
222 AUSTIN ST
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 10-1-21 AT APPROX. 1133HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT 222 AUSTIN ST. I NOTICED A RED FIRE HYDRANT ACROSS THE STREET WAS DISLODGED ROM ITS BASE AND LAYING SIDEWAYS ON THE GROUND. I SPOKE TO A WITNESS WHO LIVES ACROSS THE STREET AT 222 AUSTIN ST. ( DALLAS PERKINS ). WITNESS STATES HE HAD HEARD THE CRASH AND SAW FROM HIS WINDOW A LARGE BOX TRUCK WITH A TRAILER ATTACHMENT THAT CONTAINED SEVERAL LANDSCAPING EQUIPMENT PIECES DRIVE AWAY FROM THE SCENE. WHEN HE NOTICED THE FIRE HYDRANT WAS KNOCKED OVER HE CALLED THE POLICE. WITNESS STATES FROM HIS VANTAGE POINT HE WAS UNABLE TO GET A PLATE OR OTHER IDENTIFIABLE MARKINGS. NEWTON PUBLIC WORKS WAS NOTIFIED TO REPLACE THE HYDRANT. N525 ( OFF GAUDET ) ARRIVED AND TOOK PICTURES OF THE SCENE AND THE DAMAGE. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Crash, Fire, Pictures
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3491731
Longitude:
-71.216911
Location:
Case
number:
Date:
2021-10-01
Time:
15:53
Address:
642 CENTRE STREET
Speed
limit:
30
Violation
cited:
no
Narrative:
On 10/01/2021, while assigned to N494, I, Officer Conary, responded to Centre Street and Hyde Ave for a report of a single vehicle accident. Upon arrival, I met with operator of MV1, who was outside of the vehicle. There was significant damage to the left front tire and front end. Operator of MV1 explained to me that she was traveling Northbound on Centre Street and next thing she remembered was being pulled over on the side of the road and not being able to drive the vehicle. Operator of MV1 stated she was not traveling fast because there was another vehicle in front of her. At this time, medics were called on scene for an evaluation. I was able to determine that MV1 was traveling Northbound on Centre Street, veered off to the right, struck the curb, which caused the tire to pop, and then the front end grazed the utility pole. Tody's towed the vehicle. Operator of MV1 was transported to the hospital. There was minor damage to the Verizon Utility Pole. No structural damage. Verizon was notified. The city was notified to clean debris in the road. Pictures of the utility pole were sent to IT to be uploaded accoridingly.
Keywords:
Crash, Hospital, Pictures
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3493258
Longitude:
-71.1868807
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);