crash_reports
3 rows where keywords = "["Pictures"]" and "retrieved" is on date 2020-12-27
This data as json, CSV (advanced)
Suggested facets: date, intersection, speed_limit, hit_run, violation_cited, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-11-02
Time:
07:29
Address:
90 CRAFTS ST
Speed
limit:
10
Violation
cited:
no
Narrative:
On Monday 11/2/2020 at approx 0700hrs, while operating cruiser 504 and assigned N494, I was located at 90 Crafts St in Newton. While backing up my cruiser to turn around I struck a solid cement block, cracking the driver side tail-light and scratching the paint around it. It should be noted there was no signs of damage to the cement block. Photos were taken and submitted.
Keywords:
Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3551007
Longitude:
-71.2037235
Location:
Case
number:
Date:
2020-11-25
Time:
10:29
Address:
88 CENTRAL AVE & CHESLEY AVE
Speed
limit:
25
Violation
cited:
yes
Narrative:
On Wednesday November 25, 2020 at approximately 1029 hours I responded to 88 Central Ave for a MVA hit and run reported by Detail Officer T. McCarthy. MV1 operator was located in their driveway at their address. MV1 operator stated she attempted to back out of 88 Central Ave and did not realize she struck MV2, which was parked in front of 83 Central Ave. Central Ave is a public way. There was no reported injury at this time. Minor damage was done to both MVs, but no tow required. MV1 sustained rear right brake light damage ( broken) and paint transfer. MV2 sustained front left bumper damage and paint transfer. MV1 operator stated she did not have license at this time. MV1 operator driver status was confirmed suspended by Newton Dispatch. Please see incident report #20059699. Photos were forwarded to I.T. Bureau.
Keywords:
Pictures
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.353408
Longitude:
-71.2061415
Location:
Case
number:
Date:
2020-11-25
Time:
15:01
Address:
259 CENTRE ST
Speed
limit:
10
Violation
cited:
no
Narrative:
Operator 1 stated that he was parked in a designated parking space in the lot of 259 Centre street when he viewed mv#2 backing up and getting close to mv#1. Operator #1 stated that he beeped his horn to alert mv#2. Mv#2 then struck the front passenger side of mv#1. Operator of mv#2 stated that he was backing up and did not realize that mv#1 was still parked there, he had believed the vehicle had moved. Mv#2 struck mV#1 with the rear of the passenger side. No injuries. Minor damage and paint transfer. All vehicle could be driven from the scene. Photos taken.
Keywords:
Pictures
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3589894
Longitude:
-71.1853954
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);