About this Dataset

Legacy Baton Rouge Police Crime Incidents

***On January 1, 2021, the Baton Rouge Police Department switched to a new reporting system. This dataset contains data starting on 1/1/2011 through 12/31/2020. For data from 1/1/2021 onward, please visit: https://data.brla.gov/Public-Safety/Baton-Rouge-Police-Crime-Incidents/pbin-pcm7

Crimes reported in Baton Rouge and handled by the Baton Rouge Police Department. Crimes include Burglaries (Vehicle, Residential and Non-residential), Robberies (Individual and Business), Theft, Narcotics, Vice Crimes, Assault, Nuisance, Battery, Firearm, Homicides, Criminal Damage to Property, Sexual Assaults and Juvenile. In order to protect the privacy of sexual assault victims and juvenile victims, these incidents are not geocoded and will not be mapped.

Please see the disclaimer in the Attachments section of the About page.
Organization: City of Baton Rouge
Last updated: 2020-11-12T14:59:58.454791
Tags: brpd, crime, police

Tables

Table 1

@usgov.city_of_baton_rouge_baton_rouge_crime_incidents.table_1

24.33 MB
490,578 rows
22 columns

CREATE TABLE table_1 (
  "file_number" DOUBLE,
  "offense_date" TIMESTAMP,
  "offense_time" VARCHAR,
  "crime" VARCHAR,
  "committed" VARCHAR,
  "offense" VARCHAR,
  "offense_description" VARCHAR,
  "full_address" VARCHAR,
  "address_number" DOUBLE,
  "street_direction" VARCHAR,
  "street_name" VARCHAR,
  "street_type" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" DOUBLE,
  "district" VARCHAR,
  "zone" VARCHAR,
  "subzone" VARCHAR,
  "complete_district" VARCHAR,
  "council_district" DOUBLE,
  "crime_prevention_district" VARCHAR,
  "geolocation" VARCHAR
);