crash_reports
4 rows where dcc = "["Speeding"]", intersection = 0 and keywords contains "Citation"
This data as json, CSV (advanced)
Suggested facets: speed_limit, hit_run, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-11-17
Time:
12:57
Address:
109 FALMOUTH RD
Speed
limit:
25
Violation
cited:
yes
Narrative:
Operator 1 of vehicle 1 was on Falmouth Rd heading W/B and was going too quick around the corner, lost contol and jumped the curb colliding with a tree in front of 101 Falmouth Rd. Moderate damage to the front of vehicle 1. No damage to the tree. Minor Injuries to operator 1 and passenger 1. Vehicle towed by todys towing. Operator was issued citation (T2015498) for c90s17 Speeding and c89s4A Marked Lanes violation.
Keywords:
Citation, Moderate, Speed, Tree
Dcc:
Speeding
Report
url:
Image
url:
Latitude:
42.3607487
Longitude:
-71.2304134
Location:
Case
number:
Date:
2021-05-12
Time:
21:14
Address:
2150 WASHINGTON ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
The OP. of MV#1 stated while traveling westbound on Washington Street, just passing Beacon Street, his vehicle suddenly struck a curb and he lost control of the vehicle. He ended up on the lawn of the Northland Building at 2150 Washington Street. Based on the accident scene, its appears that MV#1 went over the median on Washington Street, took down a city sign, hit the corner of Neshobe Road and the driveway into 2150 Washington Street which formed a ramp that launched his vehicle into the air. MV#1 spun around somehow and was now facing eastbound before the rear of the vehicle was wedged between a tree and a mound of dirt. Final resting position of MV#1 is approx. 250 feet from the median first struck. The operator of MV1 was transported to Newton-Wellesley Hospital for a head laceration and other unknown injures. Vehicle was towed from the scene by todys with major damage all over the vehicle. After reviewing surveillance video, the OP. of MV#1 was mailed MA. citation #T2014846 for violation of MGL Ch 89 Sec 4A - "Marked lanes violation" and Ch 90 Sec 17 - "Speed greater than reasonable."
Keywords:
Citation, Crash, Hospital, Tree
Dcc:
Speeding
Report
url:
Image
url:
Latitude:
42.3291503
Longitude:
-71.2501096
Location:
Case
number:
Date:
2021-11-21
Time:
17:20
Address:
191 JACKSON RD
Speed
limit:
25
Violation
cited:
yes
Narrative:
On Sunday November 21st at approx. 1720 Hrs. I responded to 191 Jackson Rd for a motor vehicle accident roll over with entrapment. Upon arrival I witnessed MV1 on its side in the middle of Jackson Rd. The operator of MV1 was conscious and alert and was taken out of the MV by the Newton Fire Department. The operator of MV1 stated that she was driving S/B on Jackson Rd. and she did not see the parked car on the right side of the road. MV1 then tried to swerve around MV2 and clipped the left rear bumper, and left rear door of MV2 which caused MV1 to roll over onto the middle of the road. MV1 had major damage all around the vehicle and all airbags deployed. MV2 had major damage to the rear and to the left side of the MV. Due to the extensive damage and length of travel of MV1 it was estimated that MV1 was traveling at a speed greater than 35 MPH. Speed limit for Jackson Rd is 25 MPH. MV2 was pushed approx. 20 feet from where it was parked, and MV1 travelled approx 25 feet after on its drivers side after impact. The operator of MV1 was transported by EMS to NWH, and Todys's took possession of both motor vehicles. Pictures were taken and submitted to IT. The operator of MV1 was cited 90/17, speeding.
Keywords:
Airbag, Citation, Crash, Ems, Fire, Pictures, Severe, Solar, Speed
Dcc:
Speeding
Report
url:
Image
url:
Latitude:
42.3564835
Longitude:
-71.195531
Location:
Case
number:
Date:
2022-04-21
Time:
17:23
Address:
384 BROOKLINE ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
OPERATOR 1 OF MV 1 WAS TRAVELING S/B ON BROOKLINE ST BY REDWOOD RD AND STATED THEY WERE TRAVELING GREATER (APPROX 40MPH) THAN THE POSTED SPEED LIMIT (30MPH) AND LOST CONTROL OF THE CAR AND CROSSED OVER THE DOUBLE YELLOW LINE AND STRUCK THE VERIZON UTILITY POLE (POLE #55/1) PASSENGER WAS INJURED AND TRANSPORTED TO THE BI NEEDHAM. OPERATOR WAS NOT INJURED AND SIGNED A REFUSAL WITH MEDICS. MAJOR DAMAGE TO MV 1, TOWED BY TODYS. VERIZON NOTIFIED FOR THE DAMAGE TO THE POLE. CITATION ISSUED TO OPERATOR 1 (MA T2012684) FOR c89s4A MARKED LANES VIOLATION AND c90s17 SPEEDING. TOWED MV SHEET COMPLETED PER DEPT PROTOCOL.
Keywords:
Citation, Speed
Dcc:
Speeding
Report
url:
Image
url:
Latitude:
42.3011172
Longitude:
-71.1828427
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);