NICAR 2023 tipsheets

Introduction to web development | 9 a.m. | GitHub repository
Carla Astudillo, Texas Tribune; Andrew Briz, POLITICO; Naël Shiab, CBC

Journalism workflow hacks and tips | 9 a.m. | Slides
Amir Khafagy, Documented NY; Natalie Lung, Bloomberg; Cecilia Reyes, Business Insider; Mike Stucka, USA TODAY

Let's make mapping better! | 9 a.m. | GitHub repository, Slides
Alexandra Kanik, Hearst Texas; Cam Rodriguez, Chalkbeat

Mapping and geographic data analysis with the simple features package in R | 9 a.m. | GitHub repository
Peter Aldhous, University of California, Berkeley

Tips and techniques for handling mass records requests to local agencies | 9 a.m. | Slides
Sanjin Ibrahimovic, MuckRock Foundation; Tom Meagher, The Marshall Project; Lisa Pickoff-White, The California Reporting Project

Come learn about the Data-Driven Reporting Project | 10:15 a.m. | Tipsheet
Karina Brown, Underscore; Pam Dempsey, Northwestern University; Emilie Munson, Albany Times Union; Inori Roy, The Local; Stephannie Stokes, WABE

Covering disparities in higher education with data | 10:15 a.m. | Tipsheet & Slides
Sarah Butrymowicz, The Hechinger Report; Andrea Fuller, Wall Street Journal; Meredith Kolodner, The Hechinger Report

Excel: Basic stats | 10:15 a.m. | Tipsheet
Todd Wallack, WBUR

R: Making fancieR graphics | 10:15 a.m. | Website
Andrew Ba Tran, The Washington Post

A new data tool for identifying where people are losing their homes | 11:30 a.m. | Tipsheet
Caitlin Augustin, DataKind; Juan Pablo Garnham, Eviction Lab; Sabiha Zainulbhai, New America

Bringing data journalism to the sports section | 11:30 a.m. | GitHub repository
Matt Waite, University of Nebraska-Lincoln; Derek Willis, University of Maryland

Data and digital tools for your newsroom and classroom | 11:30 a.m. | Tipsheet
Mike Reilly, University of Illinois Chicago

Defining and measuring the success of your published work | 11:30 a.m. | Slides
Julia Haslanger, Philadelphia Inquirer

Investigative reporting for everyone with data: A quick-start guide | 11:30 a.m. | Tipsheet
Alexandra Chaidez, NBC News; Andrew Ford, The Arizona Republic; José Luis Martínez, The CT Mirror; Simone Weichselbaum, NBC News

It’s freezing! Investigating the climate crisis | 11:30 a.m. | Tipsheet & Slides (2)
Elfredah Kevin-Alerechi, independent journalist; Andrew Lehren, NBC News; Niall Sargent, Noteworthy

Under pressure: Real life in real time with breaking news | 11:30 a.m. | Tipsheet & Slides
Stephen Stock, CBS News

Data for redistricting and election coverage | 2:15 p.m. | Tipsheet
Kate Donovan, Redistricting Data Hub

Introduction to Python for data analysis | 2:15 p.m. | GitHub repository
Sahana Jayaraman and Caitlin McGlade, Arizona Republic

QGIS 1: Mapmaking for beginners | 2:15 p.m. | Slides
Christine Jeavans and Libby Rogers, BBC

QGIS 2: Analyzing geographic data | 3:30 p.m. | Slides
Christine Jeavans and Libby Rogers, BBC

Using DocumentCloud & DocumentCloud AddOns | 3:30 p.m. | Slides
Sanjin Ibrahimovic, MuckRock Foundation

When data assumes a male population | 3:30 p.m. | Tipsheet
Erin Mansfield, USA TODAY; Jasmine Mithani, The 19th*; Janelle O'Dea, Center for Public Integrity; Lucia Walinchus, Eye on Ohio, the Ohio Center for Journalism

Dataviz accessibility matters — here's what you can do to improve it | 4:45 p.m. | Tipsheet
Frank Elavsky, Carnegie Mellon University; Patrick Garvin, University of Missouri; Jasmine Mithani, The 19th*; Joe Murphy, NBC News; Thomas Wilburn, Chalkbeat

How to investigate pay inequities at your workplace | 4:45 p.m. | Tipsheet & Slides
Sarah Blaskey, Miami Herald; Andrew Pantazi, The Tributary; Steven Rich, Washington Post; Andrew Ba Tran, Washington Post

Working with PDFs using off-the-shelf tools | 4:45 p.m. | Slides
Maggie Mulvihill, Boston University

Beyond the fire perimeter: Data for wildfire investigations | 9 a.m. | Slides
Adiel Kaplan, NBC News; Veronica Penney, Colorado Public Radio; Emily Zentner, NPR’s California Newsroom

Finding the story: Nursing homes data | 9 a.m. | Slides
David Barer, KXAN

Keeping secrets: Secure source communications | 9 a.m. | Tipsheet & Slides
Sarah Kate Thomas, The New York Times

Making redistricting data your friend: Finding out what information is out there and how you can use it | 9 a.m. | Slides
Kate Huangpu, Spotlight PA

Master Class: Managing investigators … or how to lead journalists born to challenge authority | 9 a.m. | Tipsheet
Jodie Fleischer, Cox Media Group; Josh Hinkle, KXAN; Mc Nelly Torres, Center for Public Integrity

Mining social media, without depending on the sites' owners goodwill | 9 a.m. | Slides
Cam Hickey, National Conference on Citizenship; Andrea Fuller, Wall Street Journal; Jeremy Merrill, The Washington Post

Uncovering underground money networks | 9 a.m. | GitHub repository
Rob Barry, Wall Street Journal; Cindy Galli, ABC News; Jan Strozyk, OCCRP

Data analysis in JavaScript | 10:15 a.m. | Slides, Github repository, Observable notebook
Naël Shiab, CBC News

Finding the story: The American Community Survey | 10:15 a.m. | Tipsheet
Tim Henderson, Pew Charitable Trusts

How to propose an accessibility team or role in your newsroom: What they do and why they are needed | 10:15 a.m. | Slides, Website
Holden Foreman, The Washington Post

How to retain the NICAR spirit year-round | 10:15 a.m. | Tipsheet
Janelle O'Dea, Center for Public Integrity

Python: Working with PDFs using pdfplumber | 10:15 a.m. | GitHub repository
Jeremy Singer-Vine, Data Liberation Project

Quick turn data stories: Using the quick turn to your advantage | 10:15 a.m. | Slides
Allie Kanik and Ryan Serpico, San Antonio Express-News

Using OpenRefine to powerwash your data | 10:15 a.m. | GitHub repository
Susie Neilson, San Francisco Chronicle

30 places to find data to cover issues in your community | 11:30 a.m. | Slides
Willoughby Mariano, Atlanta Journal-Constitution; Sean McMinn, POLITICO; Kevin Uhrmacher, The Washington Post

Command line for reporters on a Mac | 11:30 a.m. | GitHub repository
AJ Vicens, CyberScoop

Finding the story: Inflation data | 11:30 a.m. | Tipsheet & Spreadsheet
Paul Overberg, The Wall Street Journal

Finding the story: Parole boards | 11:30 a.m. | Tipsheet & Slides, Github repository
Yanqi Xu, Flatwater Free Press

How to produce Long COVID coverage informed by data, public records and patient experiences | 11:30 a.m. | Tipsheet & Slides
Betsy Ladyzhets, Muckrock

Let's talk data memos! | 11:30 a.m. | Tipsheet
Carla Astudillo, Texas Tribune

DEI in data reporting | 2:15 p.m. | Slides
Jayme Fraser, USA Today; Samantha Sunne, Independent journalist

Data on the business and economics beat | 2:15 p.m. | Tipsheet & Slides
Matt Drange, Business Insider; Karen Ho, ARTnews; Megan Squire, Southern Poverty Law Center

QAnon in Europe: Tracing a viral conspiracy through social media through collaborative journalism | 2:15 p.m. | Slides
Justin-Casimir Braun, Lighthouse Reports; Eva Constantaras, Lighthouse Reports; Tristan Lee, Bellingcat

Regular expressions for the rest of us | 2:15 p.m. | Tipsheet
Justin Myers, Associated Press

Source tracking: Making it part of your newsroom practice | 2:15 p.m. | Tipsheet
Emma Carew Grovum, The Marshall Project; Will Lager, Reynolds Journalism Institute

Upping your Excel game | 2:15 p.m. | Website
MaryJo Webster, Star Tribune

Creating and serving vector map tiles using open source tools | 3:30 p.m. | GitHub repository, Slides
Evan Wagstaff, San Francisco Chronicle

Extracting data from PDFs | 3:30 p.m. | GitHub repository
Scott Pham, Independent journalist

Making maps with command-line tools | 4:45 p.m. | GitHub repository
Andrew Milligan, POLITICO

⚡️ Lightning Talk: Think like an accessibility engineer: Make real improvements to your content in minutes | 5 p.m. | Slides
Holden Foreman, The Washington Post

⚡️ Lightning Talk: Bad Bunny and passion data side projects | 5 p.m. | Slides
Lucio Villa, The Washington Post

⚡️ Lightning Talk: Three new file formats for your toolbox | 5 p.m. | Slides
Alex Garcia, Freelance software engineer

⚡️ Lightning Talk: Ergonomics for data journalists | 5 p.m. | Slides
Stephanie Lamm, The Atlanta Journal-Constitution

⚡️ Lightning Talk: How to battle a webmaster and win | 5 p.m. | Slides
Ryan Little, The Baltimore Banner

⚡️ Lightning Talk: Data journalism nightmares and tips: A meme story | 5 p.m. | Slides
Juan Pablo Marín Díaz, Datasketch

⚡️ Lightning Talk: GitHub, the ultimate anti-censorship tool | 5 p.m. | Slides
Léopold Mebazaa, Artefac

⚡️ Lightning Talk: A data-driven investigation: Is Nashville country music all trucks, beer and boots? | 5 p.m. | Slides
Sean McMinn, POLITICO

⚡️ Lightning Talk: How ChatGPT makes my job easier (but won't replace me anytime soon) | 5 p.m. | Slides
Arijit Sen, Dallas Morning News

Beyond the Dobbs story: Public health coverage in a post-Roe America | 9 a.m. | Slides
Annette Choi, CNN Digital; Kristen Hwang, CalMatters; Elizabeth Nash, Guttmacher Institute

Finding the story: Digging into nonprofits for fun and, um, profit | 9 a.m. | GitHub repository
Ron Campbell, NBC Owned Television Stations

Findings and using undocumented APIs | 9 a.m. | Website
Dhruv Mehrotra, WIRED; Leon Yin, The Markup

How to get a seat at the data journalism table and bring more chairs with you | 9 a.m. | Slides
Cam Rodriguez, Chalkbeat; Aria Velasquez, Reckon

How to use investigative techniques to hold algorithms and artificial intelligence accountable | 9 a.m. | Slides
Ari Sen, The Dallas Morning News; Hilke Schellman, New York University; Maddy Varner, The Markup

How to make your data story pop on TV | 10:15 a.m. | Tipsheets (2) & Slides
Rosie Cima, EW Scripps; Josh Hinkle, KXAN; Zaneta Lowe, WREG

Scraping without programming | 10:15 a.m. | Slides
Samantha Sunne, Independent journalist

Sneak peek of Google's new PDF-busting reporting tool | 10:15 a.m. | Tipsheet
Shlomo Urbach, Google

Supercharge your local investigation with machine learning | 10:15 a.m. | Tipsheet & Slides
Clayton Aldern, Grist; Tyler Dukes, The News and Observer; Naveena Sadasivam, Grist; Lucia Walinchus, Eye on Ohio

Using public data to uncover the hidden costs of the housing crisis | 10:15 a.m. | Tipsheets (3) & Slides (2)
Amy DiPierro, Center for Public Integrity; Juan Pablo Garnham, Eviction Lab; Susie Neilson, San Francisco Chronicle

How and when to open-source your code and analysis | 11:30 a.m. | Tipsheet
Alexandra Kanik, Hearst; Justin Myers, Associated Press; Libby Seline, San Antonio Express-News

Investigating the big business of medical marijuana cards | 11:30 a.m. | Tipsheet & Slides
Ed Mahon, Spotlight PA

Telling data stories in audio | 11:30 a.m. | Tipsheet
Justin Hicks, Louisville Public Media; Kelly Kenoyer and Ben Schachtman, WHQR; Natasha Senjanovic, independent journalist

The international money trail | 11:30 a.m. | Tipsheet & Slides
Sara Silver, Quinnipiac University

Data blitz | 2:15 p.m. | Slides (5)
Amy Fan, Scripps News; Larry Fenn, Associated Press; Tim Henderson, Pew Stateline; JP Marín-Díaz, Datasketch; Jeremy Singer-Vine, Data Liberation Project; Lucia Walinchus, Eye on Ohio

PDF processing with command-line tools | 2:15 p.m. | GitHub repository
Chad Day, The Wall Street Journal

R: Introduction to statistics | 2:15 p.m. | Tipsheet
Norm Lewis, University of Florida

Sharing your rapid Python analysis with the newsroom using Google Sheets | 2:15 p.m. | Slides, Github repository
Carla Astudillo, Texas Tribune

Stats in R | 2:15 p.m. | GitHub repository
Holly Hacker, Kaiser Health News

Who's behind that website? | 2:15 p.m. | Slides, Checklist
Priyanjana Bengani, Columbia University; Jon Keegan, The Markup

Census 2020: Get ready for Round 2 | 3:30 p.m. | Tipsheet & Slides (3)
Ron Campbell, NBC Owned Television Stations; Meghan Hoyer, Washington Post; Paul Overberg, Wall Street Journalism

Datasette: An ecosystem of tools for exploring data and collaborating on data projects | 3:30 p.m. | Tipsheet
Simon Willison, Independent journalist

Introducing moneyinpolitics.wtf, a new campaign-finance dictionary made by and for data journalists | 3:30 p.m. | Website
Agustin Armendariz, International Consortium of Investigative Journalists; Anupama Narayanswamy, The Washington Post; Ben Welsh, Reuters; Derek Willis, University of Maryland

Tools for statehouse reporting | 3:30 p.m. | Slides
Jeremy Finley, WSMV; Sandra Fish, Colorado Sun; Phil Williams, NewsChannel5; Yue Stella Yu, Bridge Michigan

311: The 411 on how to report on your city’s infrastructure issues — and how this data can uncover stories on gentrification | 4:45 p.m. | Tipsheet
Janelle O'Dea, Center for Public Integrity

Behind the story: Data dives on the crime beat | 4:45 p.m. | Tipsheet & Slides
Josh McGhee, MindSite News; Rachel Polansky, WANF CBS Atlanta News First; Dylan Purcell, The Philadelphia Inquirer

Building an interactive map in the newsroom: How to bring skills and talent together | 4:45 p.m. | Slides
Barnaby Skinner, NZZ

Finding the story: Higher education data | 4:45 p.m. | Google Drive Folder
Alex Richards, Syracuse University

Gathering data with APIs | 4:45 p.m. | Tipsheet & Slides
Geoff Hing, The Marshall Project

Gearing up for the 2024 election | 4:45 p.m. | Slides
Sandra Fish, Colorado Sun; Jessica Huseman, VoteBeat; Aaron Mendelson, Center for Public Integrity

Public records and data to request for (almost) any beat | 4:45 p.m. | Slides
Amy Fan, Scripps News; Mike Reicher, The Seattle Times; K. Sophie Will, FiscalNote CQ Roll Call

Which dataviz should I use (and why)? | 4:45 p.m. | Tipsheet & Slides
Scott Klein, THE CITY; Erin Petenko, VTDigger; Emilia Ruzicka, Stacker

Web scraping with Python | 9 a.m. | GitHub repository
Cody Winchester, IRE & NICAR

Tracking nursing home data amid state and federal staffing reforms | 10:15 a.m. | Slides
Jayme Fraser, USA Today; Caitlin McGlade, Arizona Republic