crash_reports
1 row where intersection = 0, "retrieved" is on date 2021-09-24 and violation_cited = 1
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-09-22
Time:
16:25
Address:
0 DEDHAM ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
On 9/22/21, Sgt Walton was in N506 (first half). H was attempting to stop a fleeing suspect after a shop lifting incident. MV Operator #1, Newton Police Sgt Walton attempted to block an egress from a parking lot located at #0 Dedham Street. This is the driveway to and from the Newton Highlands Playground. The suspects mv struck the rear passenger side of N506, causing moderate damage. (see police incident #21040584). Pictures taken and attached to report. MV Operator 2, Demaris Hardy admitted that he was trying to flee when he made contact with the newton cruiser. MV operator #2 was cited by Newton Officer Crowe for the crash: > Chp 90/24 operating to endanger > Chp 90/24/2 leaving the scene of property damage > Chp 90/23 operating a mv with a suspended license
Keywords:
Citation, Crash, Moderate, Pictures
Dcc:
Reckless driving, Other improper action
Report
url:
Image
url:
Latitude:
42.29941
Longitude:
-71.18717
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);