GitHunt
SA

SampleDataForChange/wapo-data-police-shootings

Washington Post's raw data about police shootings converted into ready-to-use databases (SQL Server, SQLite)

Police Shooting Data

Publishing Pause

Since the wapo repo changed its formatting with a new v2 data source, and stopped updating v1, this project is not able to pull in fresh data. I do not have time currently to make the necessary updates to get it to track the new data format, but welcome any contributions towards getting it fixed.


License
MSSQL 2012+
SQLIte 3.3

Build status

Sample Data For Change

This project aims to make the Washington Post's police shooting data more easily
accessible as sample data for examples, testing, and documentation as part of
Sample Data for Change.

Usage

Normalized databases are packaged into releases based off the latest raw data
available as of build time.

Documentation for the database is at wapo-data-police-shootings.md.

Formats supported:

  • SQL Server 2012+
  • SQLite 3.3

Attribution

This work, "wapo-data-police-shootings", is a derivative of
data-police-shootings
by the Washington Post, used under CC BY-NC-SA 4.0.

"wapo-data-police-shootings" is also licensed under CC BY-NC-SA 4.0
by John McCall / LowlyDBA.

Contributing

Want to see this data in more database formats? Open a request.

Languages

TSQL92.8%PowerShell7.2%

Contributors

Other
Created July 7, 2020
Updated August 16, 2023