All Library resources are free to download, use and remix (learn more)

Data Diagrams for Police Accountability Projects

These entity-relationship diagrams illustrate Berkeley Copwatch’s People’s Database for Police Accountability V2. They show the tables, fields or elements, and relationships employed in the database. For more details, download the Data Design Document as well.

We are sharing these documents as part of a set of resources that describe the Berkeley Copwatch data model, along with the data dictionary and controlled vocabularies and database template. We hope they can be used as a starting point and adapted by others who are designing their own community-centered police accountability databases.

If you have questions or would like to learn more about this project, visit or get in touch with

Region/Country United States
Topic(s) Archiving & Preservation, Data, Police Violence
Type Infographic
Language English