crash_reports
3 rows where keywords contains "Crash" and "retrieved" is on date 2021-04-01
This data as json, CSV (advanced)
Suggested facets: intersection, violation_cited, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-03-16
Time:
07:35
Address:
WASHINGTON ST & 95 OFF RAMP
Speed
limit:
25
Violation
cited:
no
Narrative:
On 3/16/2021 at approx 0735hrs while assigned to 497 I responded to the area of 2150 Washington St for a report of a two car crash w/o injury. Upon arrival Ma reg T21826 operated by Igor Belmudes and Ma Reg 9AP948 operated by Hannah Temple were off to the side of the road, I spoke with the operators who stated they were coming off the 95N Off Ramp in heavy traffic w/ Temple 9 merging onto Washington St when she was rear ended by Belmudes. no injuries or tows
Keywords:
Crash
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.2517449
Longitude:
-71.1615909
Location:
Case
number:
Date:
2021-03-22
Time:
17:48
Address:
COMMONWEALTH AVE & WOODBINE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 3/22/21 I responded to the intersection of Commonwealth Ave and Woodbine St for a single motor vehicle accident. On arrival, I had noticed the street sign to have been hit and slightly leaning. As I was observing, motor vehicle operator had pulled up and stated that he had hit the sign. He stated that the glare of the sun had caused him to not be able to see the sign. His stated he was okay and did not medical attention. His vehicle had some damage to the front end but was able to drive it home. I took photographs of the sign and vehicle.
Keywords:
Crash, Glare, Pictures, Solar
Dcc:
Glare
Report
url:
Image
url:
Latitude:
42.3471805
Longitude:
-71.2531645
Location:
Case
number:
Date:
2021-03-28
Time:
14:43
Address:
112 WALTHAM ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
ON 3-28-21 AT APPROX. 1443HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT 112 WALTHAM ST. I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES HE WAS TRAVELING N-BOUND ON WALTHAM ST. HE STATES HE STARTED TO SLIP AND SWERVED RIGHT OFF-ROAD ONTO THE FRONT YARD OF 112 WALTHAM ST. DRIVER DID DAMAGE TO EVERSOURCE TELEPHONE POLE ( # 439 ) ON THE WAY TO THE FRONT YARD OF 112 WALTHAM ST. DRIVER DID EXTENSIVE DAMAGE TO THE FRONT YARD OF 112 WALTHAM ( WOODEN FENCE, FRONT WOODEN STEPS, GRASS, SMALL GARDEN AND A BOULDER THAT SEPARATED THE DRIVEWAY FROM THE FRONT YARD). I SPOKE TO THE OWNER OF 112 WALTHAM ST ( BRIGITTE LAMARCHE, 112 WALTHAM ST., NEWTON, MA., 02465, DOB: 3-7-71 ). OWNER STATES SHE WAS IN THE REAR OF THE HOUSE WHEN SHE HEARD THE CRASH AND THEN CAME AND FOUND VEHICLE #1 IN HER YARD AFTER DOING DAMAGE TO HER FRONT YARD. IT IS UNKNOWN AT THIS TIME IF THE VEHICLES IN THE DRIVEWAY HAD DAMAGE FROM THE CRASH DUE TO MUD AND GRASS ALL OVER THE VEHICLES. OWNER OF VEHICLE #1 REPORTED NO INJURIES. VEHICLE #1 WAS TOWED BY TODYS. AS A RESULT OF THE CRASH I HAVE CHARGED THE OPERATOR OF VEHICLE #1 WITH ( T2080806, CRIMINAL APPLICATION, 90/24 DRIVING RECKLESSLY, 90/17 SPEED GREATER THAN REASONABLE, 90/23 ATTACHING PLATES ). PICTURES OF DAMAGE AND SCENE WERE TAKEN BY SGT. FLEMING AND SENT TO I.T. BOTH PARTIES WERE ADVISED TO CONTACT THEIR INSURANCE COMPANIES. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Crash, Pictures, Severe, Speed
Dcc:
Reckless driving
Report
url:
Image
url:
Latitude:
42.3627203
Longitude:
-71.2248083
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);