NICAR 2020 schedule

245 sessions • Updated March 6
Download: PDF, CSV, JSON

During the conference, the most up-to-date schedule will be on the Guidebook app (search for "2020 NICAR Conference").

You can browse through the sessions below or use the search box to filter by keyword, speaker name, skill level or session type.

Examples: R, Panel, Beginner

Loading ...

All days
Wednesday
Thursday
Friday
Saturday
Sunday

Wednesday, March 4

special

Conference registration

Wednesday, 3 – 6 p.m. (3 hours) • Preservation Foyer, 2nd floor

⚠️ Conference registration will be open on multiple days.

SHOW MORE

Description

Conference registration will be located on the 2nd floor in Preservation Foyer. Be sure to stop by and pick up your conference name badge. Name badges must be worn during the conference.

Thursday, March 5

special

Conference registration

Thursday, 7:30 a.m. – 6 p.m. (all day) • Preservation Foyer, 2nd floor

⚠️ Conference registration will be open on multiple days.

SHOW MORE

Description

Conference registration will be located on the 2nd floor in Preservation Foyer. Be sure to stop by and pick up your conference name badge. Name badges must be worn during the conference.

special

Conference sales

Thursday, 7:30 a.m. – 6 p.m. (all day) • Studio Foyers, 2nd floor

⚠️ Conference sales will be open on multiple days.

SHOW MORE

Description

Stop by the NICAR sales table located in Preservation Foyer on the 2nd floor to browse books from the IRE store, IRE merchandise and shirts with the winning design from the T-shirt contest.

special

International meet and greet

Thursday, 7:30 – 8:15 a.m. (45 minutes) • Carondelet, 3rd floor

SHOW MORE

Description

An opportunity for international attendees to network.

panel

Welcome first timers! How to make the most of NICAR20

Thursday, 8:30 – 8:50 a.m. (20 minutes) • Acadia, 3rd floor

💪 Skill level: General interest

SHOW MORE

Description

Welcome to the conference! Get a special button for first-time attendees and hear from IRE staff about tips and tactics to navigate our conference like a pro. Also, you'll learn about key resources that IRE offers once you're back home.

Speakers

Doug Haddix, IRE & NICAR 👇

Doug Haddix is executive director of Investigative Reporters & Editors. He oversees training, conferences and services for 6,000 members worldwide. Previously, Haddix worked as an IRE training director, an assistant vice president at Ohio State University, director of the Kiplinger Program in Public Affairs Journalism and as an editor and reporter at newspapers in Illinois, Ohio and Pennsylvania. He earned a master's in journalism from Indiana University.

On Twitter: @DougHaddix

Denise Malan, IRE & NICAR 👇

Denise Malan is IRE's Deputy Executive Director, overseeing all training programs, event logistics and the IRE Resource Center. She was a newspaper journalist for more than a decade, covering government, education, politics, the environment and more. After several years at the Corpus Christi Caller-Times in Texas, she joined IRE in 2013 in a joint position with the Institute for Nonprofit News, helping newsrooms around the country use data in their reporting.

On Twitter: @DeniseMalan

#welcome

hands-on

PyCAR

Thursday, 9 a.m. – 12:30 p.m. (3.5 hours) • Studio 3, 2nd floor

💪 Skill level: Intermediate

⚠️ This session requires pre-registration and an additional fee of $70 to reserve a seat.

⚠️ This session is split over multiple days.

SHOW MORE

Description

This hands-on workshop will teach journalists basic programming concepts using the Python language. The class, spread over two half-days, will introduce language basics and useful libraries in the course of a typical reporting project: scraping data from the web, analyzing a spreadsheet and visualizing the results.

Preregistration is required and seating is limited. Laptops will be provided for the training.

Workshop prerequisites: Although the class is geared toward programming beginners, attendees should have familiarity with the command line and be comfortable with databases and SQL.

Speakers

Tom Meagher, The Marshall Project 👇

Tom Meagher is the managing editor for digital and data at The Marshall Project, where he leads a team of designers, developers, visual journalists and data reporters covering the criminal justice system. A veteran reporter and editor, he's part of the team behind Klaxon, an open-source reporting tool for monitoring websites.

On Twitter: @ultracasual

Jacob Quinn Sanders, Factal 👇

Jacob Quinn Sanders somehow turned being a versatile reporter and editor into a career as a software developer. He has covered, supervised and built technology around news and real-time events across the U.S. and the world. He works at Factal, a company devoted to discovery and verification of news events as they develop.

On Twitter: @thejqs

Elaine Wong, CBC/Radio-Canada 👇

Elaine is a switcher-director at the Canadian Broadcasting Corporation, where she uses code to automate TV broadcasts. Previously, she was a technical director for an animation studio in Toronto, where she wrote Python scripts to build in-house tools, and she was a multimedia producer building interactive content for cbcnews.ca. When not coding, she organizes PyCon Canada, csvconf and PyLadies Toronto.

On Twitter: @elthenerd

#programming #python

hands-on

Upping your Excel game

Thursday, 9 a.m. – 12:30 p.m. (3.5 hours) • Studio 2, 2nd floor

💪 Skill level: Intermediate

⚠️ This session requires pre-registration and an additional fee of $35 to reserve a seat.

SHOW MORE

Description

If you've found yourself struggling in a spreadsheet, thinking that whatever you were trying to achieve seemed harder than it should've been, then this is the class for you. We’ll learn about various tools and functions in Excel that come in handy when you need to re-structure or otherwise get your data ready for analysis. We'll cover string functions, logical functions, date functions, reshaping data, merging data using lookup functions and perhaps a few other nifty tricks if time allows. We’ll do some “drills” introducing you to these concepts, then put your new skills to work in a sort of “scrimmage,” fixing up some real-life data. You’ll also walk out with practice data and a 30-page tipsheet that covers, in detail, everything from the class, plus more that we won’t have time for.

Preregistration is required and seating is limited. Laptops will be provided for the training.

Workshop prerequisites: You should have prior experience using Excel or Google Sheets, and be comfortable with introductory-level spreadsheet skills, such as sorting, filtering, SUM and AVERAGE functions, calculations such as percentage change or percent of total, and how to use pivot tables.

Speaker

MaryJo Webster, The Star Tribune 👇

MaryJo has been data editor at The Star Tribune in Minneapolis for five years. Previously, she had stints with the St. Paul Pioneer Press, USA Today, Digital First Media and Investigative Reporters & Editors. She started her career as a reporter at small papers in Minnesota and Wisconsin.

On Twitter: @MaryJoWebster

#data wrangling #excel

hands-on

Interviewing your data with SQL

Thursday, 9 a.m. – 5:45 p.m. (all day) • Studio 4, 2nd floor

💪 Skill level: Intermediate

⚠️ This session requires pre-registration and an additional fee of $70 to reserve a seat.

SHOW MORE

Description

If you flip over pivot tables, but wish you had more data tools, this session is for you. Structured Query Language, or SQL, can help you use powerful filtering functions, find patterns in millions of records and join multiple data tables.

This class will be taught by two experienced data reporters and former IRE trainers, and materials will include the IRE data boot camp binder, full of exercises, cheat sheets and tips to help you boost your data analysis and storytelling skills. We will use a free database manager that can be easily installed and used on any computer.

Preregistration is required and seating is limited. Laptops will be provided for the training.

Workshop prerequisites: The only prerequisites are a reasonable comfort level with using a spreadsheet. No previous SQL skills necessary.

Speakers

Elizabeth Lucas, Kaiser Health News 👇

Liz Lucas is the data editor at Kaiser Health News and a member of the investigative team. Previously she worked at Investigative Reporters & Editors as the NICAR Data Library director and trainer. She lives in St Louis.

On Twitter: @eklucas

Megan Luther, InvestigateTV 👇

Megan Luther is an investigative producer with InvestigateTV, Gray Television's national investigative team. Previously, she was Senior Training Director for Investigative Reporters & Editors. Other former titles include reporter, data analyst and overnight DJ. Megan, mother of two, works remotely in South Dakota.

On Twitter: @MeganLuther

#data wrangling #sql

master class

Master class: Editing the data story

Thursday, 9 a.m. – 12:30 p.m. (3.5 hours) • Galerie 5, 2nd floor

💪 Skill level: Intermediate

😬 This class is sold out. Please fill out this form to add your name to a waiting list.

⚠️ This session requires pre-registration and an additional fee of $35 to reserve a seat.

SHOW MORE

Description

Managing a data project presents challenges for any editor. No matter your comfort level with data, this half-day workshop will give you the foundation you need to help make sure your reporters aren’t running with scissors or spinning their wheels on data projects. Two veteran editors, Jennifer LaFleur of The Investigative Reporting Workshop and Maud Beelman of the Howard Center for Investigative Journalism at Arizona State University, will guide you through the ins and outs of data journalism from an editor’s point of view, including:

* How to help reporters find focus for their data stories
* Being skeptical of data and finding potential pitfalls
* Verifying analyses and bulletproofing data stories and apps
* Using data to find human sources and characters for stories
* Planning the best data workflows for your newsroom

No data experience is necessary for this workshop. Editors/producers and those interested in newsroom management are welcome. Please bring your own laptop.

Speakers

Maud Beelman, Howard Center for Investigative Reporting 👇

Maud Beelman is the executive editor of the Howard Center for Investigative Journalism at Arizona State University's Walter Cronkite School of Journalism. She was U.S. Investigations Editor for The Associated Press and founding director of the International Consortium of Investigative Journalists. Her work has been honored with numerous awards, including the George Polk, Investigative Reporters & Editors, the Society of Professional Journalists, the Online News Association and Associated Press Media Editors. She is an Alicia Patterson Foundation fellow and serves on its board of directors.

On Twitter: @maudbeelman

Jennifer LaFleur, Investigative Reporting Workshop 👇

Jennifer LaFleur is the Investigative Reporting Workshop's data editor and teaches at American University. She previously was a senior editor at Reveal from The Center for Investigative Reporting, where she managed a team of data journalists, investigative reporters and fellows. She is the former data journalism director at ProPublica and has held similar roles at newspapers. She is a former IRE training director and serves on IRE's board.

#management

panel

👋 Hello world! Choose your data adventure

Thursday, 9 – 10 a.m. (1 hour) • Acadia, 3rd floor

💪 Skill level: General interest

SHOW MORE

Description

How do you want to NICAR? The options can be overwhelming, but at this session we can help you chart a path, whether you're looking to pick up some basic spreadsheet skills or learn how to use a fancy machine learning algorithm.

Speakers

Simone Weichselbaum, The Marshall Project 👇

Simone Weichselbaum is a staff writer at The Marshall Project, focusing on issues pertaining to federal law enforcement and local policing. She is also serves as the outlet's co-chair of diversity and inclusion. Previously, Simone was a cops reporter at the New York Daily News and the Philadelphia Daily News. She holds a graduate degree in criminology from the University of Pennsylvania.

On Twitter: @SimoneJwei

Cody Winchester, IRE & NICAR 👇

Cody is a training director at Investigative Reporters & Editors. Before joining IRE, he worked at newspapers in Texas, Nebraska and South Dakota.

#welcome

hands-on

Excel 1: Getting started with spreadsheets

Thursday, 9 – 10 a.m. (1 hour) • Studio 8, 2nd floor

💪 Skill level: Beginner

SHOW MORE

Description

In this introduction to spreadsheets, you'll begin analyzing data with Excel, a simple but powerful tool. You'll learn how to enter data, navigate spreadsheets and conduct simple calculations like sum, average and median.

This session is good for: Data beginners.

Speaker

Stephanie Lamm, The Houston Chronicle 👇

Stephanie Lamm is a data journalist for the Houston Chronicle. She looks for stories in datasets and public records. She also creates interactive graphics for online stories. Stephanie previously worked for the Dallas Morning News and attended The University of North Carolina at Chapel Hill.

On Twitter: @stephanierlamm

#data analysis #excel

panel

Data Dive 1: The 2019 Philip Meyer winners

Thursday, 9 – 10 a.m. (1 hour) • Bissonet, 3rd floor

💪 Skill level: General interest

SHOW MORE

Description

A data deep dive into the 2019 Philip Meyer Award winners. Hear from reporters how they gathered, cleaned, analyzed and visualized the data behind some of the year's biggest stories.

Speakers

Sarah Cohen, Walter Cronkite School of Journalism, Arizona State University 👇

Sarah Cohen is the Knight Chair in Journalism at the Walter Cronkite School at Arizona State University. Previously, she worked as the editor of a data reporting team at The New York Times focused on long-term enterprise and investigative stories, and as a database editor for The Washington Post. Her awards include the Pulitzer Prize in Investigative Reporting, the Goldsmith Prize and the IRE medal. She is a past president of IRE and served on the IRE board for eight years.

Ren Larson, The Arizona Republic 👇

Ren Larson is a data journalist with the Arizona Republic, where she has worked on elections, environmental contamination, wildfires and immigration projects. In a previous life, she was an urban planner for the city of Austin, Texas, and a short-lived bike messenger in Beirut. Ren holds a master's degree in public policy and an M.A. in International Studies from the University of California Berkeley.

On Twitter: @renLarson_

Benjamin Lesser, Reuters 👇

Benjamin Lesser is a reporter and a deputy editor at Reuters News. He also teaches investigative reporting at the City University New York Graduate School of Journalism. Prior to joining Reuters he spent most of his career working in newspapers. He spent 12 years as an investigative/data reporter at The Record in New Jersey (2000-2006) and the New York Daily News (2006-2012).

Sean McMinn, NPR 👇

Sean McMinn is the data editor on NPR's News Apps team. Based in Washington, D.C., McMinn writes and reports news stories for NPR.org, designs infographics, and develops software that helps journalists do their jobs.

On Twitter: @shmcminn

Janet Roberts, Reuters 👇

Janet Roberts heads the data journalism team at Reuters and has been wringing stories out of data since she was a student in Phil Meyer’s journalism class at the University of North Carolina. Before Reuters, she worked at The New York Times, the St. Paul Pioneer-Press and the Wilmington Star-News. She has been a finalist for the Pulitzer Prize in Explanatory Journalism and the Goldsmith Prize for Investigative Reporting.

On Twitter: @jersey_janet

Carolyn Thompson, Independent journalist 👇

Carolyn Thompson is a Canadian freelance journalist based in Nairobi, Kenya. Her stories focus on displacement, human rights abuses and government corruption using tools such as public data, surveys and satellite imagery. She has reported for CBC, France 24, Al Jazeera, and The Washington Post, among others. She has also taught data journalism in Ghana, Kenya and Canada.

On Twitter: @caroethompson

#story ideas

hands-on

Regular expressions for the rest of us

Thursday, 9 – 10 a.m. (1 hour) • Studio 10, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Regular expressions are a powerful tool when working with data. They're supported by a variety of text editors, databases and programming languages, but they can be intimidating. Get familiar with the basics of regular expressions and how they can help with your next batch of dirty data.

This session is good for: People who have ever done more than two search/replace actions to clean a data set, or had to split a ZIP code from an address or otherwise want to conquer their fears of regex.

Speaker

Justin Myers, The Associated Press 👇

Justin Myers is a data journalist at The Associated Press, where he contributes to reporting projects, develops new tools for the newsroom and investigates how emerging technologies can help to advance AP's newsgathering and production efforts. He holds degrees in both engineering and journalism, and he lives in Chicago.

On Twitter: @myersjustinc

#data cleaning #regex

hands-on

Finding needles in haystacks with fuzzy matching

Thursday, 9 – 10 a.m. (1 hour) • Studio 9, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Fuzzy matching is a process for linking up names that are similar but not quite the same. It has become an increasingly important part of data-led investigations as a way to identify connections between public figures, key people and companies that are relevant to a story. This class will cover how fuzzy matching typically fits into the investigative process, with some story examples.

Max Harlow, who developed the CSV Match command line tool, will show you how to run some of the different types of fuzzy matching on some real datasets, including the pros and cons of each.

This session is good for: People who feel comfortable using the command line.

Speaker

Max Harlow, The Financial Times 👇

Max Harlow is a newsroom developer at the Financial Times in London. He has previously worked on investigations at The Guardian and the Bureau of Investigative Journalism. He also co-runs Journocoders, a community group for journalists developing technical skills for use in their reporting.

On Twitter: @maxharlow

#data wrangling #command line

hands-on

Introduction to VisiData

Thursday, 9 – 10 a.m. (1 hour) • Studio 6, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

VisiData is a fast, powerful, keyboard-driven tool for quickly exploring datasets. It's often the first piece of software I use to examine new data. In this hands-on session, you'll learn VisiData's essentials commands — including how to sort, filter, summarize and aggregate.

This session is good for: People who have a basic familiarity with your computer's command line interface. No programming knowledge necessary, but some knowledge of Python is a plus.

Speaker

Jeremy Singer-Vine, BuzzFeed News 👇

Jeremy Singer-Vine is the data editor at BuzzFeed News. He also publishes Data Is Plural, a weekly newsletter of useful/curious datasets. Website: jsvine.com

#data analysis #command line

panel

Tracking money spent on candidates up and down the ballot in 2020

Thursday, 9 – 10 a.m. (1 hour) • Galerie 3, 2nd floor

💪 Skill level: Beginner

SHOW MORE

Description

The 2020 election will see record levels of spending. This panel will provide a host of useful tips and advice on how to best track the money spent on candidates up and down the ballot.

Experts will explain how to use FEC.gov, OpenSecrets.org, FollowTheMoney.org and other sources to find the patterns — and anomalies — that will help you uncover relationships hidden in campaign finance data.

Speakers

Sandra Fish, Independent journalist 👇

Sandra Fish is a Colorado data journalist specializing in politics. She's done work for the Colorado Sun, Colorado Independent, OpenSecrets, ESPN, Colorado Public Radio and others. She also teaches data journalism at University of Colorado Boulder.

Denise Roth Barber, National Institute On Money In Politics 👇

Denise Roth Barber has served as managing director of the National Institute On Money In Politics since 2010, after four years as research director and seven years as researcher. As managing director, she oversees the data acquisition, research and communications departments, and she oversees the writing of grant proposals and narratives. Prior, Denise was a community organizer with the Northern Plains Resource Council in eastern/central Montana and a Peace Corps volunteer in Niger, Africa.

Ben Wieder, McClatchy 👇

Ben Wieder is a data reporter in the McClatchy D.C. Bureau who has focused on political influence, government contracts and predatory lending. He worked previously at the Center for Public Integrity and Stateline and has also written for FiveThirtyEight, The Chronicle of Higher Education and Newsday.

On Twitter: @benbwieder

#election & politics #election

commons

How I learn to tell stories with data

Thursday, 9 – 10 a.m. (1 hour) • Galerie 4, 2nd floor

SHOW MORE

Description

With a dizzying number of tools and methods to learn data, what works best for journalism students learning how to tell good and accurate stories with data? In this session, we'll ask the students! Journalism educators and students alike should benefit from this discussion of methods that help students learn sound data principles and continue adapting to new tools.

Speakers

Sophia Brown, Boston University 👇

Sophia Brown is a data journalist majoring in journalism and international relations at Boston University. She began her news career at The Daily Free Press, Boston University's independent student newspaper, where she covered crime and justice. After leaving the FreeP, Sophia interned for an international news agency in Paris and for the New England Center for Investigative Reporting. This year, she is the data journalism teaching assistant.

On Twitter: @sophiasbrown

Kimberly Cataudella, Investigative Reporting Workshop 👇

Kimberly Cataudella is a fourth-year student at American University double majoring in journalism and religious studies. She works at the Investigative Reporting Workshop as The Accountability Project's data intern. She is a news writer for her campus paper, The Eagle, reporting on the Greek life beat, having previously served as sports editor for two years. She will be earning her master's degree in investigative journalism at American in 2021.

On Twitter: @kcataudella

Theresa Diffendal, University of Maryland Philip Merrill College of Journalism 👇

Diffendal is a graduate student at the University of Maryland's Philip Merrill College of Journalism. Diffendal got hooked data and coding following an introductory course in design and graphics. Since then, she has worked on The Associated Press' "Death Behind Bars" and Capital News Service's "Code Red." In my free time, Diffendal enjoys teasing her cat and slinging frisbees.

On Twitter: @theresarose_

Maggie Mulvihill, Boston University 👇

Maggie Mulvihill’s data journalism students have been honored with 10 regional or national awards since 2011, as well as being named finalists for the prestigious Livingston Award for Young Journalists. An attorney, Maggie serves on the steering committee of the Reporter's Committee for Freedom of the Press and the board of the New England First Amendment Coalition. She is a co-founder of the New England Center for Investigative Reporting and a former Nieman Fellow.

demo

How the internet works (so you can scrape the web!)

Thursday, 9 – 10 a.m. (1 hour) • Galerie 6, 2nd floor

💪 Skill level: Beginner

SHOW MORE

Description

Need to scrape a web page? Using tools included with modern browsers, you will learn how to inspect the code behind a website and monitor network traffic to help you target information for extraction.

Speaker

Andrew Chavez, The New York Times 👇

Andrew Chavez is a journalist/developer on the Interactive News team at The New York Times. Before the Times, he worked at The Dallas Morning News, the Austin American-Statesman and the Fort Worth Star-Telegram.

#web scraping

panel

Negotiating for data at scale

Thursday, 9 – 10 a.m. (1 hour) • Galerie 2, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Negotiating a single public records request for data can be challenging, so how do you scale that up when you are requesting data from multiple agencies? This panel will discuss strategies and tools for handling requests sent out to dozens, hundreds and even thousands of agencies. We will cover the entire process from making initial requests to negotiating with agencies to finally receiving results.

Speakers

Ellen Gabler, The New York Times 👇

Ellen Gabler is an investigative reporter at The New York Times. Before joining the Times, she worked at the Milwaukee Journal Sentinel as a reporter and deputy investigations editor. A native of Eau Claire, Wisconsin, Gabler is a graduate of Emory University and the Columbia University Graduate School of Journalism. She is a former IRE board member. @egabler

On Twitter: @egabler

Cheryl Phillips, Stanford University

#data wrangling

hands-on

Finding the story: Census data

Thursday, 9 – 10 a.m. (1 hour) • Studio 7, 2nd floor

💪 Skill level: Beginner

SHOW MORE

Description

Census data can bring context and depth to stories on practically any beat. It can also be overwhelming to sift through and find what you need. This hands-on session will walk you through a real census dataset to help you find stories hidden in all that demographic data.

This session is good for: Those who have some experience with spreadsheets.

Speaker

Joe Germuska, Northwestern University Knight Lab 👇

Joe is the Chief Nerd at Knight Lab, Northwestern's cross-disciplinary media/technology/design studio. He's also the project lead for Census Reporter, a website designed to make Census data easier for journalists. Before Northwestern, Joe was a founding member of the Chicago Tribune News Applications team. He is also proud to serve on the board of directors for City Bureau, a nonprofit civic journalism lab based on the South side of Chicago.

On Twitter: @JoeGermuska

#census & demographics #excel

hands-on

"Scrollytelling" with MapBox

Thursday, 9 – 10 a.m. (1 hour) • Studio 1, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Build a scrollytelling experience using Mapbox Studio and the new Storytelling Solution by Mapbox with little to no code. In this session, you’ll learn to quickly create a scrollytelling map using Mapbox’s new template and publish the results on Glitch.

This session is good for: Those who are familiar with mapping concepts.

Speaker

Lo Bénichou, Mapbox 👇

Lo is an interactive developer and storytelling expert at Mapbox in San Francisco. They work on storytelling collaborations with external partners, write a lot of technical guides to mapping and cartography and support journalists whenever they can. They ❤️ maps and graphics. Before Mapbox, Lo was a frontend engineer at Wired. Prior to Wired, Lo worked as a visual journalist and interactive developer for numerous media outlets like Youth Radio, NPR, KQED and more.

On Twitter: @lobenichou

#mapping #mapbox

special

Exhibitors and recruiters

Thursday, 9 a.m. – 5 p.m. (all day) • Studio Foyers, 2nd floor

⚠️ Exhibitors and recruiters will be open on multiple days.

SHOW MORE

Description

Be sure to stop by the Studio foyers on the 2nd floor and visit with the exhibitors/recruiters.

hands-on

Excel 2: Formulas & sorting

Thursday, 10:15 – 11:15 a.m. (1 hour) • Studio 8, 2nd floor

💪 Skill level: Beginner

SHOW MORE

Description

Much of Excel's power comes in the form of formulas. In this class, you'll learn how to use them to analyze data with the eye of a journalist. Yes, math will be involved, but it's totally worth it! This class will show you how calculations like change, percent change, rates and ratios can beef up your reporting.

This session is good for: Anyone who is comfortable navigating Excel.

Speaker

Carli Brosseau, The News & Observer 👇

Carli Brosseau is a data reporter at The News & Observer in Raleigh, North Carolina. Previously, she worked at The Oregonian, the Arizona Daily Star and the Tucson Citizen.

On Twitter: @carlibrosseau

#data analysis #excel

hands-on

GitHub for journalists

Thursday, 10:15 – 11:15 a.m. (1 hour) • Studio 1, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

We'll cover Github's basic features — repositories, commits, branches, pull requests and issues — using a recent data-driven story as a case study. The goal is for you to leave the class and be able to use GitHub on your own for your next story.

Please note: You will need to bring your own laptop to participate in this class. You will also need to have created an account at GitHub.com and install GitHub Desktop prior to the class.

This session is good for: Journalists who want to collaborate on data analyses, back up their work and share their methodology with (nerdy) readers.

Speaker

Brent Jones, St. Louis Public Radio 👇

Brent Jones is the data visuals specialist at St. Louis Public Radio. Working with a newsroom of nearly 30 journalists, his job includes creating graphics for stories, stand-alone sites for projects and developing/discovering and training staff on newsroom tools. He previously worked at the St. Louis Beacon and is a graduate of Southern Illinois University's journalism school, where he also teaches a course in data journalism.

On Twitter: @brentajones

#work better #github

panel

Mining data into TV gold

Thursday, 10:15 – 11:15 a.m. (1 hour) • Galerie 2, 2nd floor

💪 Skill level: Beginner

SHOW MORE

Description

You see numbers; we see compelling television. Stuck looking at interminable spreadsheets and numbers that make your head swim? In this session you’ll learn how to use data to find good stories and then turn that data and all those “boring numbers” into compelling, visual television that will make your bosses and your audience sit up and take notice. We’ll even have examples of stories you can take home and do in your community.

Speakers

Jodie Fleischer, WRC-TV NBC4 Washington 👇

Jodie is an investigative reporter with NBC4 in Washington and joined the IRE Board in 2019. Her work has changed laws regarding criminally-charged police officers, house stealing by sovereign citizens and misuse of a real estate law to hold up home sales. Jodie has been honored by the FBI Director and the head of Georgia's police training agency. She's earned an IRE Award for Innovation, an Alfred I. duPont award, 18 regional Emmys and several Murrow awards.

On Twitter: @jodienbc4

A.J. Lagoe, KARE11 👇

A.J. Lagoe is an investigative reporter for KARE11 in Minneapolis, Minnesota. His reporting has led to criminal convictions, sparked numerous legislative hearings, prompted new federal and state laws and multiple Attorney General and Inspector General investigations. A.J. has earned many of journalism’s highest honors, including the Alfred I. duPont-Columbia University, George Polk, IRE, National Headliner & Sigma Delta Chi awards.

On Twitter: @AJInvestigates

Stephen Stock, NBC Bay Area 👇

Hard to believe, but more than 35 years ago, Stephen began as a general assignment reporter in Roanoke, Virginia. Since then he’s covered everything from shuttle launches to hurricanes, presidents to popes. Now a founding member of the NBC Bay Area 17-member Investigative Unit, he’s won awards including a Peabody, a duPont, a national award from the Society of Proessional Journalists, three Murrow awards and six AP awards, 17 regional Emmys and a national Emmy nomination. He's taught at IRE for a decade. His work has changed laws & lives.

On Twitter: @stephenstocktv

#broadcast

hands-on

Finding the story: Using natural language processing in social media research

Thursday, 10:15 – 11:15 a.m. (1 hour) • Studio 9, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

Ever felt lost poring over a massive archive? Want to churn up interesting stories from social networks, chat archives, or forums with (relative) ease?

Why not try using a little natural language processing (NLP)!

This session will give you a taste of how to apply a blend of linguistics and AI to the text-based world of the internet. You will learn some basic NLP concepts, and how to apply them to online texts using the Python package Spacy. You'll be able to walk out of this session ready to start digging through data of your own.

This session is good for: People who are comfortable working in Python.

Speaker

Madeleine Varner, The Markup

#machine learning #python

panel

How to negotiate for data and records

Thursday, 10:15 – 11:15 a.m. (1 hour) • Bissonet, 3rd floor

💪 Skill level: General interest

SHOW MORE

Description

The struggle is real. We'll discuss how to wrench the data/records out of agencies who don’t want to make it easy on you. Learn how to negotiate, sweet talk and strong-arm when you need to.

Speakers

Cary Aspinwall, The Marshall Project 👇

Cary Aspinwall is a Dallas-based staff writer for The Marshall Project. Previously, she was an investigative reporter at The Dallas Morning News. In 2019, she won the Gerald Loeb Award for local reporting on a Texas company's history of deadly natural gas explosions and is a past Pulitzer finalist for her work exposing flaws in Oklahoma's execution process. She is a co-founder of The Frontier, a nonprofit devoted to investigative journalism in Oklahoma.

On Twitter: @caryaspinwall

Matt Dempsey, Houston Chronicle 👇

Matt Dempsey is the data editor at the Houston Chronicle. He has worked on projects involving wildfires, state pensions and the chemical industry. His passion for public records frequently leads to disclosure of data from all levels of government. His series "Chemical Breakdown" won the 2016 IRE Innovation award and the National Press Foundation’s “Feddie” award. His work was a key part of the Chronicle’s Pulitzer Prize finalist entry for Breaking News.

Matthew Topic, Loevy & Loevy 👇

Matt Topic leads Loevy & Loevy’s Freedom of Information Act practice. Among the media cases he has handled around the country, Matt has litigated hundreds of state and federal FOIA cases, often at reduced or no cost to clients, including the release of the the Laquan McDonald shooting video in Chicago; records from the Mueller investigation; Rahm Emanuel’s “private emails” about public business; and FBI records that helped lead to the exoneration of an innocent man.

Jodi Upton, Syracuse University 👇

Upton is Knight Chair in Data and Explanatory Journalism at Syracuse University. Her students have contributed to USA TODAY, CNN and other media. Her students also helped develop data for the Syrian Accountability Project, which tracks Syrian war casualties. Previously, she led an award-winning team of journalists and researchers at USA TODAY, covering data-driven topics including Medicare fraud, new economy jobs, mass killings and college football coaches’ salaries.

#open records

panel

How to make charts less bad

Thursday, 10:15 – 11:15 a.m. (1 hour) • Galerie 6, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

Good data visualization design helps maximize your story's impact by making it easier to understand and more engaging. This session covers the basic dos and don'ts for data visualization.

We will discuss how different design strategies can help or hurt your story, with plenty of examples from leading journalism outlets. We will also share a tipsheet of design resources (books, online/offline communities, documentaries, podcasts) to help attendees explore further post-NICAR.

Speakers

Anna Flagg, The Marshall Project 👇

Anna Flagg is The Marshall Project's senior data reporter, covering criminal justice topics including immigration, crime, race, policing and incarceration. Her work has been recognized by the Global Editors Network’s Data Journalism Awards, the Society of News Design and the Information is Beautiful Awards, and she was a finalist for a 2019 Deadline Club Award.

On Twitter: @annaflagg

Sean McMinn, NPR 👇

Sean McMinn is the data editor on NPR's News Apps team. Based in Washington, D.C., McMinn writes and reports news stories for NPR.org, designs infographics, and develops software that helps journalists do their jobs.

On Twitter: @shmcminn

Moiz Syed, ProPublica 👇

Moiz Syed is a journalist, designer and developer on ProPublica's news apps team, covering the federal government. Previously he worked at The Intercept and the Wikimedia Foundation.

On Twitter: @moizsyed

#data viz & design

commons

My own worst enemy: Overcoming impostor syndrome

Thursday, 10:15 – 11:15 a.m. (1 hour) • Galerie 4, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

Did you ever get the feeling that you're a fraud and it's only a matter of time before someone finds out? Congratulations! You may have impostor syndrome. We will explore the causes of impostor syndrome, including the systemic factors that drive it, and provide evidence-based strategies for coping.

Speakers

Melissa Lewis, Reveal from The Center for Investigative Reporting 👇

Melissa Lewis is a data reporter for Reveal from The Center for Investigative Reporting. Prior to joining Reveal, she was a data editor at The Oregonian, a data engineer at Simple and a data analyst at Periscopic. She is an organizer for PyLadies Portland and the Portland chapter of the Asian American Journalists Association.

On Twitter: @iff_or

Kate Martin, Carolina Public Press 👇

Kate Martin is the lead investigative reporter for Carolina Public Press. Her work has led to the creation of four state laws and the resignation of several elected officials. Her deep analysis of years of North Carolina court records showed that fewer than 1 in 4 people charged with sexual assault are ever convicted of that or a lesser crime.

On Twitter: @Katereports

#work better

hands-on

Newsroom web scraping with JavaScript

Thursday, 10:15 – 11:15 a.m. (1 hour) • Studio 6, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

If you want to scrape websites, crawl them, extract their data, take screenshots and deal with any interactive elements, this class will show you how. A great way to scrape websites that rely heavily on JavaScript is to scrape them using JavaScript. Cypress and Puppeteer are great tools to use; Puppeteer is a Node project which provides an API to control the Chrome browser, and Cypress is normally used for site testing. We'll show you how these tools can be used to gather data for your stories, and how they fit into a newsroom data pipeline. This session will provide demos of how to scrape with both.

This session is good for: People with intermediate knowledge of JavaScript and Node.

Speakers

Alison Benjamin, BBC News 👇

Alison works in data science on the BBC News data journalism team. @hey_benjamin

On Twitter: @hey_benjamin

Jon Keegan, The Markup 👇

Jon Keegan is an Investigative Data Journalist at The Markup. Prior to The Markup, he was a Senior Research Fellow at the Tow Center for Digital Journalism at Columbia University, researching signals of trust in online news and studying the role of artificial intelligence in journalism. He also worked at The Wall Street Journal for 18 years, where he ran the interactive graphics team.

On Twitter: @jonkeegan

#web scraping #javascript

panel

Covering immigration with data

Thursday, 10:15 – 11:15 a.m. (1 hour) • Acadia, 3rd floor

💪 Skill level: General interest

SHOW MORE

Description

Migration will continue to be one of the most important issues reporters will need to cover responsibly -- this session will provide a rundown of data available on all the aspects of migration: immigration, asylum-seekers, refugees and refugee camps, detained families and children, etc., the stories that have come out of that data, and the potential stories that could come out of that data.

Speakers

Sophie Chou, ProPublica 👇

Sophie Chou is a data reporter at ProPublica who covers issues related to immigration, voting and healthcare. She previously worked as a data journalist at Public Radio International and was a Google News fellow at the Pew Research Center. Sophie holds a master’s degree from the Massachusetts Institute of Technology, where she researched misinformation and virality at the Media Lab, and a bachelor’s degree in computer science from Columbia University.

On Twitter: @mpetitchou

Kristian Hernández, Fort Worth Star-Telegram 👇

Kristian Hernández is an investigative reporter with the Fort Worth Star-Telegram. He's covered politics for the Center for Public Integrity in Washington, D.C., and immigration for the McAllen Monitor in South Texas. In 2014, Hernández was a courts reporter for Homicide Watch D.C. He is a first generation Mexican-American with a multimedia journalism degree from the University of Texas at El Paso and a masters in investigative reporting from American University.

On Twitter: @kristianreports

Tanvi Misra, CQ Roll Call 👇

Tanvi Misra is staff writer at CQ Roll Call, covering immigration policy on the Hill — and beyond. Previously, she worked at CityLab when it was a website of the Atlantic. She wrote about about immigration, housing, economic inequality and criminal justice. Tanvi's work includes timely reportage, investigative data dives, award-winning features, in-depth policy analyses and essays. Her writing has also appeared in the Atlantic, NPR, and the BBC.

#immigration

demo

Newsroom open-source tool showcase

Thursday, 10:15 – 11:15 a.m. (1 hour) • Galerie 3, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

A lightning-round showcase of innovative newsroom tools that can help you manage mass FOIAs, automate web scraping, analyze large document dumps with artificial intelligence and track how special interests influence statehouse legislation.

Speaker

Justin Mayo, Big Local News 👇

Justin Mayo is a data journalist with Big Local News, a project of Stanford’s Journalism and Democracy Initiative. He joined the team in December 2018 and believes in supporting local watchdog reporting through data gathering, analysis and training. Before Stanford, he spent 20 years as an investigative reporter with The Seattle Times, sharing the 2018 Selden Ring Award, the 2015 Breaking News Pulitzer Prize and the 2012 Pulitzer Prize for Investigative Reporting.

#tools

hands-on

Data cleaning with OpenRefine 1: The basics

Thursday, 10:15 – 11:15 a.m. (1 hour) • Studio 10, 2nd floor

💪 Skill level: Beginner

SHOW MORE

Description

Learn how to use OpenRefine, a powerful tool for quickly cleaning up dirty data. You'll learn about faceting, simple clustering, applying common data transformations and more.

This session is good for people with basic experience working with data.

Speakers

Tommy Kaas, Kaas & Mulvad 👇

Tommy Kaas is a data journalist, analyst, trainer and CEO at Kaas & Mulvad. He was co-founder of DICAR – the Danish International Center for Analytical Reporting. He has a background in print journalism and has previously worked as an assistant managing editor.

On Twitter: @tbkaas

Nils Mulvad, Kaas & Mulvad 👇

Nils Mulvad is partner and CEO at Kaas & Mulvad. He specializes in getting data by extracting websites, negotiating, using FOI requests and scraping. He started using scrapers in 2004 and has mainly worked with Kapow, Helium Scrapers, Import.io and Python. Nils analyzes data -- looking for patterns and the most interesting conclusions to be drawn out of data. He has trained journalists and others in data for more than 20 years.

On Twitter: @nmulvad

#data cleaning #openrefine

hands-on

Create interactive demographic maps in minutes with ArcGIS Online

Thursday, 10:15 – 11:15 a.m. (1 hour) • Studio 7, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Demographic information can add critical context to any story. When paired with location, it can help explain why things happen where they do. Join us for a hands-on session where we’ll explore visualization- and analysis-ready datasets available to use in your stories. We’ll show you how to quickly find authoritative content in ArcGIS Online, run powerful spatial analyses, and create responsive web apps to support your reporting.

You will get hands-on experience with the browser-based ArcGIS Online. Anyone who attends this session will also receive complimentary access to ArcGIS Pro, ArcGIS Online, and ArcGIS Maps for Office so you can continue your visualization journey long after you leave the conference.

This session is good for: Anyone who’s wanted to dig into demographics but wasn’t sure where or how to start and those interesting in telling visual stories with that data.

Speakers

Robby Deming, Esri

Christopher Vaillancourt, Esri

#mapping #arcgis

panel

Investigating natural disasters: What to do before, during and after

Thursday, 11:30 a.m. – 12:30 p.m. (1 hour) • Galerie 3, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

We'll talk about databases you need to be prepared before a disaster occurs, how to gather data in real-time, and long-range strategies for reporting on recovery efforts.

Speakers

Jeff Adelson, The Times-Picayune | The New Orleans Advocate 👇

Jeff Adelson is a reporter for The Times-Picayune | The Advocate who has been covering politics, levees and disasters in the New Orleans area for more than a decade. When not stomping through flooded streets or hanging around City Hall, he works on data projects across the three Advocate papers, including the Pulitzer Prize-winning series "Tilting the Scales."

Laura Moscoso, Centro de Periodismo Investigativo 👇

Journalist with nine years in the industry. Since 2015, she has worked as a data journalist for Centro de Periodismo Investigativo in San Juan, Puerto Rico. She teaches workshops on data and data visualization for students and journalists.

On Twitter: @laurac_moscoso

Eric Sagara, Big Local News 👇

Eric is a senior data reporter for Big Local News at Stanford University. Before that, he was on the data team at Reveal from the Center for Investigative Reporting. He also has been a news applications fellow at ProPublica and a data reporter at the Newark Star Ledger.

#natural disaster

panel

Data and docs for your arsenal

Thursday, 11:30 a.m. – 12:30 p.m. (1 hour) • Bissonet, 3rd floor

💪 Skill level: General interest

SHOW MORE

Description

Get your FOI templates ready to roll. In this quick-paced, lightning-round style session, two investigative reporters and public records geeks will cover their favorite, most unique, overlooked and under-appreciated records to request from all levels of government. They'll also give examples of how these records were used to produce stories in newsrooms around the country.

Speakers

Samah Assad, CBS Chicago/WBBM 👇

Samah Assad, an investigative journalist and producer who has won Murrow and Emmy Awards, specializes in data analysis, FOIA and digital interactivity with CBS Chicago's investigative unit. She previously produced with the investigative unit at ABC in Cleveland and worked as a crime reporter with the Morning Journal in Ohio. Her reporting focuses on uncovering systemic failures, including police misconduct, government corruption, lack of transparency and waste of taxpayer money.

On Twitter: @SAssadNews

Kate Martin, Carolina Public Press 👇

Kate Martin is the lead investigative reporter for Carolina Public Press. Her work has led to the creation of four state laws and the resignation of several elected officials. Her deep analysis of years of North Carolina court records showed that fewer than 1 in 4 people charged with sexual assault are ever convicted of that or a lesser crime.

On Twitter: @Katereports

#open records

hands-on

Excel 3: Filtering & pivot tables

Thursday, 11:30 a.m. – 12:30 p.m. (1 hour) • Studio 8, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

A look at the awesome power of pivot — and how to use it to analyze your dataset in minutes rather than hours. We'll work up to using a pivot table by first sorting and filtering a dataset, learning how to find story ideas along the way.

This session is good for: Anyone familiar with formulas and navigating Excel or another spreadsheet program.

Speaker

Mark Walker, The New York Times 👇

Mark Walker is a FOIA researcher in The New York Times Washington, D.C., bureau.

On Twitter: @bymarkwalker

#data analysis #excel

hands-on

Python: Let's scrape a website

Thursday, 11:30 a.m. – 12:30 p.m. (1 hour) • Studio 9, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

This session will show you how to use the Python programming language to scrape data from websites.

This session is good for: People who already feel comfortable writing simple Python scripts and understand basic syntax (data types, if/else statements, for loops, etc.). Experience with HTML is a plus but not necessary.

Note: It would be useful to attend the demo session "How the internet works (so you can scrape the web!)" at 9 a.m. Thursday if you’re not familiar with the topic already.

Speaker

Ryan Pitts, OpenNews 👇

Ryan Pitts is a developer and journalist in Spokane, Washington. He's the program lead for technology with OpenNews, a nonprofit organization that helps newsroom developers, designers and data analysts collaborate and share knowledge that builds stronger, more inclusive practices in journalism. He's also part of Census Reporter, which makes census data easier for journalists to use, and he was the senior editor for digital media at The Spokesman-Review in Spokane.

#web scraping #python

hands-on

Google Sheets: Scraping without coding

Thursday, 11:30 a.m. – 12:30 p.m. (1 hour) • Studio 1, 2nd floor

💪 Skill level: Beginner

SHOW MORE

Description

Yes, you can scrape data without using code -- in fact, all you need is Google Sheets! We'll be using Excel-type formulas (don't worry if you don't know what those are, either) to make simple scrapers that automatically pull data into Google Sheets. It’s the best way to get around clunky websites and unhelpful PIOs!

This session is good for: Beginners who want to start using data for their stories.

Speaker

Samantha Sunne, Independent journalist 👇

Samantha Sunne is a freelance journalist based in New Orleans. She speaks at conferences, universities and newsrooms around the world, teaching digital tools and tech literacy for journalists. Her work has been published by the Washington Post, NPR and Reuters, and recommended by the Poynter Institute and the Harvard Shorenstein Center on Media, Politics and Public Policy.

On Twitter: @samanthasunne

#web scraping #google sheets

panel

Covering polls and understanding best polling practices for 2020

Thursday, 11:30 a.m. – 12:30 p.m. (1 hour) • Acadia, 3rd floor

💪 Skill level: Beginner

SHOW MORE

Description

The 2020 presidential election is in full swing and with it comes the steady stream of horse race numbers. So which polls are methodologically sound? What’s the difference between an online poll and a telephone poll? What’s a “topline,” and why is it important? What’s an “n-size” and how much should it be? But most importantly: when is a dip or rise in vote choice worth writing about?

Speaker

Joanna Piacenza, Morning Consult 👇

Joanna Piacenza is the senior data editor for Morning Consult, a global data intelligence company delivering insights on what people think in real-time. Her editorial focus on the intersection of business, media and politics produces compelling and viral data-driven stories. Prior to Morning Consult, she served as editor for PRRI across all of its publications, also writing and managing long-term public opinion projects.

On Twitter: @jpiacenza

#election & politics

hands-on

Datasette: An ecosystem of tools for exploring data and collaborating on data projects

Thursday, 11:30 a.m. – 12:30 p.m. (1 hour) • Studio 6, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Datasette is a growing ecosystem of tools for exploring and publishing data. With Datasette you can take raw data from a variety of different formats, import it into a SQLite-backed web interface, explore it, visualize it, map it and then publish it along with an API to enable further custom development.

This workshop will introduce Datasette using Datasette Cloud, a new hosted service that allows you to run the tools and collaborate on data projects with members of your team. Topics covered will include:

* Using Datasette Cloud to upload, explore and analyze data from a variety of sources
* Using full-text search and facets to quickly analyze large and complex datasets
* Visualizing numeric and geographic data using Datasette plugins
* Running Datasette and associated tools on your own machine using the command line

This session is good for anyone. Basic familiarity with SQL and the command line is helpful but not necessary.

Speaker

Simon Willison, JSK Fellowships at Stanford 👇

Simon is the creator of Datasette, a tool for exploring and publishing data. Datasette is based on Simon's experiences working as a data journalist at the UK's Guardian newspaper. Simon is also a co-creator of the Django web framework. He is currently participating in the JSK Fellowship program at Stanford. simonwillison.net

On Twitter: @simonw

#data analysis #command line

commons

Bringing data journalism to your student newsroom

Thursday, 11:30 a.m. – 12:30 p.m. (1 hour) • Galerie 4, 2nd floor

💪 Skill level: Beginner

SHOW MORE

Description

Many journalists and journalism educators run from numbers and data because the words are scary without an understanding of real-world applications. At Loyola University New Orleans we have had success making data come alive for our students by partnering with InvestigateTV on projects so students can relate to the numbers and see how data is used professionally. We will discuss our projects and give ideas for finding partners so you can do the same whether you are an educator looking to enhance classroom learning, a student who wants to intern or work on a newsroom data project, or a professional eager for data help from a nearby university.

Speakers

Laura Jayne, Loyola University New Orleans 👇

Prof. Laura Jayne teaches journalism at Loyola University in New Orleans, where she also runs the Loyola Student News Service. Before that, she worked for The Times-Picayune for 20 years in many capacities, including Page One Editor. She has a journalism degree from Syracuse University.

On Twitter: @LauraBeat

Anum Siddiqui, Loyola New Orleans University 👇

Anum is a multimedia journalist with experience in reporting, writing, shooting and editing news stories for television and radio news. When Anum isn't chasing a story, she is pounding the pavement with her running shoes. She also enjoys being involved in her community. She holds strong pride in her South Asian culture and practices the experiences it has to offer.

On Twitter: @_anumsiddiqui2

Erin Snodgrass, Loyola University New Orleans 👇

Erin Snodgrass is a graduating senior at Loyola University New Orleans. She has worked with Gray TV's national investigation team as a news content specialist and as a student journalist. In addition to her work with Investigate TV, Erin is the editor in chief of Loyola University's award-winning media outlet The Maroon. She has interned at Česká televize in the Czech Republic, at her hometown newspaper and in the congressional office of U.S. Rep. Denny Heck.

#students

panel

Covering the Coronavirus: Reporting on local emergency preparedness

Thursday, 11:30 a.m. – 12:30 p.m. (1 hour) • Galerie 2, 2nd floor

SHOW MORE

Description

Details coming soon!

Speakers

Sarah A. Babcock, New Orleans Health Department 👇

Sarah A. Babcock is the director of policy and communications for the New Orleans Health Department, where she oversees emergency preparedness, environmental health, health policy and communications. She is the lead for all public health emergencies for the City of New Orleans and has overseen response to Ebola, Zika and now COVID-19. Ms. Babcock has a master's degree in public health from Tulane University and previously worked for the Florida Department of Health.

Anna Maria Barry-Jester, Kaiser Health News 👇

Anna Maria Barry-Jester is a senior correspondent with Kaiser Health News focusing on health disparities, public health and health care. She was previously a reporter with FiveThirtyEight, Univision and ABC News, and she has also been a freelance photographer and videographer. She lives in California.

On Twitter: @annabarryjester

Caroline Chen, ProPublica 👇

Caroline Chen covers health care for ProPublica.

On Twitter: @CarolineYLChen

hands-on

Making graphics with R

Thursday, 11:30 a.m. – 12:30 p.m. (1 hour) • Studio 7, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

It’s easy to make slick data visualizations with R’s ggplot library. But ggplot also has all the capacity you need to build sophisticated, production-ready charts without ever leaving R. Come break away from theme_grey() and learn how you can make your ggplots shine.

This class is best for: People who are comfortable with Excel and looking for something more powerful; beginner knowledge of R is good but not required.

Speaker

David Montgomery, Minnesota Public Radio News 👇

David Montgomery is a data journalist currently covering the 2020 election for Minnesota Public Radio News. He previously worked for CityLab, the Pioneer Press and other newsrooms, and he produces a history podcast about 19th Century France, The Siècle (thesiecle.com).

On Twitter: @dhmontgomery

#data viz & design #r

hands-on

Data cleaning with OpenRefine 2: More advanced uses

Thursday, 11:30 a.m. – 12:30 p.m. (1 hour) • Studio 10, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

This class will cover more advanced techniques for cleaning data using OpenRefine, including regular expressions and writing custom cleaning scripts.

The session is good for people who are comfortable using the basic functions of OpenRefine.

Speakers

Tommy Kaas, Kaas & Mulvad 👇

Tommy Kaas is a data journalist, analyst, trainer and CEO at Kaas & Mulvad. He was co-founder of DICAR – the Danish International Center for Analytical Reporting. He has a background in print journalism and has previously worked as an assistant managing editor.

On Twitter: @tbkaas

Nils Mulvad, Kaas & Mulvad 👇

Nils Mulvad is partner and CEO at Kaas & Mulvad. He specializes in getting data by extracting websites, negotiating, using FOI requests and scraping. He started using scrapers in 2004 and has mainly worked with Kapow, Helium Scrapers, Import.io and Python. Nils analyzes data -- looking for patterns and the most interesting conclusions to be drawn out of data. He has trained journalists and others in data for more than 20 years.

On Twitter: @nmulvad

#data cleaning #openrefine

demo

Introduction to Google Data Studio

Thursday, 11:30 a.m. – 12:30 p.m. (1 hour) • Galerie 6, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Data Studio helps you tell beautiful stories with data. Using this free tool from Google, you can:

*Visualize your data through highly configurable charts and tables
*Easily connect to a variety of data sources
*Share your insights with your team or with the world
*Collaborate on reports with your team.
*Speed up your report creation process with built-in sample reports.

This presentation will cover the basics of connecting to data and creating and customizing a report, and demonstrate some of the more advanced features. We'll also take a look at some of the many public reports that have been created using Data Studio.

Speaker

Rick Elliott, Google 👇

Rick is a technical and UX writer at Google, focused on helping users integrate Data Studio and Google Analytics into their professional lives. Prior to joining Google, Rick ran a small team of writers at LiveOps, Inc., launched international websites and browsers at Netscape and tested and supported database products at Borland International back in the good old days of shrink-wrapped software.

#tools

special

Journalists of color in the newsroom meetup

Thursday, 12:45 – 2 p.m. (2 hours) • Carondelet, 3rd floor

💪 Skill level: General interest

SHOW MORE

Description

Grab some lunch and join other journalists of color for a networking and discussion session. IRE & NICAR will provide snacks, drinks and dessert.

Speaker

Caroline Chen, ProPublica 👇

Caroline Chen covers health care for ProPublica.

On Twitter: @CarolineYLChen

#diversity

hands-on

Intro to R

Thursday, 2:15 – 5:45 p.m. (3.5 hours) • Studio 2, 2nd floor

💪 Skill level: Intermediate

⚠️ This session requires pre-registration and an additional fee of $35 to reserve a seat.

SHOW MORE

Description

We'll introduce you to R, a free, powerful open-source programming language that will take your data reporting to the next level. By the end of this three-hour session, you will be able to read data from common file types into R, clean and explore it, create visualizations, and make your entire data workflow reproduceable. We'll also talk about how to find help when you're stuck.

Preregistration is required and seating is limited. Laptops will be provided for the training.

Workshop prerequisites: This session will be most helpful if you’re comfortable working with data and you’re ready to take your skills to the next level.

Speakers

Hannah Fresques, ProPublica 👇

Hannah Fresques is a data reporter at ProPublica. She holds a master’s degree in quantitative methods for social sciences from Columbia University, and previously worked in education policy research.

On Twitter: @HannahFresques

Agnel Philip, ProPublica 👇

Agnel Philip is a data reporter for ProPublica’s Local Reporting Network. He was previously a data reporter at The Arizona Republic.

On Twitter: @agnel88_philip

#data analysis #r

hands-on

Introduction to web development

Thursday, 2:15 – 5:45 p.m. (3.5 hours) • Studio 9, 2nd floor

💪 Skill level: Beginner

⚠️ This session requires pre-registration and an additional fee of $35 to reserve a seat.

SHOW MORE

Description

This session will introduce you to how the web works and the building blocks of web development: HTML, CSS and (a tiny bit of) JavaScript. By the end of the class, you will have built a simple web page and published it on the internet.

Preregistration is required and seating is limited. Laptops will be provided for the training.

Workshop prerequisites: This session is good for beginners -- no experience necessary.

Speaker

Sisi Wei, OpenNews 👇

Sisi Wei is the director of programs at OpenNews, where she envisions and executes transformative initiatives for journalism, especially for journalists of color and local journalists. Previously, she was assistant managing editor at ProPublica, where she oversaw and edited news apps, graphics, visual reporting and investigations.

#web development #html

hands-on

First Observable notebook: Prototyping with polish

Thursday, 2:15 – 5:45 p.m. (3.5 hours) • Studio 3, 2nd floor

💪 Skill level: Advanced

⚠️ This session requires pre-registration and an additional fee of $35 to reserve a seat.

SHOW MORE

Description

Alex Garcia, Ellis Simani, Ben Welsh and Aaron Williams teach you how to rapidly prototype a complex data visualization with JavaScript, D3.js and an interactive Observable notebook.

This three-hour, hands-on course will show you how journalists are putting Observable’s powerful potential to work. Using nothing but your web browser, you will sketch, refine and publish an interactive graphic like one that appeared in The New York Times. Along the way, you’ll see how Observable’s groundbreaking approach to coding can help you be more creative, ambitious and efficient.

Preregistration is required and seating is limited. Laptops will be provided.

Workshop prerequisites: If you’ve used JavaScript once or twice, have a good attitude and know how to take a few code crashes in stride, you are qualified for this class. If you’re suspicious and think we might be Internet hipsters, we welcome the challenge of winning you over. This stuff is cool.

Speakers

Alex Garcia, University of California San Diego 👇

Alex Garcia is a recent graduate from the University of California, San Diego, where he studied computer engineering, and a soon-to-be software engineer. He is interested in data pipelines, newsroom tools, Observable notebooks and algorithmic bias.

On Twitter: @agarcia_me

Ellis Simani, ProPublica 👇

Ellis Simani is a data reporter who was a Metpro fellow on the L.A. Times graphics desk before joining ProPublica. At the Times, he covered a variety of topics ranging from visualizing environmental issues along California’s coast to investigating the shortcomings of the Census Bureau’s racial categories. Prior to his work at the Times, Ellis interned with the Seattle Times News Apps team and participated in ProPublica’s Data Institute.

On Twitter: @emsimani

Ben Welsh, Los Angeles Times 👇

Ben is the editor of the Data and Graphics Department in the Los Angeles Times newsroom. The team of reporters and computer programmers works together to collect, organize, analyze and present large amounts of information. He is also a co-founder of the California Civic Data Coalition, a network of journalists and computer programmers dedicated to opening up public data, and the leader of PastPages, an open-source effort to better archive digital news.

On Twitter: @palewire

#data viz & design #javascript

master class

Master class: Statistics for journalists

Thursday, 2:15 – 5:45 p.m. (3.5 hours) • Galerie 5, 2nd floor

💪 Skill level: Intermediate

⚠️ This session requires pre-registration and an additional fee of $35 to reserve a seat.

SHOW MORE

Description

Statistical methods can help you go beyond counting, sorting and filtering data to look at relationships, make predictions and level the playing fields. Statistical analyses can provide hard evidence to back up (or discredit) a theory. This master class will help you understand the concepts and methods most often used by journalists, including:

* Linear regression
* Correlation
* Statistical significance
* Describing and visualizing your data

This master class is aimed at those already familiar with basic data analysis using spreadsheets and ready to add statistical analysis to their toolkits.

Please bring your laptop to the training. Before the conference, please install R and R Studio (free, open-source software) on your computers.

Speakers

Steve Doig, Arizona State University 👇

Steve Doig teaches data journalism at the Walter Cronkite School of Journalism of Arizona State University (ASU). Before joining ASU in 1996, he was research editor of the Miami Herald, where he worked for 20 years. Various data projects on which he worked at the Herald and at ASU have won the Pulitzer Prize for Public Service, the IRE Award, the Goldsmith Prize for Investigative Reporting, the George Polk Award and other recognition.

Holly Hacker, The Dallas Morning News 👇

Holly Hacker is an investigative reporter at The Dallas Morning News. Before that, she covered education at The News, the St. Louis Post-Dispatch and the Ventura County (California) Star. She's a past winner of the Philip Meyer Award for stories that exposed cheating on standardized tests in Texas.

On Twitter: @hollyhacker

#statistics

demo

Free and easy data viz

Thursday, 2:15 – 3:15 p.m. (1 hour) • Galerie 2, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

Got a data project you want to make shine, but you're short on time, money and help? We'll demonstrate several free tools both online and on your computer so you can make interactive maps, graphs, timelines, and even simple animations. No previous experience needed — and these tools work great for social media, online, print and television.

Speakers

Jamie Grey, InvestigateTV 👇

Jamie Grey is the executive producer of investigations for Gray Television and InvestigateTV, which produces stories for the company's stations in 93 television markets. She was previously a professor at the University of Missouri and an investigative and general assignment reporter in Iowa and Idaho. Jamie loves using data for journalism and life in general, tracking her Fantasy Football drafts and running and spinning miles.

On Twitter: @tvnewsjamie

Erin Mansfield, USA Today Network 👇

Erin is an investigative reporter for the USA Today Network based in Columbus, Ohio. She previously held city and county governments accountable in East Texas for the Tyler Morning Telegraph; covered health care, business, telecommunications, energy, and the Vermont Legislature for VTDigger.org; and wrote about town Select Boards for her hometown paper, the Rutland Herald. Twitter: @_erinmansfield

On Twitter: @_erinmansfield

#data viz & design

hands-on

Excel: Advanced pivot tables

Thursday, 2:15 – 3:15 p.m. (1 hour) • Studio 8, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

You've done a few pivot tables and are getting curious what more you could do with them. What happens if you aggregate by more than one column? What are those "column" and "filter" boxes for? Come unlock the full potential of pivot tables in this intermediate spreadsheet class.

This session is good for: People familiar with spreadsheets and aggregating data with pivot tables, or anyone who has taken Excel 1-3.

Speaker

Kimbriell Kelly, Los Angeles Times 👇

Kimbriell Kelly is the Deputy Editor for Enterprise and Investigations at the Los Angeles Times' Washington, D.C., Bureau. Prior to joining the Times in June, Kelly was a reporter on the Investigative Unit at The Washington Post, where she was part of the team that won a Pulitzer in 2015 for the examination of officer-involved shootings. She was a Pulitzer finalist in 2019 for her work on "Murder with Impunity,” a series on unsolved homicides.

On Twitter: @kimbriell

#data analysis #excel

hands-on

R 1: Intro to R and RStudio

Thursday, 2:15 – 3:15 p.m. (1 hour) • Studio 7, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Jump into statistics with R, the powerful open-source programming language. In this class we’ll cover R fundamentals and learn our way around the RStudio interface for using R.

This session is good for: People with a basic understanding of code who are ready to go beyond Excel.

Speaker

Rob Wells, University of Arkansas 👇

Rob is an Arkansas journalism data journalism professor whose research focuses on business and investigative journalism. He is the author of the 2019 book, "The Enforcers: How Little-Known Trade Reporters Exposed the Keating Five and Advanced Business Journalism," a former Dow Jones D.C. bureau chief, Wall Street Journal D.C. deputy bureau chief and a reporter for Bloomberg and The Associated Press. Rob has a Masters Degree from St. John's College and a PhD from the University of Maryland. Rob is a trail runner and jazz and blues freak, hosting the Jazz Scoop show on KUAF in Fayetteville.

On Twitter: @rwells1961

#data analysis #r

hands-on

Python 1: The fundamentals

Thursday, 2:15 – 3:15 p.m. (1 hour) • Studio 6, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

An introduction to the Python programming language for absolute beginners. This session will cover the fundamentals and basic syntax to prepare you for more advanced classes.

This session is good for: People who are comfortable working with data in spreadsheets or database managers and want to make the leap to programming.

Speaker

Caitlin Ostroff, The Wall Street Journal 👇

Caitlin Ostroff is a London-based reporter for The Wall Street Journal where she uses words, numbers and code to cover the world of finance. Previously, she was a data reporter at the Miami Herald, covering elections, gun violence and Mar-a-Lago. She’s a graduate of the University of Florida and co-director of @jourinternships’ online Media Mentors program. She’s happy to chat, so reach out at caitlin.ostroff@wsj.com.

On Twitter: @ceostroff

#programming #python

hands-on

Finding the story: Using DNS search for investigative journalism

Thursday, 2:15 – 3:15 p.m. (1 hour) • Studio 1, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

Every online interaction begins with a lookup in the Domain Name System (DNS), the backbone of the Internet. As a result, there are digital footprints left behind in the DNS. With the demise of Whois, investigative reporters are looking for new tools to uncover these footprints. Learn how to use DNSDB Scout, a tool to query DNSDB, a historical passive Domain Name System (DNS) database, to discover previously unknown online connections and gain new information to advance your ongoing and breaking news investigations.

Basic knowledge of the Domain Name System (DNS) is helpful, but not required.

Speaker

Paul Vixie, Farsight Security, Inc. 👇

Dr. Paul Vixie is an Internet pioneer and CEO of Farsight Security. An Internet Hall of Fame inductee, Dr. Vixie is a prolific author of open source Internet software including BIND, and many Internet standards documents concerning DNS and DNSSEC. He founded the first anti-spam company (MAPS, 1996), the first nonprofit Internet infrastructure software company (ISC, 1994) and the first neutral and commercial Internet exchange (PAIX, 1991). He spoke at NICAR in 2019.

#research

commons

Campaign finance questions people ask … plus yours!

Thursday, 2:15 – 3:15 p.m. (1 hour) • Galerie 4, 2nd floor

💪 Skill level: Beginner

SHOW MORE

Description

Join four veterans of working with campaign finance data as they take you through a series of common (and uncommon but good) questions journalists are likely to ask when using it. We’ll have a list of questions to answer; bring yours and we’ll try to answer them, too!

Speakers

Sheila Krumholz, Center for Responsive Politics 👇

Sheila Krumholz is executive director of the Center for Responsive Politics (CRP), a nonpartisan watchdog that tracks and reports on money in U.S. politics on its website, OpenSecrets.org. Ms. Krumholz has testified before Congress and the Federal Election Commission on issues related to government transparency and regularly provides commentary on money in politics and training on CRP’s data. She has a degree in international relations and political science from the University of Minnesota.

Anna Massoglia, Center for Responsive Politics 👇

Anna Massoglia is a researcher at the Center for Responsive Politics. She runs OpenSecrets' Dark Money project, tracks digital and political advertising, investigates foreign influence, and helped launch the Foreign Lobby Watch project. Anna received her J.D. from the University of the District of Columbia School of Law in 2015 and holds dual B.A. degrees from North Carolina State University. She previously worked as an editor and research analyst at Bloomberg Tax.

On Twitter: @annalecta

Derek Willis, ProPublica 👇

Derek Willis is a news applications developer at ProPublica, focusing on politics and elections. He previously worked as a developer and reporter at The New York Times, a database editor at The Washington Post, and in roles at the Center for Public Integrity and Congressional Quarterly. He began his journalism career at The Palm Beach Post. He is a co-founder of OpenElections, a project to collect and publish election results from all 50 states.

Chris Zubak-Skees, Center for Public Integrity 👇

Chris Zubak-Skees analyzes data, writes code and does original design as the Center for Public Integrity’s data editor.

#election & politics #election

demo

Using open crime and policing data

Thursday, 2:15 – 3:15 p.m. (1 hour) • Galerie 3, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Open data provides unique insights into crime, policing and criminal justice activity within a city and creates a new opportunity to tell complex, interactive stories in dashboard format. These data are a terrific source for identifying changing crime trends, evaluating policy effectiveness, and providing transparency to the public on issues of critical importance. In this presentation Jeff Asher of AH Datalytics will go over the different types of available data throughout the criminal justice spectrum and give examples of how these data can be used both in terms of analyzing crime trends as well as building dashboards to better illustrate a story.

Speaker

Jeff Asher, AH Datalytics 👇

Jeff Asher is the co-founder of AH Datalytics, a data analytics consulting company based in New Orleans. Mr. Asher works as a public safety consultant for the New Orleans City Council and has served as a crime analyst for the New Orleans Police Department and Jefferson Parish Sheriff's Office. His work has been featured nationally on FiveThirtyEight.com, The New York Times and more.

On Twitter: @Crimealytics

#crime

panel

Year in CAR: Local innovation

Thursday, 2:15 – 3:15 p.m. (1 hour) • Acadia, 3rd floor

💪 Skill level: General interest

SHOW MORE

Description

So often the most celebrated examples of innovation in digital, visual and interactive journalism come from teams with uncommon access to resources and talent. You know the ones, often on the coasts, that continually set the industry standard for digital innovation.

This panel isn't about those newsrooms. Instead, it will showcase the creative digital storytelling happening in local and regional newsrooms, where time and resources are scarce. The panel will be framed as a series of short talks and examples and will include an ability for journalists who cannot attend NICAR to present their work as well.

Speaker

Chase Davis, Minneapolis Star Tribune 👇

Chase Davis works on initiatives related to digital transformation and strategy at the Star Tribune in his hometown of Minneapolis. Previously, he ran the Interactive News desk at The New York Times and worked as as reporter and editor in Texas, Iowa and California. He also teaches a class in advanced data journalism at his alma mater, the University of Missouri.

On Twitter: @chasedavis

#story ideas

panel

Diverse newsrooms can produce better journalism: Let's make it happen

Thursday, 2:15 – 3:15 p.m. (1 hour) • Bissonet, 3rd floor

💪 Skill level: General interest

SHOW MORE

Description

When news organizations create a culture built on inclusion and equity, they can better support their staff and provide more representative, impactful journalism to the communities they serve. We'll discuss tactics and strategies for building diverse teams, where decision-making power is transparent and there are clear career and leadership pathways for journalists of color and other marginalized journalists.

Speakers

Paul Cheung, Knight Foundation

Anna Flagg, The Marshall Project 👇

Anna Flagg is The Marshall Project's senior data reporter, covering criminal justice topics including immigration, crime, race, policing and incarceration. Her work has been recognized by the Global Editors Network’s Data Journalism Awards, the Society of News Design and the Information is Beautiful Awards, and she was a finalist for a 2019 Deadline Club Award.

On Twitter: @annaflagg

David McKie, National Observer 👇

David McKie is an Ottawa-based, award-winning journalist and co-author of three journalism textbooks and two user guides. He teaches at Carleton University and the University of King's College, and he is a trainer with the Canadian Association of Journalists.

Kae Petrin, St. Louis Public Radio 👇

Kae Petrin covers transit, housing and miscellanea as a digital reporter for St. Louis Public Radio. They work across genres and mediums but spend much of their time with data analysis, public records and data visualization. Kae won the 2019 Missouri Broadcasters Association award for Convergent Media. They have a bachelor’s degree from Washington University in St. Louis and a programming certificate from LaunchCode.

On Twitter: @kmaepetrin

#diversity

panel

Finding and researching international connection

Thursday, 2:15 – 3:15 p.m. (1 hour) • Galerie 6, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

How do we follow people, money and assets when they cross borders? How do we find the hidden cash of Kleptocrats? We’ll discuss sources, tools and communities being used by investigative reporters to find personal, company and government information around the world.

Speakers

Leila Haddou, Independent journalist 👇

Leila Haddou is an investigative reporter and former data journalism editor for The Times and Sunday Times in London. She has previously worked on investigations for the Financial Times and the Guardian and has an avid interest in how technology can aid deep-dive, public interest reporting.

On Twitter: @leilahaddou

Friedrich Lindenberg, Organized Crime and Corruption Reporting Project 👇

Friedrich leads the data team at the Organized Crime and Corruption Reporting Project, a global network of investigative reporters focussed on large-scale corruption, abuses of power and money laundering. He coordinates the development of Aleph, a data analysis suite for cross-border anti-corruption investigations.

Margot Williams, The Intercept 👇

Margot Williams is an investigative researcher at The Intercept. She has pursued jihadists online and detainees who died in U.S. immigration detention, investigated Iraq war contractors and followed the money (and private jets and yachts) of mayors, governors, senators, oligarchs, presidential candidates and ex-presidents at ICIJ, NPR, The New York Times and The Washington Post.

#international

hands-on

Mastering Google Sheets: Web scraping, running scripts and other tricks (Thursday)

Thursday, 2:15 – 5:45 p.m. (3.5 hours) • Studio 10, 2nd floor

💪 Skill level: Beginner

⚠️ This session requires pre-registration and an additional fee of $ to reserve a seat.

SHOW MORE

Description

Google Sheets is more than just free spreadsheet software to organize and store data. This hands-on session will start with pivot tables and conditional formatting, and through examples, we'll also learn how to scrape data in seconds without code, automate menial tasks with macros, write custom spreadsheet formulas as well as how to send emails, geocode addresses, translate text and more – all through the power of Google Sheets. Come with a laptop and leave with the knowledge of a Google Sheets power user.

Preregistration is required and seating is limited. You musthave a Google account. Computers will be provided.

Workshop prerequisites: You should be familiar with using spreadsheets and formulas.

Speaker

Frank Bi, Vox Media 👇

Frank Bi is a senior storytelling engineer at Vox Media in New York City where he works on innovative storytelling projects for the web. He also teaches data literacy and visualization at Fordham University and is a Google News Initiative trainer, teaching journalists in newsrooms and at conferences across the country how to use free journalism tools. Frank is the president of the Asian American Journalists Association's New York chapter.

#web scraping #google sheets

hands-on

R 2: Data analysis and plotting

Thursday, 3:30 – 4:30 p.m. (1 hour) • Studio 7, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

We'll use the tidyverse packages dplyr and ggplot2, learning how to sort, filter, group, summarize, join, and visualize to identify trends in your data. If you want to combine SQL-like analysis and charting in a single pipeline, this session is for you.

This session is good for: People who have worked with data operations in SQL or Excel and would like to do the same in R.

Speaker

Maureen Linke, Wall Street Journal 👇

Maureen Linke is a graphics editor at the Wall Street Journal, specializing in visual storytelling and data visualization around national politics.

On Twitter: @maureenlinke

#data analysis #r

hands-on

Python 2: Intro to data analysis using Pandas

Thursday, 3:30 – 4:30 p.m. (1 hour) • Studio 6, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

Imagine rolling Excel and MySQL into one tool that also allows you to track your code and share it. That’s Pandas in a nutshell. There’s a lot more you can do with it, of course, but this will be a good start. We’ll learn how to slice and dice our data and extract basic stats. Specifically, we’ll cover loading the data, filtering, sorting and grouping data.

This class is good for: People who are comfortable with Excel and are familiar with the basics of SQL and Python.

Speaker

Cody Winchester, IRE & NICAR 👇

Cody is a training director at Investigative Reporters & Editors. Before joining IRE, he worked at newspapers in Texas, Nebraska and South Dakota.

#data analysis #python

hands-on

PDF 1: How to extract text and tables from PDFs like a boss

Thursday, 3:30 – 4:30 p.m. (1 hour) • Studio 8, 2nd floor

💪 Skill level: Beginner

SHOW MORE

Description

This class will cover basic approaches for getting text out of PDF documents using online tool Cometdocs. IRE members have free subscriptions, which means no limit to the number of documents to convert. (No attendance is necessary, just email cometdocs@ire.org). For extracting tables, you'll play with Tabula in a step-by-step demo. In addition, you'll learn how to use a text editor and the import feature in Excel if neither of these approaches work. Lastly, if time allows, you'll see a demo of PDFtk, used for merging, splitting, and rotating a large batch of PDFs. Note that we will not cover Optical Character Recognition as it will be addressed in PDF2.


This session is good for: Non-coders without access to Adobe Acrobat Pro/DC and people who are unfamiliar with PDF-to-text tools or would like to learn how these tools can be used for extracting difficult text from images embedded in a PDF document.

Speaker

Kevin Crowe, USA Today 👇

Kevin Crowe is a data journalist on USA Today's national investigative team. In the past, he's worked for the Milwaukee Journal Sentinel, inewsource in San Diego and the St. Louis Post-Dispatch.

On Twitter: @kcrowebasspro

#pdfs

demo

Uncloaked: Flight tracking for investigating people, planes and patterns

Thursday, 3:30 – 4:30 p.m. (1 hour) • Galerie 2, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

Reporters might track private aircraft a CEO or head coach is using to scope out a new headquarters or hire, uncover patterns of surveillance by law enforcement or military aircraft, or detect planes or people possibly involved in illegal activity.

This session will help you understand how flight tracking works and what tools and organizations are available to help you take off, including how to set up your own feeder with a simple device and an antenna. Get beyond efforts to block identifying aircraft with solutions from representatives of ADS-B Exchange and C4ADS.

Speakers

Patrick Baine, C4ADS 👇

Patrick received his undergraduate degree in Political Science and Chinese Language from Appalachian State University. He then lived, worked, and studied in China for five years, which included a one-year Master's Certificate program at the Hopkins-Nanjing Center. Patrick received his Master's in International Relations and International Economics from the Johns Hopkins University School of Advanced International Studies.

Jake Glass, C4ADS 👇

Data scientist and developer with C4ADS in Washington, D.C., focusing on public data analysis and accessibility. Planes, vessels, cryptocurrency, and cybersecurity.

On Twitter: @jakeaglass

Paula Lavigne, ESPN 👇

Paula Lavigne has been an investigative reporter for ESPN since 2008, working for both digital and TV. She has a background in data journalism. Her work has been recognized with several awards including a Peabody, duPont and IRE's first sports investigation award. Prior to ESPN, she worked at newspapers in Dallas; Des Moines, Iowa; and Tacoma, Wash. She is a graduate of the University of Nebraska and Creighton University.

James Stanford, ADSBexchange.com 👇

ADSBexchange.com is a co-op of ADS-B/Mode S/MLAT feeders from around the world and the world’s largest source of unfiltered flight data. James Stanford is the co-maintainer of ADSBxechange.com and is responsible for daily operations and community outreach.

On Twitter: @adsbexchange

#tools

panel

Tracking dark money in the 2020 elections

Thursday, 3:30 – 4:30 p.m. (1 hour) • Bissonet, 3rd floor

💪 Skill level: General interest

SHOW MORE

Description

Dark money is already playing a major role in 2020 elections. This panel will provide an overview of what you need to know to uncover dark money activity and try to find out who is behind it.

Learn how to follow the money trails with tools and techniques to track secretive groups, piece together opaque spending networks, and uncover donors through political ad records, corporate records, and campaign finance data as well as filings with the Internal Revenue Service, Department of Labor, Congress, and more.

Speakers

Michael Beckel, Issue One 👇

Since March 2017, Michael Beckel has worked as the research director at Issue One, a bipartisan advocacy organization in Washington, D.C., focused on government accountability, ethics and transparency issues. He previously worked as a reporter at both the Center for Public Integrity and the Center for Responsive Politics. Beckel’s exploits have taken him inside the U.S. Supreme Court multiple times, including for the oral arguments in Citizens United.

On Twitter: @mjbeckel

Robert Maguire, Citizens for Responsibility and Ethics in Washington 👇

Robert is the research director at Citizens for Responsibility & Ethics in Washington (CREW), a watchdog group that promotes transparency and government ethics. Prior to joining CREW, Robert created OpenSecrets.org's program tracking the financial networks of dark money groups. In 2014, he won the Society of Professional Journalists' Sigma Delta Chi Award for a series of investigative reports tracking dark money.

On Twitter: @RobertMaguire_

Anna Massoglia, Center for Responsive Politics 👇

Anna Massoglia is a researcher at the Center for Responsive Politics. She runs OpenSecrets' Dark Money project, tracks digital and political advertising, investigates foreign influence, and helped launch the Foreign Lobby Watch project. Anna received her J.D. from the University of the District of Columbia School of Law in 2015 and holds dual B.A. degrees from North Carolina State University. She previously worked as an editor and research analyst at Bloomberg Tax.

On Twitter: @annalecta

#election & politics #election

panel

Investigating bias: From housing to policing

Thursday, 3:30 – 4:30 p.m. (1 hour) • Acadia, 3rd floor

💪 Skill level: General interest

SHOW MORE

Description

Racial biases are pervasive in many of our public systems, from policing to housing to education. Learn how you can pinpoint potential bias on your beat, and how to use additional reporting methods to make sure the evidence is there.

Speakers

Ko Bragg, FRONTLINE/PBS 👇

Ko Bragg is a Mississippi-based investigative reporter with a focus on civil rights and juvenile justice. She is the lead reporter for FRONTLINE's upcoming interactive documentary about civil rights cold cases. She was previously a fellow at Reveal from the Center of Investigative Reporting, where she led an investigation that revealed overt racial bias in sentencing Mississippi kids as adults.

On Twitter: @keaux_

Topher Sanders, ProPublica

Olivia Winslow, Newsday 👇

Olivia Winslow has been a reporter at Newsday for 26 years and currently covers demographic trends on Long Island, which involves analyzing Census data for insight into how Long Island’s population is changing. Winslow earned a bachelor's degree in print journalism from Howard University in Washington, D.C., and a master's degree in journalism from Temple University in Philadelphia, Pennsylvania.

On Twitter: @newsollie

#diversity

demo

DataKit: Workflow automation for the newsroom and classroom

Thursday, 3:30 – 4:30 p.m. (1 hour) • Galerie 3, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Managing a data analysis project, from story idea to publication, shouldn't be so hard. The Associated Press will demonstrate how it uses DataKit, an open-source tool, to tame the tangles of your data analysis projects. Speakers will highlight features for producing standardized project structures, easily sharing code and data, and publishing data as part of a story package. The session will also show how Stanford University's journalism program is using DataKit in the classroom.

For help installing DataKit, attend the install party immediately following this session in Galerie 4.

Speakers

Larry Fenn, The Associated Press 👇

Larry Fenn is a data journalist at the Associated Press. His background is in mathematics and statistics.

On Twitter: @larry_fenn

Serdar Tumgoren, Stanford University 👇

Serdar Tumgoren teaches data journalism at Stanford University. He previously worked on data and news apps teams at The Associated Press, The Washington Post and Congressional Quarterly.

On Twitter: @zstumgoren

#tools

commons

A demo of the Big Local News platform

Thursday, 3:30 – 4:30 p.m. (1 hour) • Galerie 4, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

Come explore the Big Local News platform. You will learn how Big Local News fosters and supports collaborative data journalism. Log in to the BLN platform, create projects, upload and share data with individual users and entire groups (such an investigative team or a newsroom), use Datasette to open your data and analyze it. Learn about our Open Projects where the Big Local News team, the Accountability Project and others share data for the benefit of the journalism community. And hear about archiving your project data with the Stanford Digital Repository. You archive and then receive back a link that will never expire or change — perfect for sharing data with your readers, and for making sure that you don’t lose your work over time.

Speakers

Justin Mayo, Big Local News 👇

Justin Mayo is a data journalist with Big Local News, a project of Stanford’s Journalism and Democracy Initiative. He joined the team in December 2018 and believes in supporting local watchdog reporting through data gathering, analysis and training. Before Stanford, he spent 20 years as an investigative reporter with The Seattle Times, sharing the 2018 Selden Ring Award, the 2015 Breaking News Pulitzer Prize and the 2012 Pulitzer Prize for Investigative Reporting.

Cheryl Phillips, Stanford University

Eric Sagara, Big Local News 👇

Eric is a senior data reporter for Big Local News at Stanford University. Before that, he was on the data team at Reveal from the Center for Investigative Reporting. He also has been a news applications fellow at ProPublica and a data reporter at the Newark Star Ledger.

#tools

panel

International year in CAR

Thursday, 3:30 – 4:30 p.m. (1 hour) • Galerie 6, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

What were the big stories of the year outside of the US? What were the most creative uses of data analysis? See what your international colleagues have been up to and pick up some story ideas at the same time.

Speakers

John Bones, SKUP 👇

John Bones is managing director at SKUP, the Norwegian Foundation for Investigative Reporting. He is one of the Nordic data journalism pioneers, and he has been a journalist and editor at VG, the most read daily newspaper in Norway. He has education in history, statistics, Nordic languages and French, and he has realized trainings in Norway, Denmark, Latvia, Nepal, at VVOJ, at Dataharvest, and at NICAR, IRE and GIJ conferences.

Momi Peralta Ramos, La Nación 👇

Momi Peralta Ramos is the data journalism project manager at La Nación in Argentina. She is a computer scientist and MBA. Since 2011, she has led an open data project team called La Nación Data that includes developing data-driven journalism, open collaboration and open data in a country that only recently passed an FOI law. Besides data journalism, her interests are in applying technology and data science to discover and tell stories for social impact.

#story ideas

hands-on

"Scrollytelling" with Mapbox (repeat)

Thursday, 3:30 – 4:30 p.m. (1 hour) • Studio 1, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Build a scrollytelling experience using Mapbox Studio and the new Storytelling Solution by Mapbox with little to no code. In this session, you’ll learn to quickly create a scrollytelling map using Mapbox’s new template and publish the results on Glitch.

Speaker

Lo Bénichou, Mapbox 👇

Lo is an interactive developer and storytelling expert at Mapbox in San Francisco. They work on storytelling collaborations with external partners, write a lot of technical guides to mapping and cartography and support journalists whenever they can. They ❤️ maps and graphics. Before Mapbox, Lo was a frontend engineer at Wired. Prior to Wired, Lo worked as a visual journalist and interactive developer for numerous media outlets like Youth Radio, NPR, KQED and more.

On Twitter: @lobenichou

#mapping #mapbox

hands-on

R 3: Gathering and cleaning data

Thursday, 4:45 – 5:45 p.m. (1 hour) • Studio 7, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

Learn how to use R to scrape data from web pages, access APIs and transform the results into usable data. This session will also focus on how to clean and structure the data you've gathered in preparation for analysis using tidyverse packages.

This session is good for: People who have used R and have a basic understanding of how to retrieve data from APIs.

Speaker

Matt Waite, University of Nebraska-Lincoln 👇

Matt Waite is a professor of practice in the College of Journalism and Mass Communications at the University of Nebraska-Lincoln. He teaches courses in reporting, data journalism and data visualization. From 2000-2011, he worked for the St. Petersburg Times, where he developed the Pulitzer Prize-winning website PolitiFact, was an investigative reporter for the Times and co-authored "Paving Paradise: Florida's Vanishing Wetlands and the Failure of No Net Loss."

On Twitter: @mattwaite

#data cleaning #r

hands-on

Python 3: Data cleaning and visualization

Thursday, 4:45 – 5:45 p.m. (1 hour) • Studio 6, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

Now that you’ve got a handle on Pandas, it’s time to jump into some advanced topics. You know how to import a dataset, but what happens when you load the data and nothing looks right? We’ll walk through cleaning up a dirty dataset with Pandas. Then we’ll jump into the fun part: visualizing the data you’ve analyzed.

This session is good for: People who can load and perform basic summary and grouping functions in Pandas.

Speaker

Alexandra Kanik, Louisville Public Media 👇

Alexandra Kanik works for Louisville Public Media, the parent organization of Kentucky Center for Investigative Reporting and the Ohio Valley ReSource. She spends her days writing language-agnostic code, creating data visualizations and trying to understand newsroom analytics.

On Twitter: @act_rational

#data cleaning #python

hands-on

Finding the story: Campaign finance in Excel

Thursday, 4:45 – 5:45 p.m. (1 hour) • Studio 8, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Learn how to decipher federal campaign finance filings, how to find stories and how to navigate the limitations of the data.

This session is good for: People who are comfortable with Excel, but no specific campaign finance knowledge is required.

Speaker

Chad Day, The Wall Street Journal 👇

Chad Day covers the 2020 campaign and money in politics for The Wall Street Journal. He was previously a reporter on The Associated Press investigative team covering the Russia investigation and the Trump administration.

On Twitter: @ChadSDay

#election & politics #excel #election

panel

Countdown to the big count: Getting ready for Census 2020

Thursday, 4:45 – 5:45 p.m. (1 hour) • Acadia, 3rd floor

💪 Skill level: General interest

SHOW MORE

Description

Census 2020 has already begun, and it's already creating data — and stories. This session, anchored to the timeline of the coming year, will get you up to speed: key dates, lingo and what stories are possible when. We'll also offer a compendium of Census 2010 stories and local data like 2010 response and undercount rates. You'll also get a clear explanation of the unprecedented plan to add statistical noise to most Census 2020 results, and how that will affect your stories. Also: Late updates on the plan to use the census to bootstrap a controversial new data set: a count of citizens and non-citizens in every neighborhood.

Speakers

Paul Overberg, Wall Street Journal 👇

Paul Overberg is a data reporter at The Wall Street Journal and a member of its investigative team. He focuses on economic and demographic stories but helps reporters working on many subjects. He previously worked at USA TODAY, where he worked on projects that won the Philip Meyer Award for Precision Journalism and the National Headliner Award.

Gerson Vasquez, U.S. Census Bureau 👇

Gerson Vásquez is the Data Visualization Lead for the U.S. Census Bureau. In this role, he is working towards creating better understanding of demographic and socioeconomic data through interactive visualizations. Vásquez continues serving as a speaker on various census data topics, including 2020 Census planning and innovations using the Census API. He also specializes in census data on the Hispanic population within the U.S.

On Twitter: @uscensusbureau

MaryJo Webster, The Star Tribune 👇

MaryJo has been data editor at The Star Tribune in Minneapolis for five years. Previously, she had stints with the St. Paul Pioneer Press, USA Today, Digital First Media and Investigative Reporters & Editors. She started her career as a reporter at small papers in Minnesota and Wisconsin.

On Twitter: @MaryJoWebster

#census & demographics #census

panel

The wrong things we all do

Thursday, 4:45 – 5:45 p.m. (1 hour) • Bissonet, 3rd floor

💪 Skill level: General interest

SHOW MORE

Description

Embarrassing naming conventions. Bad filing systems. Hacky collections of varied datasets. Zooming in on or tossing outliers. It's not easy to find the line between using less-than-perfect data to get a story, or not doing a story because there's less-than-perfect data. Part brass tacks, part group therapy, this session highlights some of the bad practices we all share, and practical ways to improve.

Speakers

Emily Le Coz, GateHouse Media

Matt Wynn, USA Today 👇

Matt Wynn is data reporter on USA Today's investigative team. His work has looked at copycat legislation, police and doctors who escape discipline and the medicalization of previously benign inconveniences. He is the former director of enterprise and investigations at Medpage Today and previously worked at the Omaha World-Herald.

Joe Yerardi, The Center for Public Integrity 👇

Joe Yerardi is a data reporter at the Center for Public Integrity in Washington, D.C. In this role, he's investigated everything from the influence that pharmaceutical companies wield over Medicaid programs' drug purchasing decisions to the environmental destruction that abandoned coal mines wreak on Appalachia. Before joining the Center, Joe covered a wide range of beats as the data reporter at inewsource in San Diego and as the data editor at the San Antonio Express-News.

On Twitter: @JoeYerardi

#work better

demo

Encryption and journalism: From idea to publication

Thursday, 4:45 – 5:45 p.m. (1 hour) • Galerie 3, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

Many factors come into play when considering the security of a story. The most notable is the security around conversations with sources. While this is important, this is not the only point in the process to consider the security of your interactions and information. In this training, we will overview the different types of encryption and how it comes into play when researching, writing, and communicating new stories. Attendees will walk away from this training understanding how to make informed decisions about the security of their tools and process from research to publication of a story.

Speaker

Kristen Kozinski, The New York Times 👇

Kristen manages the security education program at The New York Times. Before joining The Times, she worked as an application security engineer and helped build secure coding education at email marketing platform Mailchimp. She is passionate about building accessible security education and resources for journalists around the world.

On Twitter: @dontclickonthat

#security

demo

Advanced data journalism through a browser

Thursday, 4:45 – 5:45 p.m. (1 hour) • Galerie 6, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

Every journalist has faced down the dreaded install of a new tool that doesn't go well — or even go at all. Maybe it's led to inscrutable Python error messages that no one can help you diagnose. Perhaps you work for an organization that won't (or can't) grant admin rights on company hardware. Or it could be that you're trying to teach command-line tools to a bunch of college students without having them brick their machines.

To get around some of these pitfalls, new tools/platforms like Binder, RStudio Cloud and others have come online, offering to serve up Python and R like the second coming of the Google Suite. But which services work best? What are the limits? What do they cost, if anything? How much work do you have to put in to get them functioning properly?

Speaker

Alex Richards, Syracuse University 👇

Alex is an assistant professor at Syracuse University's Newhouse School, where he teaches data journalism. He's a former training director at Investigative Reporters & Editors, and he has previously worked as a reporter and editor at the Chicago Tribune, NerdWallet, The Chronicle of Higher Education and the Las Vegas Sun, where he was a finalist for the Pulitzer Prize in 2011 and shared the Goldsmith Prize for investigative reporting.

On Twitter: @alexrichards

#tools

panel

Covering housing from A-Z: Localizing affordable housing stories and data

Thursday, 4:45 – 5:45 p.m. (1 hour) • Galerie 2, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

Stories about redlining and the inequities among home loan recipients from big banks have dominated housing coverage in recent years. But homeownership is just one part of the affordable housing conversation that needs coverage. Public housing authorities, federal disinvestment in public housing/the Section 8 program, county/city first-time homeowner loan programs, evictions at housing courts, slumlord landlords, tenant protection ordinances, and localizing coverage of how Secretary Ben Carson's HUD is affecting communities is vital, and this panel would show attendees how to do it.

This workshop is for people interested in amping up housing coverage as a side beat, their main beat or a one-time project. We'll discuss data they should be requesting from their local agencies for quick turn stories or to find trends, including from housing courts, public housing authorities and more. This workshop goes beyond the redlining projects to help journalists find data-driven affordable housing stories no matter where they are.

Speakers

Marissa Evans, The Star Tribune 👇

Marissa Evans is the social issues reporter for The Star Tribune in Minneapolis where she covers housing, health and equity issues. She was previously the health and human services reporter with The Texas Tribune, where she won an ONA Online Journalism Award in 2018 for her reporting on maternal mortality. Her reporting has appeared in Oprah Magazine, The Atlantic, Civil Eats, The Washington Post, The Milwaukee Journal Sentinel and Kaiser Health News.

On Twitter: @marissaaevans

Jessica Williams, The New Orleans Advocate 👇

Jessica Williams has covered politics and policy in her native New Orleans for more than a decade. In her five years at The New Orleans Advocate, which recently merged with the Times-Picayune, she's covered the rise of New Orleans’ mixed-income housing developments and gentrification’s effects on the city's real estate market. Before The Advocate, she covered education for The Times-Picayune and The Lens, a nonprofit news initiative. Follow her @jwilliamsNOLA.

On Twitter: @jwilliamsNOLA

#housing

commons

DataKit install party

Thursday, 4:45 – 5:45 p.m. (1 hour) • Galerie 4, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Looking for a way to tame the tangles of your data analysis projects? Try kicking the tires on DataKit, an open-source command-line tool designed to help journalists standardize project structures, easily share code and data, and publish data as part of story packages. Get up and running with existing workflows for the newsroom and classroom, or ask for help creating a customized workflow built around your own ecosystem of tools and services.

Developers from The Associated Press and Stanford University will be on hand to help journalists install DataKit. To learn more about DataKit and how it could work for your newsroom, attend the demo immediately before this session in Galerie 3.

Speakers

Larry Fenn, The Associated Press 👇

Larry Fenn is a data journalist at the Associated Press. His background is in mathematics and statistics.

On Twitter: @larry_fenn

Meghan Hoyer, The Associated Press 👇

Meghan Hoyer is data editor at The Associated Press, where she analyzes data and helps disseminate national data sets to reporters across the country, guiding them to find local stories in the numbers. She previously worked at USA TODAY and The Virginian-Pilot.

On Twitter: @meghanhoyer

Michelle Minkoff, The Associated Press 👇

Michelle Minkoff has been a data journalist at The Associated Press since 2011. Minkoff designs and develops data visualizations and creates, cleans and analyzes data sets, with an interest in environmental reporting, recently completing a project on national dam safety. Previously, she worked at PBS and the Los Angeles Times. She also taught data journalism at Northwestern's Medill School, of which she is a 2010 graduate.

On Twitter: @michelleminkoff

Serdar Tumgoren, Stanford University 👇

Serdar Tumgoren teaches data journalism at Stanford University. He previously worked on data and news apps teams at The Associated Press, The Washington Post and Congressional Quarterly.

On Twitter: @zstumgoren

#tools

hands-on

Workbench: Reproducible data work without coding

Thursday, 4:45 – 5:45 p.m. (1 hour) • Studio 1, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Workbench is an open-source tool that puts all stages of the data journalism process in one place, including scraping, cleaning, monitoring, and visualization -- all without coding, and all reproducible.

In this hands-on tutorial, you'll learn how to use Workbench for several different newsroom tasks. Scrape and clean data, monitor public sources, create live embeddable charts that update when new data is released, or share and automate useful workflows that other journalists can use to report.

Workbench is built to help make data tasks accessible to more people in the newsroom.

This session is good for journalists of all skill levels.

Speakers

Pierre Forcioli-Conti, Workbench 👇

Pierre is the CEO and co-founder of Workbench and director of Product at Meedan.

On Twitter: @pierreconti

Adam Hooper, Workbench 👇

Adam Hooper dances among computers and journalism to decipher the world. So far, he has dispersed sexuality awareness magazines in Tanzania, broken stories for Canadian, Rwandan, Tanzanian and American news agencies and launched several online data journalism tools. He's passionate about everything he doesn't understand yet.

#data wrangling

special

Welcome reception

Thursday, 6 – 7:15 p.m. (1.25 hours) • Carondelet, 3rd floor

SHOW MORE

Description

Join us for our welcome reception on Thursday, beginning at 6 p.m. Reconnect with longtime friends and welcome new attendees! Each attendee will receive one drink ticket for beer, wine, soda or bottled water. Light snacks also will be served.

Friday, March 6

special

Mentor program breakfast

Friday, 7:30 – 8:45 a.m. (1.25 hours) • Carondelet, 3rd floor

⚠️ This is an invitation-only event.

SHOW MORE

Description

If you signed up for the conference mentor program, come meet your match at this invitation-only breakfast.

The mentorship breakfast is sponsored by the Donald W. Reynolds Journalism Institute.

special

Conference registration

Friday, 8 a.m. – 5 p.m. (all day) • Preservation Foyer, 2nd floor

⚠️ Conference registration will be open on multiple days.

SHOW MORE

Description

Conference registration will be located on the 2nd floor in Preservation Foyer. Be sure to stop by and pick up your conference name badge. Name badges must be worn during the conference.

special

Conference sales

Friday, 8 a.m. – 5 p.m. (all day) • Studio Foyers, 2nd floor

⚠️ Conference sales will be open on multiple days.

SHOW MORE

Description

Stop by the NICAR sales table located in Preservation Foyer on the 2nd floor to browse books from the IRE store, IRE merchandise and shirts with the winning design from the T-shirt contest.

hands-on

PyCAR

Friday, 9 a.m. – 12:30 p.m. (3.5 hours) • Studio 3, 2nd floor

💪 Skill level: Intermediate

⚠️ This session requires pre-registration and an additional fee of $70 to reserve a seat.

⚠️ This session is split over multiple days.

SHOW MORE

Description

This hands-on workshop will teach journalists basic programming concepts using the Python language. The class, spread over two half-days, will introduce language basics and useful libraries in the course of a typical reporting project: scraping data from the web, analyzing a spreadsheet and visualizing the results.

Preregistration is required and seating is limited. Laptops will be provided for the training.

Workshop prerequisites: Although the class is geared toward programming beginners, attendees should have familiarity with the command line and be comfortable with databases and SQL.

Speakers

Tom Meagher, The Marshall Project 👇

Tom Meagher is the managing editor for digital and data at The Marshall Project, where he leads a team of designers, developers, visual journalists and data reporters covering the criminal justice system. A veteran reporter and editor, he's part of the team behind Klaxon, an open-source reporting tool for monitoring websites.

On Twitter: @ultracasual

Jacob Quinn Sanders, Factal 👇

Jacob Quinn Sanders somehow turned being a versatile reporter and editor into a career as a software developer. He has covered, supervised and built technology around news and real-time events across the U.S. and the world. He works at Factal, a company devoted to discovery and verification of news events as they develop.

On Twitter: @thejqs

Elaine Wong, CBC/Radio-Canada 👇

Elaine is a switcher-director at the Canadian Broadcasting Corporation, where she uses code to automate TV broadcasts. Previously, she was a technical director for an animation studio in Toronto, where she wrote Python scripts to build in-house tools, and she was a multimedia producer building interactive content for cbcnews.ca. When not coding, she organizes PyCon Canada, csvconf and PyLadies Toronto.

On Twitter: @elthenerd

#programming #python

hands-on

First Python notebook: Data analysis on deadline

Friday, 9 a.m. – 5:45 p.m. (all day) • Studio 6, 2nd floor

💪 Skill level: Intermediate

⚠️ This session requires pre-registration and an additional fee of $70 to reserve a seat.

SHOW MORE

Description

James Gordon, Cheryl Phillips, Andrea Suozzo and Ben Welsh guide you through a six-hour, hands-on investigation of money in politics.

You will learn:

* just enough Python to execute an analysis with pandas, one of the most popular open-source tools for working with data tables
* how to record, remix and republish your work using Jupyter, a browser-based tool emerging as the standard for reproducible research
* and how these tools can increase the speed and veracity of your journalism.

Along the way you’ll conduct your own investigation of California campaign donors using the California Civic Data Coalition’s open-source database archive.

Preregistration is required and seating is limited. Laptops will be provided.

Prerequisites: If you've tried Python once or twice, have good attitude and know how to take a few code crashes in stride, you are qualified. We want you.

Speakers

James Gordon, Reynolds Journalism Institute/Unversity of Missouri 👇

James is a designer and developer at the Reynolds Journalism Institute. He also teaches data journalism at the Missouri School of Journalism. He was previously lead developer for the California Civic Data Coalition.

On Twitter: @JE_Gordon

Cheryl Phillips, Stanford University

Andrea Suozzo, Seven Days 👇

Andrea Suozzo is the data editor at Seven Days newspaper in Vermont. She works with reporters to develop data-driven stories, creates data visualizations for stories and builds bots and databases to support newsgathering.

Ben Welsh, Los Angeles Times 👇

Ben is the editor of the Data and Graphics Department in the Los Angeles Times newsroom. The team of reporters and computer programmers works together to collect, organize, analyze and present large amounts of information. He is also a co-founder of the California Civic Data Coalition, a network of journalists and computer programmers dedicated to opening up public data, and the leader of PastPages, an open-source effort to better archive digital news.

On Twitter: @palewire

#data analysis #python

hands-on

Digging into data for stories: A crash course in Excel

Friday, 9 a.m. – 12:30 p.m. (3.5 hours) • Studio 2, 2nd floor

💪 Skill level: Beginner

⚠️ This session requires pre-registration and an additional fee of $70 to reserve a seat.

⚠️ This session is split over multiple days.

SHOW MORE

Description

Get started using data in your stories with IRE's original mini-boot camp. In this 7-hour, hands-on workshop, IRE’s experienced trainers will start with the basics of navigating Excel and using formulas, then walk you through sorting, filtering and aggregating data with pivot tables to find story ideas.

You'll come away with a solid base for using data analysis in your newsroom, including how to find and request data, identify and clean dirty data, find story ideas and bulletproof your work.

We’ll also provide you with our detailed boot camp materials to help keep you on track long after you leave the conference.

Preregistration is required and seating is limited. Laptops will be provided for the training.


Workshop prerequisites: There are no prerequisites for this workshop and beginners are welcome. This workshop is good for those wanting to get started analyzing data for stories.

Speakers

Patti DiVincenzo, IRE & NICAR 👇

Patti DiVincenzo is a training director at IRE. She spent more than three decades working in TV stations across the country, starting in Topeka, Kansas, and eventually landing at WSB-TV in Atlanta, where she was an investigative producer and data specialist for 16 years. A longtime member of IRE, she joined the staff in February 2019.

Sarah Hutchins, IRE & NICAR 👇

Sarah Hutchins is a training director for IRE & NICAR. She previously served as the organization’s editorial director, overseeing IRE’s publications and online platforms. Sarah has worked for daily newspapers in several states. Before joining IRE in 2014, she was a reporter at The Virginian-Pilot. Sarah has a bachelor's degree in journalism from Indiana University and a master's degree in data science and analytics from the University of Missouri.

On Twitter: @sarhutch

Francisco Vara-Orta, IRE & NICAR 👇

Francisco Vara-Orta is a training director at Investigative Reporters & Editors. He brings nearly 20 years of newsroom experience and has been published by a variety of news organizations, including Chalkbeat, Education Week, the San Antonio Express-News, Austin Business Journal, Los Angeles Business Journal and the Los Angeles Times. He earned a master’s degree in investigative/data journalism at the University of Missouri and a bachelor’s degree from St. Mary’s University in San Antonio.

#data analysis #excel

master class

Master class: Election 2020 data

Friday, 9 a.m. – 12:30 p.m. (3.5 hours) • Galerie 5, 2nd floor

💪 Skill level: General interest

⚠️ This session requires pre-registration and an additional fee of $35 to reserve a seat.

SHOW MORE

Description

This year brings important elections from local school boards to statehouses and the White House. This class, taught by two veteran political reporters, will help you gear up for Election 2020 coverage at any level of government, including:

* Tools and strategies for campaign finance data, from local to federal candidates
* Following the money and the messaging from campaigns
* Tracking the players beyond candidates, from super PACs to special interests and nonprofits
* Story ideas to help you plan election coverage for your newsroom

No previous data experience is necessary for this workshop, though familiarity with spreadsheets will help. Please bring your own laptop.

Speakers

Carrie Levine, Center for Public Integrity 👇

Carrie Levine investigates the influence of money in politics. She was previously research director at Citizens for Responsibility and Ethics in Washington, a reporter and associate editor for The National Law Journal, and she has also worked for the Charlotte Observer, the Patriot Ledger of Quincy, Mass., and The Sun (Lowell, Mass.). She is a graduate of Boston University and the Columbia University Graduate School of Journalism.

On Twitter: @levinecarrie

Derek Willis, ProPublica 👇

Derek Willis is a news applications developer at ProPublica, focusing on politics and elections. He previously worked as a developer and reporter at The New York Times, a database editor at The Washington Post, and in roles at the Center for Public Integrity and Congressional Quarterly. He began his journalism career at The Palm Beach Post. He is a co-founder of OpenElections, a project to collect and publish election results from all 50 states.

#election & politics #election

panel

Victims, villains and heroes: Turning data into characters

Friday, 9 – 10 a.m. (1 hour) • Galerie 3, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

Data helps bolster our investigations and find the right anecdotes through which to tell them. Our panel will help you think about how to turn data into compelling human stories that drive a narrative, create tension and make people care. We'll talk about how to find a perfect example in all that data and what to do if you can't.

Speakers

Jennifer Forsyth, The Wall Street Journal 👇

Jennifer is deputy chief of investigations for The Wall Street Journal. In that position, she helps manage a team of eight reporters, six data specialists, a news researcher, a graphics editor and a videographer. Most recently she managed a three-year, data-driven probe of derelict health care on Native American reservations. She also helped run the Journal's coverage of Trump's hush money, for which the team won the Pulitzer prize for national reporting.

Ellen Gabler, The New York Times 👇

Ellen Gabler is an investigative reporter at The New York Times. Before joining the Times, she worked at the Milwaukee Journal Sentinel as a reporter and deputy investigations editor. A native of Eau Claire, Wisconsin, Gabler is a graduate of Emory University and the Columbia University Graduate School of Journalism. She is a former IRE board member. @egabler

On Twitter: @egabler

Sarah Rafique, KTRK-ABC 13 👇

Sarah Rafique is an investigative producer at KTRK, the ABC-owned station in Houston, Texas, where she focuses on data reporting, visualization and telling investigations through compelling narratives. She previously worked as an investigative reporter at KXAN in Austin. Before that, she was a print reporter covering Fort Hood and West Texas. She's been recognized statewide and nationally for investigative reporting, breaking news and features.

On Twitter: @SarahRafique

#writing & storytelling

hands-on

Excel: Basic stats

Friday, 9 – 10 a.m. (1 hour) • Studio 8, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

You don't need a special statistics program to run simple statistical analysis. In this session, you'll learn how to compute some basic statistics in Excel and figure out what they mean.

This session is good for: People who already are comfortable with using functions in Excel.

Speaker

Norm Lewis, University of Florida 👇

Norman P. Lewis, Ph.D., is an associate professor of journalism at the University of Florida. He has 25 years of professional experience ranging from The Washington Post to chief editor of three community daily newspapers. He was a Fulbright Scholar to Kuwait in 2018-19.

On Twitter: @bikeprof

#statistics #excel

hands-on

JavaScript 1: Fundamentals and syntax

Friday, 9 – 10 a.m. (1 hour) • Studio 9, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Functions, "for loops" and objects: They can be confusing at first, but once you master these and other JavaScript coding conventions, you'll be on your way to building fancy data visualizations and more. In this class, you will learn the basic syntax of the JavaScript programming language.

This session is good for: Beginners who have been exposed to HTML at some point.

Speaker

Erin Petenko, VTDigger 👇

Erin Petenko is a data reporter for VTDigger, a watchdog nonprofit outlet in Vermont. She has also worked for NJ.com.

On Twitter: @EPetenko

#data viz & design #javascript

hands-on

Finding the story: Business data

Friday, 9 – 10 a.m. (1 hour) • Studio 10, 2nd floor

💪 Skill level: Beginner

SHOW MORE

Description

What is the economic output of your county? What are the most common local occupations? How important are sectors like tourism or health care or manufacturing? Where can you find data on recent layoffs? We’ll explain and explore a few key data sets to understand your local economy and use them to find stories tailored to your audiences.

This session is good for: Those with basic spreadsheet skills and curiosity about your local economy.

Speakers

Paul Overberg, Wall Street Journal 👇

Paul Overberg is a data reporter at The Wall Street Journal and a member of its investigative team. He focuses on economic and demographic stories but helps reporters working on many subjects. He previously worked at USA TODAY, where he worked on projects that won the Philip Meyer Award for Precision Journalism and the National Headliner Award.

Cezary Podkul, The Wall Street Journal 👇

Cezary is a reporter on the financial investigations team at The Wall Street Journal, where he specializes in data-driven news stories focusing on finance. Prior to the Journal, Cezary worked at ProPublica, Reuters and the Washington Post. Cezary earned a B.S. in economics from the Wharton School at the University of Pennsylvania and worked briefly on Wall Street before turning to financial journalism in 2008.

On Twitter: @Cezary

#business #excel

panel

Data Dive 2: Senior care, access to clean water, the probation trap

Friday, 9 – 10 a.m. (1 hour) • Bissonet, 3rd floor

💪 Skill level: General interest

SHOW MORE

Description

A data deep dive into some of the best data journalism of 2019. Hear from reporters how they gathered, cleaned, analyzed and visualized the data behind some of the year's biggest stories.

Speakers

Cindy Galli, ABC News 👇

Cindy Galli is chief of investigative projects for ABC News in New York. She oversees a team of award-winning network correspondents and producers specializing in longform investigations. Cindy serves on the board of directors for Investigative Reporters & Editors, where she has been a member since 1994. A longtime investigative producer, her work has garnered regional and national awards over 25 years of reporting. Bay Area native and UC Berkeley alum. Go Bears!

Jeff Kelly Lowenstein, Grand Valley State University 👇

Jeff Kelly Lowenstein is an investigative journalist, author and assistant professor of journalism at Grand Valley State University. He is the founder of the Center for Collaborative Investigative Journalism, a nonprofit organization that brings together investigative journalists, photographers and data scientists to conduct international investigations. A Fulbright Scholar, specialist and teacher, he has written or edited six books.

On Twitter: @JeffKLO

Dylan Purcell, The Philadelphia Inquirer 👇

Dylan Purcell is a data reporter on the Philadelphia Inquirer’s investigative team. He’s covered topics ranging from fatal police shootings, widespread cheating on school proficiency tests and newborn deaths following heart surgery at a for-profit hospital. He shared in the 2012 Pulitzer Prize for Public Service and was one of three reporters whose "Toxic City: Sick Schools" series was a finalist for the 2019 Pulitzer Prize and received the IRE watchdog innovation award.

#story ideas

demo

Navigating data.census.gov

Friday, 9 – 10 a.m. (1 hour) • Acadia, 3rd floor

💪 Skill level: General interest

SHOW MORE

Description

The 2020 Census is coming, and journalists need to be prepared! Come learn how to use Census Bureau data in your reporting with data.census.gov, the new site to access Census data. In this live demo, we will share tips and tricks while showing how to download data, customize the table view, and map your results.

Speaker

Tyson Weister, U.S. Census Bureau 👇

Tyson Weister is a program analyst at the U.S. Census Bureau, where he engages users on the agency's new dissemination platform, data.census.gov. Previously a survey statistician, he has specialized experience in helping data users access statistics from the American Community Survey through American FactFinder, the API and PUMS files.

On Twitter: @uscensusbureau

#census & demographics

hands-on

Getting started with Tableau Public

Friday, 9 – 10 a.m. (1 hour) • Studio 7, 2nd floor

💪 Skill level: Beginner

SHOW MORE

Description

Tableau Public is a popular visualization software that allows users to create great visuals and publish them in a few easy steps. This session will walk you through the basics, teach a few tricks, and set you up for the more advanced session to follow immediately afterwards.

This session is good for: People who are comfortable working with spreadsheets and are ready to start with data visualization.

Speaker

David McKie, National Observer 👇

David McKie is an Ottawa-based, award-winning journalist and co-author of three journalism textbooks and two user guides. He teaches at Carleton University and the University of King's College, and he is a trainer with the Canadian Association of Journalists.

#mapping #tableau

hands-on

Encryption tools for journalists

Friday, 9 – 10 a.m. (1 hour) • Studio 4, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

This session will review and provide practical training in the installation, configuration, and implementation of the best encryption tools for journalists to protect their privacy and sources from malicious hackers.

This session was planned in collaboration with the Border Center for Journalists and Bloggers.

Speaker

Jorge Luis Sierra, Border Center for Journalists and Bloggers 👇

Jorge Luis is the co-founder and president of the Border Center for Journalists and Bloggers, a non-profit organization based in Edinburg, Texas. He leads the Investigative Reporting Border Hub project to produce data-driven stories on corruption issues on both sides of the U.S.-Mexico border. He is an expert on cybersecurity and developed the Salama web application for journalists to conduct risk assessments and improve their security posture.

#security

demo

Exploring the radio spectrum for news

Friday, 9 – 10 a.m. (1 hour) • Galerie 2, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

Once the exclusive domain of scientists, engineers and HAM radio operators, a new generation of cheap hardware and open source software have cracked open the radio spectrum for hackers, hobbyists — and journalists — to explore. Radios are built into dozens of devices we use every day, and the radio spectrum is a tightly regulated, poorly understood invisible national asset. There are stories flying around in the air around you, and it’s time you started looking for them. We'll give an overview of how this all works, and walk you through the tools you can use to start poking around the radio spectrum. We’ll also look at some interesting examples of how the radio spectrum has been used in reporting the news.

Speaker

Jon Keegan, The Markup 👇

Jon Keegan is an Investigative Data Journalist at The Markup. Prior to The Markup, he was a Senior Research Fellow at the Tow Center for Digital Journalism at Columbia University, researching signals of trust in online news and studying the role of artificial intelligence in journalism. He also worked at The Wall Street Journal for 18 years, where he ran the interactive graphics team.

On Twitter: @jonkeegan

#sensors

commons

Code buddies: Get help on your project

Friday, 9 – 10 a.m. (1 hour) • Galerie 4, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

Have some data and ideas but you're not sure what to do next? Trying something new you learned at NICAR and need someone to doublecheck your math? OpenNews and the Lonely Coder's Club* want to help you get past whatever's blocking your next data or code project. Bring your laptop and we'll work together to move your project forward. Everyone is welcome! If you let us know a little about your project in advance, we'll reach out to some peer experts who have just the right experience to help you out.

Ryan Pitts - twitter: @ryanpitts; email: ryan@opennews.org
Alexandra Kanik - twitter: @act_rational; email: akanik@louisvillepublicmedia.org

*The Lonely Coder's Club is a Slack community of newsroom data nerds and programmers who run solo or on small teams.

Speakers

Alexandra Kanik, Louisville Public Media 👇

Alexandra Kanik works for Louisville Public Media, the parent organization of Kentucky Center for Investigative Reporting and the Ohio Valley ReSource. She spends her days writing language-agnostic code, creating data visualizations and trying to understand newsroom analytics.

On Twitter: @act_rational

Ryan Pitts, OpenNews 👇

Ryan Pitts is a developer and journalist in Spokane, Washington. He's the program lead for technology with OpenNews, a nonprofit organization that helps newsroom developers, designers and data analysts collaborate and share knowledge that builds stronger, more inclusive practices in journalism. He's also part of Census Reporter, which makes census data easier for journalists to use, and he was the senior editor for digital media at The Spokesman-Review in Spokane.

#work better

commons

Free, powerful tools for analyzing document dumps

Friday, 9 – 10 a.m. (1 hour) • Galerie 6, 2nd floor

SHOW MORE

Description

Finding needles in a haystack of documents is getting easier, thanks to tools aimed at helping journalists sort through pdfs to find names, dates and patterns. This session will demo two free and powerful tools — MuckRock's DocumentCloud, and Google's Backlight — that can help you manage and find stories in massive document dumps.

Speakers

Pam Dempsey, Midwest Center for Investigative Reporting 👇

Pam Dempsey is the executive director of the Midwest Center for Investigative Reporting. She is an award-winning journalist who has done investigative reporting and editing on topics including agribusiness, migrant farm workers, health, housing and Native American government. Dempsey, who is an online, print and radio journalist, has developed community engagement programs and investigative reporting workshops.

On Twitter: @pamelagdempsey

Dylan Freedman, DocumentCloud 👇

Dylan Freedman leads development for DocumentCloud, a platform for analyzing, annotating, and sharing collections of documents. He received a B.A. in computer science and music at Harvard and a master’s in journalism at Stanford. Between academic pursuits, he was a software engineer and researcher in machine perception at Google. As a long-time programmer and recent journalist, Dylan strives to develop computational tools to help people find and tell stories.

On Twitter: @dylfreed

Michael Grant, Google News Lab 👇

Michael Grant is a veteran journalist who specializes in shaping the user experience of editorial products both inside and outside of newsrooms. Grant’s passionate leadership has been enjoyed by special project teams at the San Francisco Chronicle, the Star Tribune and The Center for Investigative Reporting. Grant recently joined the Google News Lab, where he provides journalists with expert in-person training on a range of editorial tools from Google.

On Twitter: @mikegrantme

special

Exhibitors and recruiters

Friday, 9 a.m. – 5 p.m. (all day) • Studio Foyers, 2nd floor

⚠️ Exhibitors and recruiters will be open on multiple days.

SHOW MORE

Description

Be sure to stop by the Studio foyers on the 2nd floor and visit with the exhibitors/recruiters.

master class

Master Class: Writing the investigative narrative (Friday morning)

Friday, 9 a.m. – 12:30 p.m. (3.5 hours) • Studio 1, 2nd floor

⚠️ This session requires pre-registration and an additional fee of $ to reserve a seat.

SHOW MORE

Description

You’ve gathered data, docs and human sources. Now it’s time to turn your reporting into a story — or a series — that packs a punch. If you’re new to investigative storytelling or a data nerd hoping to better blend numbers into compelling prose, this workshop is for you.

Reporter J. David McSwane has worked in all media, always chasing that perfect marriage of investigative and narrative. Computational journalist Andrew Chavez will also lead some of the discussion.

Topics include:

* Understanding narrative
* Reporting for story: how to gather the details and scenes that will give your piece emotional power
* Organization and framing
* Self-editing tips and techniques: do you need this character, this piece of data?
* Making the data work for you: adding scope and precision to a human story

We’ll look at examples of successful stories, pulling back the curtain to see how they came together.

Speakers

Andrew Chavez, The New York Times 👇

Andrew Chavez is a journalist/developer on the Interactive News team at The New York Times. Before the Times, he worked at The Dallas Morning News, the Austin American-Statesman and the Fort Worth Star-Telegram.

J. David McSwane, ProPublica 👇

McSwane is a reporter in ProPublica's D.C. office. Previously, he worked at the Dallas Morning News, the Austin American-Statesman and a small Florida newspaper. McSwane's reporting has spurred new laws and state and federal criminal investigations, forced belt-tightening lawmakers to invest in social programs and won several awards, including Harvard's Goldsmith Prize for Investigative Reporting, the Worth Bingham Prize, two IRE awards and a Peabody.

panel

Census: Numbers in the news

Friday, 10:15 – 11:15 a.m. (1 hour) • Acadia, 3rd floor

💪 Skill level: General interest

SHOW MORE

Description

From inequality to poverty to commute times, the census supplies hard numbers behind the big stories. We’ll show you how to use the Census Bureau’s surveys for breaking stories as well as projects. We’ll also help you prepare for the deluge of stories coming with Census 2020.

Speakers

Ronald Campbell, NBC Owned Television Stations 👇

Ronald Campbell is data editor for NBC Owned Television Stations. He previously created the computer-assisted reporting program at the Orange County Register. He has won the IRE Award, the Loeb Award and placed in the Philip Meyer Award. He lives in Orange County, California, with his wife, kids and cat. When not getting frustrated with databases, he gets frustrated hiking.

On Twitter: @campbellronaldw

Tim Henderson, Pew Stateline 👇

Tim Henderson is demographics writer at Stateline, a news service of the Pew Charitable Trusts. He has been a reporter and database editor at The Miami Herald, Gannet Newspapers and the Cincinnati Enquirer. He refused to grow up in Albuquerque, New Mexico, and remains a notorious New Mexican food snob and collector of Spanish curse words. This will be his fourth decennial census and he's starting to get it down.

#census & demographics

hands-on

JavaScript 2: Hello, D3!

Friday, 10:15 – 11:15 a.m. (1 hour) • Studio 9, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

We’ll cover the basics of getting started with D3, even if you’ve never used it before. Then we’ll take use some real data to create a few basic charts.

This session is good for: People with a basic grasp of JavaScript syntax.

Speaker

Jonathan Soma, Columbia Journalism School 👇

Jonathan Soma is director of the Lede Program at Columbia Graduate School of Journalism, where he lectures on data analysis and interactive visualization. When Soma isn't boring his students to tears, he's probably rescuing cats, and he recently published a fancy website about machine learning in journalism at investigate.ai.

On Twitter: @dangerscarf

#data viz & design #javascript

hands-on

Google Sheets: Custom formulas and automating tasks with the script editor

Friday, 10:15 – 11:15 a.m. (1 hour) • Studio 4, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Add versatility to your Google Sheets with the script editor, a transformative feature that allows you to write your own custom formulas, automate tasks and even send emails on your behalf (think FOIA requests). With a little JavaScript knowhow, you can make Google Sheets work exactly to your specifications and needs as a journalist.

This session is good for: Beginners and intermediate users who know a little bit of JavaScript.

Speaker

Frank Bi, Vox Media 👇

Frank Bi is a senior storytelling engineer at Vox Media in New York City where he works on innovative storytelling projects for the web. He also teaches data literacy and visualization at Fordham University and is a Google News Initiative trainer, teaching journalists in newsrooms and at conferences across the country how to use free journalism tools. Frank is the president of the Asian American Journalists Association's New York chapter.

#data wrangling #google sheets

panel

How to find -- and forget -- data for your environment stories

Friday, 10:15 – 11:15 a.m. (1 hour) • Galerie 2, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

Whether you’re covering oil spills in the Gulf, industrial farming in the Midwest or sea level rise on the coasts, data can help contextualize what you see on the ground. In this session, we’ll discuss datasets that will help you tell a broader story about the environment where you’ll live. We’ll also talk about the pitfalls of that data, and how it can distract from the social and cultural impacts of environmental degradation and climate change.

Speakers

Emily Hopkins, The Indianapolis Star 👇

Emily Hopkins is a data reporter for investigations at The Indianapolis Star. Prior to joining the investigative -team, they won awards covering environmental issues in Indiana.

On Twitter: @indyemapolis

Sara Sneath, The Times-Picayune, The New Orleans Advocate 👇

Sara Sneath is an environmental reporter with The Times-Picayune and The Advocate. Email her tips at ssneath@theadvocate.com.

On Twitter: @sarasneath

Tegan Wendland, WWNO-New Orleans Public Radio 👇

Tegan Wendland is senior reporter on New Orleans Public Radio's Coastal Desk, where she has reported on Louisiana's (disappearing) coast for the past five years.

On Twitter: @TeganWendland

#environment

hands-on

Advanced Tableau

Friday, 10:15 – 11:15 a.m. (1 hour) • Studio 7, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

In this lesson, you will learn how to weave charts and maps created in Tableau Desktop into an interactive dashboard. Also, you will publish it on the Tableau Public website.

This session is good for: People who have taken the intro to Tableau class

Speaker

David Herzog, IRE & NICAR 👇

David Herzog is professor at the University of Missouri School of Journalism and serves as NICAR academic adviser. He's the author of "Data Literacy: A User’s Guide" (2015, SAGE Publications). He also helped launch the online M.S. in Data Science and Analytics program at the University of Missouri.

On Twitter: @davidherzog

#mapping #tableau

hands-on

Scraping in R

Friday, 10:15 – 11:15 a.m. (1 hour) • Studio 8, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

Python has been considered the go-to for web-scraping for many, but did you know web scraping can be easy in R too? This session walks through how to scrape data from the web with R library Rvest. If you had trouble copying a table from a webpage and pasting it in an Excel spreadsheet, or if you want to access data and files buried behind hyperlinks without clicking each one of the links, this is the session for you.

This session would be the best for people who has basic knowledge of R but haven't scraped the web. Knowledge of HTML/CSS is helpful but not required.

Speaker

Jasmine (Ye) Han, Bloomberg Industry Group 👇

Jasmine (Ye) Han is a data reporter with Bloomberg Industry Group in the Washington, D.C., area. Jasmine, an alumna of the Missouri School of Journalism, is pursuing a master's degree in data science. Talk to her about R, rock climbing and food.

On Twitter: @JasmineHanYe

#web scraping #r

panel

Data Blitz

Friday, 10:15 – 11:15 a.m. (1 hour) • Galerie 3, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

Like Lightning Talks, but for data. Five presenters will guide you through their favorite datasets.

Speaker

Jeremy Singer-Vine, BuzzFeed News 👇

Jeremy Singer-Vine is the data editor at BuzzFeed News. He also publishes Data Is Plural, a weekly newsletter of useful/curious datasets. Website: jsvine.com

#story ideas

panel

Beyond the horserace of election results graphics

Friday, 10:15 – 11:15 a.m. (1 hour) • Galerie 6, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

We all love making political graphics, and election night can be a fun exercise in showing off our data graphics prowess. But is there any point to these graphics beyond just showing election results, especially since there’s so many news outlets doing the same iterations of the exact same data? Is there any way to contextualize our graphics so we stop explaining WHO has power, but instead focus on HOW that power is used FOR or AGAINST who?

In the lead-up to 2020, let’s thoughtfully discuss why we do election results graphics and how can we make it better so that we can move beyond the “horserace” aspect of data journalism.

Speakers

Carla Astudillo, Texas Tribune 👇

Carla Astudillo is a news app and data visuals developer with a focus on elections and political data. Previously, she was a data and interactive visuals journalist at NJ.com and The Star-Ledger in New Jersey, where she helped build a database of police use of force in the state as part of a 16-month investigative project. She got her master's degree from the Craig Newmark Graduate School of Journalism at CUNY and her bachelor's degree from the University of Florida.

Ella Koeze, FiveThirtyEight 👇

Ella is a visual journalist at FiveThirtyEight.

On Twitter: @ellawinthrop

Allison McCartney, Bloomberg News 👇

Allison is a data journalist and graphics developer at Bloomberg News in New York. She specializes in creative data visualization and election graphics. Before she was at Bloomberg, she spent time at ProPublica, Stanford, The Center for Investigative Reporting and The PBS NewsHour.

On Twitter: @anmccartney

Sara Simon, Spotlight PA 👇

Sara Simon is an investigative data reporter at Spotlight PA, a new collaborative newsroom covering Pennsylvania's state government. Previously, she worked as a software engineer on the New York Times Interactive News Technologies team and a web developer at Vermont Public Radio.

On Twitter: @sarambsimon

#election & politics #election

commons

Build your own collaborative documentation site: An introduction to Library

Friday, 10:15 – 11:15 a.m. (1 hour) • Galerie 4, 2nd floor

💪 Skill level: Beginner

SHOW MORE

Description

Writing and maintaining good documentation is hard. After trying several other approaches at the New York Times, we built Library, a collaborative site powered by Google Docs.

Library is an open-source documentation tool released by the New York Times in collaboration with Northwestern University’s Knight Lab in 2019. Because every page in Library is a Google Doc, you already know how to use it!

In this, we’ll show you how to set up a copy of Library for your own organization, following the Deploy to Heroku steps outlined in the open source release. Prior experience working with the command line will be helpful, but is not required.

Speaker

Isaac White, The New York Times 👇

Isaac White is a senior software engineer on the Interactive News desk at The New York Times. In his spare time, he enjoys baking bread.

On Twitter: @TweetAtIsaac

#tools

demo

Interviewing your data

Friday, 10:15 – 11:15 a.m. (1 hour) • Bissonet, 3rd floor

💪 Skill level: Intermediate

SHOW MORE

Description

You’ve learned how to use formulas and make pivot tables in Excel or maybe you've dabbled in a SQL program or R, but too often when you sit down in front of your own data, you find yourself staring at the computer screen, unsure how to proceed.

This session will give you a framework for a process you can follow with every new dataset you work with and set you up with some best practices that will make you more efficient and less likely to make a mistake, regardless of what tool you are using for your analysis.

At the heart of this framework is the idea that you are “interviewing” data in much the same way you would a human source. Many of the same steps you take in preparing for and conducting a human interview can be applied to your data work. Beyond that, the framework will help you navigate common issues with data that you need to find and deal with before you even start your analysis.

Speaker

MaryJo Webster, The Star Tribune 👇

MaryJo has been data editor at The Star Tribune in Minneapolis for five years. Previously, she had stints with the St. Paul Pioneer Press, USA Today, Digital First Media and Investigative Reporters & Editors. She started her career as a reporter at small papers in Minnesota and Wisconsin.

On Twitter: @MaryJoWebster

#data analysis

hands-on

Finding the story: Data-driven disaster coverage

Friday, 10:15 – 11:15 a.m. (1 hour) • Studio 10, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Floods, fire, a shooting or an explosion have occurred in your area. We know a lot about that in Houston. We had major flooding three years in a row, chemical fires or explosions every six weeks and a school shooting last year. We'll show you how you can use data to find in-depth stories about the disaster in your community.

This session is good for: those who are comfortable with Excel and relational database concepts.

Speaker

Matt Dempsey, Houston Chronicle 👇

Matt Dempsey is the data editor at the Houston Chronicle. He has worked on projects involving wildfires, state pensions and the chemical industry. His passion for public records frequently leads to disclosure of data from all levels of government. His series "Chemical Breakdown" won the 2016 IRE Innovation award and the National Press Foundation’s “Feddie” award. His work was a key part of the Chronicle’s Pulitzer Prize finalist entry for Breaking News.

#disasters #excel

panel

Everything we know about covering guns, in one hour

Friday, 11:30 a.m. – 12:30 p.m. (1 hour) • Galerie 6, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

At the intersection of Americans and firearms is an ever-shifting business, regulatory, legal and political landscape. In this fast-paced session, we'll walk through the most reliable sources, the best data, common pitfalls, biggest players, game-changing court cases, and the basic mechanics of guns. You'll leave the session with story ideas, useful datasets you've never heard of, a gun guide, and an understanding of why caliber counts.

Speakers

Brian Freskos, The Trace 👇

Brian Freskos is an award-winning staff writer for The Trace, where his reporting has primarily focused on gun trafficking networks and community-based violence prevention. His work at The Trace has been published in partnership with The New Yorker, The Guardian and several other outlets. He holds degrees from UNC-Chapel Hill and Columbia University.

On Twitter: @BrianFreskos

Kristin Hussey, Independent journalist 👇

Kristin Hussey is a Connecticut-based freelance reporter. Since 2007, Kristin has reported on corruption, philanthropy, guns, politics, poverty, pizza and prom dresses for The New York Times. Kristin has also been a staff writer for WSJ.com, The Capital in Annapolis, Maryland, and The News in Boca Raton, Florida.

On Twitter: @kristinhussey1

#guns

hands-on

JavaScript 3: Making a map in D3

Friday, 11:30 a.m. – 12:30 p.m. (1 hour) • Studio 9, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

Learn how to create an easy D3 map by turning shapefiles into nice, reusable TopoJSON, then turning it into a map and connecting it to your data. You can then have these maps ready for future use by just switching out a few variables.

This session is good for: People who have a basic grasp of JavaScript syntax and have been exposed to the D3 library at some point.

Speaker

Al Shaw, ProPublica 👇

Al Shaw is a news applications developer at ProPublica, where he uses data and interactive graphics to cover environmental issues, natural disasters and politics.

#data viz & design #javascript

hands-on

Hitchhikers guide to APIs

Friday, 11:30 a.m. – 12:30 p.m. (1 hour) • Studio 7, 2nd floor

💪 Skill level: Beginner

SHOW MORE

Description

In this hands-on session, you will learn the ins and outs of working with APIs, a flexible way for computers to communicate and share data. We'll cover working with public APIs as well as using APIs protected behind keys and other authentication methods. After this session you'll have the tools to dig deeper into your city's open data portal, scrape "unscrapeable" websites, convert addresses to coordinates, send texts or emails on command, grab data from Twitter or even handle payments!

Note: You will need a Google account for this session.

This session is good for: Everyone. We'll be working with tools non-coders can appreciate, but also wrangling the Python code that can take us to the next level.

Speaker

Jonathan Soma, Columbia Journalism School 👇

Jonathan Soma is director of the Lede Program at Columbia Graduate School of Journalism, where he lectures on data analysis and interactive visualization. When Soma isn't boring his students to tears, he's probably rescuing cats, and he recently published a fancy website about machine learning in journalism at investigate.ai.

On Twitter: @dangerscarf

#data wrangling #apis

hands-on

Finding the story: Using DNS search for investigative journalism (repeat)

Friday, 11:30 a.m. – 12:30 p.m. (1 hour) • Studio 4, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

Every online interaction begins with a lookup in the Domain Name System (DNS), the backbone of the Internet. As a result, there are digital footprints left behind in the DNS. With the demise of Whois, investigative reporters are looking for new tools to uncover these footprints. Learn how to use DNSDB Scout, a tool to query DNSDB, a historical passive Domain Name System (DNS) database, to discover previously unknown online connections and gain new information to advance your ongoing and breaking news investigations.

Basic knowledge of the Domain Name System (DNS) is helpful, but not required.

Speaker

Paul Vixie, Farsight Security, Inc. 👇

Dr. Paul Vixie is an Internet pioneer and CEO of Farsight Security. An Internet Hall of Fame inductee, Dr. Vixie is a prolific author of open source Internet software including BIND, and many Internet standards documents concerning DNS and DNSSEC. He founded the first anti-spam company (MAPS, 1996), the first nonprofit Internet infrastructure software company (ISC, 1994) and the first neutral and commercial Internet exchange (PAIX, 1991). He spoke at NICAR in 2019.

#research

hands-on

Making interactive maps with R

Friday, 11:30 a.m. – 12:30 p.m. (1 hour) • Studio 8, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

Exploratory data analysis sometimes involves quickly iterating through visualizations to see patterns that stand out, particularly when working with spatial data. In this workshop, we'll be creating interactive maps using R packages that work on top of Leaflet and Mapbox using real life data while coming close to reproducing maps from The Washington Post in the process.

This class is good for: People who are familar with RStudio and want to add interactive mapping in R to their toolbox.

Speaker

Peter Aldhous, BuzzFeed News 👇

Aldhous is a reporter on the science desk at BuzzFeed News, based in San Francisco. His data-driven projects have included the use of machine learning to find spy planes in public flight-tracking data and text analysis of the Twitter accounts of President Donald Trump and all members of Congress.

On Twitter: @paldhous

#mapping #r

panel

Investigating sexual assault, for newsrooms big and small

Friday, 11:30 a.m. – 12:30 p.m. (1 hour) • Bissonet, 3rd floor

💪 Skill level: General interest

SHOW MORE

Description

Learn effective approaches to investigating the justice system’s response to sexual assault from reporters who conducted their own investigations into police procedures around sexual assault, exposed problematic loopholes in state laws and delved into a national nonprofit's child sex abuse secrets. From digging through federal statistics and case files to parsing a difficult dataset with code, you’ll leave this session with strategies to launch an investigation of your own.

Speakers

Hannah Dellinger, Houston Chronicle 👇

Hannah Dellinger was the lead reporter on Hearst Connecticut Media's investigation into child sexual abuse connected to Boys & Girls Clubs of America. She is currently a reporter at the Houston Chronicle.

On Twitter: @hdellingermedia

Kate Martin, Carolina Public Press 👇

Kate Martin is the lead investigative reporter for Carolina Public Press. Her work has led to the creation of four state laws and the resignation of several elected officials. Her deep analysis of years of North Carolina court records showed that fewer than 1 in 4 people charged with sexual assault are ever convicted of that or a lesser crime.

On Twitter: @Katereports

Brandon Stahl, KARE 11 👇

Brandon Stahl works as an investigative reporter and producer for KARE 11, the Minneapolis NBC affiliate. Prior to that, he worked in newspapers for more than a decade, including the Minneapolis Star Tribune, where his work resulted in dozens of reforms and changes in state laws. He, along with three other Star Tribune journalists, were named Pulitzer Prize finalists in 2019 for "Denied Justice," a series on botched rape investigations.

#story ideas

panel

Data on the wildfire beat

Friday, 11:30 a.m. – 12:30 p.m. (1 hour) • Galerie 2, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

As wildfires have become more frequent and more intense, newsrooms have opportunities to raise the bar of their reporting by bringing data into their coverage of these disasters. Over the past year, media outlets have increasingly incorporated data into their wildfire coverage, whether to track fires while they happen, provide new context or by digging into data about contributing factors and fallout. We will highlight some of the best examples, review how projects we worked on came together, discuss how data-driven wildfire reporting could be improved in the future and go through sources and ideas that newsrooms can put into use for their own wildfire coverage.

Speakers

Ren Larson, The Arizona Republic 👇

Ren Larson is a data journalist with the Arizona Republic, where she has worked on elections, environmental contamination, wildfires and immigration projects. In a previous life, she was an urban planner for the city of Austin, Texas, and a short-lived bike messenger in Beirut. Ren holds a master's degree in public policy and an M.A. in International Studies from the University of California Berkeley.

On Twitter: @renLarson_

Casey Miller, Los Angeles Times 👇

Casey is a data and visual journalist working on the data and graphics team at the Los Angeles Times. In the past, she has helped create visual and data driven graphics and narratives at Mapbox, Vox Media and The Wall Street Journal.

Evan Wyloge, Colorado Springs Gazette 👇

Wyloge is a Denver-based data and investigative reporter for The Colorado Springs Gazette focused on statewide accountability journalism. Formerly: The Desert Sun/USA Today Network, Arizona Center for Investigative Reporting, Arizona Capitol Times.

On Twitter: @EvanWyloge

#data analysis

demo

Digital sleuthing with Bellingcat

Friday, 11:30 a.m. – 12:30 p.m. (1 hour) • Acadia, 3rd floor

💪 Skill level: General interest

SHOW MORE

Description

Learn advanced tricks and tips for mining Facebook, Twitter, Telegram, and other sites with Robert Evans of Bellingcat, the international collective of researchers and citizen journalists specializing in digital sleuthing. Learn how to do geographic searches to find sources, visuals and other material near a specific address or in a particular city. You will leave this session armed with tools and tricks to quickly find information about both public and private figures.

Speaker

Robert Evans, Bellingcat 👇

Robert Evans has worked as a conflict journalist in Iraq, Syria, Ukraine, and at protests across the United States. He currently covers the far right and online radicalization for Bellingcat. He also hosts podcasts for iHeartRadio.

On Twitter: @IwriteOK

#research

panel

FOIA from the flip side

Friday, 11:30 a.m. – 12:30 p.m. (1 hour) • Galerie 3, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

A panel of state and local officials offer advice on how to wring the best responses out of open records requests. They’ll identify common pitfalls that bog down or doom requests and offer advice on work you can do before you file your FOI request to give it the best chance of succeeding. They’ll place special emphasis on data requests.

Speakers

Meg Casper Sunstrom, Louisiana Board of Regents 👇

Meg Casper Sunstrom’s career began in television news, where she spent almost decade working for WAFB-TV in Baton Rouge. Next, she transitioned into communications and public relations, spending several years as the communications director at the Louisiana Department of Education before transitioning to deputy secretary for the Louisiana Secretary of State. Currently, Meg serves as deputy commissioner for strategic communications at the Louisiana Board of Regents.

Deborah Spiess Henton, 22nd Judicial District Attorney's Office - Parish of St. Tammany 👇

Deborah Spiess Henton has practiced law for 25 years. For more than nine years, she has represented St. Tammany Parish Government, processing public records requests and advising and defending Parish Government on varied matters such as sales tax, drainage disputes, development issues, public works and other legal matters. She has taught classes on Louisiana's Public Records Law for lawyers and non-lawyers who work for public entities.

Benjamin Lesser, Reuters 👇

Benjamin Lesser is a reporter and a deputy editor at Reuters News. He also teaches investigative reporting at the City University New York Graduate School of Journalism. Prior to joining Reuters he spent most of his career working in newspapers. He spent 12 years as an investigative/data reporter at The Record in New Jersey (2000-2006) and the New York Daily News (2006-2012).

J.B. Slaton, Louisiana State Police 👇

Captain J.B. Slaton is the public affairs commander for the Louisiana State Police. He has 22 years of law enforcement experience, including over 18 years with the state police. Captain’s Slaton’s career experience includes corrections, uniformed patrol, internal affairs and public affairs. He holds a Bachelor of Science degree in Criminal Justice and a Master of Arts degree in Education and Homeland Security, and he is a graduate of the FBI National Academy.

#open records

hands-on

Excel tricks you've never used

Friday, 11:30 a.m. – 12:30 p.m. (1 hour) • Studio 10, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Excel has so many tips, tricks and time-saving tools you might not know about, even if you're a whiz at CONCATENATE functions and PivotTables. You should pick up a few new tricks in this fast-paced and fun session.

This session is best for: Those with intermediate knowledge of spreadsheets.

Speaker

Denise Malan, IRE & NICAR 👇

Denise Malan is IRE's Deputy Executive Director, overseeing all training programs, event logistics and the IRE Resource Center. She was a newspaper journalist for more than a decade, covering government, education, politics, the environment and more. After several years at the Corpus Christi Caller-Times in Texas, she joined IRE in 2013 in a joint position with the Institute for Nonprofit News, helping newsrooms around the country use data in their reporting.

On Twitter: @DeniseMalan

#data wrangling #excel

commons

Breaking through coding plateaus

Friday, 11:30 a.m. – 12:30 p.m. (1 hour) • Galerie 4, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

There are plenty of tutorials and training sessions to help a new coder get started. And there are plenty of awards lists and conference sessions that will wow you with some amazing advanced work. But once you've done the tutorials and experimented with what you've learned in the hands-on sessions, you'll likely find yourself stuck — you're no longer a beginner, but you're also not an expert, and you don’t really understand how to take the next step on that journey.

You've hit a classic learning plateau, and there aren't many resources to help you break through and take your coding to the next level. In this session, we'll discuss key concepts that bridge the gap between beginner and expert coder and present strategies for leveling-up — while still meeting your deadlines.

Speaker

Serdar Tumgoren, Stanford University 👇

Serdar Tumgoren teaches data journalism at Stanford University. He previously worked on data and news apps teams at The Associated Press, The Washington Post and Congressional Quarterly.

On Twitter: @zstumgoren

#work better

special

Media lawyers Q&A

Friday, 12:45 – 1:45 p.m. (1 hour) • Galerie 2, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

Does your investigation contain complex legal questions? Unsure of how to proceed? Bring your lunch and your questions for a personal discussion with some prominent media law experts. We'll provide drinks and dessert.

Speakers

Maggie Mulvihill, Boston University 👇

Maggie Mulvihill’s data journalism students have been honored with 10 regional or national awards since 2011, as well as being named finalists for the prestigious Livingston Award for Young Journalists. An attorney, Maggie serves on the steering committee of the Reporter's Committee for Freedom of the Press and the board of the New England First Amendment Coalition. She is a co-founder of the New England Center for Investigative Reporting and a former Nieman Fellow.

Scott Sternberg, Sternberg, Naccari & White LLC 👇

Scott Sternberg of Sternberg, Naccari & White LLC is counsel to the Louisiana Press Association and numerous Louisiana media organizations, including The Advocate/The Times-Picayune, The Lens, WVUE and WAFB. His statewide practice involves public records, open meetings, libel and privacy defense. He has taught at Louisiana State University and Loyola University New Orleans. The remainder of his practice is high-profile and business litigation.

On Twitter: @ScottLSternberg

Matthew Topic, Loevy & Loevy 👇

Matt Topic leads Loevy & Loevy’s Freedom of Information Act practice. Among the media cases he has handled around the country, Matt has litigated hundreds of state and federal FOIA cases, often at reduced or no cost to clients, including the release of the the Laquan McDonald shooting video in Chicago; records from the Mueller investigation; Rahm Emanuel’s “private emails” about public business; and FBI records that helped lead to the exoneration of an innocent man.

Katie Townsend, Reporters Committee for Freedom of the Press

#media law

hands-on

ArcGIS: From spreadsheets to StoryMaps

Friday, 2:15 – 5:45 p.m. (3.5 hours) • Studio 7, 2nd floor

💪 Skill level: Beginner

⚠️ This session requires pre-registration and an additional fee of $35 to reserve a seat.

SHOW MORE

Description

Interested in mapping your data but aren't sure where to start? In this half-day workshop, we’ll walk attendees through an investigation into short-term rentals in New Orleans and their potential impacts on the community. Along the way, we’ll focus on the tools, workflows and best practices to help you transform public data into compelling maps and narrative stories. This workshop will specifically address:

* Creating interactive maps directly within Excel from a spreadsheet of public data with ArcGIS Maps for Office
* Publishing spreadsheet data as an interactive layer
* Styling and configuring interactive maps with ArcGIS Online
* Filtering, analyzing, aggregating and enriching geospatial data
* Performing on-the-fly calculations and customization with Arcade scripts
* Finding and using authoritative data from the Living Atlas
* Creating interactive maps that fuse narrative elements and maps using ArcGIS StoryMaps

Preregistration is required and seating is limited. Laptops will be provided for the training. Class attendees will receive free licenses of ArcGIS from Esri.

Workshop prerequisites: No data or mapping experience required.

Speakers

Robby Deming, Esri

Christopher Vaillancourt, Esri

#mapping #arcgis

hands-on

Write better Python code

Friday, 2:15 – 5:45 p.m. (3.5 hours) • Studio 9, 2nd floor

💪 Skill level: Advanced

⚠️ This session requires pre-registration and an additional fee of $35 to reserve a seat.

SHOW MORE

Description

You’ve written a few Python scripts that get the job done, but the initial euphoria has worn off. Your code is hard to read. Bugs are cropping up. And you can’t always explain your process or results to an editor — or yourself. There must be a better way, but the path forward is not clear.

If you’ve had that itchy feeling, this three-hour, hands-on workshop is for you. This class will explore Python language features that will help you write readable, reliable and reusable code.

Preregistration is required and seating is limited. Attendees must bring a laptop and charger to the training.

Workshop prerequisites: Experience with basic Python language features like variables, data types, conditionals and functions are required.

Speaker

Serdar Tumgoren, Stanford University 👇

Serdar Tumgoren teaches data journalism at Stanford University. He previously worked on data and news apps teams at The Associated Press, The Washington Post and Congressional Quarterly.

On Twitter: @zstumgoren

#work better #python

master class

Master class: Writing the investigative narrative (Friday afternoon)

Friday, 2:15 – 5:45 p.m. (3.5 hours) • Galerie 5, 2nd floor

💪 Skill level: General interest

⚠️ This session requires pre-registration and an additional fee of $35 to reserve a seat.

SHOW MORE

Description

You’ve gathered data, docs and human sources. Now it’s time to turn your reporting into a story -- or a series -- that packs a punch. If you’re new to investigative storytelling or want to up your writing game, this workshop is for you.

Veteran editor Maria Carrillo has led some of the best narrative teams in the country. In this half-day workshop, she’ll cover the entire story lifecycle, from reporting to writing to planning for publication. Topics include:

* Understanding narrative
* Reporting for story -- How to gather the details and scenes that will give your piece emotional power
* Focus and framing – Finding your way through all that material
* Self-editing tips and techniques
* Developing a story team -- How to get photographers, artists, designers, digital producers and editors unified behind a common vision

We’ll look at examples of successful stories, pulling back the curtain to see how they came together.

Speaker

Maria Carrillo, Tampa Bay Times 👇

Maria Carrillo is deputy editor/enterprise at the Tampa Bay Times, where she oversees a team of reporters and works with journalists across the newsroom on ambitious stories. She was previously enterprise editor at the Houston Chronicle and managing editor at The Virginian-Pilot. She has overseen numerous award-winnings projects, frequently lectures on narrative journalism and has been a Pulitzer Prize juror four times.

On Twitter: @havana58

#writing & storytelling

panel

Career paths in data journalism

Friday, 2:15 – 3:15 p.m. (1 hour) • Bissonet, 3rd floor

💪 Skill level: General interest

SHOW MORE

Description

Data journalism encompasses many different kinds of work, whether you work full time with data, manage a data team, use data to cover a beat, or use data visualization and interactivity to tell visual stories. It's not always clear what professional options may be available, or how you might go about growing into new opportunities.

In this session, we'll hear from a newspaper reporter whose focus on data eventually took them into academia, a designer/developer/journalist who ended up moving into leadership to help bring together her newsroom's visual storytelling departments, as well as a veteran TV journalist who forged her own path when there wasn't a data job in the newsroom.

Speakers

Patti DiVincenzo, IRE & NICAR 👇

Patti DiVincenzo is a training director at IRE. She spent more than three decades working in TV stations across the country, starting in Topeka, Kansas, and eventually landing at WSB-TV in Atlanta, where she was an investigative producer and data specialist for 16 years. A longtime member of IRE, she joined the staff in February 2019.

Alex Richards, Syracuse University 👇

Alex is an assistant professor at Syracuse University's Newhouse School, where he teaches data journalism. He's a former training director at Investigative Reporters & Editors, and he has previously worked as a reporter and editor at the Chicago Tribune, NerdWallet, The Chronicle of Higher Education and the Las Vegas Sun, where he was a finalist for the Pulitzer Prize in 2011 and shared the Goldsmith Prize for investigative reporting.

On Twitter: @alexrichards

Sisi Wei, OpenNews 👇

Sisi Wei is the director of programs at OpenNews, where she envisions and executes transformative initiatives for journalism, especially for journalists of color and local journalists. Previously, she was assistant managing editor at ProPublica, where she oversaw and edited news apps, graphics, visual reporting and investigations.

#career

hands-on

Excel 1: Getting started with spreadsheets (repeat)

Friday, 2:15 – 3:15 p.m. (1 hour) • Studio 8, 2nd floor

💪 Skill level: Beginner

SHOW MORE

Description

In this introduction to spreadsheets, you'll begin analyzing data with Excel, a simple but powerful tool. You'll learn how to enter data, navigate spreadsheets and conduct simple calculations like sum, average and median.

This session is good for: Data beginners.

Speaker

Carlie Procell, USA Today Network 👇

Carlie Procell is a data visualization journalist for USA Today Network's national data and investigations team.

On Twitter: @CarlieProcell

#data analysis #excel

hands-on

SQL 1: Exploring data

Friday, 2:15 – 3:15 p.m. (1 hour) • Studio 10, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Learning to manipulate data is a bit like learning a new language. Actually, it is a language, called Structured Query Language (SQL). This session is an introduction to using SQL to zero in on your data by viewing slices and chunks of it and putting it into a useful order so you can spot the stuff you need to get started toward a story. We'll use DB Browser for SQLite, a free database manager.

This session is good for: People with some experience working with data in columns and rows, in spreadsheets or database managers.

Speaker

Lucia Walinchus, Eye on Ohio, the Ohio Center for Investigative Journalism 👇

Lucia Walinchus is an award-winning journalist, attorney and ice hockey addict. She is currently the Executive Director at Eye on Ohio, the Ohio Center for Investigative Journalism. Walinchus was named a 2016 Fulbright Berlin Capital Program Scholar. She has been featured as a guest speaker on CNN and is a contracted freelancer for the New York Times. Walinchus has a degree in Journalism from American University and a Juris Doctor degree from California Western School of Law.

On Twitter: @SoSaysLucia

#data analysis #sql

hands-on

Stats 1: An introduction

Friday, 2:15 – 3:15 p.m. (1 hour) • Studio 4, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Statisticians need to really understand their data (and so do you!) before they begin running analyses. As a result, stats software like RStudio has many powerful tools to summarize your data. You're going to love them. We'll take a look at the structure of data in RStudio, do data transformations and run some basic statistical tests.

This session is good for: People who have familiarity with Excel and some database software. We've got a *lot* of ground to cover in this hour.

Speaker

Ryann Grochowski Jones, ProPublica 👇

Ryann Grochowski Jones is the data editor at ProPublica. Previously, she was deputy editor for data at ProPublica and a data reporter at inewsource in San Diego. She received her master's degree from the University of Missouri School of Journalism, where she was a data librarian for IRE/NICAR. Ryann began her career as a municipal beat reporter for her hometown newspaper in Wilkes-Barre, Pennsylvania.

On Twitter: @ryanngro

#statistics #r

hands-on

Google Sheets: Scraping without coding (repeat)

Friday, 2:15 – 3:15 p.m. (1 hour) • Studio 1, 2nd floor

💪 Skill level: Beginner

SHOW MORE

Description

Yes, you can scrape data without using code -- in fact, all you need is Google Sheets! We'll be using Excel-type formulas (don't worry if you don't know what those are, either) to make simple scrapers that automatically pull data into Google Sheets. It’s the best way to get around clunky websites and unhelpful PIOs!

This session is good for: Beginners who want to start using data for their stories.

Speaker

Samantha Sunne, Independent journalist 👇

Samantha Sunne is a freelance journalist based in New Orleans. She speaks at conferences, universities and newsrooms around the world, teaching digital tools and tech literacy for journalists. Her work has been published by the Washington Post, NPR and Reuters, and recommended by the Poynter Institute and the Harvard Shorenstein Center on Media, Politics and Public Policy.

On Twitter: @samanthasunne

#web scraping #google sheets

hands-on

Finding the story: Census data (repeat)

Friday, 2:15 – 3:15 p.m. (1 hour) • Studio 2, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Census data can bring context and depth to stories on practically any beat. It can also be overwhelming to sift through and find what you need. This hands-on session will walk you through a real census dataset to help you find stories hidden in all that demographic data.

This session is good for: Those who have some experience with spreadsheets.

Speaker

Robert Gebeloff, The New York Times 👇

Robert Gebeloff has been a staff editor for data projects at The New York Times since 2008. He was a Pulitzer Prize finalist twice, and also once produced a 59-part Census series later published as the collection "Saginaw in the 1980s."

On Twitter: @gebeloffnyt

#census & demographics #excel

hands-on

An automated election twitterbot using R and Python

Friday, 2:15 – 3:15 p.m. (1 hour) • Studio 3, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

In 2019 the BBC used R and Python to take live election results, draw graphics and tweet them out. We will show you how we did it. The session will give an insight into automatically turning live election results into graphics with R and tweeting them out using Python, providing a live election results service.

👉 Read more here

This session is good for people with experience coding in R or Python.

Speakers

Alison Benjamin, BBC News 👇

Alison works in data science on the BBC News data journalism team. @hey_benjamin

On Twitter: @hey_benjamin

Wesley Stephenson, BBC 👇

Wesley is a senior data journalist on the BBC's data journalism team. Over the last 20 years he has worked across online, TV and radio. He loves solving problems, which is always an advantage when programming with R.

#election & politics #python #election

panel

Quick-turn data stories

Friday, 2:15 – 3:15 p.m. (1 hour) • Acadia, 3rd floor

💪 Skill level: Beginner

SHOW MORE

Description

We’ve all disappeared down the data rabbit hole on occasion or become embroiled in huge projects. But what about data stories that need a fast turnaround? This panel session will cover tips for getting stories out quickly and keeping clarity (and sanity) along the way.

Speakers

Anthony Cave, KXAN News 👇

Anthony Cave is an investigative producer and digital reporter on KXAN’s investigative team in Austin. He’s reported on everything from education benefits for post-9/11 veterans to domestic gun violence.

On Twitter: @Anthony_Cave

Christine Jeavans, BBC News 👇

Christine Jeavans is a senior data journalist at BBC News with a focus on health, social issues and politics. Recent projects include covering the UK's 2019 general election, and the award-winning NHS Tracker.

On Twitter: @chrisjeavans

Lauryn Schroeder, San Diego Union-Tribune 👇

Lauryn Schroeder is an investigative data reporter for the San Diego Union-Tribune. She previously worked for The Associated Press and took part in major data investigations with The Washington Post. She won an IRE award in 2013 for a series on shaken-baby syndrome, a controversial diagnosis that has led to hundreds of questionable child-abuse and murder convictions nationwide.

On Twitter: @laurynschroed

#story ideas

panel

Avant garde data viz

Friday, 2:15 – 3:15 p.m. (1 hour) • Galerie 6, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

You know all the rules of data viz — north belongs at the top of maps, timelines read left to right, bar charts are used for comparison. Now it's time to break the rules. This panel will explore when and why to break with convention, and when not to. We'll look at the best examples of unconventional data viz and show how you can mix up your own work in new and interesting ways.

Speakers

Agnes Chang, ProPublica 👇

Agnes is a creative story technologist at ProPublica. Previously, she spent six years at The New York Times as a software engineer and product manager. She is also currently an adjunct professor at Columbia University.

On Twitter: @aggggnessss

Jan Diehm, The Pudding 👇

Jan Diehm is a journalist-engineer with The Pudding, where she uses data to craft visual stories. Before joining The Pudding, she had stops at CNN, The Guardian US, ABC News, HuffPost, the Baltimore Sun and the Hartford Courant. She appreciates the finer things in life: LEGO sets; southern delicacies like pimento cheese, fried green tomatoes and good bourbon; and vintage Britney Spears. She lives in San Antonio with her wife and two cats.

On Twitter: @jadiehm

Scott Klein, ProPublica 👇

Scott Klein is a deputy managing editor at ProPublica. He oversees ProPublica's visual and data journalism. He also manages ProPublica's Electionland project, which is a large-scale cross-newsroom collaboration that covers voting and election integrity. Scott is also a co-founder of DocumentCloud and a board member of MuckRock.

On Twitter: @kleinmatic

#data viz & design

panel

Covering disparities in education with data

Friday, 2:15 – 3:15 p.m. (1 hour) • Galerie 2, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

State and federal governments hold treasure troves of education data that reporters and news nerds can dig into to find great stories and hold schools accountable. Come learn how to parse the latest iteration of federal civil rights data (CRDC), which reveals resource and discipline inequities across the nation’s +96,000 schools. Dive deep into school segregation data and mapping data. Find out how to use federal College Scorecard data to showcase debt and tuition inequities across the nation’s +7,000 colleges. And hear an overview of the other great data sources that are available for education stories.

This session was sponsored by the Lumina Foundation. IRE retains control of content, including the topic and speaker selection, for all conference sessions.

Speakers

Andrea Fuller, The Wall Street Journal 👇

Andrea Fuller is a reporter for The Wall Street Journal in New York City who specializes in data analysis. She uses spreadsheets, databases and computer code to find stories. Ms. Fuller joined the Journal in April 2014. She previously was a data journalist at Gannett Digital, The Center for Public Integrity, and The Chronicle of Higher Education.

Bracey Harris, The Hechinger Report 👇

Bracey Harris is a staff writer for The Hechinger Report. Prior to joining Hechinger, she covered politics and education for the Clarion Ledger, where she also focused on government accountability for the paper’s investigative and enterprise team. The Magnolia State native sometimes bumps into her old high school principal on reporting assignments.

On Twitter: @braceyharris

Annie Waldman, ProPublica

#education

commons

State of newsroom diversity reports

Friday, 2:15 – 3:15 p.m. (1 hour) • Galerie 4, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

In recent years, a handful of news organizations have published diversity reports to educate people in the industry about their challenges with diversity and to indicate that they are taking newsroom diversity seriously. This has also led to conversations about the effectiveness of diversity reports, what they should cover and how we can convince management to publish more revelatory indicators of diversity.

This will be a working session around all these questions. We will start with a quick survey of recent diversity reports published by prominent journalism outlets and then move to a discussion/group activity to work out what measures should be included in diversity reports to further the actual goals of increasing diversity in newsrooms.

Speaker

Moiz Syed, ProPublica 👇

Moiz Syed is a journalist, designer and developer on ProPublica's news apps team, covering the federal government. Previously he worked at The Intercept and the Wikimedia Foundation.

On Twitter: @moizsyed

#diversity

demo

Tracking health misinformation across social media

Friday, 2:15 – 3:15 p.m. (1 hour) • Galerie 3, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Learn how to track and investigate health misinformation across social media using a host of data tools and dashboards, including CrowdTangle, TCAT, and 4CAT. While the training will focus on health misinformation, you can use the same methods to investigate all types of online mis- and disinformation. An intermediate level of Python is recommended for this workshop.

Speaker

Rory Smith, First Draft 👇

Rory is the research manager at First Draft. With a background in data journalism, investigative reporting and international development, he looks into the various ways that mis- and disinformation spreads online as well as the constant evolution of information disorder. Before joining First Draft, Rory worked for CNN, Vox, Vice and Truthout, covering various topics from immigration and food policy to politics and organized crime.

#research

panel

Covering undercovered communities

Friday, 3:30 – 4:30 p.m. (1 hour) • Bissonet, 3rd floor

💪 Skill level: General interest

SHOW MORE

Description

Don’t settle for “it can’t be done” or "I don't have any sources in that culture." Although some undercovered communities might seem a mystery, they don't have to remain that way. This session will discuss how to blend diverse voices and sources of data into your stories, and cover hard-to-reach communities, such as those filled with older and more recent immigrants, some who may not have much experience with the media, minority communities who are often fearful of the repercussions of speaking with media, and others.

Speakers

Jan Diehm, The Pudding 👇

Jan Diehm is a journalist-engineer with The Pudding, where she uses data to craft visual stories. Before joining The Pudding, she had stops at CNN, The Guardian US, ABC News, HuffPost, the Baltimore Sun and the Hartford Courant. She appreciates the finer things in life: LEGO sets; southern delicacies like pimento cheese, fried green tomatoes and good bourbon; and vintage Britney Spears. She lives in San Antonio with her wife and two cats.

On Twitter: @jadiehm

Nausheen Husain, Chicago Tribune 👇

Nausheen (no'sheen) is a reporter at the Chicago Tribune who is interested in civil liberties, migration, surveillance and community. She thinks frequently about what it is to be both American and Muslim, and how those affect her work with data and words.

Mark Walker, The New York Times 👇

Mark Walker is a FOIA researcher in The New York Times Washington, D.C., bureau.

On Twitter: @bymarkwalker

#diversity

hands-on

Excel 2: Formulas & sorting (repeat)

Friday, 3:30 – 4:30 p.m. (1 hour) • Studio 8, 2nd floor

💪 Skill level: Beginner

SHOW MORE

Description

Much of Excel's power comes in the form of formulas. In this class, you'll learn how to use them to analyze data with the eye of a journalist. Yes, math will be involved, but it's totally worth it! This class will show you how calculations like change, percent change, rates and ratios can beef up your reporting.

This session is good for: Anyone who is comfortable navigating Excel.

Speaker

Emily Hopkins, The Indianapolis Star 👇

Emily Hopkins is a data reporter for investigations at The Indianapolis Star. Prior to joining the investigative -team, they won awards covering environmental issues in Indiana.

On Twitter: @indyemapolis

#data analysis #excel

hands-on

SQL 2: Grouping and summing data

Friday, 3:30 – 4:30 p.m. (1 hour) • Studio 10, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

If you know how to write a basic SELECT statement in SQL but are looking to make calculations, then this is the session for you. Learn to count how many times certain records appear in a database, and sum totals across records. These skills can come in handy whether you're covering campaign finance or boating licenses. We'll use SQLite and DB Browser, a free database manager.

This session is good for: People who took “SQL 1: Exploring data” or are familiar with “SELECT” and “WHERE” statements in SQL.

Speaker

Jessica Huseman, ProPublica 👇

Jessica Huseman is a reporter for ProPublica based in Austin, Texas. She is the lead reporter for Electionland, ProPublica's collaborative effort to cover ballot access. She is a data journalism instructor at Columbia Graduate School of Journalism.

#data analysis #sql

hands-on

Stats 2: Linear regression

Friday, 3:30 – 4:30 p.m. (1 hour) • Studio 4, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

Go beyond counting and sorting. Learn how (and when) to measure relationships, level playing fields and make predictions. This class will be taught in R.

This session is good for: People who took “Stats 1: An introduction” and want to know how to apply what they learned, or are comfortable with summary statistics and RStudio and new to stats. Familiarity with spreadsheets and database managers is recommended.

Speaker

Olga Pierce, University of Nebraska - Lincoln

#statistics #r

hands-on

PDF 2: Using OCR to extract data from PDFs

Friday, 3:30 – 4:30 p.m. (1 hour) • Studio 3, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

This class will cover basic approaches for getting text out of PDF documents using powerful and freely available tools. Participants will be introduced to basic concepts and walked-through tackling common challenges encountered with tricky PDF documents.

This session is good for: People who are unfamiliar with the PDF to text tools or would like to learn how optical character recognition (OCR) tools can be used for extracting difficult text from images embedded in PDF document.

Speaker

Chad Day, The Wall Street Journal 👇

Chad Day covers the 2020 campaign and money in politics for The Wall Street Journal. He was previously a reporter on The Associated Press investigative team covering the Russia investigation and the Trump administration.

On Twitter: @ChadSDay

#pdfs

hands-on

Power BI 1: Create interactive data visualizations

Friday, 3:30 – 4:30 p.m. (1 hour) • Studio 2, 2nd floor

💪 Skill level: Beginner

SHOW MORE

Description

Create interactive charts and maps to analyze your data and let your audience play with the numbers in embeddable interactives. This hands-on workshop will introduce you Microsoft Power BI, a free data visualization tool that requires no coding.

This session is good for journalists who already know how to use Excel and have dreamed of turning spreadsheets into beautiful, interactive visuals.

Speaker

Cathleen Crowley, Times Union

#data viz & design #power bi

hands-on

Data visualization & storytelling with Flourish

Friday, 3:30 – 4:30 p.m. (1 hour) • Studio 1, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Learn how to use Flourish, a free, online tool to build custom visualizations from your spreadsheets, no coding required. The tool has created templates for a huge range of visualisations. Flourish grew out of Kiln, the award-winning data studio that has helped dozens of organizations to visualize and tell stories with data. All newsrooms have access to a full enterprise account supported by Google.

**You must bring a laptop and sign up for a free account at flourish.studio to participate in this class.

This session is good for: Anyone familiar with spreadsheets. No visualization experience required.

Speaker

Michael Grant, Google News Lab 👇

Michael Grant is a veteran journalist who specializes in shaping the user experience of editorial products both inside and outside of newsrooms. Grant’s passionate leadership has been enjoyed by special project teams at the San Francisco Chronicle, the Star Tribune and The Center for Investigative Reporting. Grant recently joined the Google News Lab, where he provides journalists with expert in-person training on a range of editorial tools from Google.

On Twitter: @mikegrantme

#data viz & design

panel

CANCELED - Communicating statistical significance

Friday, 3:30 – 4:30 p.m. (1 hour) • Acadia, 3rd floor

🚫 Due to speaker cancellations, this session has been canceled.

💪 Skill level: Advanced

SHOW MORE

Statistical significance and inference are hard to interpret correctly and harder to communicate clearly. Print “we fail to reject the null hypothesis at 95% level” and you’ll be looking for a job but say “the chance we got it wrong is 5%” and you should be.

Unfortunately, that difficulty of staying interesting while being precise keeps useful declarations of what is and isn’t likely off pages where they’re needed. But it is possible to do and do well.

Statisticians and science communicators across disciplines interest readers in correct but casual versions of their inferences all the time. What techniques help them get the point across? Are p-value statements even necessary? This panel of statisticians, science communicators, and journalists will discuss how to take the hidden model you worked so hard on and make it something worthy of the front page.

#statistics

commons

Being a better ally

Friday, 3:30 – 4:30 p.m. (1 hour) • Galerie 4, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

We know the stats. We hear the stories. What can we do to retain journalists from underrepresented groups? In this safe space, we’ll discuss questions you can ask management and tips on how to support your colleagues from marginalized communities. All are welcome, white people especially encouraged to attend.

Speakers

Madi Alexander, The Dallas Morning News 👇

Madi Alexander is a computational journalist at The Dallas Morning News. She was previously a data reporter at Bloomberg Government in Washington, D.C. Madi has a master's degree in journalism from the University of Missouri. She volunteers for the Dallas puppy-raising chapter of Guide Dogs for the Blind. Madi also keeps a database of all the national parks and historical sites she has visited — a total of 40 thus far.

On Twitter: @MadiLAlexander

Megan Luther, InvestigateTV 👇

Megan Luther is an investigative producer with InvestigateTV, Gray Television's national investigative team. Previously, she was Senior Training Director for Investigative Reporters & Editors. Other former titles include reporter, data analyst and overnight DJ. Megan, mother of two, works remotely in South Dakota.

On Twitter: @MeganLuther

Jon Schleuss, NewsGuild

Moiz Syed, ProPublica 👇

Moiz Syed is a journalist, designer and developer on ProPublica's news apps team, covering the federal government. Previously he worked at The Intercept and the Wikimedia Foundation.

On Twitter: @moizsyed

#diversity

panel

Day-turn investigations

Friday, 3:30 – 4:30 p.m. (1 hour) • Galerie 6, 2nd floor

💪 Skill level: Beginner

SHOW MORE

Description

From the morning meeting to the 4 p.m. deadline, how to take a day-turn story and add an investigative angle to it with tools you already have.

Speakers

Christopher Heath, WFTV 👇

Heath has been an investigative and political reporter for WFTV (ABC, Orlando) since 2013 covering state and local government. He has also worked at KENS (CBS, San Antonio) and WLWT (NBC, Cincinnati).

On Twitter: @CHeathWFTV

Josh Hinkle, KXAN 👇

Josh Hinkle is KXAN’s Director of Investigations & Innovation, leading the station’s duPont- and IRE Award-winning investigative team on multiple platforms. He also leads KXAN’s political coverage as the executive producer and host of “State of Texas,” a weekly program focused on the Texas Legislature and elections, seen in 14 markets statewide.

On Twitter: @hinklej

Nicole Vap, KUSA 9NEWS 👇

Nicole Vap is the director of investigative journalism at KUSA in Denver and with TEGNA. Nicole leads a team of award-winning reporters and producers who investigate government corruption, questionable business practices, crime and scams in Denver and across the country. Nicole and her 9Wants to Know team have been recognized with an IRE Award in 2019, a Columbia duPont Silver Baton in 2011, and a national Edward R. Murrow award and a Sigma Delta Chi award in 2018.

#broadcast

panel

Machine learning for the rest of us

Friday, 3:30 – 4:30 p.m. (1 hour) • Galerie 3, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

How your newsroom can use machine learning techniques to solve practical reporting problems — even if you don't have a team of experts on staff.

Speakers

Anatoly Bondarenko, Texty.org 👇

Co-founder and head of data journalism for Texty.org.ua, in Kyiv, Ukraine. Author of a data visualization course for Prometheus (a Ukrainian MOOC platform) and visiting lecturer at Ukrainian Catholic University in Lviv.

On Twitter: @dvrnd

Simon Rogers, Google News Lab 👇

Simon Rogers is an award-winning data journalist, writer and speaker. Author of ‘Facts are Sacred‘, published by Faber & Faber in the UK, China and South Korea. He has also written a range of infographics for children books from Candlewick. Data editor on the News Lab team at Google, based in San Francisco, he is director of the Data Journalism Awards and teaches Data Journalism at Medill-Northwestern University in San Francisco.

On Twitter: @smfrogers

Madeleine Varner, The Markup

#machine learning

panel

Beyond pictures: Turning satellite imagery into data

Friday, 3:30 – 4:30 p.m. (1 hour) • Galerie 2, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

Satellite imagery has become easier to obtain, process and analyze, and journalists have increasingly turned to pictures from space to show burned land, eroding coastline and storm-ravaged landscapes. But there’s data in those pixels that journalists might not have considered that can be used to tell stories about the world around them — ethnic cleansing, tribal clashes, the health of forests, pollution and more.

We turn to a panel of leading geospatial experts to explain how we could use remote sensing methods and tools like Google Earth Engine to lend authority to stories that otherwise might rely on anecdotes or worse yet, never get told at all.

Speakers

Jessica McCarty, Miami University 👇

Dr. McCarty has more than 15 years of experience in geospatial and data science, with applications in fire, climate change, emissions, air quality, agriculture and food security, land-cover/land-use change and forestry. Her work scales from farm-level to global. She currently works with U.S. state and federal agencies on wild and prescribed fire management, in addition to her work in India, Nepal, Peru, Vietnam, Ethiopia, Kenya, Côte d'Ivoire, Ukraine, Mexico and the Arctic.

On Twitter: @jmccarty_geo

Ryan McNeill, Reuters 👇

Ryan McNeill is the London-based deputy editor of the Reuters data journalism team. Most recently, his work showed how Burkina Faso’s increasing instability is putting thousands of gold mines in reach of jihadists, as well as how billions of dollars of gold are leaving Africa illegally through the United Arab Emirates. He has previously worked for The Dallas Morning News, the South Florida Sun-Sentinel and The Oklahoman. He is a graduate of Oklahoma State University.

Odean Serrano, Countering Wildlife Trafficking Institute 👇

Dr. Odean Serrano worked for 26 years with NASA and the National Geospatial-Intelligence Agency, and she was designated the first intelligence community lead for combatting wildlife trafficking. Now retired, Odean founded the Countering Wildlife Trafficking Institute, which is designed to implement collaboration and systemic thinking to solve wildlife trafficking using cutting-edge geospatial tools, analysis and AI modeling to provide continuity to mission-driven intelligence and law enforcement priorities. She also serves as the director of geospatial analytics for Chengeta Wildlife, a premier NGO with multidisciplinary expertise to support front line rangers and anti-poaching missions in Africa.

#data viz & design

hands-on

Excel 3: Filtering & pivot tables (repeat)

Friday, 4:45 – 5:45 p.m. (1 hour) • Studio 8, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

A look at the awesome power of pivot — and how to use it to analyze your dataset in minutes rather than hours. We'll work up to using a pivot table by first sorting and filtering a dataset, learning how to find story ideas along the way.

This session is good for: Anyone familiar with formulas, sorting and filtering in Excel or another spreadsheet program.

Speaker

Aimee Edmondson, Ohio University 👇

Edmondson is an associate professor in the E.W. Scripps School of Journalism at Ohio University where she teaches data journalism, media law and the History of American Journalism. She works to bridge the gap between professional journalists and academics. She also trains journalists in data journalism, most recently working in East Africa, Central Asia, China and India.

On Twitter: @ProfEdmondson

#data analysis #excel

hands-on

SQL 3: Joining tables

Friday, 4:45 – 5:45 p.m. (1 hour) • Studio 10, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Learn how to join tables, matching information from one file to another. We'll use SQLite and DB Browser, a free database manager.

This session is good for: People who are familiar with counting, summing or “GROUP BY” in SQL and want to add another tool to their SQL skill set.

Speaker

Rosie Cima, E.W. Scripps 👇

Rosie Cima is a data journalist with the Scripps D.C. bureau and Newsy. She was previously the 2018 Knight Data Journalism Fellow at the Center for Public Integrity, a writer at Priceonomics and a politics blogger at MapLight. Her stories or graphics have also appeared in Vox, Quartz, The Washington Post, The L.A. Times and The Pudding. She has an M.A. in Journalism ('12) and a B.S. in Symbolic Systems ('11), both from Stanford University.

On Twitter: @rosiecima

#data analysis #sql

hands-on

Stats 3: Logistic regression

Friday, 4:45 – 5:45 p.m. (1 hour) • Studio 4, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

Linear regression helps you find relationships between two or more variables, but when an outcome has only two possibilities, you need a different tool. That, my friends, is where logistic regression comes in. This class will be taught in R.

This session is good for: People who took "Stats: An introduction" or are comfortable with summary statistics and spreadsheets. Experience with R is recommended.

Speaker

Hannah Fresques, ProPublica 👇

Hannah Fresques is a data reporter at ProPublica. She holds a master’s degree in quantitative methods for social sciences from Columbia University, and previously worked in education policy research.

On Twitter: @HannahFresques

#statistics #r

hands-on

PDF 3: Batch pdf processing

Friday, 4:45 – 5:45 p.m. (1 hour) • Studio 3, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

Practice processing multiple documents with the open-source Python tool pdfplumber. Dan Keemahill will walk through the steps that helped reporters collaboratively count issues at immigration detention facilities. The class will discuss techniques for working with thousands or millions of documents, but the hands-on component will involve a smaller batch. The class will also discuss Optical Character Recognition, but see the PDF2 class for more hands-on examples of OCR.

This session is good for: People with some programming experience who are able to install third-party software.

Speaker

Dan Keemahill, Austin American-Statesman 👇

Dan Keemahill is a web developer for Gannett and the Austin American-Statesman. He previously built interactive data projects for the Texas Tribune and the radio program Marketplace. He was also a student fellow with the Knight Lab at Northwestern University, where he received a bachelor's degree in journalism.

On Twitter: @dankeemahill

#pdfs #python

hands-on

Geocoding using online tools

Friday, 4:45 – 5:45 p.m. (1 hour) • Studio 1, 2nd floor

💪 Skill level: Beginner

SHOW MORE

Description

If you've had to place many addresses on a map before, you know how problematic bulk geocoding can be — technical issues, terms of service, fun, fun, fun! If you've never had the pleasure, don't worry, we'll show you how to happily (and correctly) geocode large sets of addresses. Learn how to use Geocod.io to turn rows of addresses into points on a map.

This session is good for: Anyone familiar with spreadsheets. No mapping experience necessary.

Speaker

Jack Gillum, ProPublica 👇

Jack Gillum is a senior reporter at ProPublica covering the intersection of technology and privacy, focusing this year on election security and disinformation. He’s previously reported on D.C.-based investigations at The Washington Post and The Associated Press, and worked for USA Today and the Arizona Daily Star in Tucson.

On Twitter: @jackgillum

#mapping #geocoding

hands-on

Power BI 2: Clean, join and visualize data

Friday, 4:45 – 5:45 p.m. (1 hour) • Studio 2, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Tired of losing track of the steps you took to clean a dirty dataset in Excel? Can’t figure out how to combine two datasets that are related but are in different files? This hands-on workshop will delve deeper into the advanced features of Microsoft Power BI, a free data visualization tool that does not require coding skills. This is a great tool for journalists who use Excel to clean and analyze data, but want to build dashboards with charts that interact.

This workshop is good for people who have strong Excel skills.

Speaker

Cathleen Crowley, Times Union

#data viz & design #power bi

special

Lightning Talks

Friday, 5 – 6:15 p.m. (1.25 hours) • Acadia, 3rd floor

💪 Skill level: General interest

SHOW MORE

Description

Moderated by Brittany Mayes, The Washington Post

Sometimes you don't need 45 minutes to explain a useful technique or interesting resource. Join your colleagues for a session of short (5-minute) talks about doing data journalism, web development or other related topics. The NICAR20 talks will be:

1. "Fade In: What Data Journalism Can Learn from Screenwriting," by Phi Do
2. "Life Lessons from Filing 75,000 FOIA Requests," by Michael Morisy
3. "Easy Ways to Become More Secure Online in Under an Hour," by K. Sophie Will
4. "The Three Kinds of Code You'll Write in the Newsroom," by Chris Amico
5. "Covering Immigration as an Immigrant," by Sinduja Rangarajan
6. "The Secret History of Pokémon as Told Through Metadata," by Elliot Bentley
7. "5 Things You Can Learn From Court Records," by Jenn Topper
8. "Investigating Our Own Institutions," by Steven Rich
9. "25 Newsrooms, 1 Baby Data Journalist," by Julie Christie
10. "What Rocket Science Can Teach Us About Designing for Humans," by Justin Myers


Lightning Talks are sponsored by Knight Foundation.

#welcome

special

Philip Meyer Award presentation

Friday, 6:15 – 6:30 p.m. (15 minutes) • Acadia, 3rd floor

SHOW MORE

Description

The presentation of the 2019 Philip Meyer Journalism Awards will take place on Friday evening, directly following Lightning Talks.

The awards recognize the best uses of social research methods in journalism and are named in honor of Philip Meyer, author of “Precision Journalism” and retired Knight Chair in Journalism and UNC School of Journalism and Mass Communications.

special

Philip Meyer reception

Friday, 6:30 – 7:30 p.m. (1 hour) • Carondelet, 3rd floor

SHOW MORE

Description

Join fellow NICAR attendees and award winners at a reception with light appetizers and a cash bar immediately following the awards presentation beginning at 6:30 p.m. Friday.

Saturday, March 7

special

Conference registration

Saturday, 8:30 a.m. – 6 p.m. (all day) • Preservation Foyer, 2nd floor

⚠️ Conference registration will be open on multiple days.

SHOW MORE

Description

Conference registration will be located on the 2nd floor in Preservation Foyer. Be sure to stop by and pick up your conference name badge. Name badges must be worn during the conference.

special

Conference sales

Saturday, 8:30 a.m. – 6 p.m. (all day) • Studio Foyers, 2nd floor

⚠️ Conference sales will be open on multiple days.

SHOW MORE

Description

Stop by the NICAR sales table located in Preservation Foyer on the 2nd floor to browse books from the IRE store, IRE merchandise and shirts with the winning design from the T-shirt contest.

hands-on

Mastering Google Sheets: Web scraping, running scripts and other tricks (Saturday)

Saturday, 9 a.m. – 12:30 p.m. (3.5 hours) • Studio 1, 2nd floor

💪 Skill level: Beginner

⚠️ This session requires pre-registration and an additional fee of $35 to reserve a seat.

SHOW MORE

Description

Google Sheets is more than just free spreadsheet software to organize and store data. This hands-on session will start with pivot tables and conditional formatting, and through examples, we'll also learn how to scrape data in seconds without code, automate menial tasks with macros, write custom spreadsheet formulas as well as how to send emails, geocode addresses, translate text and more – all through the power of Google Sheets. Come with a laptop and leave with the knowledge of a Google Sheets power user.

Preregistration is required and seating is limited. You must bring your own laptop (no tablets) to this training and have a Google account.

Workshop prerequisites: You should be familiar with using spreadsheets and formulas.

Speakers

Frank Bi, Vox Media 👇

Frank Bi is a senior storytelling engineer at Vox Media in New York City where he works on innovative storytelling projects for the web. He also teaches data literacy and visualization at Fordham University and is a Google News Initiative trainer, teaching journalists in newsrooms and at conferences across the country how to use free journalism tools. Frank is the president of the Asian American Journalists Association's New York chapter.

Samantha Sunne, Independent journalist 👇

Samantha Sunne is a freelance journalist based in New Orleans. She speaks at conferences, universities and newsrooms around the world, teaching digital tools and tech literacy for journalists. Her work has been published by the Washington Post, NPR and Reuters, and recommended by the Poynter Institute and the Harvard Shorenstein Center on Media, Politics and Public Policy.

On Twitter: @samanthasunne

#web scraping #google sheets

hands-on

Digging into data for stories: A crash course in Excel

Saturday, 9 a.m. – 12:30 p.m. (3.5 hours) • Studio 2, 2nd floor

💪 Skill level: Beginner

⚠️ This session requires pre-registration and an additional fee of $70 to reserve a seat.

⚠️ This session is split over multiple days.

SHOW MORE

Description

Get started using data in your stories with IRE's original mini-boot camp. In this 7-hour, hands-on workshop, IRE’s experienced trainers will start with the basics of navigating Excel and using formulas, then walk you through sorting, filtering and aggregating data with pivot tables to find story ideas.

You'll come away with a solid base for using data analysis in your newsroom, including how to find and request data, identify and clean dirty data, find story ideas and bulletproof your work.

We’ll also provide you with our detailed boot camp materials to help keep you on track long after you leave the conference.

Preregistration is required and seating is limited. Laptops will be provided for the training.


Workshop prerequisites: There are no prerequisites for this workshop and beginners are welcome. This workshop is good for those wanting to get started analyzing data for stories.

Speakers

Patti DiVincenzo, IRE & NICAR 👇

Patti DiVincenzo is a training director at IRE. She spent more than three decades working in TV stations across the country, starting in Topeka, Kansas, and eventually landing at WSB-TV in Atlanta, where she was an investigative producer and data specialist for 16 years. A longtime member of IRE, she joined the staff in February 2019.

Sarah Hutchins, IRE & NICAR 👇

Sarah Hutchins is a training director for IRE & NICAR. She previously served as the organization’s editorial director, overseeing IRE’s publications and online platforms. Sarah has worked for daily newspapers in several states. Before joining IRE in 2014, she was a reporter at The Virginian-Pilot. Sarah has a bachelor's degree in journalism from Indiana University and a master's degree in data science and analytics from the University of Missouri.

On Twitter: @sarhutch

Francisco Vara-Orta, IRE & NICAR 👇

Francisco Vara-Orta is a training director at Investigative Reporters & Editors. He brings nearly 20 years of newsroom experience and has been published by a variety of news organizations, including Chalkbeat, Education Week, the San Antonio Express-News, Austin Business Journal, Los Angeles Business Journal and the Los Angeles Times. He earned a master’s degree in investigative/data journalism at the University of Missouri and a bachelor’s degree from St. Mary’s University in San Antonio.

#data analysis #excel

hands-on

Exploring the tidyverse in R

Saturday, 9 a.m. – 5:45 p.m. (all day) • Studio 7, 2nd floor

💪 Skill level: Advanced

⚠️ This session requires pre-registration and an additional fee of $70 to reserve a seat.

SHOW MORE

Description

Learn how to use the tidyverse, a collection of R packages, to help you make your data journalism more efficient, stronger and more fun. Learn how to import, clean, analyze and plot data for your stories. If you want to modernize your R workflow with dplyr, tidyr, readr, ggplot2, tibble and purr, this class is for you. This workshop assumes some familiarity with R and RStudio, or programming experience in another language (e.g., Python or JavaScript), but will start from the beginning with tidyverse principles.

Preregistration is required and seating is limited. Laptops will be provided for the training.

Workshop prerequisites: You should be comfortable working with R and RStudio and be familiar with basic data analysis.

Speakers

Aaron Kessler, Bloomberg Industry Group 👇

Aaron Kessler specializes in investigative reporting and data analysis at the intersection of business and politics. He's currently on the investigative team at Bloomberg Industry Group, pursuing projects tied to the executive agencies, Congress and the corporate world. He's a Mizzou alumnus who got his start covering city hall for the Joplin Globe and has worked at CNN, the Sarasota Herald-Tribune and wrote about the auto industry for the New York Times.

On Twitter: @akesslerdc

Amelia McNamara, University of St. Thomas 👇

Dr. McNamara is an assistant professor of statistics in the Department of Computer Science at the University of St. Thomas in Minnesota. She is interested in how journalists use tools to work with data.

On Twitter: @AmeliaMN

#data analysis #r

hands-on

First graphics app: Node.js in the newsroom

Saturday, 9 a.m. – 5:45 p.m. (all day) • Studio 3, 2nd floor

💪 Skill level: Advanced

⚠️ This session requires pre-registration and an additional fee of $70 to reserve a seat.

SHOW MORE

Description

Armand Emamdjomeh, Elbert Wang and Ben Welsh teach you how America’s top news organizations escape rigid content-management systems to publish custom graphics on deadline.

Take this six-hour class to get hands-on experience in every stage of the development process, writing JavaScript, HTML and CSS within a Node.js framework. You’ll start with data from a real-life Los Angeles Times analysis. You won’t stop until you’ve crafted a custom presentation and deployed a working application on the World Wide Web.

Preregistration is required and seating is limited. Laptops will be provided.

Workshop prerequisites: If you have a good attitude and know how to take a few code crashes in stride, you are qualified for this class. If you’re a little scared, that’s a good thing. You’re ready for this.

Speakers

Elbert Wang, The Wall Street Journal 👇

Elbert is a graphics reporter at The Wall Street Journal on the U.S. news desk. Previously, he was a fellow on the data visuals team at the Texas Tribune and an intern on the interactives team at the San Francisco Chronicle. He is a graduate of Brown University, where he studied computer science and classics.

On Twitter: @elbertwang1

Ben Welsh, Los Angeles Times 👇

Ben is the editor of the Data and Graphics Department in the Los Angeles Times newsroom. The team of reporters and computer programmers works together to collect, organize, analyze and present large amounts of information. He is also a co-founder of the California Civic Data Coalition, a network of journalists and computer programmers dedicated to opening up public data, and the leader of PastPages, an open-source effort to better archive digital news.

On Twitter: @palewire

#programming #javascript

hands-on

Web scraping with Python

Saturday, 9 a.m. – 12:30 p.m. (3.5 hours) • Studio 9, 2nd floor

💪 Skill level: Intermediate

😬 This class is sold out. Please fill out this form to add your name to a waiting list.

⚠️ This session requires pre-registration and an additional fee of $35 to reserve a seat.

SHOW MORE

Description

If you need data that's trapped on a website, writing some code to scrape the page could be your solution. This entry-level class will show you how to use the Python programming language to harvest information from websites into a spreadsheet. We'll introduce you to the command line and show you how to write enough code to fetch and parse web content.

Preregistration is required and seating is limited. Laptops will be provided.

Workshop prerequisites: This class is programming for beginners. Some basic familiarity with Python and HTML is helpful but not required.

Speaker

Cody Winchester, IRE & NICAR 👇

Cody is a training director at Investigative Reporters & Editors. Before joining IRE, he worked at newspapers in Texas, Nebraska and South Dakota.

#web scraping #python

master class

Master class: Finding and telling stories with earth imagery

Saturday, 9 a.m. – 12:30 p.m. (3.5 hours) • Galerie 5, 2nd floor

💪 Skill level: Intermediate

⚠️ This session requires pre-registration and an additional fee of $35 to reserve a seat.

SHOW MORE

Description

Satellites, planes, drones — thanks to these and other planetary-sensors, we know more about our earth, its oceans, landscapes and cityscapes than ever before. With heaps of new data and tools at our disposal, journalists are among the many people accessing this wellspring of source data and using it to show changes at global and local scales at an ever-increasing rate, from the disappearing polar ice caps to monitoring local port shipments.

This workshop will provide an introduction to practical geographic journalism through concrete case studies. It will then offer tools and skills that can help you start infusing earth imagery into your stories. You will leave this workshop with a new way of thinking about earth imagery and how to use it.

Prerequisites: There are no prerequisites but it would be helpful to have some experience with QGIS, bash (imagemagick, ffmpeg, gdal), and Photoshop.

Speaker

Tim Wallace, Descartes Labs 👇

Tim Wallace is a geographer and visual journalist at Descartes Labs in Santa Fe, New Mexico. He has a PhD in geography from The University of Wisconsin-Madison and was a recently a graphics editor at The New York Times, where he created visual stories on neighborhoods, cities, regions and the world with information gathered from land, sky and space.

On Twitter: @wallacetim

#mapping

commons

Educators meetup

Saturday, 9 – 10 a.m. (1 hour) • Galerie 4, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

If you teach data journalism, investigative reporting or any journalism course, join your fellow instructors for a discussion about what works, what doesn’t, and what’s new in the classroom. We’ll include a preview of the upcoming edition of IRE’s Investigative Reporters Handbook and the related resources it will offer, coming out in June.

Speakers

Mark Horvit, University of Missouri 👇

Mark Horvit is an associate professor at the University of Missouri School of Journalism, where he teaches investigative reporting and directs the school’s state government reporting program. He previously served as executive director of Investigative Reporters & Editors (IRE) and the National Institute for Computer-Assisted Reporting (NICAR). Horvit worked as a reporter and editor for 20 years before joining IRE.

Brant Houston, University of Illinois 👇

Brant Houston is the Knight Chair in Investigative Reporting at the University of Illinois. Before Illinois he was executive director of IRE for more than a decade after 17 years as an award-winning investigative reporter in U.S. newsrooms. He is author of "Data for Journalists: A Practical Guide to Computer-Assisted Reporting" and co-author of "The Investigative Reporter's Handbook." He works with nonprofit newsrooms and co-founded INN and GIJN.

On Twitter: @branthouston

#education

hands-on

Advanced SQL: Update queries, sub-queries and more

Saturday, 9 – 10 a.m. (1 hour) • Studio 10, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

If you feel comfortable with the Structured Query Language basics that IRE teaches in its bootcamps — SELECT, FROM, WHERE, GROUP BY — but are ready to see what else SQL can do, this session is for you. We will cover more advanced ways of manipulating and questioning data, such as UPDATE queries, joins, writing sub-queries and other neat tricks. We will use SQLite in the class.

This session will be most helpful if: You are comfortable with counting and summing in SQL.

Speaker

Madi Alexander, The Dallas Morning News 👇

Madi Alexander is a computational journalist at The Dallas Morning News. She was previously a data reporter at Bloomberg Government in Washington, D.C. Madi has a master's degree in journalism from the University of Missouri. She volunteers for the Dallas puppy-raising chapter of Guide Dogs for the Blind. Madi also keeps a database of all the national parks and historical sites she has visited — a total of 40 thus far.

On Twitter: @MadiLAlexander

#data analysis #sql

panel

Data Dive 3: Cancer Alley, H-1B Visas, sexual abuse and assault

Saturday, 9 – 10 a.m. (1 hour) • Bissonet, 3rd floor

💪 Skill level: General interest

SHOW MORE

Description

A data deep dive into some of the best data journalism of 2019. Hear from reporters how they gathered, cleaned, analyzed and visualized the data behind some of the year's biggest stories.

Speakers

Lise Olsen, Texas Observer 👇

Lise Olsen, senior editor and writer at the Texas Observer magazine, has had many adventures in more than two decades of data journalism and digging for newspapers in five states. Her work has been featured in two documentaries. In one of her favorite former jobs, she directed IRE's Mexico project.

On Twitter: @lisedigger

Sinduja Rangarajan, Mother Jones 👇

Sinduja Rangarajan is the senior data journalist at Mother Jones. She previously worked at Reveal from the Center for Investigative Reporting, where her series on the lack of diversity in Silicon Valley led to many tech giants publicly releasing their data. Her work has won several awards, including the National Edward Murrow Award in 2019. She wrangles and analyzes datasets to tell stories and finds innovative ways to report on issues by collaborating with academics.

Lucia Walinchus, Eye on Ohio, the Ohio Center for Investigative Journalism 👇

Lucia Walinchus is an award-winning journalist, attorney and ice hockey addict. She is currently the Executive Director at Eye on Ohio, the Ohio Center for Investigative Journalism. Walinchus was named a 2016 Fulbright Berlin Capital Program Scholar. She has been featured as a guest speaker on CNN and is a contracted freelancer for the New York Times. Walinchus has a degree in Journalism from American University and a Juris Doctor degree from California Western School of Law.

On Twitter: @SoSaysLucia

Lylla Younes, ProPublica 👇

Lylla Younes is a news apps developer for ProPublica’s Local Reporting Network. She was previously a data reporter with New York Public Radio (WNYC) and Gothamist.

On Twitter: @lyllayounes

#story ideas

hands-on

Command line for reporters (Mac)

Saturday, 9 – 10 a.m. (1 hour) • Studio 6, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Too often in data journalism we forget about the basics. And it doesn't get as basic as the command line. Even knowing a little will make your job easier. Mother Jones reporter AJ Vicens will run through some simple commands, dive into working with spreadsheets and show you some handy tools he frequently uses at work.

This session is good for: People who feel intimidated by the command line on their computer, but want to explore the power of command line tools.

Speaker

AJ Vicens, Mother Jones 👇

AJ Vicens is a cybersecurity/election security reporter at Mother Jones.

On Twitter: @AJVicens

#tools #command line

demo

Enriched census data from IPUMS

Saturday, 9 – 10 a.m. (1 hour) • Galerie 6, 2nd floor

💪 Skill level: intermediate

SHOW MORE

Description

IPUMS provides census and survey data from around the world integrated across time and space. In this session, we’ll take a tour of IPUMS data collections and resources, focusing on unique U.S. census data products and how to access them. We have U.S. census data from 1790 through the present and for all geographic levels down to blocks, including microdata (individual-level responses), summary data, time series, and GIS files. Users can download customized data files, generate microdata summaries online, or access geographic data through a new API.

Whether you’re an IPUMS newbie or a regular, this session will get you caught up with the latest IPUMS has to offer.

Speaker

Jonathan Schroeder, IPUMS 👇

Jonathan Schroeder is a geographer and information designer at the IPUMS Center for Data Integration at the University of Minnesota. In his role as project manager for the National Historical Geographic Information System (NHGIS), he tries to fit in as much data visualization and analysis as he can. He also contributes to the IPUMS USA project by leading the development of integrated geographic variables for U.S. Census microdata.

On Twitter: @j_p_schroeder

#census & demographics

demo

Mobile, data and desktop reporting tools for your newsroom

Saturday, 9 – 10 a.m. (1 hour) • Acadia, 3rd floor

💪 Skill level: General interest

SHOW MORE

Description

Trainer Mike Reilley returns to NICAR to share the latest and greatest mobile and desktop tools to create data viz, handle digital workflow and fact-check information.

This workshop is fast-paced, so bring a fully charged laptop, smartphone and a double espresso. You'll leave with some cool projects, digital handouts and other resources you can take back to your newsroom or classroom.

Speaker

Mike Reilley, University of Illinois-Chicago 👇

Mike teaches data and digital journalism at the University of Illinois-Chicago. He's an SPJ digital trainer in the Google News Initiative training program and consults with several news organizations through Penny Press Digital and the Media Shift Training Network. A former staffer for the Los Angeles Times, the Chicago Tribune and WashingtonPost.com, Mike has taught for 17 years at UIC, Northwestern, Arizona State University and DePaul. He is the founder of JournalistsToolbox.org.

On Twitter: @journtoolbox

#work better

hands-on

QGIS 1: Mapmaking for beginners

Saturday, 9 – 10 a.m. (1 hour) • Studio 8, 2nd floor

💪 Skill level: Beginner

SHOW MORE

Description

Learn to how to make your own maps using free, open-source software called QGIS. This class will teach you how to get started importing and displaying geographic data. Not all datasets need to be mapped, but some do! We'll go over how to find publicly available data, prepare it for mapping, and join together different datasets.

This session is good for: Beginners looking to learn the basics of visualizing geographic data.

Speaker

John Walton, BBC News 👇

John Walton is Data Journalism Editor at BBC News. Recent projects include December’s UK general election results coverage, a climate change project ("How much warmer is your city?") and a data project on deaths in Afghanistan ("Afghanistan war: Tracking the killings"). John has taken mapping workshops at NICAR several times in the past.

#mapping #qgis

panel

How researchers and journalists work together and why it sometimes falls apart

Saturday, 9 – 10 a.m. (1 hour) • Galerie 3, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

A discussion between three researchers/scientists and a journo, exploring how the press can best work with academic communities, both as a source of wisdom and knowledge and also data. What are each side’s complementary interests, and why do they sometimes collide? How do scientists and journos use data, and how those uses sometimes differ? And why journos often focus on outliers, the statistical tails, and why scientists usually don’t.

Speakers

Michael Polito, Louisiana State University, Department of Oceanography and Coastal Sciences 👇

Michael Polito is an assistant professor at Louisiana State University. He is an ecologist with a focus on the influence of climate change on the food web dynamics of marine and coastal ecosystems ranging from Louisiana to Antarctica. His research, which explores species responses to climate change and other stressors, has been profiled by The New York Times, BBC News, The Wall Street Journal and Scientific American, among others.

On Twitter: @MJPolito

Nancy Rabalais, Louisiana Universities Marine Consortium

Edward Shihadeh, Louisiana State University

Maurice Tamman, Reuters 👇

Maurice Tamman is a reporter and editor on the Reuters enterprise unit based in New York City. Most recently he published "Ocean Shock," an expansive examination of how climate change is causing chaos for fisheries around the planet. Previously, Mo ran the unit’s forensic data team, which he created after joining Reuters in 2011 from The Wall Street Journal.

On Twitter: @motamman

#research

special

Exhibitors and recruiters

Saturday, 9 a.m. – 5 p.m. (all day) • Studio Foyers, 2nd floor

⚠️ Exhibitors and recruiters will be open on multiple days.

SHOW MORE

Description

Be sure to stop by the Studio foyers on the 2nd floor and visit with the exhibitors/recruiters.

panel

FOIA on the fly

Saturday, 9 – 10 a.m. (1 hour) • Galerie 2, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

The promise of the Freedom of Information Act often falls short of expectations, and the process can be long and drawn-out. For a beat reporter, FOIA can be particularly daunting. This panel will provide concrete strategies for conceptualizing, drafting, filing and employing strategies to get records on deadline. It also will offer a realistic guide to filing and managing your FOIA requests, how to use FOIA when you're swamped or busy, how to strategize to get materials more quickly, and where to look for already-FOIA'd information that might be in the public domain.

Speakers

James Grimaldi, The Wall Street Journal 👇

James Grimaldi is a senior writer on the investigative desk at The Wall Street Journal. A former IRE president, he now serves on the Reporters Committee for Freedom of the Press. He won a Pulitzer in 2006 and has won many other awards, including an IRE FOI award in 2010 and a Dirksen award from the National Press Foundation in 2018. He previously worked for The Washington Post, Seattle Times, Orange County Register and San Diego Tribune. He is based in Washington, D.C.

Daniel Jeon, Reporters Committee for Freedom of the Press 👇

Daniel Jeon as a legal fellow at the Reporters Committee for Freedom of the Press (rcfp.org), a nonprofit legal services organization in Washington, D.C. He primarily works on litigation and amicus briefs to ensure that reporters get the records they requested under state and federal public records acts.

Katie LaGrone, E.W. Scripps Company 👇

Katie LaGrone is the Florida investigative correspondent for The E.W. Scripps Company. An award-winning broadcast journalist, Katie’s investigative reports can be seen on ABC Action News in Tampa, WPTV NewsChannel 5 in West Palm Beach, FOX 4 in Fort Myers and WTXL in Tallahassee. Her reports have earned her more than a dozen Emmy's, AP awards and Edward R. Murrow awards.

#open records

hands-on

Practical machine learning for investigations with fast.ai (Saturday morning)

Saturday, 9 a.m. – 12:30 p.m. (3.5 hours) • Studio 4, 2nd floor

💪 Skill level: Advanced

⚠️ This session requires pre-registration and an additional fee of $35 to reserve a seat.

SHOW MORE

Description

Get hands-on experience using this accessible, open-source Python library to classify images, text, and rows of data -- potentially saving you hours or days of work poring through the data. In the process, you'll also get a feel for the power -- and limits -- of machine learning.

This session with John Keefe and Jeremy Merrill of the Quartz investigations team will introduce you to the concept of machine learning and several practical uses for it in your newsroom.

Preregistration is required and seating is limited. Computers will be provided.

Prerequisites: A Google (aka Gmail) account. Basic understanding of Python is recommended but not required.

Speakers

John Keefe, Quartz 👇

John Keefe is the investigations editor at Quartz. He also teaches classes on investigative reporting, product prototyping, and machine learning at the Craig Newmark Graduate School of Journalism at CUNY. Before joining Quartz, he was Senior Editor for Data News at public radio station WNYC. Keefe blogs at johnkeefe.net.

On Twitter: @jkeefe

Jeremy Merrill, Quartz 👇

Jeremy B. Merrill is a reporter with Quartz's investigations team, covering online political influence using computer-assisted reporting and artificial intelligence.

#machine learning #python

panel

Finding and using international data

Saturday, 10:15 – 11:15 a.m. (1 hour) • Galerie 6, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

You find yourself having to find data in a country you've never dealt with before, or you'd like to explore the data available in your own country. Where do you even start? This panel will take you through a tried and tested path which will help unearth data in unfamiliar territory around the world. If you already have experience of this, come along and share.

Speakers

Winny de Jong, NOS 👇

Winny de Jong works as a data journalist at the Dutch public news broadcast, NOS. When she’s is not working, she enjoys other hobbies like yoga, crossfit and learning Portuguese. Até logo!

Louis Goddard, Global Witness 👇

Louis Goddard is a data investigations advisor at the anti-corruption non-profit group Global Witness. He joined Global Witness in 2019 after two and a half years as a data journalist at The Times of London, where he worked on more than a dozen front-page stories, including flagship investigations into cyber-crime, tax havens and government contracting.

Giannina Segnini, Columbia University 👇

Giannina Segnini is the director of the Data Journalism Degree at Columbia University in New York City. She also oversees the cross-border data investigative fellowship at the J-School, an initiative to investigate organized crime and corruption across borders using data. Segnini is an investigative journalist from Costa Rica, where she used to lead a team of reporters that triggered more than 50 criminal investigations after their revelations.

#international

hands-on

MySQL

Saturday, 10:15 – 11:15 a.m. (1 hour) • Studio 10, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Data often comes in large or relational tables that require a good database manager beyond what Excel can offer. MySQL is a free powerful and popular open-source tool and with it you can transform and analyze almost any data set. In this class we will introduce you to MySQL and how it works.

This session is good for: People with some experience working with data in columns and rows and who are familiar with SQL

Speaker

Mike Stucka, USA TODAY Network

#data analysis #sql

panel

Voter file data, from toplines to deep dives to breaches

Saturday, 10:15 – 11:15 a.m. (1 hour) • Bissonet, 3rd floor

💪 Skill level: General interest

SHOW MORE

Description

Voter file data can be an important reporting tool, but the data is so fragmented it's difficult to find, standardize and aggregate. In addition, readers are often shocked that this level of data is available. We will discuss practical tips for when voter data is useful, how to find and process it, what it can't do, and how to report accurately and responsibly on voter data breaches, and leave lots of time for voter data questions!

Speakers

Carla Astudillo, Texas Tribune 👇

Carla Astudillo is a news app and data visuals developer with a focus on elections and political data. Previously, she was a data and interactive visuals journalist at NJ.com and The Star-Ledger in New Jersey, where she helped build a database of police use of force in the state as part of a 16-month investigative project. She got her master's degree from the Craig Newmark Graduate School of Journalism at CUNY and her bachelor's degree from the University of Florida.

Jessica Huseman, ProPublica 👇

Jessica Huseman is a reporter for ProPublica based in Austin, Texas. She is the lead reporter for Electionland, ProPublica's collaborative effort to cover ballot access. She is a data journalism instructor at Columbia Graduate School of Journalism.

Caitlin Ostroff, The Wall Street Journal 👇

Caitlin Ostroff is a London-based reporter for The Wall Street Journal where she uses words, numbers and code to cover the world of finance. Previously, she was a data reporter at the Miami Herald, covering elections, gun violence and Mar-a-Lago. She’s a graduate of the University of Florida and co-director of @jourinternships’ online Media Mentors program. She’s happy to chat, so reach out at caitlin.ostroff@wsj.com.

On Twitter: @ceostroff

Rachel Shorey, The New York Times 👇

Rachel is a Senior Software Engineer and Assistant Editor for Data Projects on the Interactive News team at The New York Times. She works on a variety of software and data projects, including campaign finance and voter data. In addition, she is especially excited to chat about prime numbers.

#election & politics #election

hands-on

Exploring networks with graph databases

Saturday, 10:15 – 11:15 a.m. (1 hour) • Studio 6, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

As data journalists, we're used to using relational databases — data organised in rows and columns such as a spreadsheet or SQL — to do our analysis and find stories. Graph databases are incredibly powerful for finding connections and patterns within our databases that would be difficult if not impossible to spot using traditional software.

This session will provide a hands-on introduction to graph database Neo4j, showing examples of its use for investigative journalism including the Panama Papers, and teach you how to build your own graph database, importing public datasets to see at a glance the networks involved.

This session is good for: Beginners to graph databases.

Speaker

Leila Haddou, Independent journalist 👇

Leila Haddou is an investigative reporter and former data journalism editor for The Times and Sunday Times in London. She has previously worked on investigations for the Financial Times and the Guardian and has an avid interest in how technology can aid deep-dive, public interest reporting.

On Twitter: @leilahaddou

#data analysis #graph databases

panel

Dear diary: Best practices for keeping a data diary

Saturday, 10:15 – 11:15 a.m. (1 hour) • Galerie 3, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

Data diaries are absolutely necessary and very hard to do right. They're an honest description of your steps and missteps, a way to recover from errors and a critical guide to self-learning. What formats do people use to keep track of their data, their queries, etc.?

Speakers

Ally Jarmanning, WBUR 👇

Ally Jarmanning champions data and public records at WBUR, the NPR station in Boston. She focuses on policing and technology and leads training in the newsroom. Before jumping into radio, she was a crime reporter at The Columbus Dispatch in Ohio and reported for The Patriot Ledger and Boston.com in Massachusetts.

On Twitter: @allyjarmanning

Emmanuel Martinez, The Markup

Ken Sweet, The Associated Press 👇

Ken Sweet covers banking, financial discrimination and consumer protection issues for The Associated Press. Before joining the AP in 2013, Ken worked for The Wall Street Journal and CNN. He’s an Arizona native and an owner of a corgi named Latke.

#work better

hands-on

QGIS 2: Analyzing geographic data

Saturday, 10:15 – 11:15 a.m. (1 hour) • Studio 8, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Build on your existing knowledge of QGIS and learn how to filter and analyze geographic datasets, before familiarising yourself with labelling and exporting publication-ready maps using the print composer.

This session is good for: Those who attended the QGIS I workshop or already know the basics of visualizing geographic data in QGIS.

Speaker

Christine Jeavans, BBC News 👇

Christine Jeavans is a senior data journalist at BBC News with a focus on health, social issues and politics. Recent projects include covering the UK's 2019 general election, and the award-winning NHS Tracker.

On Twitter: @chrisjeavans

#mapping #qgis

demo

CANCELED - Burner profiles: Using virtual machines to protect yourself from doxxing

Saturday, 10:15 – 11:15 a.m. (1 hour) • Acadia, 3rd floor

🚫 Due to speaker cancellations, this session has been canceled.

💪 Skill level: Intermediate

SHOW MORE

#security

panel

Unpacking AI’s influence in society

Saturday, 10:15 – 11:15 a.m. (1 hour) • Galerie 2, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

From shopping to dating, many companies are already using AI technology to shape our everyday life. But what about our most trusted community institutions? This panel will unpack how AI is being deployed and adapted by our institutions from police to courts to news outlets and more.

Speakers

Nicholas Diakopoulos, Northwestern University 👇

Nick Diakopoulos is a professor of communication studies and computer science at Northwestern University. He studies automation and algorithms as they impact news media including aspects of journalistic data mining, automated content production, news bots and algorithmic accountability. He is author of "Automating the News: How Algorithms are Rewriting the Media" from Harvard University Press, and co-editor of "Data-Driven Storytelling" from CRC Press.

On Twitter: @ndiakopoulos

Andrea Hickerson, University of South Carolina 👇

Andrea Hickerson is a professor, the director of the school of Journalism and Mass Communications and an associate dean in the College of Information and Communications at the University of South Carolina. She conducts research on journalism routines with an emphasis on technology use and political communication. She is a member of an interdisciplinary team based at Rochester Institute of Technology studying deepfakes.

On Twitter: @aehickerson

#artificial intelligence

commons

Introducing and implementing security protocols in your reporting process

Saturday, 10:15 – 11:15 a.m. (1 hour) • Galerie 4, 2nd floor

💪 Skill level: Beginner

SHOW MORE

Description

Opening secure communication channels is a great way to establish trust and offer confidentially to sources. But setting up secure tip lines costs time and money, and it can be a challenge if you have limited resources.

This will be a space to talk about different ways to include security measures in your reporting process, whether you're a local reporter, student journalist, freelancer, etc. No digital security experience required!

We'll discuss the different tools available (e.g. encrypted messaging apps), resources you can start with, what protocols you can set up if you and/or your newsroom have a limited budget, and common security challenges.

Let's brainstorm ideas and help you find solutions that work best for you and/or your newsroom!

Speaker

Phi Do, Los Angeles Times 👇

Phi is a data journalist at The Los Angeles Times, where she launched and manages the newsroom tip line. Prior, she helped develop databases for Voice of OC and wrote for the Santa Barbara Independent and the Hollywood Reporter. She graduated with a film degree from the University of California at Santa Barbara.

#security

demo

The opioid crisis: Inflection points and damning data

Saturday, 10:15 – 11:15 a.m. (1 hour) • Acadia, 3rd floor

💪 Skill level: General interest

SHOW MORE

Description

This session will explore how you can use data to find and tell the stories of the opioid epidemic and other medical trends and crises.

Speaker

Lisa Girion, Reuters 👇

Girion's award-winning investigations for Reuters and the Los Angeles Times have led to new laws and criminal and Congressional investigations. She documented the dubious science behind police Tasers, the real problem with OxyContin and the asbestos that Johnson & Johnson didn't want you to know about. Her report on modern-day slavery in Myanmar is chronicled in the book "Global Muckrakers." Her insurance exposé won back health coverage for thousands and is cited in the Affordable Care Act.

#drugs

panel

Building and telling a bulletproof data story

Saturday, 11:30 a.m. – 12:30 p.m. (1 hour) • Galerie 3, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

Whether you’re the lone data-cruncher in your organization or the manager of a big-time newsroom, we’re going to share techniques everyone can use to ensure they’ve got bulletproof data. We will first go over questions everyone should ask to avoid dangerous mistakes and assumptions, and then give tips on how to incorporate that data into a compelling story.

Speakers

Helena Bengtsson, Sveriges Television 👇

Helena Bengtsson is editor for data journalism at Sveriges Television, Sweden’s national television broadcaster. She worked as editor for data projects at the Guardian UK between 2014-2017. In 2006 and 2007, she was database editor at the Center for Public Integrity in Washington, D.C. She was twice awarded Stora Journalistpriset (The Swedish Grand Prize for Journalism) in Sweden, in 2010 for Valpejl.se and in 2016 for innovator of the year.

On Twitter: @HelenaBengtsson

Matt Dempsey, Houston Chronicle 👇

Matt Dempsey is the data editor at the Houston Chronicle. He has worked on projects involving wildfires, state pensions and the chemical industry. His passion for public records frequently leads to disclosure of data from all levels of government. His series "Chemical Breakdown" won the 2016 IRE Innovation award and the National Press Foundation’s “Feddie” award. His work was a key part of the Chronicle’s Pulitzer Prize finalist entry for Breaking News.

Kimbriell Kelly, Los Angeles Times 👇

Kimbriell Kelly is the Deputy Editor for Enterprise and Investigations at the Los Angeles Times' Washington, D.C., Bureau. Prior to joining the Times in June, Kelly was a reporter on the Investigative Unit at The Washington Post, where she was part of the team that won a Pulitzer in 2015 for the examination of officer-involved shootings. She was a Pulitzer finalist in 2019 for her work on "Murder with Impunity,” a series on unsolved homicides.

On Twitter: @kimbriell

#bulletproofing

panel

Reasoning for data visualization

Saturday, 11:30 a.m. – 12:30 p.m. (1 hour) • Bissonet, 3rd floor

💪 Skill level: General interest

SHOW MORE

Description

Visualization is often taught as a set of rules that are set in stone — "pie charts are dumb!", "make all your graphs start at 0!", "increase data-ink ratio!" — but what if those rules have shaky foundations, being based just on the very personal aesthetic preferences of a handful of influential authors? This talk suggests that visualization is more similar to writing that we think: It's constrained by the limitations of the human brain but, beyond that, it's as flexible as written language, if not more. Instead of thinking of rules, then, visualization designers should learn how to make justified and informed decisions instead.

Speaker

Alberto Cairo, University of Miami 👇

Alberto Cairo is the Knight Chair in Visual Journalism at the University of Miami and the director of the Visualization Program at the university's Center for Computational Science. He's been a graphics director a media publications in Spain and Brazil, and he's currently a consultant for companies like Google. He's also the author of several books about visualization, such as 'How Charts Lie' (2019) and 'The Truthful Art' (2016).

On Twitter: @albertocairo

#data viz & design

hands-on

Text mining in R with tidytext

Saturday, 11:30 a.m. – 12:30 p.m. (1 hour) • Studio 6, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

Do you want to analyze the themes, sentiment, and complexity of every State of the Union address, or analyze @realDonaldTrump's use of Twitter? This session will introduce you to the tools needed to tackle these and other challenges in text analysis in R, using the tidytext package.

This session is good for: People familiar with the basics of R.

Speaker

Peter Aldhous, BuzzFeed News 👇

Aldhous is a reporter on the science desk at BuzzFeed News, based in San Francisco. His data-driven projects have included the use of machine learning to find spy planes in public flight-tracking data and text analysis of the Twitter accounts of President Donald Trump and all members of Congress.

On Twitter: @paldhous

#data analysis #r

panel

Beyond formulas: A statistical world view

Saturday, 11:30 a.m. – 12:30 p.m. (1 hour) • Galerie 6, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

For years, we’ve been talking to each other about how to think about numbers and statistical tools. Now hear from a leading applied statistician and get views from outside our world on how journalists should be thinking about data and numbers. We’ll talk about methods new and old --- and how to avoid mistakes that give statisticians heartburn.

Speakers

James Cochran, The University of Alabama 👇

James Cochran earned a PhD in Statistics from the University of Cincinnati in 1997. Dr. Cochran has received the INFORMS Prize for the Teaching of OR/MS Practice, the Mu Sigma Rho Statistical Education Award, the ASA’s Founders Award, the Karl E. Peace Award for outstanding statistical contributions for the betterment of society, the ASA’s Waller Distinguished Teaching Career Award and the INFORMS President’s Award. He is a fellow of both the ASA and INFORMS.

Sarah Cohen, Walter Cronkite School of Journalism, Arizona State University 👇

Sarah Cohen is the Knight Chair in Journalism at the Walter Cronkite School at Arizona State University. Previously, she worked as the editor of a data reporting team at The New York Times focused on long-term enterprise and investigative stories, and as a database editor for The Washington Post. Her awards include the Pulitzer Prize in Investigative Reporting, the Goldsmith Prize and the IRE medal. She is a past president of IRE and served on the IRE board for eight years.

#statistics

hands-on

Making graphics with R (repeat)

Saturday, 11:30 a.m. – 12:30 p.m. (1 hour) • Studio 8, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

Numbers tell stories. Charts and maps bring those stories alive. We’ll use R and some of its libraries to find and visualize stories in census data about New Orleans and Louisiana.

This class is best for: People who are comfortable with Excel and looking for something more powerful; beginner knowledge of R is good but not required.

Speaker

Ronald Campbell, NBC Owned Television Stations 👇

Ronald Campbell is data editor for NBC Owned Television Stations. He previously created the computer-assisted reporting program at the Orange County Register. He has won the IRE Award, the Loeb Award and placed in the Philip Meyer Award. He lives in Orange County, California, with his wife, kids and cat. When not getting frustrated with databases, he gets frustrated hiking.

On Twitter: @campbellronaldw

#data viz & design #r

panel

Art of the interview

Saturday, 11:30 a.m. – 12:30 p.m. (1 hour) • Galerie 2, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

Learn proven strategies for managing the investigative interview, with tips on preparation, approaching difficult subjects and keeping the conversation on track.

Speakers

Lauren McGaughy, The Dallas Morning News 👇

Lauren McGaughy is an investigative reporter for The Dallas Morning News capitol bureau in Austin, Texas. She has covered Texas politics and policy for six years, focusing on everything from education and gun laws to criminal justice and issues pertinent to the LGBTQ community. She previously worked for The Houston Chronicle and New Orleans Times-Picayune. She loves cats and comic books and cooks a mean steak.

On Twitter: @lmcgaughy

Tisha Thompson, ESPN 👇

Tisha is an investigative reporter at ESPN, appearing on Outside the Lines, E:60 and SportsCenter. A member of ESPN's 2019 Peabody Award-winning team for "Spartan Secrets,” she also won the 2019 national Gracie Award for Best Online Video Host for espnW’s "Being Believed: A Conversation with Sister Survivors," which also received the 2019 Gold Telly Award for Best Online Talk Show. She’s been a member of IRE/NICAR for more than 20 years.

Lee Zurik, WVUE-TV 👇

Lee Zurik is an Evening News Anchor and Chief Investigative Reporter at WVUE-TV in New Orleans and Director of Investigations at Gray Television and Investigate TV. Lee has been honored with many of journalism’s top awards, including the Peabody, the duPont and the IRE Medal. Before Hurricane Katrina, Lee was a sports anchor/reporter. He taught himself to be an investigative reporter by reading IRE resources (books and tipsheets) and attending IRE conferences.

#interviewing

panel

Finding data for local investigations

Saturday, 11:30 a.m. – 12:30 p.m. (1 hour) • Acadia, 3rd floor

💪 Skill level: General interest

SHOW MORE

Description

Local investigations present unique opportunities and challenges for journalists working with data. Local data is often thought of as sparse since smaller localities do not always have the resources necessary to document and open source their information. Similarly, small newsrooms don’t always have the bandwidth to sponsor long-term and expensive data-collection initiatives.

However, working with data at the local level also presents advantages. Local reporters have the opportunity to grow intimately familiar with the various types of information aggregated in their jurisdictions. Also working at a smaller scale can make a greater number of investigations possible.

This talk will shed light on how to find data for local investigations, and take advantage of the seemingly limited resource environment that local reporters draw from when seeking aggregate information for their stories.

Speakers

Tyler Dukes, WRAL News 👇

Tyler Dukes is an investigative reporter at WRAL News in Raleigh, North Carolina, where he specializes in data and public records. In 2017, he completed a fellowship at the Nieman Foundation for Journalism at Harvard University and currently teaches at Duke University's DeWitt Wallace Center for Media & Democracy. Prior to joining WRAL, he worked as managing editor for Duke University’s Reporters’ Lab, a project to reduce the costs of investigative journalism.

On Twitter: @mtdukes

Jenifer McKim, New England Center for Investigative Reporting 👇

Jenifer McKim is a senior investigative reporter at WGBH's New England Center for Investigative Reporting and a professor of journalism at Boston University. She is a multimedia reporter focusing on topics including child welfare, sex trafficking and criminal justice. Her radio and print stories have received multiple awards, including a 2019 Edward R. Murrow Award and a 2011 Casey Medal for Meritorious Journalism.

On Twitter: @jbmckim

Lylla Younes, ProPublica 👇

Lylla Younes is a news apps developer for ProPublica’s Local Reporting Network. She was previously a data reporter with New York Public Radio (WNYC) and Gothamist.

On Twitter: @lyllayounes

#story ideas

hands-on

CANCELED - Consolidate, shape, and re-use web data with Excel Power Query

Saturday, 11:30 a.m. – 12:30 p.m. (1 hour) • Studio 10, 2nd floor

🚫 Due to speaker cancellations, this session has been canceled.

💪 Skill level: Intermediate

SHOW MORE

There is extremely valuable data available to anyone on the web. However, it is often published in ways that make it laborious to use. During this hands-on training session we will consolidate historic women’s soccer data from the past 54 years.

We will be using a tool you most likely already have access to: Microsoft Excel and the Power Query functionality built into it. Power Query is Microsoft’s Data Connectivity and Data Preparation technology that lets you seamlessly access data stored in hundreds of sources and reshape it to fit your needs — all with an easy to use, engaging, no-code experience. This technology is also used in Power BI, so the skills you’ll learn will be applicable there.

This session is good for: Those who are familiar with spreadsheets.

#data wrangling #power bi

commons

Using the Public Accountability Project to boost your reporting

Saturday, 11:30 a.m. – 12:30 p.m. (1 hour) • Galerie 4, 2nd floor

SHOW MORE

Description

The Accountability Project from The Investigative Reporting Workshop lets you search more than half a billion records from federal, state and local government data. We'll give you a tour of the site, show you the latest features and send you home with data you can turn into stories.

Speakers

Jacob Fenton, PublicAccountability.org 👇

Jacob Fenton is the lead developer of The Investigative Reporting Workshop’s Public Accountability Project. He’s worked previously as editorial engineer at The Sunlight Foundation, as director of computer-assisted reporting at the Investigative Reporting Workshop and as a reporter and editor for newspapers in Pennsylvania and California. In 2015-16 he was a JSK Fellow at Stanford. He's based in Portland, Oregon.

Jennifer LaFleur, Investigative Reporting Workshop 👇

Jennifer LaFleur is the Investigative Reporting Workshop's data editor and teaches at American University. She previously was a senior editor at Reveal from The Center for Investigative Reporting, where she managed a team of data journalists, investigative reporters and fellows. She is the former data journalism director at ProPublica and has held similar roles at newspapers. She is a former IRE training director and serves on IRE's board.

hands-on

Excel: Advanced Pivot Tables (repeat)

Saturday, 11:30 a.m. – 12:30 p.m. (1 hour) • Studio 10, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

You've done a few pivot tables and are getting curious what more you could do with them. What happens if you aggregate by more than one column? What are those "column" and "filter" boxes for? Come unlock the full potential of pivot tables in this intermediate spreadsheet class.

This session is good for: People familiar with spreadsheets and aggregating data with pivot tables, or anyone who has taken Excel 1-3.

Speaker

Jessica Huseman, ProPublica 👇

Jessica Huseman is a reporter for ProPublica based in Austin, Texas. She is the lead reporter for Electionland, ProPublica's collaborative effort to cover ballot access. She is a data journalism instructor at Columbia Graduate School of Journalism.

#data analysis #excel

hands-on

Interactive data viz with D3

Saturday, 2:15 – 5:45 p.m. (3.5 hours) • Studio 9, 2nd floor

💪 Skill level: Intermediate

⚠️ This session requires pre-registration and an additional fee of $35 to reserve a seat.

SHOW MORE

Description

Bring your data to life with elegant and intelligent visualizations with the D3 JavaScript library. We'll start with some Scalable Vector Graphics (SVG) basics and learn what makes the D3 library so powerful, then use real-world datasets to build your first D3 chart. We will build on D3 basics by exploring more complex chart forms, covering functions for fetching and manipulating data, and introducing transitions and interaction. We will write working code together, break down how some of our favorite examples of D3 charts work and practice reading documentation so you can gain expertise on your own.

Preregistration is required and seating is limited. Laptops will be provided for the training.

Workshop prerequisites: Attendees should have some knowledge of HTML/CSS and JavaScript. Previous D3 experience is not required.

Speaker

Darla Cameron, Texas Tribune 👇

Darla Cameron is the data visuals editor at The Texas Tribune in Austin, where she leads a team of developers at the intersection of graphics and news applications. Previously, she was a graphics editor at The Washington Post. She began her career in Florida at the Tampa Bay Times after completing a fellowship at the Poynter Institute. Darla is a Colorado native with a degree in journalism from the University of Missouri.

#data viz & design #d3

master class

CANCELED - Master class: Interviewing

Saturday, 2:15 – 5:45 p.m. (3.5 hours) • Galerie 5, 2nd floor

🚫 Due to speaker cancellations, this session has been canceled.

💪 Skill level: General interest

⚠️ This session requires pre-registration and an additional fee of $35 to reserve a seat.

SHOW MORE

Learn how to master the interview to hold your sources accountable. This workshop will move from getting the interview, to conducting the interview, to capitalizing on the interview when it’s time to write.

This master class by investigative reporters Monica Rhor and Audra Burch is designed to teach you:

* how — and when — to land a tough interview
* how to prepare before an interview and also adapt on the spot
* the power of silence
* the power of sincerity
* interviewing people who have been hurt, and interviewing the people who hurt them

#writing & storytelling

panel

Research gumbo: Redux

Saturday, 2:15 – 3:15 p.m. (1 hour) • Galerie 6, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

Williams and Gray engineer a stew out of the latest in public records research and advanced search techniques.

Speakers

Barbara Gray, Craig Newmark Graduate School of Journalism, CUNY 👇

Barbara Gray is a research methods professor and oversees the research center at the Craig Newmark Graduate School of Journalism at City University New York. She is the former director of news research at The New York Times and a recognized expert on investigative research.

On Twitter: @BarbGray

Margot Williams, The Intercept 👇

Margot Williams is an investigative researcher at The Intercept. She has pursued jihadists online and detainees who died in U.S. immigration detention, investigated Iraq war contractors and followed the money (and private jets and yachts) of mayors, governors, senators, oligarchs, presidential candidates and ex-presidents at ICIJ, NPR, The New York Times and The Washington Post.

#research

hands-on

Excel: Importing data

Saturday, 2:15 – 3:15 p.m. (1 hour) • Studio 8, 2nd floor

💪 Skill level: Beginner

SHOW MORE

Description

Don't give up if your data isn't presented in a neat Excel file. This session will teach you how to clean and format data to get it into Excel. We will look at how to import text files and get a table on a web page into Excel.

This session is good for: Anyone comfortable working in Excel.

Speaker

Jeff Kelly Lowenstein, Grand Valley State University 👇

Jeff Kelly Lowenstein is an investigative journalist, author and assistant professor of journalism at Grand Valley State University. He is the founder of the Center for Collaborative Investigative Journalism, a nonprofit organization that brings together investigative journalists, photographers and data scientists to conduct international investigations. A Fulbright Scholar, specialist and teacher, he has written or edited six books.

On Twitter: @JeffKLO

#data wrangling #excel

hands-on

SQL 1: Exploring data (repeat)

Saturday, 2:15 – 3:15 p.m. (1 hour) • Studio 10, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Learning to manipulate data is a bit like learning a new language. Actually, it is a language, called Structured Query Language (SQL). This session is an introduction to using SQL to zero in on your data by viewing slices and chunks of it and putting it into a useful order so you can spot the stuff you need to get started toward a story. We'll use DB Browser for SQLite, a free database manager.

This session is good for: People with some experience working with data in columns and rows, in spreadsheets or database managers.

Speaker

Emmanuel Martinez, The Markup

#data analysis #sql

hands-on

R 1: Intro to R and RStudio (repeat)

Saturday, 2:15 – 3:15 p.m. (1 hour) • Studio 2, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Jump into statistics with R, the powerful open-source programming language. In this class we’ll cover R fundamentals and learn our way around the RStudio interface for using R.

This session is good for: People with a basic understanding of code who are ready to go beyond Excel.

Speaker

Ryan Thornburg, UNC-Chapel Hill

#data analysis #r

hands-on

Practical machine learning for investigations with fast.ai (Saturday afternoon)

Saturday, 2:15 – 5:45 p.m. (3.5 hours) • Studio 1, 2nd floor

💪 Skill level: Advanced

⚠️ This session requires pre-registration and an additional fee of $35 to reserve a seat.

SHOW MORE

Description

Get hands-on experience using this accessible, open-source Python library to classify images, text, and rows of data -- potentially saving you hours or days of work poring through the data. In the process, you'll also get a feel for the power -- and limits -- of machine learning.

This session with John Keefe and Jeremy Merrill of the Quartz investigations team will introduce you to the concept of machine learning and several practical uses for it in your newsroom.

Preregistration is required and seating is limited. You must bring your own laptop (no tablets) to this training.

Prerequisites: A Google (aka Gmail) account. Basic understanding of Python is recommended but not required.

Speakers

John Keefe, Quartz 👇

John Keefe is the investigations editor at Quartz. He also teaches classes on investigative reporting, product prototyping, and machine learning at the Craig Newmark Graduate School of Journalism at CUNY. Before joining Quartz, he was Senior Editor for Data News at public radio station WNYC. Keefe blogs at johnkeefe.net.

On Twitter: @jkeefe

Jeremy Merrill, Quartz 👇

Jeremy B. Merrill is a reporter with Quartz's investigations team, covering online political influence using computer-assisted reporting and artificial intelligence.

#machine learning #python

hands-on

Using csvkit to wrangle data without Excel

Saturday, 2:15 – 3:15 p.m. (1 hour) • Studio 6, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Ever had data too large to open in Excel? Or need to quickly join or merge datasets without the benefit of a database? We will show you how to harness the awesome power of csvkit to wrangle large datasets on the command line. It's easy to use, fast and powerful. It's a must in every data journalist's toolbox.

This session is good for: People who want a solution for working with multiple CSV files without having to open Excel or to join or merge files without a database.

Speaker

Christian McDonald, University of Texas at Austin 👇

Christian McDonald is an Assistant Professor of Practice at the University of Texas at Austin's School of Journalism, with a focus on data journalism and programming. His most recent professional position was data and online projects editor at the Austin American-Statesman. He also worked at the Atlanta Journal-Constitution and at Cox publications in suburban Phoenix and Longview, Texas.

On Twitter: @crit

#data wrangling #command line

demo

Tracking 2020 digital ads: Learn the secrets of new political ad databases

Saturday, 2:15 – 3:15 p.m. (1 hour) • Galerie 2, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

In summer 2018, Facebook, Google and Twitter created new political ad archives to help the public and the press track political ads on their platforms, bringing more transparency to the sponsors of digital ads. These databases and data sets are not widely known or widely utilized, but they can be used for stories about candidates and dark money groups. Here’s what you need to know about these new political ad databases.

Speakers

Laura Edelson, New York University 👇

Laura Edelson is a PhD Candidate in Computer Science at New York University’s Tandon School of Engineering. Laura studies online political communication and develops methods to identify inauthentic content and activity. Prior to her current time in academia, Laura was a software engineer for Palantir and Factset. During her time in industry, her work focused on applied machine learning and big data.

Erika Franklin Fowler, Wesleyan Media Project 👇

Erika Franklin Fowler is Associate Professor of Government at Wesleyan University, where she directs the Wesleyan Media Project, which tracks and analyzes political advertising in real-time during elections. Fowler specializes in large-scale analyses of political communication — local media and campaign advertising in particular — in electoral and health policy settings. She is also co-author of Political Advertising in the United States.

On Twitter: @efranklinfowler

Sheila Krumholz, Center for Responsive Politics 👇

Sheila Krumholz is executive director of the Center for Responsive Politics (CRP), a nonpartisan watchdog that tracks and reports on money in U.S. politics on its website, OpenSecrets.org. Ms. Krumholz has testified before Congress and the Federal Election Commission on issues related to government transparency and regularly provides commentary on money in politics and training on CRP’s data. She has a degree in international relations and political science from the University of Minnesota.

Nancy Watzman, Lynx LLC 👇

Nancy Watzman is an award-winning investigative journalist, researcher and strategist who works on the cusp of technology and journalism. Her career spans work with the Internet Archive, the Sunlight Foundation, the Center for Public Integrity, the Center for Responsive Politics and the Democracy Fund. In 2019, she served as director of the Colorado Media Project, and in 2018, as outreach editor for the Knight Commission on Trust, Media and Democracy.

#election & politics #election

panel

The life of a data story: Going from data to narrative

Saturday, 2:15 – 3:15 p.m. (1 hour) • Acadia, 3rd floor

💪 Skill level: General interest

SHOW MORE

Description

Learn tactics for writing the data-laden investigation — from using best cases to illuminate your findings to organizing story elements into a compelling narrative and not a starchy data-dump. We’ll walk through common problems, examples of well-crafted tops and best practices for structuring stories with emotional heft.

Speakers

Ariana Giorgi, The Dallas Morning News 👇

Ariana Giorgi is a Senior Computational Journalist at the Dallas Morning News, where she writes and contributes to stories involving data analysis.

On Twitter: @ArianaNGiorgi

Anita Hassan, NBC News Digital 👇

Anita Hassan joined NBC News Digital as a national reporter in 2019. Previously, she worked on the I-team at the Las Vegas Review Journal. Before moving to Las Vegas, Hassan was an investigative reporter for the Houston Chronicle, where her award-winning reporting highlighted a massive backlog of untested rape kits, county jail abuses and failures in the criminal justice system that allowed a serial rapist in to go free for a decade.

Brooke Williams, Boston University 👇

Brooke Williams is an investigative reporter who specializes in data journalism. Her work has contributed to a Pulitzer Prize for Investigative Reporting, a George Polk Award and a Gerald Loeb Award, among others. She is an associate professor of the practice of computational journalism at Boston University and writes for The Intercept. Her data-driven investigations have appeared in The New York Times, inewsource, the Center for Public Integrity and more.

On Twitter: @reporterbrooke

#writing & storytelling

commons

Being scrappy: Doing data journalism as a team of one

Saturday, 2:15 – 3:15 p.m. (1 hour) • Galerie 4, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

How can solo journalists pull off ambitious data projects without the resources of a newsroom team? In this session, two journalists dive into their data world to offer support and ideas for real stories you can turn, organizational tips, and how/where to dig in order to successfully produce impactful pieces.

Speakers

Samah Assad, CBS Chicago/WBBM 👇

Samah Assad, an investigative journalist and producer who has won Murrow and Emmy Awards, specializes in data analysis, FOIA and digital interactivity with CBS Chicago's investigative unit. She previously produced with the investigative unit at ABC in Cleveland and worked as a crime reporter with the Morning Journal in Ohio. Her reporting focuses on uncovering systemic failures, including police misconduct, government corruption, lack of transparency and waste of taxpayer money.

On Twitter: @SAssadNews

Carolyn Thompson, Independent journalist 👇

Carolyn Thompson is a Canadian freelance journalist based in Nairobi, Kenya. Her stories focus on displacement, human rights abuses and government corruption using tools such as public data, surveys and satellite imagery. She has reported for CBC, France 24, Al Jazeera, and The Washington Post, among others. She has also taught data journalism in Ghana, Kenya and Canada.

On Twitter: @caroethompson

#work better

demo

Finding the story in property records

Saturday, 2:15 – 3:15 p.m. (1 hour) • Bissonet, 3rd floor

💪 Skill level: General interest

SHOW MORE

Description

“Who owns what” is a classic reporting problem with a broad range of applications, whether you’re breaking news or during investigative work. In this workshop, we’d go over common types of property records that are likely kept by your local, county, and state governments—including corporation filings that are useful for peeking behind pesky LLCs. We’ll also point out a few common issues with this type of data (assessors and recorders usually don’t share data!), pose general solutions to them (both with and without knowledge of coding languages), and walk through a sample scraper.

Speaker

Haru Coryne, ProPublica Illinois 👇

Haru Coryne is a data reporter for ProPublica Illinois. He uses a combination of statistical methods, computer software and document-based research to find stories in large troves of information. A former real estate reporter covering Chicago, Miami and Los Angeles for The Real Deal, he is especially interested in housing and public finance.

#local government

panel

Career roundtable: Making big moves

Saturday, 2:15 – 3:15 p.m. (1 hour) • Galerie 3, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

Whether it's a new investigation, a new beat or a new job, the choices we make early on can set us on the path to success — or ruin. This panel of four reporters will offer practical tips on changing gears or media, source-development and finding the story others have missed.

Speakers

Caitlin Ostroff, The Wall Street Journal 👇

Caitlin Ostroff is a London-based reporter for The Wall Street Journal where she uses words, numbers and code to cover the world of finance. Previously, she was a data reporter at the Miami Herald, covering elections, gun violence and Mar-a-Lago. She’s a graduate of the University of Florida and co-director of @jourinternships’ online Media Mentors program. She’s happy to chat, so reach out at caitlin.ostroff@wsj.com.

On Twitter: @ceostroff

Brian Rosenthal, The New York Times 👇

Brian M. Rosenthal is a metro investigative reporter at the The New York Times. Previously, he covered government for The Houston Chronicle and The Seattle Times. He was part of the reporting team that won the 2015 Pulitzer Prize in breaking news. He also was a finalist for the 2017 Pulitzer Prize in public service for a series that exposed that Texas was denying special education services to thousands of kids with disabilities. He is a member of IRE's board of directors.

Brandon Stahl, KARE 11 👇

Brandon Stahl works as an investigative reporter and producer for KARE 11, the Minneapolis NBC affiliate. Prior to that, he worked in newspapers for more than a decade, including the Minneapolis Star Tribune, where his work resulted in dozens of reforms and changes in state laws. He, along with three other Star Tribune journalists, were named Pulitzer Prize finalists in 2019 for "Denied Justice," a series on botched rape investigations.

Cheryl W. Thompson, National Public Radio 👇

Cheryl W. Thompson is IRE board president and an investigative correspondent for NPR. Prior to joining NPR, she spent 22 years at The Washington Post. Her investigations include local political corruption, cops killed by guns, witnesses killed for cooperating with police, people who died after being Tasered by police and the unsolved murders of six black girls nearly 50 years ago. Her awards include a shared Pulitzer, an Emmy, IRE and two NABJ awards.

#career

hands-on

Excel tricks you've never used (repeat)

Saturday, 2:15 – 3:15 p.m. (1 hour) • Studio 4, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

Excel has so many tips, tricks and time-saving tools you might not know about, even if you're a whiz at CONCATENATE functions and PivotTables. You should pick up a few new tricks in this fast-paced and fun session.

This session is best for: Those with intermediate knowledge of spreadsheets.

Speaker

Denise Malan, IRE & NICAR 👇

Denise Malan is IRE's Deputy Executive Director, overseeing all training programs, event logistics and the IRE Resource Center. She was a newspaper journalist for more than a decade, covering government, education, politics, the environment and more. After several years at the Corpus Christi Caller-Times in Texas, she joined IRE in 2013 in a joint position with the Institute for Nonprofit News, helping newsrooms around the country use data in their reporting.

On Twitter: @DeniseMalan

#data analysis #excel

hands-on

Excel CARwash: Cleaning dirty data

Saturday, 3:30 – 4:30 p.m. (1 hour) • Studio 8, 2nd floor

💪 Skill level: Beginner

SHOW MORE

Description

Dirty data lurk everywhere. We'll walk through some integrity checks to help diagnose problems with your data and learn how to deal with some of the most common problems, including standardizing misspelled names.

This session is good for: People with some experience working with data in columns and rows, in spreadsheets or database managers.

Speaker

Jennifer Smith Richards, Chicago Tribune 👇

Jennifer Smith Richards has been a reporter at the Chicago Tribune since 2015. Jennifer has a specialty in data analysis and previously covered schools and education for more than a decade at newspapers in Huntington, West Virginia; Utica, New York; Savannah, Georgia; and Columbus, Ohio. Her work has touched on everything from sexual abuse in schools to police accountability to school choice.

On Twitter: @jsmithrichards

#data cleaning #excel

hands-on

SQL 2: Grouping and summing data (repeat)

Saturday, 3:30 – 4:30 p.m. (1 hour) • Studio 10, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

If you know how to write a basic SELECT statement in SQL but are looking to make calculations, then this is the session for you. Learn to count how many times certain records appear in a database, and sum totals across records. These skills can come in handy whether you're covering campaign finance or boating licenses. We'll use SQLite and DB Browser, a free database manager.

This session is good for: People who took “SQL 1: Exploring data” or are familiar with “SELECT” and “WHERE” statements in SQL.

Speaker

Pam Dempsey, Midwest Center for Investigative Reporting 👇

Pam Dempsey is the executive director of the Midwest Center for Investigative Reporting. She is an award-winning journalist who has done investigative reporting and editing on topics including agribusiness, migrant farm workers, health, housing and Native American government. Dempsey, who is an online, print and radio journalist, has developed community engagement programs and investigative reporting workshops.

On Twitter: @pamelagdempsey

#data analysis #sql

hands-on

R 2: Data analysis and plotting (repeat)

Saturday, 3:30 – 4:30 p.m. (1 hour) • Studio 2, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

We'll use the tidyverse packages dplyr and ggplot2, learning how to sort, filter, group, summarize, join, and visualize to identify trends in your data. If you want to combine SQL-like analysis and charting in a single pipeline, this session is for you.

This session is good for: People who have worked with data operations in SQL or Excel and would like to do the same in R.

Speaker

Meghan Hoyer, The Associated Press 👇

Meghan Hoyer is data editor at The Associated Press, where she analyzes data and helps disseminate national data sets to reporters across the country, guiding them to find local stories in the numbers. She previously worked at USA TODAY and The Virginian-Pilot.

On Twitter: @meghanhoyer

#data analysis #r

panel

Using data viz to explore data and find stories

Saturday, 3:30 – 4:30 p.m. (1 hour) • Galerie 3, 2nd floor

SHOW MORE

Description

Details coming soon!

Speakers

Stephanie Lamm, The Houston Chronicle 👇

Stephanie Lamm is a data journalist for the Houston Chronicle. She looks for stories in datasets and public records. She also creates interactive graphics for online stories. Stephanie previously worked for the Dallas Morning News and attended The University of North Carolina at Chapel Hill.

On Twitter: @stephanierlamm

CJ Sinner, The Star Tribune

#data viz & design

hands-on

How to build a live data-driven application that never crashes

Saturday, 3:30 – 4:30 p.m. (1 hour) • Studio 6, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

One of the hardest parts about building a live data-driven application is building one that both responds to new data quickly and doesn't crash under the load of traffic. In this session, you will learn how to build resilient services that make traffic no longer a concern.

This session is good for: People with experience deploying web applications.

Speaker

Tyler Fisher, News Catalyst 👇

Tyler Fisher is the deputy director of technology at News Catalyst. Previously, Tyler worked as a news apps developer at POLITICO and NPR.

On Twitter: @tylrfishr

#programming #javascript

panel

How to make data findings come to life on radio

Saturday, 3:30 – 4:30 p.m. (1 hour) • Galerie 6, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

It's always been tricky to make data findings come to life on radio. Radio producers appreciate the role of data in investigative findings, but often producers and data reporters have to come up with creative and innovative solutions. This session will take the audience through some successful award-winning examples and unpack the different kinds of datasets that can lend themselves to the different strategies whether it is programmatic data sonification, creative use of narration or using a live church choir.

Speakers

Robert Benincasa, National Public Radio 👇

Robert Benincasa does data-driven reporting for NPR's investigations team in Washington, D.C.. Recent work includes a series on how federal disaster aid favors the wealthy and a consumer investigation into diabetic alert dogs.

On Twitter: @robertbenincasa

Michael Corey, The Star Tribune 👇

A news developer at the Star Tribune in Minneapolis, Minnesota. Past lives at Reveal and the Des Moines Register. Analog/digital synthesizer. Current interests include mapping, science, history, data on the radio, police use of force and sexual abuse in the Catholic Church.

On Twitter: @mikejcorey

Jenifer McKim, New England Center for Investigative Reporting 👇

Jenifer McKim is a senior investigative reporter at WGBH's New England Center for Investigative Reporting and a professor of journalism at Boston University. She is a multimedia reporter focusing on topics including child welfare, sex trafficking and criminal justice. Her radio and print stories have received multiple awards, including a 2019 Edward R. Murrow Award and a 2011 Casey Medal for Meritorious Journalism.

On Twitter: @jbmckim

Sinduja Rangarajan, Mother Jones 👇

Sinduja Rangarajan is the senior data journalist at Mother Jones. She previously worked at Reveal from the Center for Investigative Reporting, where her series on the lack of diversity in Silicon Valley led to many tech giants publicly releasing their data. Her work has won several awards, including the National Edward Murrow Award in 2019. She wrangles and analyzes datasets to tell stories and finds innovative ways to report on issues by collaborating with academics.

#audio

panel

Digital security hygiene and threat modeling for journalists

Saturday, 3:30 – 4:30 p.m. (1 hour) • Bissonet, 3rd floor

💪 Skill level: Advanced

SHOW MORE

Description

Details coming soon!

Speakers

Kristen Kozinski, The New York Times 👇

Kristen manages the security education program at The New York Times. Before joining The Times, she worked as an application security engineer and helped build secure coding education at email marketing platform Mailchimp. She is passionate about building accessible security education and resources for journalists around the world.

On Twitter: @dontclickonthat

Rowen S, Freedom of the Press Foundation 👇

Rowen is the newsroom services coordinator at Freedom of the Press Foundation, working with the SecureDrop and Digital Security teams. A former community organizer and software developer, Rowen combines privacy nerdery with the desire to make tech accessible and useful to those who need it. *Come find me at NICAR and ask me about secure tip-line workflows for newsrooms and freelancers, digital security, or how I learned to stop killing all of my houseplants.*

Mike Tigas, ProPublica 👇

Mike is a hacker-journalist at ProPublica, where he works on news applications, network infrastructure and digital security. Outside of ProPublica, he is a core contributor to the Tor Project working on censorship-circumventing mobile apps. He was an adjunct instructor at New York University’s Studio20 digital journalism program and was a 2013 Knight-Mozilla OpenNews Fellow.

On Twitter: @mtigas

#security

panel

Leading the data team, or how to get the best from your newsroom’s brightest people

Saturday, 3:30 – 4:30 p.m. (1 hour) • Galerie 2, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

This panel will discuss the non-technical side of data team management and share ideas for handling some of the thornier issues most teams face. How to work with other teams in the newsroom. Avoiding the dreaded “service desk” mentality. Creating a supportive environment for learning while also holding folks accountable for the work they do. How to manage team members who are more technically skilled than you are.

Speakers

Matt Dempsey, Houston Chronicle 👇

Matt Dempsey is the data editor at the Houston Chronicle. He has worked on projects involving wildfires, state pensions and the chemical industry. His passion for public records frequently leads to disclosure of data from all levels of government. His series "Chemical Breakdown" won the 2016 IRE Innovation award and the National Press Foundation’s “Feddie” award. His work was a key part of the Chronicle’s Pulitzer Prize finalist entry for Breaking News.

Emily Le Coz, GateHouse Media

#management

panel

How to squeeze court records to get the most juice

Saturday, 3:30 – 4:30 p.m. (1 hour) • Acadia, 3rd floor

💪 Skill level: General interest

SHOW MORE

Description

Whether you're on a beat, on an investigative team or at a research desk, court records are a resource you can't ignore. They are as valuable as they are difficult to access and analyze en masse. In this panel we'll talk about our myriad experiences getting these tricky troves to bear fruit for stories, as well as tips for finding and using them.

Speakers

Jaimi Dowdell, Reuters 👇

Jaimi Dowdell is a data journalist for Reuters. Previously she was a training director for Investigative Reporters & Editors and data editor for the St. Louis Post-Dispatch. jaimi.dowdell@tr.com

On Twitter: @JaimiDowdell

Elizabeth Lucas, Kaiser Health News 👇

Liz Lucas is the data editor at Kaiser Health News and a member of the investigative team. Previously she worked at Investigative Reporters & Editors as the NICAR Data Library director and trainer. She lives in St Louis.

On Twitter: @eklucas

Brett Murphy, USA TODAY 👇

Brett Murphy is a reporter on USA Today’s investigations desk. He’s also an adjunct journalism professor at George Washington University. Murphy co-founded Local Matters, a weekly newsletter curating the best local investigative reporting around the country. Murphy has won numerous journalism awards and was a 2018 Pulitzer finalist for his series on worker exploitation in the port trucking industry. He is based in Washington, D.C.

On Twitter: @brettmmurphy

#open records

commons

Census Reporting 2.0

Saturday, 3:30 – 4:30 p.m. (1 hour) • Galerie 4, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

With the decennial census approaching, the Census Reporter team is thinking again about making tools to help journalists use Census data. We want to hear from journalists of all experience levels about what they want to do with Census data, especially decennial and American Community Survey. We don’t have funding right now, but we’re hoping that you all can help us paint an irresistible picture of a system that could be built, and use it to help build the support we need to make it happen. This will be a structured session designed to capture “step,” “stretch,” and “leap” improvements to the experience of finding and making sense of Census data.

Speaker

Joe Germuska, Northwestern University Knight Lab 👇

Joe is the Chief Nerd at Knight Lab, Northwestern's cross-disciplinary media/technology/design studio. He's also the project lead for Census Reporter, a website designed to make Census data easier for journalists. Before Northwestern, Joe was a founding member of the Chicago Tribune News Applications team. He is also proud to serve on the board of directors for City Bureau, a nonprofit civic journalism lab based on the South side of Chicago.

On Twitter: @JoeGermuska

#census & demographics

hands-on

Finding the story: Campaign finance in SQL

Saturday, 3:30 – 4:30 p.m. (1 hour) • Studio 4, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Learn how to decipher federal campaign finance filings, how to find stories and how to navigate the limitations of the data.

This session is good for: People who are comfortable with SQL, but no specific campaign finance knowledge is required.

Speaker

Charles Minshew, IRE & NICAR 👇

Charles Minshew is the Director of Data Services for IRE & NICAR. He leads the Database Library, helps members with data analysis and is a trainer. An award-winning data journalist, he previously worked at the Orlando Sentinel and was on the Denver Post team that won the 2012 Pulitzer Prize for breaking news. A 2013 graduate of the University of Missouri School of Journalism and Georgia Southern University, Charles is a native of Rochelle, Ga.

On Twitter: @charlesminshew

#election & politics #sql

hands-on

Excel: Using string functions to manipulate data

Saturday, 4:45 – 5:45 p.m. (1 hour) • Studio 8, 2nd floor

💪 Skill level: Beginner

SHOW MORE

Description

Maybe you converted a PDF or imported a table into Excel -- or maybe an agency gave you a poorly formatted file. You can use string functions to reformat your data and get your spreadsheets working for you.

This session is good for: Anyone comfortable with using formulas in Excel.

Speaker

MaryJo Webster, The Star Tribune 👇

MaryJo has been data editor at The Star Tribune in Minneapolis for five years. Previously, she had stints with the St. Paul Pioneer Press, USA Today, Digital First Media and Investigative Reporters & Editors. She started her career as a reporter at small papers in Minnesota and Wisconsin.

On Twitter: @MaryJoWebster

#data cleaning #excel

hands-on

SQL 3: Joining tables (repeat)

Saturday, 4:45 – 5:45 p.m. (1 hour) • Studio 10, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Learn how to join tables, matching information from one file to another. We'll use SQLite and DB Browser, a free database manager.

This session is good for: People who are familiar with counting, summing or “GROUP BY” in SQL and want to add another tool to their SQL skill set.

Speaker

Janelle O’Dea, St. Louis Post-Dispatch 👇

Janelle is a data reporter focusing on housing and inequity for the St. Louis Post-Dispatch.

#data analysis #sql

hands-on

R 3: Gathering and cleaning data (repeat)

Saturday, 4:45 – 5:45 p.m. (1 hour) • Studio 2, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

Learn how to use R to scrape data from web pages, access APIs and transform the results into usable data. This session will also focus on how to clean and structure the data you've gathered in preparation for analysis using tidyverse packages.

This session is good for: People who have used R and have a basic understanding of how to retrieve data from APIs.

Speaker

Sean Mussenden, Howard Center for Investigative Journalism 👇

Sean Mussenden is the data editor for the Howard Center for Investigative Journalism, a reporting unit housed at the University of Maryland Philip Merrill College of Journalism. He is also a professor of data and computational journalism at the Merrill College.

On Twitter: @smussenden

#data cleaning #r

hands-on

Exploratory data viz: A tool for collaborative data reporting

Saturday, 4:45 – 5:45 p.m. (1 hour) • Studio 4, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

As data reporters, we can find that our skills are in demand across the newsroom, making it essential that we are able to collaborate effectively with more traditional beat reporters. We may find ourselves working with a non-data reporter who needs to be able to explore a large dataset herself, securely and on deadline. This workshop will present a selection of Python-based methods for producing exploratory visualizations at speed from medium- to large-sized and geographic datasets.

This session uses web-based tools such as Colaboratory and Vega Editor, and no coding experience is required (though Google and GitHub accounts are required to be able to follow the tutorial).

Speaker

David Blood, Financial Times 👇

David Blood is a data reporter and visual journalism developer at the Financial Times in London. His reporting for the FT includes data-driven investigations into financial irregularities, online misinformation and electoral fraud. His visual and interactive journalism has been honoured with awards from bodies including the Online News Association, the Society for News Design and the Malofiej Infographic World Summit.

On Twitter: @davidcblood

#data viz & design #python

panel

Work-life balance

Saturday, 4:45 – 5:45 p.m. (1 hour) • Acadia, 3rd floor

💪 Skill level: General interest

SHOW MORE

Description

Details coming soon!

Speakers

Rebecca Catalanello, Politifact

Steve Myers, USA TODAY 👇

Steve Myers is a national enterprise editor for investigations at USA TODAY. Before joining USA TODAY, he was a 2019 Nieman fellow. As an editor at The Lens, a nonprofit newsroom in New Orleans, he shaped editorial strategy and oversaw its investigative reporting. He was managing editor of Poynter Online, and before that, he spent 10 years reporting on environmental issues, criminal justice, clergy sex abuse and hurricane preparation and response.

#work better

commons

Using data in your reporting as a student

Saturday, 4:45 – 5:45 p.m. (1 hour) • Galerie 4, 2nd floor

💪 Skill level: Beginner

SHOW MORE

Description

Join a discussion to learn how you can use data in your reporting as a student journalist. Bring tips on how you reported with data in your newsroom and questions if you're looking to break into data journalism.

Speakers

Taylor Johnston, Ohio University 👇

Taylor Johnston is a senior at Ohio University majoring in journalism and visual communication. In order to balance both majors, Johnston keeps busy at The Post, OU's student-run independent newspaper, where she does a mixture of reporting, designing and developing. When not sifting through spreadsheets or inspecting the code of a webpage, Johnston is usually practicing calligraphy or reading a book.

On Twitter: @TF_Johnston

Yue Stella Yu, Independent journalist 👇

Stella received her Master's degree in journalism at the University of Missouri in December. As a student journalist, she worked as a local and state government reporter for the Columbia Missourian for two years. She produced data projects while interning at The Salt Lake Tribune and covered money-in-politics news for the Center for Responsive Politics last fall.

#education

panel

News automation is booming: How newsrooms are embracing automation

Saturday, 4:45 – 5:45 p.m. (1 hour) • Galerie 6, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

Join us to discuss how automation is changing newsrooms and journalism roles. Some newsrooms are vanguards for automating parts of news production, from information gathering and storytelling to data-driven tools that help journalists to do their jobs. Our panelists will share insights about how the industry has adopted automation techniques. Where are these tools heading next? What could other newsrooms learn from their experience? Also, what kind of new skills do journalists need when newsrooms embrace this kind of technology?

Speakers

Nicholas Diakopoulos, Northwestern University 👇

Nick Diakopoulos is a professor of communication studies and computer science at Northwestern University. He studies automation and algorithms as they impact news media including aspects of journalistic data mining, automated content production, news bots and algorithmic accountability. He is author of "Automating the News: How Algorithms are Rewriting the Media" from Harvard University Press, and co-editor of "Data-Driven Storytelling" from CRC Press.

On Twitter: @ndiakopoulos

Tiff Fehr, The New York Times 👇

Ms. Fehr is an assistant editor and lead developer at The New York Times. As a developer within the Times' newsroom, she specializes in software supporting breaking news and live coverage workflows, as well as programmatic approaches to analyzing massive source material collections.

Casey Miller, Los Angeles Times 👇

Casey is a data and visual journalist working on the data and graphics team at the Los Angeles Times. In the past, she has helped create visual and data driven graphics and narratives at Mapbox, Vox Media and The Wall Street Journal.

Brad Skillman, Bloomberg News 👇

Skillman is a senior editor at Bloomberg focused on breaking news and data journalism. He previously served as managing editor for news automation and helped found First Word, a real-time contextual breaking news service.

On Twitter: @bradqskillman

#writing & storytelling

demo

Using IRS nonprofit data and decoding 990s

Saturday, 4:45 – 5:45 p.m. (1 hour) • Bissonet, 3rd floor

💪 Skill level: Beginner

SHOW MORE

Description

Learn how to use nonprofit data from the IRS, including how to read a 990. This session will cover how to read key parts of the 990 for news and research purposes, how to use some of the IRS’ own data files to learn more about how nonprofits in your state rank (including the filing extracts file, which contains a wealth of information and many people don’t know about), and how to use Nonprofit Explorer’s new full-text search.

Speakers

Andrea Fuller, The Wall Street Journal 👇

Andrea Fuller is a reporter for The Wall Street Journal in New York City who specializes in data analysis. She uses spreadsheets, databases and computer code to find stories. Ms. Fuller joined the Journal in April 2014. She previously was a data journalist at Gannett Digital, The Center for Public Integrity, and The Chronicle of Higher Education.

Ken Schwencke, ProPublica 👇

Ken Schwencke is the editor of ProPublica's news applications team, which creates interactive databases and graphics. Ken has been with ProPublica since 2016, where he has worked on the award-winning Electionland project, ran Nonprofit Explorer and reported on LGBTQ issues and white supremacists. Previously, he worked on The New York Times’ interactive news team and the Los Angeles Times data desk.

On Twitter: @schwanksta

#nonprofits

demo

Collaborate tool

Saturday, 4:45 – 5:45 p.m. (1 hour) • Galerie 2, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

Learn about open-source tools for making data projects involving multiple teams or newsrooms easier. ProPublica's Collaborate tool can help organize, sort, assign, label and redact data sets, either within a newsroom or between organizations.

Speaker

Rachel Glickhouse, ProPublica 👇

Rachel Glickhouse is a journalist and the partner manager for ProPublica's large collaborative projects. She has taught engagement journalism at the Craig Newmark Graduate School of Journalism at City University New York and The New School. She previously worked at Univision, Medium and Americas Society/Council of the Americas, in addition to freelancing.

#tools

panel

Community-powered data collection: Enlisting your audience to help power investigations

Saturday, 4:45 – 5:45 p.m. (1 hour) • Galerie 3, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

This panel will walk through key considerations in doing “community-powered” data journalism, in which the public is enlisted to build tools, collect data, share records or dig through documents. We will look at large and small scale projects with big impact.

Speakers

Ally Levine, Reuters 👇

Ally Levine is a graphics reporter at Reuters, where she reports her own stories and collaborates with text reporters throughout the organization to produce visual stories. Previously, she worked as the data visualization fellow for ProPublica's Electionland during the 2018 Midterms and as a graphics intern at the Los Angeles Times.

Maya Miller, 👇

Miller is an engagement reporting fellow with ProPublica's Local Reporting Network.

On Twitter: @mayatmiller

Deborah Nelson, University of Maryland Philip Merrill College of Journalism 👇

Deborah Nelson is a Pulitzer Prize-winning journalist based at University of Maryland, home of the new Howard Center for Investigative Journalism. Recent student projects examined jail suicides with the Associated Press, urban heat islands with NPR and juvenile lifers with PBS NewsHour. Nelson co-authored a series for Reuters on military base housing that won top honors from the Society for Professional Journalists, National Press Club and the White House Correspondents Association last year. She previously worked at the Washington Post, the Los Angeles Times and the Seattle Times.

Krishnan Vasudevan, Philip Merrill College of Journalism, University of Maryland, College Park 👇

Krishnan Vasudevan is a critical scholar and filmmaker whose work examines within the intersections of media, cultural, journalism, and design studies. He employs filmmaking and ethnographic methods such as field research and collaboration to understand how and why members of different social groups such as journalists, taxi drivers and artists produce media.

#story ideas

hands-on

Geocoding using programming

Saturday, 4:45 – 5:45 p.m. (1 hour) • Studio 6, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Sometimes, you need more firepower than what you can get using online geocoding tools. This session will show you how to access a geocoding API to retrieve location data using the Python programming language.

This session is good for people whose geocoding needs have outgrown point-and-click tools and who have basic experience writing Python.

Speaker

Jonathan Soma, Columbia Journalism School 👇

Jonathan Soma is director of the Lede Program at Columbia Graduate School of Journalism, where he lectures on data analysis and interactive visualization. When Soma isn't boring his students to tears, he's probably rescuing cats, and he recently published a fancy website about machine learning in journalism at investigate.ai.

On Twitter: @dangerscarf

#mapping #python

special

Closing reception

Saturday, 6:30 – 7:30 p.m. (1 hour) • New Orleans Audubon Aquarium of the Americas

SHOW MORE

Description

Head to the New Orleans Audubon Aquarium of the Americas for a closing reception hosted by The Times-Picayune and The Advocate. Enjoy the aquarium while networking with fellow attendees. Light hors d’ oeuvres will be served, and each conference attendee will receive one drink ticket for a soft drink, beer, wine, call liquor or water.

Audubon Aquarium of the Americas is located at 1 Canal Street, New Orleans, approximately 0.4 miles from the New Orleans Marriott.

#aquarium

Sunday, March 8

hands-on

JavaScript 2: Hello D3! (repeat)

Sunday, 9 – 10 a.m. (1 hour) • Studio 3, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

We’ll cover the basics of getting started with D3, even if you’ve never used it before. Then we’ll take use some real data to create a few basic charts.

This session is good for: People with a basic grasp of JavaScript syntax.

Speaker

Ellis Simani, ProPublica 👇

Ellis Simani is a data reporter who was a Metpro fellow on the L.A. Times graphics desk before joining ProPublica. At the Times, he covered a variety of topics ranging from visualizing environmental issues along California’s coast to investigating the shortcomings of the Census Bureau’s racial categories. Prior to his work at the Times, Ellis interned with the Seattle Times News Apps team and participated in ProPublica’s Data Institute.

On Twitter: @emsimani

#data viz & design #javascript

hands-on

Stats 1: An introduction (repeat)

Sunday, 9 – 10 a.m. (1 hour) • Studio 2, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Statisticians need to really understand their data (and so do you!) before they begin running analyses. As a result, stats software like RStudio has many powerful tools to summarize your data. You're going to love them. We'll take a look at the structure of data in RStudio, do data transformations and run some basic statistical tests.

This session is good for: People who have familiarity with Excel and some database software. We've got a *lot* of ground to cover in this hour.

Speaker

Sara Stoudt, University of California Berkeley 👇

Sara is an applied statistician and aspiring data journalist. Her dissertation work covers both ecology applications and the teaching of statistics communication. She previously interned on the Data and Graphics team at the Los Angeles Times.

On Twitter: @sastoudt

#statistics #r

hands-on

Python 1: The fundamentals (repeat)

Sunday, 9 – 10 a.m. (1 hour) • Studio 6, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

An introduction to the Python programming language for absolute beginners. This session will cover the fundamentals and basic syntax to prepare you for more advanced classes.

This session is good for: People who are comfortable working with data in spreadsheets or database managers and want to make the leap to programming.

Speaker

Mindy McAdams, University of Florida 👇

Mindy McAdams is a professor at the University of Florida, where she teaches journalism, code and news applications. She holds the Knight Chair in Journalism Technologies and the Democratic Process. She has trained hundreds of journalists in digital skills and strategy in 19 countries, including Argentina, the Czech Republic, Laos, Singapore, South Africa and Vietnam. She was a journalist and copy editor at The Washington Post, Time magazine and other media organizations.

On Twitter: @macloo

#programming #python

hands-on

PDF 1: Using free online tools (repeat)

Sunday, 9 – 10 a.m. (1 hour) • Studio 7, 2nd floor

💪 Skill level: Beginner

SHOW MORE

Description

This class will cover basic approaches for getting text out of PDF documents using powerful and freely available tools. Participants will be introduced to basic concepts and walked through tackling common challenges encountered with tricky PDF documents.

This session is good for: People who are unfamiliar with PDF-to-text tools or would like to learn how these tools can be used for extracting difficult text from images embedded in a PDF document.

Speaker

Adelaide Chen, Orlando Sentinel 👇

Adelaide Chen is a data/multimedia specialist at the Orlando Sentinel, where she uses free third-party tools mixed with Python, Sequel Pro and Excel for data analysis and JavaScript for visualization. Former data editor at the Las Vegas Review-Journal. Journalism school graduate from UC Berkeley.

#pdfs

hands-on

CANCELED - Finding the story: Opioid data

Sunday, 9 – 10 a.m. (1 hour) • Studio 4, 2nd floor

🚫 Due to speaker cancellations, this session has been canceled.

💪 Skill level: Intermediate

SHOW MORE

As the opioid epidemic morphs in communities across the country, this session will help you identify data sources to cover opioid prescribing, hospitalizations, overdoses and treatment options, as well as strategies to cover an ever-changing problem.

This session is good for: Those with basic spreadsheet skills.

#health #excel

panel

TL;DR: What to remember when you forget everything else

Sunday, 9 – 10 a.m. (1 hour) • Galerie 2, 2nd floor

💪 Skill level: Beginner

SHOW MORE

Description

There is so much to take away from this conference and so many data tools available that it can be hard to remember just what to remember when you head home, especially if you're newer to the data world.

This session will be in everyone's favorite viral format: The listicle! You'll get these tips — and plenty more: The five most important SQL tips, five random (but helpful) Excel functions, and 10 ways to fact-check your analysis.

Speakers

Jamie Grey, InvestigateTV 👇

Jamie Grey is the executive producer of investigations for Gray Television and InvestigateTV, which produces stories for the company's stations in 93 television markets. She was previously a professor at the University of Missouri and an investigative and general assignment reporter in Iowa and Idaho. Jamie loves using data for journalism and life in general, tracking her Fantasy Football drafts and running and spinning miles.

On Twitter: @tvnewsjamie

Bracey Harris, The Hechinger Report 👇

Bracey Harris is a staff writer for The Hechinger Report. Prior to joining Hechinger, she covered politics and education for the Clarion Ledger, where she also focused on government accountability for the paper’s investigative and enterprise team. The Magnolia State native sometimes bumps into her old high school principal on reporting assignments.

On Twitter: @braceyharris

Tisha Thompson, ESPN 👇

Tisha is an investigative reporter at ESPN, appearing on Outside the Lines, E:60 and SportsCenter. A member of ESPN's 2019 Peabody Award-winning team for "Spartan Secrets,” she also won the 2019 national Gracie Award for Best Online Video Host for espnW’s "Being Believed: A Conversation with Sister Survivors," which also received the 2019 Gold Telly Award for Best Online Talk Show. She’s been a member of IRE/NICAR for more than 20 years.

#work better

special

Election 2020 hackathon

Sunday, 9 a.m. – 12:30 p.m. (3.5 hours) • Galerie 4, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

Details coming soon!

Speaker

Derek Willis, ProPublica 👇

Derek Willis is a news applications developer at ProPublica, focusing on politics and elections. He previously worked as a developer and reporter at The New York Times, a database editor at The Washington Post, and in roles at the Center for Public Integrity and Congressional Quarterly. He began his journalism career at The Palm Beach Post. He is a co-founder of OpenElections, a project to collect and publish election results from all 50 states.

#election & politics #election

master class

Master class: Getting ready to cover Census 2020

Sunday, 9 a.m. – 12:30 p.m. (3.5 hours) • Galerie 5, 2nd floor

💪 Skill level: Beginner

⚠️ This session requires pre-registration and an additional fee of $35 to reserve a seat.

SHOW MORE

Description

The 2020 census has already begun. In mid-March, it ramps up with a blizzard of millions of mailed invitations to respond. The data and story possibilities will follow almost immediately and continue through at least 2022. Are you ready? Especially if you have not covered a census, this workshop will prepare you to make a plan, gather the data, understand it and turn it into compelling stories.

D'Vera Cohn and Paul Overberg have each been writing about the census since 1990. Dee, who covered census topics for The Washington Post before working for Pew Research, led five Poynter Institute 2020 census workshops for journalists over the past year. Paul led IRE-sponsored census training workshops and panels since 2000, and covered demographics for USA Today and The Wall Street Journal for more than 25 years.

This three-hour workshop will include:

* What numbers are coming when?
* Census-speak: Concepts and definitions to unlock the data and avoid newbie errors
* Geography: Understanding the "where" to find stories from neighborhood to national
* Seven stories any newsroom can do
* Examples of great 2010 census stories
* How census numbers can be used on every beat
* Making a newsroom plan: How to pick your spots and get outside help too

Speakers

D’Vera Cohn, Pew Research Center 👇

D'Vera Cohn writes about demographics and immigration for Pew Research Center, where she has worked since 2007. Before that, she had a 21-year career as a Washington Post reporter covering the same topics. In the past year, she organized and taught five Poynter Institute journalism workshops about covering the 2020 census. The 2020 census will be the fourth she has written about.

On Twitter: @allthingscensus

Paul Overberg, Wall Street Journal 👇

Paul Overberg is a data reporter at The Wall Street Journal and a member of its investigative team. He focuses on economic and demographic stories but helps reporters working on many subjects. He previously worked at USA TODAY, where he worked on projects that won the Philip Meyer Award for Precision Journalism and the National Headliner Award.

#census & demographics

hands-on

Finding the story: Using natural language processing in social media research (repeat)

Sunday, 9 – 10 a.m. (1 hour) • Studio 9, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

Ever felt lost poring over a massive archive? Want to churn up interesting stories from social networks, chat archives, or forums with (relative) ease?

Why not try using a little natural language processing (NLP)!

This session will give you a taste of how to apply a blend of linguistics and AI to the text-based world of the internet. You will learn some basic NLP concepts, and how to apply them to online texts using the Python package Spacy. You'll be able to walk out of this session ready to start digging through data of your own.

This session is good for: People who are comfortable working in Python.

Speakers

Garance Burke, JSK Fellow at Stanford University 👇

Garance Burke is a national investigative reporter whose data-driven work has revealed vital truths in the public interest. She is a John S. Knight Journalism-Artificial Intelligence fellow at Stanford University, where she is researching algorithmic accountability while on leave from her position with The Associated Press. In 2019, her work was honored as a finalist for the Pulitzer Prize in National Reporting.

On Twitter: @garanceburke

Matt Kiefer, Stanford University 👇

Matt Kiefer is a John S. Knight Journalism Fellow at Stanford University, researching and prototyping automation tools to monitor civil and human rights. He's on leave from his job as data editor at the Chicago Reporter, a nonprofit newsroom that investigates inequality.

On Twitter: @matt_kiefer

#machine learning #python

special

Conference sales

Sunday, 9 – 10:30 a.m. (1.5 hours) • Studio Foyers, 2nd floor

⚠️ Conference sales will be open on multiple days.

SHOW MORE

Description

Stop by the NICAR sales table located in Preservation Foyer on the 2nd floor to browse books from the IRE store, IRE merchandise and shirts with the winning design from the T-shirt contest.

panel

Storyboarding and perfecting your pitch

Sunday, 9 – 10 a.m. (1 hour) • Galerie 3, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

What does it take to tackle a data-driven story while covering your beat? We'll talk about tools and strategies for managing your time, storyboarding your ideas, keeping up with data and documents, rolling quick-hit investigations and pitching story ideas to your editor.

Speakers

Patti DiVincenzo, IRE & NICAR 👇

Patti DiVincenzo is a training director at IRE. She spent more than three decades working in TV stations across the country, starting in Topeka, Kansas, and eventually landing at WSB-TV in Atlanta, where she was an investigative producer and data specialist for 16 years. A longtime member of IRE, she joined the staff in February 2019.

Sarah Hutchins, IRE & NICAR 👇

Sarah Hutchins is a training director for IRE & NICAR. She previously served as the organization’s editorial director, overseeing IRE’s publications and online platforms. Sarah has worked for daily newspapers in several states. Before joining IRE in 2014, she was a reporter at The Virginian-Pilot. Sarah has a bachelor's degree in journalism from Indiana University and a master's degree in data science and analytics from the University of Missouri.

On Twitter: @sarhutch

#work better

hands-on

Google Sheets: Scraping without coding (second repeat)

Sunday, 9 – 10 a.m. (1 hour) • Studio 4, 2nd floor

💪 Skill level: Beginner

SHOW MORE

Description

Yes, you can scrape data without using code -- in fact, all you need is Google Sheets! We'll be using Excel-type formulas (don't worry if you don't know what those are, either) to make simple scrapers that automatically pull data into Google Sheets. It’s the best way to get around clunky websites and unhelpful PIOs!

This session is good for: Beginners who want to start using data for their stories.

Speaker

Samantha Sunne, Independent journalist 👇

Samantha Sunne is a freelance journalist based in New Orleans. She speaks at conferences, universities and newsrooms around the world, teaching digital tools and tech literacy for journalists. Her work has been published by the Washington Post, NPR and Reuters, and recommended by the Poynter Institute and the Harvard Shorenstein Center on Media, Politics and Public Policy.

On Twitter: @samanthasunne

#web scraping #google sheets

hands-on

CANCELED - JavaScript 3: Making a map in D3 (repeat)

Sunday, 10:15 – 11:15 a.m. (1 hour) • Studio 3, 2nd floor

🚫 Due to speaker cancellations, this session has been canceled.

💪 Skill level: Advanced

SHOW MORE

Learn how to create an easy D3 map by turning shapefiles into nice, reusable TopoJSON, then turning it into a map and connecting it to your data. You can then have these maps ready for future use by just switching out a few variables.

This session is good for: People who have a basic grasp of JavaScript syntax and have been exposed to the D3 library at some point.

#data viz & design #javascript

hands-on

Stats 2: Linear regression (repeat)

Sunday, 10:15 – 11:15 a.m. (1 hour) • Studio 2, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

Go beyond counting and sorting. Learn how (and when) to measure relationships, level playing fields and make predictions. This class will be taught in R.

This session is good for: People who took “Stats 1: An introduction” and want to know how to apply what they learned, or are comfortable with summary statistics and RStudio and new to stats. Familiarity with spreadsheets and database managers is recommended.

Speaker

Ryan McNeill, Reuters 👇

Ryan McNeill is the London-based deputy editor of the Reuters data journalism team. Most recently, his work showed how Burkina Faso’s increasing instability is putting thousands of gold mines in reach of jihadists, as well as how billions of dollars of gold are leaving Africa illegally through the United Arab Emirates. He has previously worked for The Dallas Morning News, the South Florida Sun-Sentinel and The Oklahoman. He is a graduate of Oklahoma State University.

#statistics #r

hands-on

Python 2: Intro to data analysis using Pandas (repeat)

Sunday, 10:15 – 11:15 a.m. (1 hour) • Studio 6, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

Imagine rolling Excel and MySQL into one tool that also allows you to track your code and share it. That’s Pandas in a nutshell. There’s a lot more you can do with it, of course, but this will be a good start. We’ll learn how to slice and dice our data and extract basic stats. Specifically, we’ll cover loading the data, filtering, sorting and grouping data.

This class is good for: People who are comfortable with Excel and are familiar with the basics of SQL and Python.

Speaker

Sandra Fish, Independent journalist 👇

Sandra Fish is a Colorado data journalist specializing in politics. She's done work for the Colorado Sun, Colorado Independent, OpenSecrets, ESPN, Colorado Public Radio and others. She also teaches data journalism at University of Colorado Boulder.

#data analysis #python

hands-on

Python: Let's scrape a website (repeat)

Sunday, 10:15 – 11:15 a.m. (1 hour) • Studio 9, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

This session will show you how to use the Python programming language to scrape data from websites.

This session is good for: People who already feel comfortable writing simple Python scripts and understand basic syntax (data types, if/else statements, for loops, etc.). Experience with HTML is a plus but not necessary.

Note: It would be useful to attend the demo session "How the internet works (so you can scrape the web!)" at 9 a.m. Thursday if you’re not familiar with the topic already.

Speaker

Matt Wynn, USA Today 👇

Matt Wynn is data reporter on USA Today's investigative team. His work has looked at copycat legislation, police and doctors who escape discipline and the medicalization of previously benign inconveniences. He is the former director of enterprise and investigations at Medpage Today and previously worked at the Omaha World-Herald.

#web scraping #python

panel

Turning your stack of documents into structured data

Sunday, 10:15 a.m. – 12:30 p.m. (2.25 hours) • Galerie 6, 2nd floor

💪 Skill level: Beginner

SHOW MORE

Description

By using public records from an actual investigation, we will teach people how to think through turning their reams and reams of paper records into structured data. We want reporters to read through the documents and actively think about what information they need, how they can structure the data, and how they would need to fact-check data entry. We want attendees to leave feeling ready and willing to do heavy-hitting data investigations in their own newsrooms.

Speakers

Will Craft, APM Reports 👇

Will Craft is the data reporter for APM Reports and the podcast In The Dark. He does numbers and web stuff for radio and podcasts. He is often typing stuff into a spreadsheet.

On Twitter: @craftworksxyz

Lisa Pickoff-White, KQED 👇

Lisa Pickoff-White is a data reporter at KQED, a public radio and TV station based in San Francisco. She previously worked at the Center for Investigative Reporting and other outlets. Her work has been honored with awards from the Online News Association, Investigative Reporters & Editors, the Society of Professional Journalists and SXSW Interactive. Feathered dinosaur and data enthusiast.

On Twitter: @pickoffwhite

#data wrangling

demo

Where'd I put that file?

Sunday, 10:15 – 11:15 a.m. (1 hour) • Galerie 2, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

You know you downloaded that data, but now that you need it for your story, where'd it go? Or did your source send it to you in an email? Oh well. Now it's time to send that feature to your editor, but you can't remember if it's my-great-story-thisone.doc or my great-story-final-final.doc.

Come hear about how to keep from feeling overwhelmed by disorganization when juggling multiple projects. We'll cover file naming and folder structures, apps that can help you manage files, and even some tips for organizing things like email and FOIA requests.

Speakers

Brent Jones, St. Louis Public Radio 👇

Brent Jones is the data visuals specialist at St. Louis Public Radio. Working with a newsroom of nearly 30 journalists, his job includes creating graphics for stories, stand-alone sites for projects and developing/discovering and training staff on newsroom tools. He previously worked at the St. Louis Beacon and is a graduate of Southern Illinois University's journalism school, where he also teaches a course in data journalism.

On Twitter: @brentajones

Sarah Rafique, KTRK-ABC 13 👇

Sarah Rafique is an investigative producer at KTRK, the ABC-owned station in Houston, Texas, where she focuses on data reporting, visualization and telling investigations through compelling narratives. She previously worked as an investigative reporter at KXAN in Austin. Before that, she was a print reporter covering Fort Hood and West Texas. She's been recognized statewide and nationally for investigative reporting, breaking news and features.

On Twitter: @SarahRafique

#work better

hands-on

PDF 2: Using OCR to extract data from PDFs (repeat)

Sunday, 10:15 – 11:15 a.m. (1 hour) • Studio 7, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

This class will cover basic approaches for getting text out of PDF documents using powerful and freely available tools. Participants will be introduced to basic concepts and walked-through tackling common challenges encountered with tricky PDF documents.

This session is good for: People who are unfamiliar with the PDF to text tools or would like to learn how optical character recognition (OCR) tools can be used for extracting difficult text from images embedded in PDF document.

Speaker

Geoff Hing, APM Reports 👇

Geoff is a data reporter with APM Reports whose reporting has focused on voting rights and policing. He is interested in emergent forms of journalism and multidisciplinary, collective practice.

#pdfs

hands-on

Advanced SQL: Update queries, sub-queries and more (repeat)

Sunday, 10:15 – 11:15 a.m. (1 hour) • Studio 4, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

If you feel comfortable with the Structured Query Language basics that IRE teaches in its bootcamps — SELECT, FROM, WHERE, GROUP BY — but are ready to see what else SQL can do, this session is for you. We will cover more advanced ways of manipulating and questioning data, such as UPDATE queries, joins, writing sub-queries and other neat tricks. We will use SQLite in the class.

This session will be most helpful if: You are comfortable with counting and summing in SQL.

Speaker

Troy Thibodeaux, The Associated Press 👇

Troy Thibodeaux leads the data journalism team at The Associated Press. The data team works with reporters and editors across AP, building software and analyzing and visualizing data to tell stories in word and pixel. They also manage the data sharing network, which has helped news organizations across the U.S. localize important data stories. He lives in New Orleans with his family and a new dog, and like most New Orleanians, he loves to talk about the place.

#data analysis #sql

demo

CANCELED - Accessing political ad data from the Facebook and Google ad libraries

Sunday, 10:15 – 11:15 a.m. (1 hour) • Galerie 3, 2nd floor

🚫 Due to speaker cancellations, this session has been canceled.

💪 Skill level: Advanced

SHOW MORE

Due to speaker cancelations, this session has been canceled.

Mozilla is releasing a data integration tool for those looking to better understand online political advertising in the upcoming U.S. elections. The tool pulls the political ad data available from the Facebook and Google ad libraries. This is the same tool that helped discover that paid political ads were disappearing in the Facebook Ad Library during the EU and UK elections. We plan to continue to improve this tool, and build more functionality by working directly with those who are using and relying on the tool.

#tools

hands-on

Scraping in R (repeat)

Sunday, 10:15 – 11:15 a.m. (1 hour) • Studio 3, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

Python has been considered the go-to for web-scraping for many, but did you know web scraping can be easy in R too? This session walks through how to scrape data from the web with R library Rvest. If you had trouble copying a table from a webpage and pasting it in an Excel spreadsheet, or if you want to access data and files buried behind hyperlinks without clicking each one of the links, this is the session for you.

This session would be the best for people who has basic knowledge of R but haven't scraped the web. Knowledge of HTML/CSS is helpful but not required.

Speaker

Charles Minshew, IRE & NICAR 👇

Charles Minshew is the Director of Data Services for IRE & NICAR. He leads the Database Library, helps members with data analysis and is a trainer. An award-winning data journalist, he previously worked at the Orlando Sentinel and was on the Denver Post team that won the 2012 Pulitzer Prize for breaking news. A 2013 graduate of the University of Missouri School of Journalism and Georgia Southern University, Charles is a native of Rochelle, Ga.

On Twitter: @charlesminshew

#web scraping #r

hands-on

SQL CARwash: Cleaning dirty data

Sunday, 11:30 a.m. – 12:30 p.m. (1 hour) • Studio 4, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

Spend enough time around databases and inevitably you’ll come across one that has an obnoxious number of variations on city names: New York City. New York. NYC. NY. And yes, even NY City. If you’re not sure how to handle that, this session is for you. We’ll cover how to deal with multiple spellings and misspellings, strange date formats and category codes, as well as a few other tricks and tips for using SQL to clean data.

This session will be most useful if: You are familiar with basic SQL statements.

Speaker

David Herzog, IRE & NICAR 👇

David Herzog is professor at the University of Missouri School of Journalism and serves as NICAR academic adviser. He's the author of "Data Literacy: A User’s Guide" (2015, SAGE Publications). He also helped launch the online M.S. in Data Science and Analytics program at the University of Missouri.

On Twitter: @davidherzog

#data cleaning #sql

hands-on

Python 3: Data cleaning and visualization (repeat)

Sunday, 11:30 a.m. – 12:30 p.m. (1 hour) • Studio 6, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

Now that you’ve got a handle on Pandas, it’s time to jump into some advanced topics. You know how to import a dataset, but what happens when you load the data and nothing looks right? We’ll walk through cleaning up a dirty dataset with Pandas. Then we’ll jump into the fun part: visualizing the data you’ve analyzed with Matplotlib.

This session is good for: People who can load and perform basic summary and grouping functions in Pandas.

Speaker

Michael Corey, The Star Tribune 👇

A news developer at the Star Tribune in Minneapolis, Minnesota. Past lives at Reveal and the Des Moines Register. Analog/digital synthesizer. Current interests include mapping, science, history, data on the radio, police use of force and sexual abuse in the Catholic Church.

On Twitter: @mikejcorey

#data cleaning #python

panel

How and why to Dockerize your project

Sunday, 11:30 a.m. – 12:30 p.m. (1 hour) • Galerie 3, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

Docker simplifies the development and deployment of projects by bundling application code with everything it needs to run, including languages, libraries, and services. In this panel, we’ll discuss the many ways in which Docker has made our programming lives easier. We’ll also share tips for getting started with Docker and tease more advanced applications. If you’ve ever struggled to maintain a legacy news app, manage a rogue software installation, or collaborate on projects with complex dependencies, this session is for you!

Speakers

Alexander Cohen, Independent journalist 👇

Cohen is a developer and reporter based in Washington, D.C. He's spent more than a decade investigating public and private interests for outlets including CNN, the Las Vegas Review-Journal, the Center for Public Integrity and Reuters.

On Twitter: @capitolmuckrakr

Pratheek Rebala, The Center for Public Integrity 👇

Pratheek is a news developer at the Center for Public Integrity. He previously worked on the graphics team at Time Magazine.

#work better #containers

hands-on

GitHub for journalists (repeat)

Sunday, 11:30 a.m. – 12:30 p.m. (1 hour) • Studio 3, 2nd floor

💪 Skill level: Intermediate

SHOW MORE

Description

We'll cover Github's basic features — repositories, commits, branches, pull requests and issues — using a recent data-driven story as a case study. The goal is for you to leave the class and be able to use GitHub on your own for your next story.

Please note: You will need to have created an account at GitHub.com prior to the class.

This session is good for: Journalists who want to collaborate on data analyses, back up their work and share their methodology with (nerdy) readers.

Speakers

Jeremy C.F. Lin, Bloomberg News 👇

Originally from Taiwan, Jeremy C.F. Lin is a graphics data journalist at Bloomberg News where he focuses on visual storytelling, charts and maps. Previously, he worked at POLITICO, the Washington Post, The New York Times and the Texas Tribune. He received his master’s degree from UC Berkeley Graduate School of Journalism. And no, he has never played in the NBA.

On Twitter: @Jeremy_CF_Lin

Allison McCartney, Bloomberg News 👇

Allison is a data journalist and graphics developer at Bloomberg News in New York. She specializes in creative data visualization and election graphics. Before she was at Bloomberg, she spent time at ProPublica, Stanford, The Center for Investigative Reporting and The PBS NewsHour.

On Twitter: @anmccartney

#work better #github

hands-on

Finding the story: Scripting your census analysis

Sunday, 11:30 a.m. – 12:30 p.m. (1 hour) • Studio 2, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

Writing a little code can speed up your census analysis and set you up for success down the line. Come to this hands-on workshop to explore some sample scripts written in Python that you can take home and tweak to answer your own reporting questions.

This session is good for people who are comfortable writing basic Python.

Speaker

Joe Germuska, Northwestern University Knight Lab 👇

Joe is the Chief Nerd at Knight Lab, Northwestern's cross-disciplinary media/technology/design studio. He's also the project lead for Census Reporter, a website designed to make Census data easier for journalists. Before Northwestern, Joe was a founding member of the Chicago Tribune News Applications team. He is also proud to serve on the board of directors for City Bureau, a nonprofit civic journalism lab based on the South side of Chicago.

On Twitter: @JoeGermuska

#census & demographics #python

hands-on

PDF 3: Batch pdf processing (repeat)

Sunday, 11:30 a.m. – 12:30 p.m. (1 hour) • Studio 7, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

Practice processing dozens of documents with open-source tools like the Python library pdfplumber. The class will discuss techniques for working with thousands or millions of documents, but the hands-on component will involve a smaller batch. The class will also discuss Optical Character Recognition, but see the PDF2 class for more hands-on examples of OCR.

This session is good for: People with some programming experience who are able to install third-party software.

Speaker

Jacob Fenton, PublicAccountability.org 👇

Jacob Fenton is the lead developer of The Investigative Reporting Workshop’s Public Accountability Project. He’s worked previously as editorial engineer at The Sunlight Foundation, as director of computer-assisted reporting at the Investigative Reporting Workshop and as a reporter and editor for newspapers in Pennsylvania and California. In 2015-16 he was a JSK Fellow at Stanford. He's based in Portland, Oregon.

#pdfs #python

hands-on

Mapping in Python

Sunday, 11:30 a.m. – 12:30 p.m. (1 hour) • Studio 9, 2nd floor

💪 Skill level: Advanced

SHOW MORE

Description

Learn how to use GeoPandas, a handy Python library that lets you do powerful geospatial analysis from the comfort of a Jupyter Notebook. We'll cover mapping, filtering and merging datasets, changing between projections and formatting publication-ready maps.

This session is good for: Those with intermediate to advanced knowledge of Python.

Speaker

Allan James Vestal, POLITICO 👇

Allan James Vestal is the senior news apps developer at POLITICO, where he focuses on reporting and systems development around the 2020 election. Vestal previously worked at the Milwaukee Journal Sentinel and The Dallas Morning News, where he and his reporting teammates conducted award-winning investigations into the nation’s newborn screening programs and the safety of Texas' natural gas pipelines.

On Twitter: @allanjvestal

#mapping #python

panel

🤓 Install party!

Sunday, 11:30 a.m. – 12:30 p.m. (1 hour) • Galerie 2, 2nd floor

💪 Skill level: General interest

SHOW MORE

Description

Need help installing that cool piece of software you learned about in another session? Bring your laptop and we'll help you get set up.

Speakers

Alexandra Kanik, Louisville Public Media 👇

Alexandra Kanik works for Louisville Public Media, the parent organization of Kentucky Center for Investigative Reporting and the Ohio Valley ReSource. She spends her days writing language-agnostic code, creating data visualizations and trying to understand newsroom analytics.

On Twitter: @act_rational

Charles Minshew, IRE & NICAR 👇

Charles Minshew is the Director of Data Services for IRE & NICAR. He leads the Database Library, helps members with data analysis and is a trainer. An award-winning data journalist, he previously worked at the Orlando Sentinel and was on the Denver Post team that won the 2012 Pulitzer Prize for breaking news. A 2013 graduate of the University of Missouri School of Journalism and Georgia Southern University, Charles is a native of Rochelle, Ga.

On Twitter: @charlesminshew

Cody Winchester, IRE & NICAR 👇

Cody is a training director at Investigative Reporters & Editors. Before joining IRE, he worked at newspapers in Texas, Nebraska and South Dakota.

#work better