crash_reports
1 row where dcc_code = "[2]", intersection = 0 and keywords contains "Severe"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
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:
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);