I'm entitled to a spreadsheet, dang it!

  • Event: 2018 CAR Conference
  • Speakers: Steven Rich of The Washington Post; Sarah Ryley of The Trace; Annie Waldman of ProPublica
  • Date/Time: Saturday, Mar. 10 at 3:30pm
  • Location: Grand Ballroom II
  • Audio file: Only members can listen to conference audio

Public records requests for data come with their own unique set of challenges — from agencies that insist their databases can only export documents, to those that will only send a fraction of the fields that are disclosable under the law. We’ll give you tips on writing rock-solid public records request for data, and how to respond to the common excuses used to deny these requests. Topics will include: Common sources that prove the agency has a database and can export data; statute, case law and language to make it more likely you’ll receive data (versus a PDF, or even worse, scans of redacted printouts); how to negotiate the confidentiality issues that come with medical and educational data; and managing the mass FOIA request project. We’ll provide a sample data request, a few good war stories, and links to helpful resources.


Speaker Bios

  • Steven Rich is the database editor for investigations at The Washington Post. He's worked on investigations probing the National Security Agency, tax lien sales, asset forfeiture, policing and college athletics. He has been a reporter on two teams awarded Pulitzer Prizes, in 2014 and 2016, and on a team awarded a Peabody in 2018. Steven is a graduate of Mizzou and Virginia Tech. He was elected to IRE’s Board of Directors in 2015. @dataeditor

  • Sarah Ryley is an investigative reporter at The Trace, a nonprofit newsroom focused on gun issues. She covered policing for six years at The Trace and New York Daily News, producing data-driven stories that led to more than 20 new laws. Her work has been the recipient of the Pulitzer Prize for Public Service, two Sidney Awards, and the James Aronson Award for Social Justice Journalism. She studied journalism at Wayne State University in Detroit. @MissRyley

  • Annie Waldman is a reporter at ProPublica, where she covers education. She has won two Education Writers Association awards and been a finalist twice. She was part of the ProPublica team that investigated maternal mortality, which was a finalist for a Pulitzer Prize in 2018. | @anniewaldman

Related Tipsheets

No tipsheets have yet been uploaded for this event.