RequestAtlas: Supporting the Slow and Iterative Process of Requesting Public Records
Rachel B. Warren, Lisa Pickoff-White, Aditya G. Parameswaran, Niloufar Salehi
Abstract
Public records requests are a central mechanism for government transparency. In practice, they are slow, complex processes that require analyzing large amounts of messy, unstructured data. In this paper, we introduce RequestAtlas, a system that helps investigative journalists review large quantities of unstructured data that result from submitting many public records requests. RequestAtlas was developed through a year-long participatory design collaboration with the California Reporting Project (CRP), a journalistic collective researching police use of force and police misconduct in California. RequestAtlas helps journalists evaluate the results of public records requests for completeness and negotiate with agencies for additional information. RequestAtlas has had significant real-world impact. It has been deployed for more than a year to identify missing data in response to public records requests and to facilitate negotiation with public records request officers. Through the process of designing and observing the use of RequestAtlas, we explore the technical challenges associated with the public records request process and the design needs of investigative journalists more generally. We argue that public records requests represent an instance of an adversarial technical relationship in which two entities engage in a prolonged, iterative, often adversarial exchange of information. Technologists can support information-gathering efforts within these adversarial technical relationships by building flexible local solutions that help both entities account for the state of the ongoing information exchange. Additionally, we offer insights on ways to design applications that can assist investigative journalists in the inevitably significant data cleaning phase of processing large documents while supporting journalistic norms of verification and human review. Finally, we reflect on the ways that this participatory design process, despite its success, lays bare some of the limitations inherent in the public records request process and in the ''request and respond'' model of transparency more generally.
Ask about this paper
Ask your agent about it.
Lune has read the top-tier papers around this one, so every answer names the papers it rests on.
Related papers
- Privacy versus Transparency: Navigating Public Records Requests and Adversarial Dynamics in a Distributed Multi-Stakeholder CollaborationRachel E. Moran, Sukrit Venkatagiri, Emma S. Spiro, Kate StarbirdCSCW 2025 · 1 citation
- Table Scraps: An Actionable Framework for Multi-Table Data Wrangling From An Artifact Study of Computational JournalismStephen Kasica, Charles Berret, Tamara MunznerIEEE VIS 2020 · 32 citations
- Design for Civic Quality of Life ThingsGraham Dove, Eric CorbettCHI 2025 · 1 citation
- Embracing Chaos Again: Tracing Boundary Negotiating Artifacts in Knowledge Workers' Data Practices for Collaborative Public Health Crisis ResponseJian-Sin Lee, Tiffany C. Veinot, Elizabeth YakelCHI 2026 · 1 citation
- Towards Understanding and Supporting Journalistic Practices Using Semi-Automated News Discovery ToolsNicholas Diakopoulos, Daniel Trielli, Grace LeeCSCW 2021 · 33 citations
