Summary

This comprehensive project contains 55 unique questions regarding police killings, misconduct, and or personnel from 330+ law enforcement agencies across Louisiana spanning 60+ years, for a total of 120,000+ quick facts. We created this project to make actionable insights easy to search, find, and share.

Sources

The data for this tool is sourced from:

• Louisiana Law Enforcement and Accountability Database
• Mapping Police Violence
• FBI Crime Explorer Law Enforcement Personnel Data

Replicating

1. Clone

Clone the repository to your local machine:

git clone https://github.com/aclu-national/LA_police_facts

2. Data

Open the data_creation.Rproj project and run master_script.R. This should download df.csv inside the app_creation folder.

3. App

Open the app_creation.Rproj project and run app.R. This should create the app.

Git Structure

LA_police_facts
├── README.md
├── app_creation
│   ├── LA_police_facts_app.Rproj
│   ├── app.R
│   ├── df.csv
│   └── rsconnect
│       └── shinyapps.io
│           └── laaclu
│               └── test2.dcf
├── data_creation
│   ├── data
│   │   ├── killing_data
│   │   │   ├── 2024-01-11
│   │   │   │   └── Mapping Police Violence.csv
│   │   │   ├── 2024-03-01
│   │   │   │   └── Mapping Police Violence.csv
│   │   │   ├── 2024-03-25
│   │   │   │   └── Mapping Police Violence.csv
│   │   │   ├── 2024-09-05
│   │   │   │   └── Mapping Police Violence.csv
│   │   │   ├── 2024-11-18
│   │   │   │   └── Mapping Police Violence.csv
│   │   │   ├── 2025-01-27
│   │   │   │   └── Mapping Police Violence.csv
│   │   │   ├── 2025-02-26
│   │   │   │   └── Mapping Police Violence.csv
│   │   │   ├── 2025-03-26
│   │   │   │   └── Mapping Police Violence.csv
│   │   │   ├── 2025-05-07
│   │   │   │   └── Mapping Police Violence.csv
│   │   │   ├── 2025-07-03
│   │   │   │   └── Mapping Police Violence.csv
│   │   │   └── cheat_sheet_killing.csv
│   │   ├── misconduct_data
│   │   │   ├── data_agency-reference-list.csv
│   │   │   ├── data_event.csv
│   │   │   └── misconduct.csv
│   │   └── overview_data
│   │       ├── 2024-02-27
│   │       │   └── pe_1960_2022.csv
│   │       ├── 2025-01-27
│   │       │   └── lee_1960_2023.csv
│   │       ├── 35158-0001-Codebook.pdf
│   │       ├── 35158-0001-Data.rda
│   │       └── cheat_sheet_overview.csv
│   ├── data_creation_master_script.R
│   ├── quick_fact_data_creation.Rproj
│   └── scripts
│       ├── killing_df_creation.R
│       ├── misconduct_df_creation.R
│       └── personnel_df_creation.R
└── image_facts.png

Disclaimer

All of the information accessible from this tool is generated using publicly accessible resources. As a result, we cannot verify the accuracy of any of the numbers generated.

Questions

If you have any questions or concerns about the content of this tool, you can contact eappelson@laaclu.org.