Data Diagrams for Police Accountability Projects



These entity-relationship diagrams illustrate Berkeley Copwatch’s People’s Database for Police Accountability. They show the tables, fields or elements, and relationships employed in the database.


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

Help WITNESS create more human rights change

Join us by subscribing to our newsletter.