Dataset: Providence Police Case Log - Past 180 Days

About this Dataset

Providence Police Case Log - Past 180 Days

Recorded state and municipal offenses from AEGIS records management system of the Providence Police. A single case can contain multiple offenses. Refer to the case number to see all offenses for a particular case. The case number can also be used to look up arrest activity for a case in the Providence Police Arrest Log.
UPDATE:
Incident location is now using block range instead of house numbers. Addresses between 1 and 99 will be 0 Block, addresses between 100 and 199 will use 100 block and so on. If you are looking for actual addresses you can use the city's Open Records Portal to make a request.

To help maintain the anonymity of special victims and juveniles this list does not include violent sexual offenses, non-violent sexual offenses or incidents of harassment. Cases being investigated by the department's Special Victims Unit (SVU) or Youth Services Bureau (YSB) will not be published.
Organization: City of Providence
Last updated: 2020-11-12T12:31:58.681550
Tags: crime, police, safety

Tables

Table 1

@usgov.city_of_providence_providence_police_case_log_past_180_days.table_1

158.14 KB
5854 rows
10 columns


CREATE TABLE table_1 (
  "casenumber" VARCHAR,
  "location" VARCHAR,
  "reported_date" VARCHAR,
  "month" BIGINT,
  "year" BIGINT,
  "offense_desc" VARCHAR,
  "statute_code" VARCHAR,
  "statute_desc" VARCHAR,
  "counts" BIGINT,
  "reporting_officer" VARCHAR
);