crash_reports
2 rows where dcc contains "Swerving", intersection = 0 and "retrieved" is on date 2020-10-07
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-10-16
Time:
23:38
Address:
15 NEEDHAM ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On 10/16/19 at 2338 I responded to the area of 15 Needham St for a report of a single vehicle accident with the car into a pole and no one inside the vehicle. Upon arrival MA Reg 7TM878 was facing SW on Needham St leaned up against a telephone pole (#2) with heavy front end damage. Units searched the area for the operator and Officer Keefe located the party in the McDonalds up the street. The operator of MV#1 stated he was turning right onto Needham St from Winchester St when his power steering locked and he couldn't redirect his truck away from the curb and telephone pole. He further stated he left his truck because it was raining and his door wouldn't close. Medics responded to evaluate the operator, who signed a patient refusal. Tody's towing responded and towed the vehicle.
Keywords:
Crash, Rain
Dcc:
Swerving, Over-steering
Report
url:
Image
url:
Latitude:
42.3168424
Longitude:
-71.2097042
Location:
Case
number:
Date:
2019-12-01
Time:
18:16
Address:
OAK ST.
Speed
limit:
20
Violation
cited:
no
Narrative:
MV#1 was traveling southbound on Oak St. Due to the snowy, wet conditions MV#1 lost traction with the roadway and skidded into the Saco St. sign. Damage was observed to the driver side front bumper of MV#1. No injuries were reported and MV#1 was able to be driven from the scene. The Saco St. sign was damaged and left on the side of the road. The city of Newton Public Works Deptartment was notified about the damage to the sign and photos of the damage were given to the Newton Police IT Bureau.
Keywords:
Pictures, Snow
Dcc:
Swerving
Report
url:
Image
url:
Latitude:
42.3096255
Longitude:
-71.2205779
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);