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.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"brla-gov/legacy-baton-rouge-police-crime-incidents-fabb-cnnu\".\"legacy_baton_rouge_police_crime_incidents\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.