crash_reports
1 row where "datetime" is on date 2019-11-20, hit_run = 0 and speed_limit = 5
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2019-11-20
Time:
11:09
Address:
25 CHESTNUT ST
Speed
limit:
5
Violation
cited:
no
Narrative:
On Wednesday, November 20, 2019, I met with Officer Lazarakis at 25 Chestnut Street, Newton for a report of damage to Newton Police unmarked cruiser 1325. Officer Lazarakis stated she was retrieving an item out of the front passenger side door of the 2017 Ford Fusion (MA: 7HD877) when she observed a medium size dent near the door. Officer Lazarakis stated she does not know when or where the damage occurred. The vehicle has been moved several times in the last few days. The vehicle is typically parked in the rear parking lot of 25 Chestnut Street. It appears the dent was caused by a vehicle backing into the side of the vehicle. I observed no paint transfer or any other physical evidence left by the unknown vehicle. Pictures were taken to document the damage to the front passenger side door and submitted to the IT Bureau. IT was asked to check the surveillance cameras at 25 Chestnut Street to see if the incident was captured. I checked the area for vehicles for damage consistent to the damage on 1325 with a negative result.
Keywords:
Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3488353
Longitude:
-71.2257494
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);