crash_reports
1 row where dcc contains "Unknown", "retrieved" is on date 2022-05-25 and speed_limit = 15
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-05-17
Time:
14:37
Address:
1188 CENTRE ST
Speed
limit:
15
Violation
cited:
no
Narrative:
Operator of MV#1 parked her vehicle in a parking spot behind 1188 Centre St at 0800. When she returned to her vehicle at 1200 there was moderate damage to the left rear door of the vehicle. It appears the vehicle was sideswiped by a vehicle that left the scene. White paint transfer indicates the other vehicle would be white in color. At the time of this report, I am waiting to hear back from Keith Scott - Management, regarding cameras. On 5/19/22 I spoke with Jean Lew who stated the only camera that may have potentially faced the parking lot would be the ATM camera. Citizens Bank would only release that information to a police officer. I spoke with Det Koerber about obtaining contact information for Citizens Bank. To be followed up.
Keywords:
Moderate
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.331746
Longitude:
-71.1937265
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);