Dataset: Crime In Baltimore

About this Dataset

Crime In Baltimore

All BPD data on Open Baltimore is preliminary data and subject to change. The information presented through Open Baltimore represents Part I victim based crime data. The data do not represent statistics submitted to the FBI's Uniform Crime Report (UCR); therefore any comparisons are strictly prohibited. For further clarification of UCR data, please visit http://www.fbi.gov/about-us/cjis/ucr/ucr. Please note that this data is preliminary and subject to change. Prior month data is likely to show changes when it is refreshed on a monthly basis. All data is geocoded to the approximate latitude/longitude location of the incident and excludes those records for which an address could not be geocoded. Any attempt to match the approximate location of the incident to an exact address is strictly prohibited.

Acknowledgements

This dataset was kindly made available by the City of Baltimore. You can find the original dataset, which is updated regularly, here.

Tables

Bpd Part 1 Victim Based Crime Data

@kaggle.sohier_crime_in_baltimore.bpd_part_1_victim_based_crime_data

6.95 MB
276529 rows
15 columns


CREATE TABLE bpd_part_1_victim_based_crime_data (
  "crimedate" TIMESTAMP,
  "crimetime" VARCHAR,
  "crimecode" VARCHAR,
  "location" VARCHAR,
  "description" VARCHAR,
  "inside_outside" VARCHAR,
  "weapon" VARCHAR,
  "post" DOUBLE,
  "district" VARCHAR,
  "neighborhood" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "location_1" VARCHAR,
  "premise" VARCHAR,
  "total_incidents" BIGINT
);