# sessions

name: (Generally) painless collaboration with the greater newsroom
start_date_clean: 2019-03-09
start_time: 2019-03-09 15:30:00
end_time: 2019-03-09 16:30:00
session_title: (Generally) painless collaboration with the greater newsroom
clean_description:
Traditional reporters and editors often view the data team as a one-stop service desk, a group of unapproachable nerds who will shoot down all their ideas, or full-stack programmers who can magically visualize all the data bouncing around in their heads. In this panel, we’ll discuss ways to revamp your newsroom reputation, change perceptions of your team and open up the lines of communication with your colleagues. 

speakers_cleaned:
Ryann Grochowski Jones, ProPublica (moderator); Ariana Giorgi, The Dallas Morning News; Yan Wu, NJ Advance Media


name: 25th CAR: What a ride it's been!
start_date_clean: 2019-03-08
start_time: 2019-03-08 15:30:00
end_time: 2019-03-08 16:30:00
speakers_cleaned: Doug Haddix, IRE/NICAR; Shawn McIntosh, Atlanta Journal-Constitution
session_title: 25th CAR: What a ride it's been!
clean_description:
Buckle up for a fast-paced ride through 25 years of data journalism, told through the people who drove CAR into the mainstream of investigative reporting. You’ll hear about pivotal moments, bizarre twists and befuddled bureaucrats who didn’t know what hit them. Featuring special guests! Expected guest speakers include Crina Boros, Center for Investigative Journalism; Sarah Cohen, ASU Walter Cronkite School of Journalism; Steve Doig, ASU Walter Cronkite School of Journalism; Jaimi Dowdell, Reuters; Mark Horvit, University of Missouri; Brant Houston, University of Illinois; Clarence Jones, independent journalist; Jennifer LaFleur, Investigative Reporting Workshop; and James B. Steele, independent journalist. 


name: 50 databases to request right now
start_date_clean: 2019-03-09
start_time: 2019-03-09 14:15:00
end_time: 2019-03-09 15:15:00
speakers_cleaned: Mark Walker, The New York Times; Kate Martin, South Carolina Press
session_title: 50 databases to request right now
clean_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. 


name: A conversation with James B. Steele: Insights and lessons for data journalists
start_date_clean: 2019-03-09
start_time: 2019-03-09 10:15:00
end_time: 2019-03-09 11:15:00
session_title: A conversation with James B. Steele: Insights and lessons for data journalists
clean_description:
This special session features the wit and wisdom of James B. Steele, one of the nation's most accomplished investigative journalists and a data journalism pioneer. In 1972, Steele and reporting partner Donald L. Barlett in collaboration with Philip Meyer used a computer to analyze more than 1,000 cases of violent crime in Philadelphia for The Philadelphia Inquirer -- the largest CAR project of its time. Barlett and Steele worked together for more than 40 years on investigative stories that won two Pulitzer Prizes, two National Magazine Awards, six IRE Awards and a slew of other honors. Over the years, Steele also has produced investigative pieces for Time Inc., Vanity Fair, the Investigative Reporting Workshop and REVEAL from the Center for Investigative Reporting. Bring your own questions and participate in this special conversation, which will be moderated by Sarah Cohen, the Knight Chair in Journalism at the Walter Cronkite School of Journalism at Arizona State University. Cohen previously ran the data reporting team at The New York Times and worked as database editor at The Washington Post, where she shared in the Pulitzer Prize for Investigative Reporting, the IRE medal and other national awards. 

speakers_cleaned:
Sarah Cohen, ASU Cronkite School of Journalism (moderator); James B. Steele, independent journalist 


name: Adding a text editor to your CAR toolkit
start_date_clean: 2019-03-10
start_time: 2019-03-10 10:15:00
end_time: 2019-03-10 11:15:00
speakers_cleaned: Agustin Armendariz, The New York Times
session_title: Adding a text editor to your CAR toolkit
clean_description:
A good text editor is an essential tool for data journalists, allowing you to inspect and tidy data and seamlessly import into other programs (Excel, a database GUI, your CMS). Stop by this demo session for examples of how a text editor can round out your CAR toolkit. 


name: Advanced OpenRefine: Intro to GREL
start_date_clean: 2019-03-08
start_time: 2019-03-08 11:30:00
end_time: 2019-03-08 12:30:00
speakers_cleaned: Martin Magdinier, OpenRefine Foundation
session_title: Advanced OpenRefine: Intro to GREL
clean_description:
There is so much more to OpenRefine than the clustering and faceting feature. This session is a deep dive to GREL, OpenRefine expression language (the equivalent of Excel formulas). After a thorough introduction to GREL syntax, we will review the most common functions to explore and clean up your dataset. Functions covered in this session include replace, split, concatenate, string comparison, if, cell.cross (to join multiple projects together), and forEach. This session is good for: People who are familiar with OpenRefine or with at least some Excel experience. For an introduction to OpenRefine, check out the scheduled demo session. 


name: Advanced SQL: Working with dates, sub-queries and more
start_date_clean: 2019-03-08
start_time: 2019-03-08 10:15:00
end_time: 2019-03-08 11:15:00
speakers_cleaned: Jennifer Peebles, The Atlanta Constitution
session_title: Advanced SQL: Working with dates, sub-queries and more
clean_description:
If you feel comfortable with the Structured Query Language basics that IRE teaches in its boot camps — 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 date functions, 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. 


name: After a disaster: Long-term reporting on floods, fires and other emergencies
start_date_clean: 2019-03-07
start_time: 2019-03-07 14:15:00
end_time: 2019-03-07 15:15:00
session_title: After a disaster: Long-term reporting on floods, fires and other emergencies
clean_description:
We’ll talk about databases and documents you can use to cover natural and unnatural disasters before, during and after they occur, and strategies for identifying long-term issues after the initial incident. 

speakers_cleaned:
Lisa Song, ProPublica (moderator); Eric Sagara, Reveal from The Center for Investigative Reporting; Rebecca Hersher, NPR


name: Always appeal: Fighting public records battles
start_date_clean: 2019-03-09
start_time: 2019-03-09 16:45:00
end_time: 2019-03-09 17:45:00
speakers_cleaned: Jason Leopold, BuzzFeed News; Katie Townsend, Reporters Committee for Freedom of the Press
session_title: Always appeal: Fighting public records battles
clean_description:
Fighting for public records often involves lengthy and frustrating battles. But don't let that intimidate you -- always go through the appeals process available under state law or the federal Freedom of Information Act. Hear from reporter and "FOIA terrorist" Jason Leopold and experienced media attorney Katie Townsend how you can prepare for these battles and see them through to get what you want. 


name: America's dirtiest jobs? Meet America's dirtiest data
start_date_clean: 2019-03-09
start_time: 2019-03-09 10:15:00
end_time: 2019-03-09 11:15:00
speakers_cleaned: John Schoen, NBC Universal
session_title: America's dirtiest jobs? Meet America's dirtiest data
clean_description:
Journalists who have successfully cleaned up some exceptionally dirty data explain how they pulled it off. 


name: An introduction to data visualization with Tableau (Hosted by Tableau)
start_date_clean: 2019-03-07
start_time: 2019-03-07 09:00:00
end_time: 2019-03-07 10:00:00
speakers_cleaned: Florian Ramseger & Jonni Walker, Tableau Software
session_title: An introduction to data visualization with Tableau (Hosted by Tableau)
clean_description:
Skill level: Beginner. Participants will get an introduction to Tableau and the Tableau Public platform. In this hands-on session, we will use a simple data set to create an interactive visualization ready for publication. We will look at how to quickly create maps in Tableau and how to make the final chart responsive so it can be seen on different devices. Software, data files and laptops are provided for the duration of the class. In the course of the session we will create a free account on Tableau Public. 


name: Analyzing birth and death data: The wonders of CDC WONDER
start_date_clean: 2019-03-09
start_time: 2019-03-09 09:00:00
end_time: 2019-03-09 10:00:00
speakers_cleaned: Paul Overberg, The Wall Street Journal
session_title: Analyzing birth and death data: The wonders of CDC WONDER
clean_description:
From birth to death: CDC WONDER is indispensable if you're analyzing local, regional or national rates for cancer. Or suicide. Or premature birth. Or pedestrian traffic fatalities. Or fatal drug overdoses. It's a powerful front end to query tens of millions of birth and death certificates; the national cancer registry; and more. Bonus: A gentle introduction to age-adjusted rates. Bring your laptop to follow along. 


name: ArcGIS Online: Connect the where and the why with interactive demographic maps
start_date_clean: 2019-03-08
start_time: 2019-03-08 16:45:00
end_time: 2019-03-08 17:45:00
speakers_cleaned: Robby Deming, Esri; Christopher Vaillancourt, Esri
session_title: ArcGIS Online: Connect the where and the why with interactive demographic maps
clean_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. 


name: Archiving digital journalism
start_date_clean: 2019-03-07
start_time: 2019-03-07 09:00:00
end_time: 2019-03-07 10:00:00
session_title: Archiving digital journalism
clean_description:
Digital journalism is disappearing. Chances are, if you read a cool piece of interactive journalism on the web today, that same story won't be online in two years. How can we stop this erosion? How can you, as an individual journalist, make sure that your clips remain available online after you switch jobs? In this panel, journalists and librarians will explain how tools borrowed from libraries and from the field of reproducible scientific research can help ensure that we'll be able to read today's news on tomorrow's computers. We'll talk about ways to use the most popular online archiving site, the Internet Archive; we'll talk about simple strategies for saving visual journalism, and we'll give an update on an exciting new project to preserve news apps. 

speakers_cleaned:
Katherine Boss, New York University; Meredith Broussard, New York University (moderator); Ben Welsh, Los Angeles Times


name: Avant garde data viz
start_date_clean: 2019-03-07
start_time: 2019-03-07 11:30:00
end_time: 2019-03-07 12:30:00
speakers_cleaned: Scott Klein, ProPublica (moderator); Nonny de la Pena, Emblematic Group; Rachel Binx, Netflix
session_title: Avant garde data viz
clean_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. 


name: Become an instant expert
start_date_clean: 2019-03-07
start_time: 2019-03-07 14:15:00
end_time: 2019-03-07 15:15:00
speakers_cleaned: Dan Russell, Google
session_title: Become an instant expert
clean_description:
Are you looking for sources on social media, government websites, academic papers? What if you're looking for local Facebook pages about Donald Trump, but Trump's page himself keeps popping up? What if you're looking for government reports on Obamacare and you keep getting weird health blogs? What if you could filter all this out with a little website called Google dot com? We'll go over some of the lesser-known Google filters like "related:", "location:" and "-inurl:" 


name: Before you ever start your analysis
start_date_clean: 2019-03-07
start_time: 2019-03-07 10:15:00
end_time: 2019-03-07 11:15:00
speakers_cleaned: Jaimi Dowdell, Reuters; Rob Barry, Wall Street Journal; MaryJo Webster, Star Tribune (moderator)
session_title: Before you ever start your analysis
clean_description:
Don't just rush out and file that FOIA! Though requesting or finding data is often an early step in a data-driven story, not giving enough thought to what it is you're gathering can lead to weeks or months of delays, only to discover the data you get doesn’t fit your needs. We’ll show you why putting your reporting skills to work and planning your analysis before filing a public records request can pay off big time. We’ll give you a checklist of questions to ask and red flags to watch out for to ensure you get your story off to a good start. This session will be interactive and prizes will be awarded to some lucky attendees. 


name: Behind the story: Case Cleared
start_date_clean: 2019-03-09
start_time: 2019-03-09 15:30:00
end_time: 2019-03-09 16:30:00
session_title: Behind the story: Case Cleared
clean_description:
This panel takes a rare deep dive behind the scenes of "Case Cleared,” a year-long joint investigation from Newsy, Reveal from the Center for Investigative Reporting and ProPublica. Their work uncovered how dozens of police agencies in America are inflating clearance rates for rape by making many rape cases look as if they are solved when they are simply closed with no arrest. The team will share reporting methods you can apply to discover key sources that will bring data-heavy stories to life, transforming them into stories that drive impact, and talk about the special challenges of doing that on subjects as sensitive as rape. The team will also describe its continuing collection of rape prosecution data and how you can be a part of that ongoing work and access our data to check on your local police. 

speakers_cleaned:
Mark Fahey &  Mark Greenblatt, Scripps/Newsy; Nadia Hamdan, KUT; Emily Harris, Reveal, Sophie Chou, ProPublica


name: Being scrappy: Doing data journalism as a team of one
start_date_clean: 2019-03-09
start_time: 2019-03-09 10:15:00
end_time: 2019-03-09 11:15:00
speakers_cleaned: Taeler De Haes, KYTX CBS 19; Moiz Syed, The Intercept
session_title: Being scrappy: Doing data journalism as a team of one
clean_description:
In many small to medium-sized newsrooms, you could find yourself the only person doing data or interactive journalism. In this NICAR Commons session, we will share tips, tricks and strategies that will help get your data stories published as a team of one. We will also discuss suitable project types that a one-person or scrappy small team is much more efficient at getting done. 


name: Bring your investigative reporting to life using animation and illustrations
start_date_clean: 2019-03-08
start_time: 2019-03-08 15:30:00
end_time: 2019-03-08 16:30:00
session_title: Bring your investigative reporting to life using animation and illustrations
clean_description:
Got court transcripts of a particular riveting moment during a trial? Need readers to understand a wonky concept that’s hard to explain in writing? This panel will show you new ways animation and illustrations can bring important moments of your investigation that happened behind closed doors or inside a computer to life. You will learn how investigative journalists and animators have used illustrations of courtrooms, nursing homes, and prison cells to “re-create” and animate crucial moments in an investigation that no one had access to. We will share how animation works and what best practices producers have developed in their newsrooms, whether or not they had access to fancy software. We will also tackle ethical pitfalls that investigative journalists have faced using animations and cover how to get started producing your own explainer video a la Vox. 

speakers_cleaned:
Ranjani Chakraborty, Vox Media; Blake Nelson, NJ Advance Media;  Hilke Schellmann, New York University (moderator)  


name: Building a data library in your newsroom
start_date_clean: 2019-03-07
start_time: 2019-03-07 15:30:00
end_time: 2019-03-07 16:30:00
session_title: Building a data library in your newsroom
clean_description:
Stockpiling data helps your newsroom be ready for breaking news, mine data for tips, provides context for multiple stories, offers content for visualizations, and build data literacy among reporters, editors and producers. But there are crucial questions to ask before you build your data arsenal: What databases does your newsroom need? What databases will be used for more than one story, serve as a reference library and improve with annual updates? What technology should you use to house data and what tools would make it accessible across the newsroom? What metadata and documentation should be attached? 

speakers_cleaned:
Acton Gorton, Chicago Tribune (moderator); Brant Houston, University of Illinois; Meghan Hoyer, Associated Press 


name: Building and telling a bulletproof data story
start_date_clean: 2019-03-09
start_time: 2019-03-09 09:00:00
end_time: 2019-03-09 10:00:00
session_title: Building and telling a bulletproof data story
clean_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_cleaned:
Matt Dempsey, Houston Chronicle; Pam Dempsey, Midwest Center for Investigative Reporting; Andy Lehren, NBC News (moderator) 


name: Building your own database
start_date_clean: 2019-03-07
start_time: 2019-03-07 14:15:00
end_time: 2019-03-07 15:15:00
speakers_cleaned: Steven Rich, The Washington Post
session_title: Building your own database
clean_description:
In this hands-on session we'll turn some paper records into machine-readable data. Along the way we'll learn the best practices of structuring a data set and entering data, and we'll talk about pitfalls such as data types, unstandardized data and memo fields. **You must bring a laptop and have a Google account to participate in this session. This session is good for: Anyone familiar with the basics of spreadsheets and frustrated by paper records. 


name: Building your own database (repeat)
start_date_clean: 2019-03-08
start_time: 2019-03-08 16:45:00
end_time: 2019-03-08 17:45:00
speakers_cleaned: Matt Carroll, Northeastern University
session_title: Building your own database (repeat)
clean_description:
In this hands-on session, we'll turn some paper records into machine-readable data. Along the way, we'll learn the best practices of structuring a data set and entering data, and we'll talk about pitfalls such as data types, unstandardized data and memo fields. **You must bring a laptop and have a Google account to participate in this session. This session is good for: Anyone familiar with the basics of spreadsheets and frustrated by paper records. 


name: Calling bullshit: Data reasoning in a digital world
start_date_clean: 2019-03-07
start_time: 2019-03-07 11:30:00
end_time: 2019-03-07 12:30:00
speakers_cleaned: Jevin West, University of Washington
session_title: Calling bullshit: Data reasoning in a digital world
clean_description:
The internet and information ecosystem today is awash in bullshit: junk science, fake news, biased algorithms, predatory publishing and on and on. Jevin West, a professor at the University of Washington, co-created a course to help students with the life skill of calling BS when necessary. West will talk about one aspect of this course: statistical trickery. This session will touch on conditional probabilities, fallacies, biases and what to make of p-values. 


name: CAR Conference registration (Friday)
start_date_clean: 2019-03-08
start_time: 2019-03-08 08:00:00
end_time: 2019-03-08 17:00:00
clean_description:
CAR Conference registration will be located in Salon EF on the lobby level of the Newport Beach Marriott. 


name: CAR Conference sales (Friday)
start_date_clean: 2019-03-08
start_time: 2019-03-08 08:00:00
end_time: 2019-03-08 17:00:00
clean_description:
Stop by the CAR Conference sales table and browse our merchandise, including the IRE bookstore's most popular titles and shirts with the winning design from the T-shirt contest. 


name: CAR throwback
start_date_clean: 2019-03-08
start_time: 2019-03-08 14:15:00
end_time: 2019-03-08 15:15:00
session_title: CAR throwback
clean_description:
This year, we’re going way, way back. We’ll take you on a ride on the Information Superhighway 1990s style. We’ll tell you about the tools we used to work with records on a computer! Expect classic NICAR datasets, dated references and more lame jokes. Along with the history lesson, we will provide some of the same data tips that are vital to data journalism. 

speakers_cleaned:
Jennifer LaFleur, Investigative Reporting Workshop (moderator); Cheryl Phillips, Stanford University; Aron Pilhofer, Temple University


name: Career roundtable
start_date_clean: 2019-03-08
start_time: 2019-03-08 16:45:00
end_time: 2019-03-08 17:45:00
session_title: Career roundtable
clean_description:
Looking for advice on how to take the next step in your career? Get practical tips from panelists who will talk about their own experiences and discuss what employers are looking for. 

speakers_cleaned:
Michelle Minkoff, The Associated Press; Lee Zurik, WVUE-New Orleans (moderator); Alden Loury, WBEZ; Soo Oh, The Wall Street Journal; Coburn Dukehart, Wisconsin Center for Investigative Journalism


name: College sports finances: Where the money comes from and where the money goes
start_date_clean: 2019-03-09
start_time: 2019-03-09 14:15:00
end_time: 2019-03-09 15:15:00
speakers_cleaned: Scott Hirko, Knight Commission on Intercollegiate Athletics; Jodi Upton, Syracuse University
session_title: College sports finances: Where the money comes from and where the money goes
clean_description:
The playing field is about to change in college athletics. Lawsuits and other challenges are expected to fundamentally change the way college sports -- and especially football -- are financed and played. But how to cover the ongoing story? Who will end up as winners and who will lose out? This interactive session will provide attendees a hands-on opportunity (bring your laptop!) to use the Knight Commission’s NCAA Division I Athletic and Academic Spending Database to understand the financial landscape for Division I college sports, and the differences between well-resourced athletics programs and the ones that depend on school resources. Specific tools for reporters to compare financial statements and trends over time will be revealed for the first time at the 2019 CAR conference. These resources can help lead to enlightening and impactful stories about schools' athletics programs in your region. 


name: Command line on Macs
start_date_clean: 2019-03-09
start_time: 2019-03-09 09:00:00
end_time: 2019-03-09 10:00:00
speakers_cleaned: AJ Vicens, Mother Jones
session_title: Command line on Macs
clean_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. 


name: Connecting the dots with health data: The Implant Files case
start_date_clean: 2019-03-08
start_time: 2019-03-08 09:00:00
end_time: 2019-03-08 10:00:00
speakers_cleaned: Emilia Diaz Struck, Margot Williams, Karrie Kehoe, Andy Lehren and Emily Siegel
session_title: Connecting the dots with health data: The Implant Files case
clean_description:
The Implant Files investigation involved a global effort of more than 1,500 FOI requests to gather data on medical devices in different parts of the world. It was a collaboration that involved more than 250 journalists in 36 countries. As a result, ICIJ released the first International Medical Devices Database that facilitates the exploration of more than 75,000 recalls, safety alerts and field safety notices of medical devices and their connections with manufacturers. Join us to explore the possibilities this data collection has to offer and how to connect it with other health datasets to report on stories linked to the medical devices industry. 


name: Cops, docs, and traffic stops: Criminal justice reporting through data
start_date_clean: 2019-03-08
start_time: 2019-03-08 09:00:00
end_time: 2019-03-08 10:00:00
session_title: Cops, docs, and traffic stops: Criminal justice reporting through data
clean_description:
This panel explores the pathways of finding, capturing and using data to tell compelling and relevant criminal justice stories. The group will also share techniques for breaking through the thin blue line of secrecy, and how to avoid common pitfalls along the way. 

speakers_cleaned:
Alain Stephens, inewsource (moderator); Alysia Santo, The Marshall Project; Anita Hassan, Las Vegas Review Journal; Ben Poston, Los Angeles Times  


name: Covering immigration with data
start_date_clean: 2019-03-08
start_time: 2019-03-08 14:15:00
end_time: 2019-03-08 15:15:00
session_title: Covering immigration with data
clean_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_cleaned:
Nausheen Husain, The Chicago Tribune (moderator);  Ryan McNeill, Reuters; Christine Mehta, Syracuse University


name: Covering the 2020 Census
start_date_clean: 2019-03-07
start_time: 2019-03-07 14:15:00
end_time: 2019-03-07 15:15:00
session_title: Covering the 2020 Census
clean_description:
Census 2020 is less than a year away, and many different kinds of reporting will be required to adequately cover it. From lawsuits and policies to misinformation campaigns on social media, to the new changes to differential privacy rules around data release, a journalist working the census has a vast beat. Local outlets have a special responsibility to make sure their communities are informed of the impact of being adequately counted. This means stories that underscore the importance of a good count (for both political as well as economic reasons -- nearly $900 billion a year in federal funds will return to communities based on these counts), and make sure their vulnerable populations are being addressed. This panel discussion will cover the different aspects involved in adequately covering the 2020 Census, including both Census officials and journalists currently on the beat. 

speakers_cleaned:
Mark Hansen, Columbia Journalism School ; Hansi Lo Wang, NPR ; Jodi Upton, Syracuse University (moderator) Gerson Vasquez, The U.S. Census Bureau 


name: Creating inclusive, welcoming teams
start_date_clean: 2019-03-08
start_time: 2019-03-08 10:15:00
end_time: 2019-03-08 11:15:00
session_title: Creating inclusive, welcoming teams
clean_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_cleaned:
Peggy Bustamante, University of Southern California-Annenberg; Cheryl W. Thompson, NPR (moderator); Erika Owens, OpenNews


name: Creating your first satellite image
start_date_clean: 2019-03-10
start_time: 2019-03-10 11:30:00
end_time: 2019-03-10 12:30:00
speakers_cleaned: David Yanofsky, Quartz
session_title: Creating your first satellite image
clean_description:
In this hands-on training, we'll learn how to find, download, combine, and turn data captured by satellites into ready-for-publication images. We'll learn three ways to do this, one using entirely point and click tools, another using the command line, and a third using Google Earth Engine. This session is good for someone who has never worked with satellite imagery before or wants a refresher. 


name: Creative ways to teach difficult concepts
start_date_clean: 2019-03-09
start_time: 2019-03-09 16:45:00
end_time: 2019-03-09 17:45:00
speakers_cleaned: Jennifer LaFleur, Investigative Reporting Workshop yes); Jaimi Dowdell, Reuters
session_title: Creative ways to teach difficult concepts
clean_description:
Teaching data journalism in newsrooms and at universities has forced us to come up with creative techniques. We wrote The SQL Song to help one group of boot camp attendees understand the order of commands. In an attempt to help students fine-tune their programs, we did a game show called Query Cash. To make string functions make more sense, we’ve created silly, but useful performances. Bring your fun ideas and we can work out creative solutions together. 


name: csvkit
start_date_clean: 2019-03-09
start_time: 2019-03-09 11:30:00
end_time: 2019-03-09 12:30:00
speakers_cleaned: Leila Haddou, The Times of London
session_title: csvkit
clean_description:
Ever struggled with large data sets? 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. 


name: Cyberwar: Investigating hacking by advanced actors
start_date_clean: 2019-03-09
start_time: 2019-03-09 15:30:00
end_time: 2019-03-09 16:30:00
speakers_cleaned: Rob Barry, WSJ; Surya Mattu, The Markup
session_title: Cyberwar: Investigating hacking by advanced actors
clean_description:
How to investigate warfare’s newest front: the cyber realm. We'll walk you through getting more information about this secretive world, including tracking down information about who owns what on the internet, disentangling server logs, studying IP addresses and analyzing malware and emails and more in this session. We’ll also talk about some of the tactics advanced hackers have used in the past to penetrate sensitive networks--and how those efforts can provide clues in future attacks. 


name: D3 in a reactive world
start_date_clean: 2019-03-09
start_time: 2019-03-09 09:00:00
end_time: 2019-03-09 10:00:00
speakers_cleaned: Beatrice Jin & Jon McClure, POLITICO
session_title: D3 in a reactive world
clean_description:
In this session, we’ll introduce you to how we bridge the gap between visualization libraries like D3 and the latest component frameworks in JavaScript. We’ll show you how mixing the two can become a powerful way to build reusable chart components that will shortcut your dev time and extend the impact of your work. Students will get a reusable chart template they can take home. This session is good for: people with some background in D3. 


name: Data blitz
start_date_clean: 2019-03-08
start_time: 2019-03-08 11:30:00
end_time: 2019-03-08 12:30:00
speakers_cleaned: Jeremy Singer-Vine, Buzzfeed News
session_title: Data blitz
clean_description:
Like Lightning Talks, but for data. Five presenters will guide you through their favorite datasets. 


name: Data journalism educators resource swap
start_date_clean: 2019-03-07
start_time: 2019-03-07 11:30:00
end_time: 2019-03-07 12:30:00
speakers_cleaned: Mark Berkey-Gerard, Rowan University; Dana Chinn, University of Southern California
session_title: Data journalism educators resource swap
clean_description:
If you teach a data journalism course or want to, join this NICAR Commons conversation and idea exchange. Bring your best teaching resources and assignments to share with others. And come ready to contribute to the discussion. What aspects of your courses and curriculum have produced the best results? What knowledge and skills do students need to secure an entry-level data reporting job? What data stories can students cover and add to their portfolio? How can we help IRE & NICAR update teaching resources? Educators: Upload your sample assignments, syllabi and discussion ideas for NICAR 2019. 


name: Data visualization and storytelling with Flourish
start_date_clean: 2019-03-08
start_time: 2019-03-08 15:30:00
end_time: 2019-03-08 16:30:00
speakers_cleaned: Marco Tulio Pires
session_title: Data visualization and storytelling with Flourish
clean_description:
Learn how to use Flourish, a free, online tool to build custom visualizations from your spreadsheets, no coding required. Flourish grew out of Kiln, the award-winning data studio that has helped dozens of organizations to visualize and tell stories with data. **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. 


name: Digging into data for stories (cont'd-Saturday) *pre-registered attendees only
start_date_clean: 2019-03-09
start_time: 2019-03-09 14:15:00
end_time: 2019-03-09 17:45:00
speakers_cleaned: IRE & NICAR staff
session_title: Digging into data for stories: A crash course in Excel - Group B *pre-registered attendees only
clean_description:
This is a continuation of Digging into data for stories: A crash course from Friday, March 8 for pre-registered attendees of this class. 


name: Digging into data for stories (cont'd-Sunday) *pre-registered attendees only
start_date_clean: 2019-03-10
start_time: 2019-03-10 09:00:00
end_time: 2019-03-10 12:30:00
clean_description:
This is a continuation of Digging into data for stories: A crash course from Saturday, March 9 for pre-registered attendees of this class. 


name: Digging into data for stories: A crash course in Excel - *pre-registered attendees only
start_date_clean: 2019-03-08
start_time: 2019-03-08 14:15:00
end_time: 2019-03-08 17:45:00
speakers_cleaned: IRE & NICAR staff
session_title: Digging into data for stories: A crash course in Excel - Group A *pre-registered attendees only
clean_description:
Skill level: Beginner?? Get started with using data in your stories with IRE's original mini-boot camp. In this 9-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 PivotTables 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. Workshop times are Friday, March 8, 2:15 p.m. - 5:45 p.m.; Saturday, March 9, 2:15 p.m. - 5:45 p.m.; Sunday, March 10, 9:00 a.m. - 12:30 p.m. (Registration for this session reserves your seat for all days of this workshop and attendees are expected to attend all sessions to complete the workshop.) 


name: Digging into education data: From preschool to college
start_date_clean: 2019-03-07
start_time: 2019-03-07 10:15:00
end_time: 2019-03-07 11:15:00
session_title: Digging into education data: From preschool to college
clean_description:
State and federal governments hold treasure troves of education data that reporters and news nerds can dig into to find great stories. 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. Find out the pros and cons of reporting with federal College Scorecard data, which tells the story of tuition and student debt across the nation’s +7,000 colleges. And hear an overview of the other great data sources that are available for education stories. 

speakers_cleaned:
Annie Waldman, ProPublica; Francisco Vara-Otra, IRE/NICAR (moderator); Andrea Fuller, The Wall Street Journal 


name: Doxxing for good: Tracing your online footprint before hackers can
start_date_clean: 2019-03-07
start_time: 2019-03-07 15:30:00
end_time: 2019-03-07 16:30:00
speakers_cleaned: Neena Kapur & Kristen Kozinski, The New York Times
session_title: Doxxing for good: Tracing your online footprint before hackers can
clean_description:
In this demo Kristen Kozinski and Neena Kapur from The New York Times Information Security team will share their experience creating a doxxing education program in their newsroom. They’ll cover why doxxing is a threat to reporters, recommended tools and techniques for cleaning up your online footprint, and suggestions for implementing a doxxing program in your newsroom. 


name: Early career straight-talk: A Q&A on all things jobs and internships
start_date_clean: 2019-03-10
start_time: 2019-03-10 09:00:00
end_time: 2019-03-10 10:00:00
speakers_cleaned: Alex Duner, Axios; Brett Murphy, USA TODAY Network; Taeler De Haes, WEWS-Cleveland
session_title: Early career straight-talk: A Q&A on all things jobs and internships
clean_description:
Do you have questions on how to break into the field, get an internship, or land a job? Simple or impolite ones that you couldn’t ask a boss or hiring manager/editor? Questions about newsroom “culture” or how to network or interview for a job? Get honest advice and input from journalists who once had the same questions you have now. We’re trying to create an informal panel discussion — and encouraging people with hiring power not to attend. Come with your questions, or submit them in advance anonymously: bit.ly/2tl6gY8 


name: Easy machine learning for data journalists
start_date_clean: 2019-03-09
start_time: 2019-03-09 11:30:00
end_time: 2019-03-09 12:30:00
speakers_cleaned: Dale Markowitz, Google Cloud AI
session_title: Easy machine learning for data journalists
clean_description:
In newsrooms, machine learning has been used to identify secret spy planes, tag unreported hate crimes, track overfishing, and more. Google’s machine learning tools make it easy to build projects like this, no data science background required. This one hour talk will give an overview of these tools and show how they can be used for compelling, data-driven reporting. 


name: Excel 1: Getting started with spreadsheets
start_date_clean: 2019-03-07
start_time: 2019-03-07 09:00:00
end_time: 2019-03-07 10:00:00
speakers_cleaned: Stephanie Lamm, Dallas Morning News
session_title: Excel 1: Getting started with spreadsheets
clean_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. 


name: Excel 1: Getting started with spreadsheets (repeat)
start_date_clean: 2019-03-09
start_time: 2019-03-09 14:15:00
end_time: 2019-03-09 15:15:00
speakers_cleaned: Janelle O'Dea, St. Louis Post Dispatch
session_title: Excel 1: Getting started with spreadsheets (repeat)
clean_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, sort it, filter it and conduct simple calculations like sum, average and median. This session is good for: Data beginners. 


name: Excel 2: Formulas & sorting
start_date_clean: 2019-03-07
start_time: 2019-03-07 10:15:00
end_time: 2019-03-07 11:15:00
speakers_cleaned: Sean Mussenden, University of Maryland
session_title: Excel 2: Formulas & sorting
clean_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. 


name: Excel 3: Filtering & pivot tables
start_date_clean: 2019-03-07
start_time: 2019-03-07 11:30:00
end_time: 2019-03-07 12:30:00
speakers_cleaned: Crina Boros, independent journalist
session_title: Excel 3: Filtering & pivot tables
clean_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. 


name: Excel 3: Filtering & pivot tables (repeat)
start_date_clean: 2019-03-09
start_time: 2019-03-09 16:45:00
end_time: 2019-03-09 17:45:00
speakers_cleaned: Phillip Reese, The Sacramento Bee
session_title: Excel 3: Filtering & pivot tables (repeat)
clean_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. 


name: Excel CARwash: Cleaning dirty data
start_date_clean: 2019-03-08
start_time: 2019-03-08 15:30:00
end_time: 2019-03-08 16:30:00
speakers_cleaned: Jennifer Smith Richards, Chicago Tribune
session_title: Excel CARwash: Cleaning dirty data
clean_description:
Dirty data lurk everywhere: in text files, spreadsheets, databases and PDFs. We'll walk you through some examples of the most common types of dirty data, point out telltale signs of data illness and explain how you can whip data into shape using some simple tools and methods. This session is good for: People with some experience working with data in columns and rows, in spreadsheets or database managers. 


name: Excel for business & economics
start_date_clean: 2019-03-07
start_time: 2019-03-07 11:30:00
end_time: 2019-03-07 12:30:00
speakers_cleaned: Aaron Kessler, CNN
session_title: Excel for business & economics
clean_description:
Whether you just started using Excel or it's been your companion for years, chances are there's a lot it can do that you've never realized. We sometimes think of Excel as the stepping stone to database managers like Access or SQL Server, and overlook just how powerful its tools can be — especially if you're covering business and economics. Come find out why Excel is still so popular in the business world and we'll unlock some of its secrets. The people you're covering know these tricks — you should too. 


name: Excel: Advanced pivot tables
start_date_clean: 2019-03-08
start_time: 2019-03-08 09:00:00
end_time: 2019-03-08 10:00:00
speakers_cleaned: Kimbriell Kelly, The Washington Post
session_title: Excel: Advanced pivot tables
clean_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. 


name: Excel: Importing data
start_date_clean: 2019-03-07
start_time: 2019-03-07 16:45:00
end_time: 2019-03-07 17:45:00
speakers_cleaned: Manuel Villa, The Marshall Project
session_title: Excel: Importing data
clean_description:
Not all data comes in ready-to-use, elegant spreadsheets. This session will teach you how to import data from text files and website tables. We will look at how to clean and organize data that may not come in the friendliest format. This session is good for: Anyone comfortable with working in Excel. 


name: Excel: Using string functions to reformat data
start_date_clean: 2019-03-07
start_time: 2019-03-07 15:30:00
end_time: 2019-03-07 16:30:00
speakers_cleaned: Rachel Alexander, Salem Reporter
session_title: Excel: Using string functions to reformat data
clean_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. 


name: Exploring the tidyverse in R *pre-registered attendees only
start_date_clean: 2019-03-09
start_time: 2019-03-09 09:00:00
end_time: 2019-03-09 17:45:00
speakers_cleaned: Aaron Kessler, CNN; Olga Pierce, University of Nebraska-Lincoln; Andrew Tran, The Washington Post
session_title: Exploring the tidyverse in R *pre-registered attendees only
clean_description:
Skill level: Intermediate Learn how to use the tidyverse, a collection of R packages will help you make your data journalism more efficient, stronger and fun. Learn how to import, clean, analyze and plot data for your stories. If you've used packages like dplyr, tidyr, readr, ggplot2, tibble and purr, or would like to learn more about how these work together, this class is for you. 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. You should also be familiar with basic data analysis. 


name: Favorite code snippets: A responsibly sourced, artisanal list from the Lonely Coder's Club
start_date_clean: 2019-03-08
start_time: 2019-03-08 10:15:00
end_time: 2019-03-08 11:15:00
speakers_cleaned: Alexandra Kanik, Louisville Public Media (moderator); David Montgomery, The Atlantic CityLab
session_title: Favorite code snippets: A responsibly sourced, artisanal list from the Lonely Coder's Club
clean_description:
The Lonely Coder's Club, a Slack community of newsroom programmers without big teams, would like to present our favorite, most-used code snippets. We've translated these snippets to most common coding languages and commented the heck out them so you can plug and play with ease! During this session, a few Lonely Coders will go through our favorites on the list and how they help save us time on project after project. We’ll also share tips on how you can start writing your own reusable code, no matter how lonely a coder you are. 


name: Finding hidden stories in hidden communities
start_date_clean: 2019-03-08
start_time: 2019-03-08 11:30:00
end_time: 2019-03-08 12:30:00
speakers_cleaned: Nausheen Husain, Chicago Tribune (moderator); Youyou Zhou, Quartz; Anh Do, Los Angeles Times
session_title: Finding hidden stories in hidden communities
clean_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. 


name: Finding needles in haystacks with fuzzy matching
start_date_clean: 2019-03-09
start_time: 2019-03-09 14:15:00
end_time: 2019-03-09 15:15:00
speakers_cleaned: Max Harlow, Financial Times
session_title: Finding needles in haystacks with fuzzy matching
clean_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 anyone looking for a better way to identify individuals or companies of interest within dirty data. 


name: Finding the story: Covering class and poverty at the local level
start_date_clean: 2019-03-07
start_time: 2019-03-07 14:15:00
end_time: 2019-03-07 15:15:00
speakers_cleaned: Heather Bryant, Project Facet
session_title: Finding the story: Covering class and poverty at the local level
clean_description:
A discussion touching on the unseen aspects of covering class and poverty. This session will include an overview of key sources and documents and a guided exploration of data sets that can help you tell important but undercovered stories in your community. This session is good for: Everyone! 


name: Finding the story: Data-driven disaster coverage
start_date_clean: 2019-03-08
start_time: 2019-03-08 10:15:00
end_time: 2019-03-08 11:15:00
speakers_cleaned: Matt Stiles, Los Angeles Times
session_title: Finding the story: Data-driven disaster coverage
clean_description:
Natural disasters such as hurricanes, floods, wildfires and extreme temperature swings are causing historic damage. Together we’ll explore key data sets and learn how to use them to explain catastrophic events to audiences. This session is best for people who are already comfortable working with data in spreadsheets and have a basic familiarity with the capabilities of mapping tools such as QGIS or R. 


name: Finding the story: Open policing data
start_date_clean: 2019-03-07
start_time: 2019-03-07 09:00:00
end_time: 2019-03-07 10:00:00
session_title: Finding the story: Open policing data
clean_description:
Researchers at Stanford University have collected and examined the records from millions of local police stops in more than 50 cities. Using the programming language R, learn how to analyze this local policing data and find patterns for stories. This session is good for: People who have worked with data (or R) and want to learn how to analyze police data. 

speakers_cleaned:
Daniel Jenson, Stanford University; Cheryl Phillips, Stanford University; Amy Shoemaker, Stanford University


name: Finding the story: The state of immigration
start_date_clean: 2019-03-07
start_time: 2019-03-07 11:30:00
end_time: 2019-03-07 12:30:00
speakers_cleaned: Tim Henderson, Pew Stateline
session_title: Finding the story: The state of immigration
clean_description:
Accusations are flying in the immigration debate and you can be prepared to document the truth. How many are coming, where are they coming from and why? A hands-on look at how to use the data sources you need to follow the immigration debate nationally and in your town. This session is good for: those familiar with Excel. 


name: Finding the story: Using DNS search for investigative journalism
start_date_clean: 2019-03-08
start_time: 2019-03-08 14:15:00
end_time: 2019-03-08 15:15:00
speakers_cleaned: Paul Vixie, Farsight Security
session_title: Finding the story: Using DNS search for investigative journalism
clean_description:
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 investigations. DNSDB Scout is available for both Google Chrome and Mozilla Firefox. Dr. Paul Vixie, an internet pioneer who was inducted into the Internet Hall of Fame in 2014 for his work related to DNS, will provide a brief DNS primer before providing the journalists a hands-on opportunity, using DNSDB, to examine the online footprint of a well-known political network to uncover dozens of its affiliated organizations. **You must bring a laptop with Firefox and Google Chrome installed for this workshop. Logins will be provided to use DNSDB. Basic knowledge of the Domain Name System (DNS) is helpful, but not required. 


name: Finding your data story: Visual analytics best practices using Tableau (Hosted by Tableau)
start_date_clean: 2019-03-07
start_time: 2019-03-07 10:15:00
end_time: 2019-03-07 11:15:00
speakers_cleaned: Florian Ramseger & Jonni Walker, Tableau Software
session_title: Finding your data story: Visual analytics best practices using Tableau (Hosted by Tableau)
clean_description:
Skill level: Some experience working with data would be ideal. Participants will get a crash-course in the fundamentals of Tableau, working with a slightly more complex dataset than we did in the introduction course. We will discuss how the data is shaped and will use Tableau to find an interesting story in the data, before turning it into a publishable visualization. Depending on the time available and the appetite of participants, we can also dive deeper into maps, simple statistical tools, or design best practices. Software, data files and laptops are provided for the duration of the class. The session is designed to follow the session “An introduction to Data Visualization with Tableau” but can also be taken on its own. Participants are expected to create a free account on Tableau Public before or at the beginning of the session. 


name: First graphics app: Node.js in the newsroom **pre-registered attendees only
start_date_clean: 2019-03-09
start_time: 2019-03-09 09:00:00
end_time: 2019-03-09 17:45:00
clean_description:
Skill level: Intermediate Dana Amihere, Armand Emamdjomeh 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 and 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. 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. 


name: First Observable notebook: Prototyping with polish **pre-registered attendees only
start_date_clean: 2019-03-07
start_time: 2019-03-07 14:15:00
end_time: 2019-03-07 17:45:00
session_title: First Observable notebook: Prototyping with polish *pre-registered attendees only
clean_description:
Skill level: Advanced Sahil Chinoy, Iris Lee, 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_cleaned:
Sahil Chinoy, The New York Times; Iris Lee, Los Angeles Times; Ben Welsh, Los Angeles Times; Aaron Williams, The Washington Post 


name: First Python notebook: Data analysis on deadline *pre-registered attendees only
start_date_clean: 2019-03-08
start_time: 2019-03-08 09:00:00
end_time: 2019-03-08 17:45:00
session_title: First Python notebook: Data analysis on deadline *pre-registered attendees only
clean_description:
Skill level: Beginner/intermediate Ben Welsh, James Gordon and Cheryl Phillips teach data analysis with Python. Their 6-hour, hands-on tutorial will guide you through an investigation of money in politics. You will learn: 1) Just enough Python to execute an analysis with the powerful pandas data analysis library, one of the most popular open-source tools for working with large data files. 2) How to record, remix and republish your work using the Jupyter Notebook, a browser-based tool emerging as the standard for reproducible research in the sciences. 3) Most important of all, how these tools increase the speed and veracity of your journalism.?? Preregistration is required and seating is limited. Laptops will be provided for the training.?? Workshop 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 for this class. 

speakers_cleaned:
James Gordon, Reynolds Journalism Institute; Cheryl Phillips, Stanford University; Ben Welsh, Los Angeles Times 


name: Free, easy data viz
start_date_clean: 2019-03-08
start_time: 2019-03-08 15:30:00
end_time: 2019-03-08 16:30:00
speakers_cleaned: Jamie Grey, Raycom Media
session_title: Free, easy data viz
clean_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. 


name: Freelancers' roundtable
start_date_clean: 2019-03-08
start_time: 2019-03-08 14:15:00
end_time: 2019-03-08 15:15:00
speakers_cleaned: Sandra Fish, Samantha Sunne, Allison McCartney
session_title: Freelancers' roundtable
clean_description:
A freelancer has to juggle more than the average reporter - long lead time, high expectations, a wide variety of tasks and deadlines (or sometimes worse, no deadlines). Join the conversation and discuss how to know when you have a good enough story to pitch? How deep do you dive before you know you're getting paid? How do you build sources without a household name? A few freelance investigative reporters with experience in these areas will share their own tips and take questions from the audience - past, current and prospective freelancers welcome. 


name: From messy data to insightful story: Cleaning data using Tableau (Hosted by Tableau)
start_date_clean: 2019-03-07
start_time: 2019-03-07 11:30:00
end_time: 2019-03-07 12:30:00
speakers_cleaned: Florian Ramseger & Jonni Walker, Tableau Software
session_title: From messy data to insightful story: Cleaning data using Tableau (Hosted by Tableau)
clean_description:
Skill level: Some experience working with data and is necessary; knowledge of Tableau Desktop/Tableau Public would be ideal. Participants will get a crash-course in the fundamentals of Tableau Prep. We will work with a couple of messy real-world data sets. We will clean, shape, and merge our data in Tableau Prep with the aim of analyzing it in Tableau Desktop and finally publishing an interactive chart with Tableau Public. Software, data files and laptops are provided for the duration of the class. The session is designed to follow the sessions “An introduction to Data Visualization with Tableau” and “Finding your data story: Visual analytics best practices using Tableau” but can also be taken on its own by participants who have some experience in working with data. Participants are expected to create a free account on Tableau Public before or at the beginning of the session. 


name: Full-stack React
start_date_clean: 2019-03-09
start_time: 2019-03-09 10:15:00
end_time: 2019-03-09 11:15:00
speakers_cleaned: Tyler Fisher, POLITICO
session_title: Full-stack React
clean_description:
In this session, we'll walk through how to connect a database-driven backend to a modern, React-driven static website frontend. We'll use Django as our backend of choice for this class, but the principles will apply to any news developer building databases and wanting to connect them to a modern frontend infrastructure. You'll come away knowing how to build the best of both worlds: a backend robust enough to handle huge datasets, and a frontend performant enough to handle your wildest traffic dreams. This session is good for: People who are comfortable writing JavaScript and have experience in a backend language. 


name: Geocoding and avoiding pitfalls
start_date_clean: 2019-03-07
start_time: 2019-03-07 10:15:00
end_time: 2019-03-07 11:15:00
speakers_cleaned: Michael Corey, Reveal from the Center for Investigative Reporting
session_title: Geocoding and avoiding pitfalls
clean_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. 


name: GitHub for journalists
start_date_clean: 2019-03-07
start_time: 2019-03-07 16:45:00
end_time: 2019-03-07 17:45:00
speakers_cleaned: Brent Jones, St. Louis Public Radio
session_title: GitHub for journalists
clean_description:
We'll cover Github's basics 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. **You must bring a laptop to participate in this class. You will also need to create 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 


name: Google Sheets: Scraping without coding
start_date_clean: 2019-03-07
start_time: 2019-03-07 10:15:00
end_time: 2019-03-07 11:15:00
speakers_cleaned: Samantha Sunne, independent journalist
session_title: Google Sheets: Scraping without coding
clean_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! **You must bring a laptop and have a Google account to participate in this session. This session is good for: Beginners who want to start using data for their stories. 


name: Google Sheets: Scraping without coding (repeat)
start_date_clean: 2019-03-08
start_time: 2019-03-08 11:30:00
end_time: 2019-03-08 12:30:00
speakers_cleaned: Samantha Sunne, independent journalist
session_title: Google Sheets: Scraping without coding (repeat)
clean_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! **You must have a Google account for this session. This session is good for: Beginners who want to start using data for their stories. 


name: Graph databases 1: Building a database
start_date_clean: 2019-03-07
start_time: 2019-03-07 10:15:00
end_time: 2019-03-07 11:15:00
speakers_cleaned: William Lyon, Neo4j; Leila Haddou, The Times of London
session_title: Graph databases 1: Building a database
clean_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. 


name: Graph databases 2: Finding stories in data
start_date_clean: 2019-03-07
start_time: 2019-03-07 11:30:00
end_time: 2019-03-07 12:30:00
speakers_cleaned: William Lyon, Neo4j; Leila Haddou, The Times of London
session_title: Graph databases 2: Finding stories in data
clean_description:
Learn to analyze your newly built graph database using Cypher, Neo4j's query language. It is advisable to have completed part one to get the most out of this session, however, it is not strictly necessary. We will show how to find stories in the data by analyzing the combined datasets using the Cypher query language in Neo4j. We will also explore more advanced graph database concepts such as applying graph algorithms and graph visualization. This session is good for: Those who attended Graph databases 1, or those already familiar with Neo4j. 


name: Healthcare: Diagnose and treat a data dearth
start_date_clean: 2019-03-09
start_time: 2019-03-09 16:45:00
end_time: 2019-03-09 17:45:00
session_title: Healthcare: Diagnose and treat a data dearth
clean_description:
Learn to navigate healthcare's data minefield to challenge conventional wisdom, unleash hidden trends and expose industry lies. Our speakers found creative ways around bad or non-existent data to expose a global network of faulty medical devices, track the true danger of giving birth at home and show how private Medicaid contractors systematically deny treatments to boost profits. We'll explore the data and documents you'll need (and those you won't) for your next big investigation. 

speakers_cleaned:
J. David McSwane, The Dallas Morning News (moderator); Marina Walker Guevara, International Consortium of Investigative Journalists; Emily Le Coz, GateHouse Media


name: Hitchhiker's guide to APIs
start_date_clean: 2019-03-09
start_time: 2019-03-09 10:15:00
end_time: 2019-03-09 11:15:00
speakers_cleaned: Roberto Rocha, CBC News
session_title: Hitchhiker's guide to APIs
clean_description:
In this hands-on session, you will use Postman to interrogate a web API. We'll guide you through the process of constructing a magic URL that will tell you how Chicago’s violent crime in 2018 compares to other years. This session is good for: Beginners. If you’ve ever thought about what goes on in the location bar of your browser, have an eye for patterns, or want better ways to answer your reporting questions, you’ll have a blast. 


name: Holding algorithms accountable
start_date_clean: 2019-03-09
start_time: 2019-03-09 10:15:00
end_time: 2019-03-09 11:15:00
speakers_cleaned: Nicholas Diakopoulos, Northwestern University (moderator); Heather Krause, Orb Media
session_title: Holding algorithms accountable
clean_description:
Algorithms are increasingly used throughout the public and private sectors, making decisions that impact people’s lives in myriad ways. Algorithmic accountability reporting is an emerging set of methods for investigating how algorithms exert influence and power in society. In this session, we’ll detail concrete investigations in this domain and discuss strategies, methods and techniques for pursuing algorithmic accountability reporting. 


name: How and why to make your data analysis reproducible
start_date_clean: 2019-03-07
start_time: 2019-03-07 09:00:00
end_time: 2019-03-07 10:00:00
session_title: How and why to make your data analysis reproducible
clean_description:
You understand how you processed your data. Does your editor? Your reader? You, in six months? Without a replicable approach to extracting, transforming and loading data, we are often frustrated in our efforts to share or update our work. Join us for a panel discussion of reproducible data workflows. We’ll talk about why we use standardized processes for collecting, cleaning and analyzing data, and share practices that work for us. We’ll also discuss strategies for smart human intervention (i.e. reporting, logging and documentation) in automated workflows. 

speakers_cleaned:
Ryann Grochowski Jones, ProPublica ; Jeremy Singer-Vine, Buzzfeed News (moderator); Andrew Tran, Washington Post; Hannah Cushman, DataMade 


name: How data can inform one of the hottest topics across the country: Housing
start_date_clean: 2019-03-09
start_time: 2019-03-09 14:15:00
end_time: 2019-03-09 15:15:00
session_title: How data can inform one of the hottest topics across the country: Housing
clean_description:
How do local housing markets adapt when decimated by natural or man-made disasters? What’s the affordable housing strategy when Google comes to town? Want to unearth property tax inequities or fraud? This panel of experts will show you how to tackle the trends and complexities of the housing market, and how to make the most of ArcGIS, get help from Zillow Research and navigate property tax data. 

speakers_cleaned:
Matt Clark, Newsday; Lorie Hearn, inewsource (moderator); Jon Schleuss, Los Angeles Times; Aaron Terrazas, Zillow 


name: How it works: APIs
start_date_clean: 2019-03-07
start_time: 2019-03-07 16:45:00
end_time: 2019-03-07 17:45:00
speakers_cleaned: Jonathan Soma, Columbia Journalism School
session_title: How it works: APIs
clean_description:
What is an Application Programming Interface (API), and how are journalists using them to power newsroom projects? Come to this session to get an overview of how APIs work and some ideas for integrating them into your own data projects. This session is ideal for API beginners to attend before the hands-on class "A hitchhiker's guide to APIs." 


name: How it works: Artificial intelligence
start_date_clean: 2019-03-08
start_time: 2019-03-08 09:00:00
end_time: 2019-03-08 10:00:00
speakers_cleaned: Meredith Broussard, New York University
session_title: How it works: Artificial intelligence
clean_description:
Artificial intelligence is the hottest new frontier in computing — but what is AI, really? This session introduces you to the basics of AI, demystifying the fundamentals so you can understand what's real and what's still science fiction. We'll talk about the reasons you don't have to be afraid of killer robots, but you should worry about facial recognition and the ways that AI systems reinforce inequality. After the basics, we'll look at how AI can be used for investigative reporting. We'll answer questions like: how can you get started with AI for reporting? What can AI do for you in the newsroom, and what can't it do? What claims about AI should trigger your journalistic skepticism? This session is designed for people who have unanswered questions about AI, journalists who are curious about AI in the newsroom, and anyone who has wondered exactly why machine learning is such a big deal. 


name: How it works: Blockchain
start_date_clean: 2019-03-09
start_time: 2019-03-09 14:15:00
end_time: 2019-03-09 15:15:00
speakers_cleaned: Shane Shifflett, The Wall Street Journal
session_title: How it works: Blockchain
clean_description:
Learn what the blockchain is, the basic principles of a transaction and how money moves between wallets. We'll also suggest ways to analyze transactions for financial investigations and list some obvious obstacles. 


name: How it works: The internet (for journalists who want to scrape it)
start_date_clean: 2019-03-07
start_time: 2019-03-07 14:15:00
end_time: 2019-03-07 15:15:00
speakers_cleaned: Melissa Lewis, Reveal
session_title: How it works: The internet (for journalists who want to scrape it)
clean_description:
If you want to scrape a website, it helps to understand a little bit about how the internet works under the hood. In this session, we’ll talk a little bit about the internet works, how it differs from the web and how to examine source code and network traffic to target and scrape newsworthy information. There will be an optional component where you can run commands from your computer that help illustrate these points, but you’ll also just be able to follow the presentation. 


name: How it works: Version control for journalists (git/GitHub)
start_date_clean: 2019-03-07
start_time: 2019-03-07 14:15:00
end_time: 2019-03-07 15:15:00
speakers_cleaned: Dan Nguyen, independent journalist
session_title: How it works: Version control for journalists (git/GitHub)
clean_description:
Branching, forking, merging and cloning. Version control can be a complicated issue, but this session for beginners will show you how newsrooms are using this technology to solve real-world problems. This session is ideal to attend before the hands-on class in GitHub. 


name: How to build a collaborative investigation from scratch
start_date_clean: 2019-03-10
start_time: 2019-03-10 11:30:00
end_time: 2019-03-10 12:30:00
speakers_cleaned: Rachel Glickhouse, ProPublica
session_title: How to build a collaborative investigation from scratch
clean_description:
With projects like Documenting Hate and Electionland, ProPublica has developed large collaborations with other newsrooms by using a central database. And now you, too, can launch this type of database-focused project, even without a developer. Find out about free tools ProPublica is creating to make it possible to create a crowd-powered investigation and database, and learn tips and best practices from a new guide on recruiting and working with partners on collaborative investigations. We'll talk about ProPublica's approach to crowd-powered, collaborative investigations and soon-to-be-available free tools to allow any newsroom to set up this type of project. 


name: How to collaborate across multiple newsrooms to solve big problems
start_date_clean: 2019-03-09
start_time: 2019-03-09 16:45:00
end_time: 2019-03-09 17:45:00
session_title: How to collaborate across multiple newsrooms to solve big problems
clean_description:
There are fewer journalists and fewer outlets, but the problems aren't getting smaller. Learn how to build a successful collaboration that's more than just a single story. 

speakers_cleaned:
Heather Bryant, Project Facet; Matt Dempsey, The Houston Chronicle; Deborah Nelson, University of Maryland; Cheryl Phillips, Stanford University (moderator) 


name: How to follow the dark money in politics
start_date_clean: 2019-03-08
start_time: 2019-03-08 15:30:00
end_time: 2019-03-08 16:30:00
session_title: How to follow the dark money in politics
clean_description:
Nearly $1 billion has been spent by dark money groups since the U.S. Supreme Court's Citizens United decision in 2010. These opaque organizations generally aren't required to disclose their donors, but obscure public records can help you shine a light on their activities and their funders. OpenSecrets.org and MapLight.org have numerous resources available for reporters interested in following the dark money in politics, and Issue One recently published a database of nearly 1,200 transactions detailing contributions from more than 400 unique donors to the leading dark money groups — a database that is searchable online (bit.ly/DarkMoneyData) and on ProPublica's FEC Itemizer tool. As the 2020 election cycle ramps up, come learn tips from some of the top dark money sleuths in the country for scouring filings with the Federal Election Commission, Internal Revenue Service, Department of Labor, Congress, corporate websites and other sources. 

speakers_cleaned:
Michael Beckel, Issue One (moderator); Anna Massoglia, Center for Responsive Politics; Andrew Perez, MapLight


name: How to help your TV newsroom achieve a data journalism mindset
start_date_clean: 2019-03-07
start_time: 2019-03-07 14:15:00
end_time: 2019-03-07 15:15:00
speakers_cleaned: Taylor Mirfendereski & Jake Wittenberg, KING5
session_title: How to help your TV newsroom achieve a data journalism mindset
clean_description:
Data journalism is a staple in many print newsrooms and for most investigative teams. But TV newsrooms have historically shied away from telling stories with data because it's complex, time consuming and hard to explain in a visual and entertaining way. Here's the good news: It doesn't have to be so daunting! Our team at KING-TV teamed up with data experts at Microsoft to find visually-compelling ways to integrate data into the daily mix. We came up with a style that shines on all platforms. In this NICAR Commons session, we'll share key takeaways from our journey, swap practical tips for building a newsroom culture that embraces data storytelling, and we'll work together to remove roadblocks on your path to achieving the data journalism mindset. 


name: How to impress the boss & save democracy: Data stories you can turn in 30 days or less
start_date_clean: 2019-03-07
start_time: 2019-03-07 16:45:00
end_time: 2019-03-07 17:45:00
speakers_cleaned: Jill Riepenhoff, InvestigateTV; Holly Hacker, The Dallas Morning News
session_title: How to impress the boss & save democracy: Data stories you can turn in 30 days or less
clean_description:
Beginners to seasoned data journalists will learn about easy-to-find, easy-to-navigate datasets that lead to quick-turn watchdog stories. We’ll show examples across beats. You’ll leave this panel with a notebook full of story ideas that you can tackle as soon as you return to your newsroom. 


name: How to make data a routine part of your beat
start_date_clean: 2019-03-07
start_time: 2019-03-07 15:30:00
end_time: 2019-03-07 16:30:00
session_title: How to make data a routine part of your beat
clean_description:
Data-driven stories don’t have to be relegated to the enterprise stories that we spend a lot of time on. Pretty much every beat should have some data source(s) that you can be monitoring & requesting regularly, or there might be datasets you can build on your own, that help generate stories. We’ll also talk about how to scope out your beat to find data sources at the outset. 

speakers_cleaned:
Angela Caputo, APM Reports; John Harden, The Washington Post, Brandon Quester, inewsource (moderator) 


name: How to make your campaign finance dataset useful year-round
start_date_clean: 2019-03-09
start_time: 2019-03-09 09:00:00
end_time: 2019-03-09 10:00:00
session_title: How to make your campaign finance dataset useful year-round
clean_description:
Campaign finance data contains a wealth of data points about the local political power structure that can be used to monitor relationships, priorities and potential influences at any time of the year — not just during a campaign. Join us for a conversation about how we might meaningfully categorize and analyze political donor data in order to create a year-round backgrounding tool that reveals networks operating behind the scenes. We’ll compare and contrast the potential in this approach at the local, state and federal scale. 

speakers_cleaned:
AmyJo Brown, War Streets Media (moderator) ; Sandra Fish, independent journalist; Anu Narayanswamy, Washington Post  


name: How to make your data stories shine for different audiences
start_date_clean: 2019-03-08
start_time: 2019-03-08 10:15:00
end_time: 2019-03-08 11:15:00
speakers_cleaned: Patti DiVencenzo, WSB-TV (moderator); Dana Amihere, KPCC; Youyou Zhou, Quartz
session_title: How to make your data stories shine for different audiences
clean_description:
Learn how to turn your data into a compelling story, whether your audience is on their phone or laptop, listening to the radio, watching television or reading the newspaper. We’ll discuss the limits and advantages of different platforms as well as the considerations that go into planning and production for them. We’ll go over tips and tricks for creating data-driven stories that don’t overwhelm your audience with numbers and stats. We’ll review content’s role in driving story presentation decisions, whether you’re developing a custom project or using an out-of-the-box template. 


name: How to teach yourself code
start_date_clean: 2019-03-07
start_time: 2019-03-07 10:15:00
end_time: 2019-03-07 11:15:00
speakers_cleaned: Scott Pham, BuzzFeed News; CJ Sinner, Star Tribune
session_title: How to teach yourself code
clean_description:
You're a journalist with pretty much no coding experience who loves Excel and working with spreadsheets. You've attended IRE and NICAR for years and feel ready to make the leap but might be a little intimidated by code or have trouble finding the time to learn a new skill. Let's talk about the challenges to learning a programming language (whether Python, R, SQL or any other) and how to overcome them. Two self-taught coders will share their journeys and lessons they learned along the way. 


name: How to turn data into human stories
start_date_clean: 2019-03-09
start_time: 2019-03-09 11:30:00
end_time: 2019-03-09 12:30:00
session_title: How to turn data into human stories
clean_description:
Some reporters are afraid of losing people’s interest by using too many numbers in stories. But data can lead to great narratives, in addition to charts and findings. Our panel will show you how to turn data into compelling human stories that help drive a narrative, create tension and make people care. We will show you how even the most complicated data can be explored in ways that engage and surprise. 

speakers_cleaned:
Aaron Mendelson, Southern California Public Radio / KPCC (moderator); Brandon Stahl, Star Tribune ;  Sarah Ryley, The Trace  


name: How to verify that emails are authentic with DKIM and ARC
start_date_clean: 2019-03-08
start_time: 2019-03-08 15:30:00
end_time: 2019-03-08 16:30:00
speakers_cleaned: Jeremy Merrill, Quartz
session_title: How to verify that emails are authentic with DKIM and ARC
clean_description:
Suppose someone leaks you an email -- maybe it's an email they received from a public official that's noteworthy. Maybe it's from a hacker. How do you make sure it's not a fake? In this hands-on session, we'll guide you through that process. How do you get what you need from the source? What the heck is a DKIM header? How do you interpret the results of the verification process? What hiccups might you run into? Some basic familiarity with the command line will be helpful, but no coding knowledge or experience necessary. 


name: Inside the sausage factory: An inside look at government data making
start_date_clean: 2019-03-09
start_time: 2019-03-09 11:30:00
end_time: 2019-03-09 12:30:00
clean_description:
What lives behind the records request? This session will bring together experts in government data collection and use to discuss how governments collect, use and distribute data. Each of the panelists has extensive experience collecting and using data at either the local, state or federal level. With that, they will discuss why data is collected, how to track down data, what formats are used and other nuances of the governmental data making process. 


name: Install party
start_date_clean: 2019-03-10
start_time: 2019-03-10 09:00:00
end_time: 2019-03-10 10:00:00
speakers_cleaned: Caitlin Ostroff, McClatchy; Cody Winchester, IRE/NICAR; Matt Wynn, USA TODAY
session_title: Install party
clean_description:
Need help installing that cool piece of software you learned about in another session? Bring your laptops and we'll help you get set up. 


name: Interactive data viz with D3 **pre-registered attendees only
start_date_clean: 2019-03-09
start_time: 2019-03-09 14:15:00
end_time: 2019-03-09 17:45:00
clean_description:
Skill level: Intermediate Bring your data to life with elegant and intelligent visualizations with the D3 JavaScript library. We'll start with some JavaScript 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.js 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 and break down how some of our favorite examples of D3 charts work. Preregistration is required and seating is limited. Laptops will be provided for the training. Workshop prerequisites: You should have some knowledge of HTML/CSS and programming concepts. Previous JavaScript or D3 experience is not required. 


name: Interactive visualization for news readers' beliefs: Why and how
start_date_clean: 2019-03-08
start_time: 2019-03-08 10:15:00
end_time: 2019-03-08 11:15:00
speakers_cleaned: Jessica Hullman, Northwestern University & Yea-Seul Kim
session_title: Interactive visualization for news readers' beliefs: Why and how
clean_description:
Many data journalists perceive their goal to be presenting data as clearly as possible. But a single data set provides only a partial view on what's true. Readers' prior beliefs about a topic can — and should — influence what they conclude from new data. Visualizations can be used to gather and represent beliefs in ways that transform the reader's experience and your own journalistic design process. This talk will introduce you to techniques and theories for helping your readers understand, What do (and should I) believe? We'll demo a new tool that allows anyone to create a "You draw it" style visualization to elicit and visualize readers' predictions. 


name: Interviewing your data with SQL (cont'd Friday) **pre-registered attendees only
start_date_clean: 2019-03-08
start_time: 2019-03-08 09:00:00
end_time: 2019-03-08 12:30:00
clean_description:
his is a continuation of Interviewing your data with SQL from Thursday, March 7 for pre-registered attendees of this class. 


name: Interviewing your data with SQL **pre-registered attendees only
start_date_clean: 2019-03-07
start_time: 2019-03-07 14:15:00
end_time: 2019-03-07 17:45:00
speakers_cleaned: Liz Lucas, Kaiser Health News; Megan Luther, InvestigateTV
session_title: Interviewing your data with SQL *pre-registered attendees only
clean_description:
Skill level: Intermediate 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 Computer-Assisted Reporting 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. This class takes place on Thursday, March 7 from 2:15-5:45 p.m. and continues Friday, March 8, 9 a.m. - 12:30 p.m. (Registration for this session reserves your seat for both days of this workshop and attendees are expected to attend both sessions to complete the workshop.) 


name: Intro to OpenRefine
start_date_clean: 2019-03-08
start_time: 2019-03-08 09:00:00
end_time: 2019-03-08 10:00:00
speakers_cleaned: Martin Magdinier, OpenRefine Foundation
session_title: Intro to OpenRefine
clean_description:
OpenRefine is a free, open-source tool for working with messy data. This session will provide a comprehensive overview of OpenRefine features. We will showcase how you can use OpenRefine to Explore and make sense of a new data set Clean up dirty data (fix typos, join and split fields) Enrich your dataset from a third party API Use wikidata reconciliation service A lab session is scheduled separately for those interested in a hands-on experience. 


name: Intro to R (Friday) *pre-registered attendees only
start_date_clean: 2019-03-08
start_time: 2019-03-08 14:15:00
end_time: 2019-03-08 17:45:00
clean_description:
Skill level: Intermediate Charles Minshew, IRE/NICAR will introduce you to R, a free, powerful open-source programming language, that will add statistical heft to your reporting. By the end of this three-hour session, you will be able to take raw data, import it into R, and start your analysis. Topics will include basic data importing, working with directories, reading in data, installing packages, creating simple visualizations, and how to clean, explore and sort your data. 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. 


name: Intro to R (Thursday) *pre-registered attendees only
start_date_clean: 2019-03-07
start_time: 2019-03-07 14:15:00
end_time: 2019-03-07 17:45:00
clean_description:
Skill level: Intermediate Hannah Fresques and Sandhya Kambhampati of ProPublica, along with MaryJo Webster of the Minneapolis Star Tribune, will introduce you to R, a free, powerful open-source programming language, that will add statistical heft to your reporting. By the end of this three-hour session, you will be able to take raw data, import it into R, and start your analysis. Topics will include basic data importing, working with directories, reading in data, installing packages, creating simple visualizations, and how to clean, explore and sort your data. 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. 


name: Intro to web development
start_date_clean: 2019-03-07
start_time: 2019-03-07 16:45:00
end_time: 2019-03-07 17:45:00
speakers_cleaned: Melissa Lewis, The Oregonian/OregonLive.com
session_title: Intro to web development
clean_description:
If you've been trying to figure out what all the fuss is about HTML, CSS and JavaScript, this session is for you. This session will introduce you to the basics of web development, help you make sense of the jargon and answer your questions. At the end of the session, you will have built a simple web page using HTML, CSS and JavaScript. This session is good for: Beginners in web development. No coding experience required. 


name: Introducing Slidetrack: Visual annotation for your podcast
start_date_clean: 2019-03-09
start_time: 2019-03-09 15:30:00
end_time: 2019-03-09 16:30:00
speakers_cleaned: Daniel Lathrop
session_title: Introducing Slidetrack: Visual annotation for your podcast
clean_description:
Did you know that a third of podcast listening is done on a desktop or laptop computer? Wouldn't it be great to give those listeners access to your visualizations, searchable databases and DocumentCloud embeds? Now you can. SlideTrack is a new, open source project that allows you to annotate audio with documents, photos, graphics, text and embeds. Plus, it's so simple that even an editor can do it. 


name: Introducing The Public Accountability search project
start_date_clean: 2019-03-09
start_time: 2019-03-09 09:00:00
end_time: 2019-03-09 10:00:00
speakers_cleaned: Jacob Fenton
session_title: Introducing The Public Accountability search project
clean_description:
The Public Accountability Project is a new site to search hundreds of millions of rows of U.S. transparency data for people, addresses and companies. To date, we've indexed federal and state campaign finance, nonprofit grants and employees, 527s, and some personnel records and voter rolls from states that probably won't sue. We'll be demoing the site, and looking for input on what public data you think should be added next. 


name: Introduction to digital security
start_date_clean: 2019-03-09
start_time: 2019-03-09 10:15:00
end_time: 2019-03-09 11:15:00
speakers_cleaned: Harlo Holmes, Freedom of the Press Foundation
session_title: Introduction to digital security
clean_description:
This demo aims to teach journalists of any knowledge base how to identify their unique threat model and develop a security protocol — regarding secure communication, data storage, and browsing — accordingly. From addressing low-hanging fruit to mitigating sophisticated threats, the tools discussed in this session will introduce journalists to essential concepts in digital security and privacy. 


name: Introduction to VisiData
start_date_clean: 2019-03-09
start_time: 2019-03-09 10:15:00
end_time: 2019-03-09 11:15:00
speakers_cleaned: Jeremy Singer-Vine, BuzzFeed News
session_title: Introduction to VisiData
clean_description:
VisiData is a relatively new tool for quickly exploring datasets. It's fast, powerful and keyboard-driven. 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. 


name: Investigating nonprofits with data
start_date_clean: 2019-03-07
start_time: 2019-03-07 16:45:00
end_time: 2019-03-07 17:45:00
speakers_cleaned: Todd Wallack, The Boston Globe; Andrea Fuller, The Wall Street Journal
session_title: Investigating nonprofits with data
clean_description:
We'll show reporters at all levels how to work with nonprofit data. We'll walk you through spreadsheets and databases that contain information on how nonprofits are spending their money and give you tips for identifying red flags. We'll also talk about digitized 990 filings and how you or other programmers in your newsroom can parse the data and root out corruption. 


name: JavaScript 1: Fundamentals and syntax
start_date_clean: 2019-03-08
start_time: 2019-03-08 09:00:00
end_time: 2019-03-08 10:00:00
speakers_cleaned: Allison McCartney, Bloomberg
session_title: JavaScript 1: Fundamentals and syntax
clean_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 able to build fancy data visualizations and more. In this class, you will learn the basic fundamentals and syntax of the JavaScript programming language. No coding experience is necessary. This session is good for: Beginners who want to start building things for the web. 


name: JavaScript 1: Fundamentals and syntax (repeat)
start_date_clean: 2019-03-10
start_time: 2019-03-10 10:15:00
end_time: 2019-03-10 11:15:00
speakers_cleaned: Adelaide Chen, The Orlando Sentinel
session_title: JavaScript 1: Fundamentals and syntax (repeat)
clean_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 able to build fancy data visualizations and more. In this class, you will learn the basic fundamentals and syntax of the JavaScript programming language. No coding experience is necessary. This session is good for: Beginners who want to start building things for the web. 


name: JavaScript 2: Hello D3!
start_date_clean: 2019-03-08
start_time: 2019-03-08 10:15:00
end_time: 2019-03-08 11:15:00
speakers_cleaned: Ashlyn Still, Reuters
session_title: JavaScript 2: Hello D3!
clean_description:
We’ll cover the basics of getting started with D3, even if you’ve never used it before. Then we’ll take several real datasets and use them to create a few basic charts. This session is good for: People with a basic grasp of JavaScript syntax who are interested in building data visualizations for the web. 


name: JavaScript 3: Building a map in D3
start_date_clean: 2019-03-08
start_time: 2019-03-08 11:30:00
end_time: 2019-03-08 12:30:00
speakers_cleaned: Emily Merwin, The Atlanta Journal-Constitution
session_title: JavaScript 3: Building a map in D3
clean_description:
Learn how to create an easy D3 map by converting GIS data into nice, reusable TopoJSON, 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. 


name: Journalists of color in the newsroom meetup
start_date_clean: 2019-03-07
start_time: 2019-03-07 12:45:00
end_time: 2019-03-07 14:00:00
speakers_cleaned: Soo Oh, The Wall Street Journal; Disha Raychaudhuri, NJ Advance Media
session_title: Journalists of color in the newsroom meetup
clean_description:
Grab lunch and bring a brown bag for this networking and discussion session with other journalists of color. IRE & NICAR will provide drinks and dessert. 


name: Keeping your career lit while raising humans
start_date_clean: 2019-03-09
start_time: 2019-03-09 11:30:00
end_time: 2019-03-09 12:30:00
speakers_cleaned: Megan Luther, InvestigateTV
session_title: Keeping your career lit while raising humans
clean_description:
Come to this NICAR Commons session to discuss and share tips on how to keep your career on course after parental leave, childcare struggles and juggling the work-family balance. 


name: Learn from my fail: Data always sucks edition
start_date_clean: 2019-03-09
start_time: 2019-03-09 15:30:00
end_time: 2019-03-09 16:30:00
speakers_cleaned: Kristin Hussey, independent journalist; Matt Wynn, USA TODAY
session_title: Learn from my fail: Data always sucks edition
clean_description:
Gather round, friends, and we'll tell some personal stories of otherwise good reporting that failed because we lost sight of a cardinal truth: Data always sucks. 


name: Lessons learned from building a database with colleagues
start_date_clean: 2019-03-08
start_time: 2019-03-08 11:30:00
end_time: 2019-03-08 12:30:00
speakers_cleaned: Todd Wallack, The Boston Globe; MaryJo Webster, The Star Tribune (moderator); Dana Amihere, KPCC
session_title: Lessons learned from building a database with colleagues
clean_description:
Building your own database takes some effort. Doing it with a team of other people takes it up a few notches. Panelists will share best practices and some of the nitty-gritty details you need to know before you build your own database, plus the extra things you need to plan for when it’s a group effort. We’ll talk about software options, how you can have multiple people entering data at the same time, ensuring you end up with standardized data and other details you’ll be glad to know before you start your own project. 


name: Life after FactFinder
start_date_clean: 2019-03-09
start_time: 2019-03-09 16:45:00
end_time: 2019-03-09 17:45:00
session_title: Life after FactFinder
clean_description:
Love it or hate it, American FactFinder has been the go-to source for Census data since 2010. That will change in the coming months as the Census Bureau switches to its new site, data.census.gov. We’ll take you on a tour and show you some favorite tricks and secrets that we’ve discovered. We’ll also show you how to go deeper into Census data and learn the surprising ways real life affects the way it’s collected. 

speakers_cleaned:
Ronald Campbell, NBC Owned Television Stations; Angel Kastanis, The Associated Press; Tyson Weister, Census


name: Lightning Talks
start_date_clean: 2019-03-08
start_time: 2019-03-08 17:00:00
end_time: 2019-03-08 18:15:00
clean_description:
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. Here's the 2019 lineup: 1. How to write a data story in five minutes — Youyou Zhou 2. 5 ways to write racist code (with examples) —Alex Garcia 3. How to build a massive database that no one wants you to build — Disha Raychaudhuri 4. FOIA is my API — Matt Kiefer 5. 911, What’s Your Emergency: how insider knowledge of law enforcement has been an asset — Stacy Montemayor 6. How To Use Your Data Skills To Gain Financial Independence — Sean McMinn 7. My own worst enemy: Overcoming impostor syndrome* — Kate Martin 8. How to beat a serious case of the post-project blues — Christopher Baxter 9. Blindspotting: Covering communities you’re not a part of — Emmanuel Martinez 10. Save Student Newsrooms. How you can help the next generation of journalists — Caitlin Ostroff Lightning Talks is sponsored by the Knight Foundation. 


name: Machine learning and investigative reporting
start_date_clean: 2019-03-07
start_time: 2019-03-07 15:30:00
end_time: 2019-03-07 16:30:00
session_title: Machine learning and investigative reporting
clean_description:
Has your editor ever asked for a couple of examples? What if you could use machine learning to find some of those examples and investigate a real phenomenon? Join reporters who have used machine learning as a tool in investigative reporting. You’ll hear about how we used machine learning to find patients whose deaths were potentially linked to medical devices; tracked fake news and identified illegal ads on Facebook; investigated potential campaign finance fraud; and did financial muckraking in the tax records of a global financial corporation. We’ll answer important questions like: What is machine learning? What kind of stories could it help with? and What do you need to take into account to get started? 

speakers_cleaned:
Meredith Broussard, New York University (moderator); Emilia Diaz Struck, International Consortium of Investigative Journalists, Jeff Ernsthausen, ProPublica 


name: Making graphics and maps with R
start_date_clean: 2019-03-08
start_time: 2019-03-08 14:15:00
end_time: 2019-03-08 15:15:00
speakers_cleaned: Mary Ryan, University of California, Irvine
session_title: Making graphics and maps with R
clean_description:
Learn how to visualize data in R with this introductory graphics class. From scatter plots to bar charts to box plots, we'll cover the basics of what you need to get an idea of what your data is telling you using ggplot2 and base R. We will also cover labeling, faceting, legends, and some cosmetics (changing colors and line/dot patterns, and displaying multiple plots in one window). This session is good for: R beginners who want to know how to visualize data. 


name: Making the leap from Excel to R
start_date_clean: 2019-03-07
start_time: 2019-03-07 11:30:00
end_time: 2019-03-07 12:30:00
speakers_cleaned: MaryJo Webster, Star Tribune
session_title: Making the leap from Excel to R
clean_description:
R might sound intimidating because it’s a programming language, but you might be surprised to learn that the leap from Excel to R isn’t as big as you might think, thanks to the RStudio interface and lots of simple-to-use R packages. We’ll go through the pros and cons between the two software tools and give you tips on how to make the transition as smooth as possible, should you decide to go that route. This will be for those who are comfortable in Excel but have no experience with R and would just like to get a taste of it before diving into a hands-on class. 


name: Management: Leading the data reporting team
start_date_clean: 2019-03-09
start_time: 2019-03-09 09:00:00
end_time: 2019-03-09 10:00:00
speakers_cleaned: Helena Bengtsson, Sveriges TV; John Kelly, USA TODAY Network; Janet Roberts, Reuters (moderator)
session_title: Management: Leading the data reporting team
clean_description:
Managing a data team or data story presents challenges for any editor. This session takes an editor's point of view on the ins and outs of managing data journalism. Topics include helping 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; and planning the best data workflows for your newsroom. 


name: MapCamp: QGIS *pre-registered attendees only
start_date_clean: 2019-03-08
start_time: 2019-03-08 09:00:00
end_time: 2019-03-08 17:45:00
speakers_cleaned: David Herzog, IRE/NICAR; Jennifer LaFleur, Investigative Reporting Workshop
session_title: MapCamp: QGIS *pre-registered attendees only
clean_description:
Skill level: Intermediate ?Learn how to uncover interesting news stories by mapping data with geographic information system (GIS) software during our intensive mini-boot camp. Experienced journalists conduct this hands-on training using the latest version of QGIS, open source-software that runs on all platforms. We will look at noteworthy stories that have used mapping and show you how to uncover stories using census and other data. You’ll learn how to display data geographically; import and query data; and geocode to merge databases with addresses into maps. In addition, we'll 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: Participants should have basic knowledge in using relational database programs such as Microsoft Access, MySQL or SQLite. 


name: Mapping with R
start_date_clean: 2019-03-08
start_time: 2019-03-08 15:30:00
end_time: 2019-03-08 16:30:00
speakers_cleaned: Andrew Tran, The Washington Post
session_title: Mapping with R
clean_description:
Learn how to create beautiful static or interactive maps and conduct geospatial analyses all within R. We'll map with sf and leaflet packages. We'll write scripts to pull data and shapefiles through packages that utilize APIs from the Census. We'll transform and analyze data and turn your exploratory map viz into maps nearly pretty enough to publish. This session is good for: People who already have some familiarity with R, mapping, Census data, and using ggplot2. 


name: Master class: Design thinking for journalists **pre-registered attendees only
start_date_clean: 2019-03-08
start_time: 2019-03-08 14:15:00
end_time: 2019-03-08 17:45:00
speakers_cleaned: Lena Groeger, ProPublica; Angelica McKinley, AppleNews
session_title: Master class: Design thinking for jourmalists *pre-registered attendees only
clean_description:
Skill level: Beginner Speakers: Angelica McKinley and Lena Groeger. Anyone can improve the design and usability of a journalistic project (from a basic story page to an interactive graphic) with a few simple fixes. Even if you have zero experience in design and concepts like " alignment" and "responsiveness" seem like technical jargon, this session is for you. We'll go through our favorite design rules of thumb, covering everything from typography to interaction to accessibility, and apply them to real-life examples in the news and beyond. We’ll also cover: Thinking like a user Designing for inclusiveness Ambiguity in design How and when to break the rules By the end of this workshop, you'll be able to recognize poor designs and identify how to fix them, and you’ll be on your way to creating your own designs with better organization, unity and clarity. Preregistration is required and seating is limited. 


name: Master class: Leading the data team **pre-registered attendees only
start_date_clean: 2019-03-07
start_time: 2019-03-07 09:00:00
end_time: 2019-03-07 12:30:00
speakers_cleaned: Janet Roberts, Reuters; Troy Thibodeaux, Associated Press
session_title: Master class: Leading the data team *pre-registered attendees only
clean_description:
Experienced data journalists will share practical tips on how they've led their teams and convinced higher-ups to integrate data into the newsroom. Our instructors will show how they made it into leadership and how they excelled once they got there. Topics will include: How to lead a team to create their best work Handling expectations from management Carving out a career path in leadership when you're known for your data skills Making data journalism a core principle in your newsroom Managing your time and the time of your team This class is ideal for data journalists who are looking to break into leadership and need guidance on how to get there or existing leaders who need tips on how to lead effectively. Preregistration is required and seating is limited. 


name: Master class: Mastering the interview **pre-registered attendees only
start_date_clean: 2019-03-09
start_time: 2019-03-09 09:00:00
end_time: 2019-03-09 12:30:00
speakers_cleaned: Ken Armstrong, ProPublica
session_title: Master class: Interviewing *pre-registered attendees only
clean_description:
When it comes to interviewing, some reporters are naturals. ProPublica’s Ken Armstrong isn’t one of them. He’ll share the (many) mistakes he’s made and what he’s learned from them. This workshop will move from getting the interview, to conducting the interview, to capitalizing on the interview when it’s time to write. Topics will include: How — and when — to land a tough interview The power of silence The power of sincerity Interviewing people who have been hurt, and interviewing the people who hurt them How to interview someone who won’t talk to you (and yes, this can be done — sort of) We will venture, ever so briefly, into the mysterious realm of emotions (open mind, open heart). We’ll challenge some of the conventional wisdom surrounding interviewing (pure hooey, some of it). And we’ll watch outstanding interviewers at work, studying what they do — and, more important, what they don’t do. Preregistration is required and seating is limited. 


name: Master class: Self-editing & bulletproofing the data **pre-registered attendees only
start_date_clean: 2019-03-07
start_time: 2019-03-07 14:15:00
end_time: 2019-03-07 17:45:00
speakers_cleaned: Kimbriell Kelly, The Washington Post; Shawn McIntosh, The Atlanta Journal Constitution
session_title: Master class: Self-editing & bulletproofing the data story *pre-registered attendees only
clean_description:
Data-driven stories can overwhelm a writer juggling data and storytelling and leave even the best editors feeling out of their depth. In this half-day workshop, we’ll focus on the core data editing and bulletproofing skills every journalist should have, whether you are a hands-on data journalist or an editor supervising this work. Two data journalists, Atlanta Journal Constitution’s deputy managing editor Shawn McIntosh and Washington Post investigative reporter Kimbriell Kelly, will share lessons they have learned writing and presenting data-driven stories. You will receive tips and strategies from an editor's and reporter's point of view, including: Common data errors -- How to spot and fix them Using a data diary to track your methodology Practical strategies for bulletproofing and fact-checking your data analysis and findings Going beyond numbers -- Using data to find human sources and characters for stories Untangling the writing and avoiding reader turnoffs Managing up -- Working with an editor who doesn’t speak data Managing the numbers as deadline approaches Whether you want to get better at editing yourself or others, we’ll have tips and resources for you. No data experience is required for this workshop. Bring questions and examples as there will be plenty of time for discussion. Preregistration is required and seating is limited. 


name: Master class: Telling the data story across platforms **pre-registered attendees only
start_date_clean: 2019-03-08
start_time: 2019-03-08 09:00:00
end_time: 2019-03-08 12:30:00
speakers_cleaned: Josh Hinkle, KXAN; Lisa Pickoff-White
session_title: Master class: Telling the data story across platforms *pre-registered attendees only
clean_description:
No matter your media type, a successful data story or investigation requires the ability to connect with audiences on several platforms, including broadcast, digital and social media. But with limited time and resources, it can be challenging to develop and execute a plan that cuts across media. We’ll cover: Identifying which platforms to use to tell your story Techniques for making data and documents work across platforms Developing a project team and getting buy-in from newsroom leaders Common challenges and red-flags — dealing with marketing/promotions departments, ensuring accuracy across platforms and measuring success This session is good for reporters, editors and producers. We’ll talk about the roles each person plays in this process, and provide tips to take back to your team. Please come with a story you’re investigating to workshop as well as your laptop. Preregistration is required and seating is limited. 


name: Master class: Writing the data-driven narrative **pre-registered attendees only
start_date_clean: 2019-03-09
start_time: 2019-03-09 14:15:00
end_time: 2019-03-09 17:45:00
speakers_cleaned: T. Christian Miller, ProPublica; Sarah Cohen, ASU
session_title: Master class: Writing the data-driven narrative *pre-registered attendees only
clean_description:
You’ve gathered and analyzed data, talked to human sources and now you’re ready to write. If you’re new to data-driven storytelling, this workshop is for you. Sarah Cohen is the Knight Chair in Journalism at ASU’s Walter Cronkite School of Journalism and a former editor at The New York Times and The Washington Post. T. Christian Miller is a reporter at ProPublica, where his coverage of sexual assault was recognized with a 2016 Pulitzer Prize. Together they’ll share tips and techniques for writing data-driven stories that pack an emotional punch. Topics include: Understanding narrative Reporting for story — How to gather the details and scenes that will make your numbers come to life. Focus and framing – Finding your way through all that material Communicating data – Deciding how many numbers to include and putting them in context Self-editing tips and techniques We’ll look at examples of successful stories, pulling back the curtain to see how they came together. Preregistration is required and seating is limited. 


start_date_clean: 2019-03-08
start_time: 2019-03-08 09:00:00
end_time: 2019-03-08 12:30:00
speakers_cleaned: Frank Bi, SB Nation
name:
Mastering Google Sheets: Web scraping, running scripts and other tricks **pre-registered attendees only

clean_description:
Skill level: Beginner Google Sheets is more than just free spreadsheet software to organize and store data. In this hands-on session will start with pivot tables and conditional formatting but 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. Attendees must bring a laptop and charger (no tablets) to this training. Workshop prerequisites: You should be familiar with using spreadsheets and formulas. 

session_title:
Mastering Google Sheets: Web scraping, running scripts and other tricks *pre-registered attendees only


name: Media lawyers brown bag
start_date_clean: 2019-03-08
start_time: 2019-03-08 12:45:00
end_time: 2019-03-08 13:45:00
session_title: Media lawyers brown bag
clean_description:
**Moderated by Maggie Mulvihill, Boston University During the media lawyers brown bag, between 12:45 and 1:45 p.m. on Friday, March 8, bring your lunch and your questions for a personal discussion with a panel of media lawyers and FOIA-savvy speakers. IRE & NICAR will provide drinks and dessert. 

speakers_cleaned:
Maggie Mulvihill, Boston University (moderator); Katie Townsend, Reporters Committee for Freedom of the Press; Tina Salvato & Matthew Halgren, Sheppard Mullin; Adam Marshall, Reporters Committee for Freedom of the Press 


name: MySQL
start_date_clean: 2019-03-08
start_time: 2019-03-08 14:15:00
end_time: 2019-03-08 15:15:00
speakers_cleaned: Jack Gillum, ProPublica
session_title: MySQL
clean_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. 


name: NICAR-L improvement project
start_date_clean: 2019-03-07
start_time: 2019-03-07 16:45:00
end_time: 2019-03-07 17:45:00
speakers_cleaned: Derek Willis, ProPublica
session_title: NICAR-L improvement project
clean_description:
Help make the NICAR-L archives more user-friendly by creating ways to identify and surface useful posts and threads. We'll discuss possible new ways to access the archives, a basic app to make things like up-voting and categorization possible and an initial roadmap. During this session, we will gather ideas and create a plan that we'll continue working on after the conference. 


name: No code required: Create compelling interactive data visualizations with Microsoft Power BI
start_date_clean: 2019-03-09
start_time: 2019-03-09 11:30:00
end_time: 2019-03-09 12:30:00
speakers_cleaned: Cathleen Crowley, Albany Times Union; Vera Chan & Lukasz Pawlowski, Microsoft
session_title: No code required: Create compelling interactive data visualizations with Microsoft Power BI
clean_description:
Join Microsoft's Modern Journalism Team for a hands-on workshop where you'll learn to use Microsoft’s free Power BI software and cloud service (Excel’s data visualization cousin) to quickly create and publish engaging interactives that uncover the story hidden in the data. The session will also show how to style your interactive for your publication or station. You’ll learn to: Connect a data set Clean up the data Drag-and-drop existing data visualization options onto the canvas Customize colors and fonts to create a style-consistent visualization Publish the visualization to your website or big screen for in-studio use …all through powerful, menu-driven software that readily connects to numerous data sources. This session is good for: Anyone, including data beginners. 


name: Observable notebooks: Your interactive data journal
start_date_clean: 2019-03-09
start_time: 2019-03-09 11:30:00
end_time: 2019-03-09 12:30:00
speakers_cleaned: Jeremy Ashkenas, ObservableHQ; Aaron Williams, The Washington Post
session_title: Observable notebooks: Your interactive data journal
clean_description:
In this gentle introduction, we'll show you how to analyze and visualize data in an Observable notebook, whip up a series of rough prototypes, and export the bones to finish as a news graphic. There's nothing to install, no way to get yourself into a bad state with reactive cells, and no problem loading almost any JavaScript library you can think of. We’ll finish by walking through a series of published Washington Post pieces that started their life as Observable notebooks. 


name: One map, no code: The power of Mapbox Studio
start_date_clean: 2019-03-09
start_time: 2019-03-09 14:15:00
end_time: 2019-03-09 15:15:00
speakers_cleaned: Lo Benichou, Mapbox; Casey Miller, Los Angeles Times
session_title: One map, no code: The power of Mapbox Studio
clean_description:
Think you need code to make a highly customized data-driven map? We’re here to show you that you don’t. In this session, we’re going to make a choropleth map and show you how to fine-tune the smallest details with Mapbox Studio. **You must bring a laptop to participate in this class. You will also need Mapbox and GitHub accounts. This session is good for: All skill levels. No JavaScript knowledge required, but basic computer literacy is necessary. 


name: One-size-doesn't-fit-all: How to make multilingual DDJ work
start_date_clean: 2019-03-10
start_time: 2019-03-10 10:15:00
end_time: 2019-03-10 11:15:00
session_title: One-size-doesn't-fit-all: How to make multilingual DDJ work
clean_description:
Producing a multilingual data journalism project involves more than just translating your story. In this session we'll demonstrate how the BBC, Deutsche Welle and Al Jazeera work with international journalists, developers and designers to develop multilingual data-driven stories that address the needs of local audiences. From carefully planning your project, sourcing hard-to-get data, designing around your audience’s expectations and deploying a sustainable project, this session will cover it all. 

speakers_cleaned:
Ana Lucia Gonzalez Paz, BBC World Service (moderator); Gianna Grün, Deutsche Welle; Mohammed Haddad, Al Jazeera English


name: OpenElections hackathon
start_date_clean: 2019-03-10
start_time: 2019-03-10 09:00:00
end_time: 2019-03-10 12:30:00
speakers_cleaned: Derek Willis, ProPublica
session_title: OpenElections hackathon
clean_description:
Come join the OpenElections team to help with standardizing 2018 primary and general election results and rebuilding the openelections.net site. No programming skills required, and we’re always interested in finding ways to make it easier for journalists to use our data. 


name: PDF 1: Using free online tools
start_date_clean: 2019-03-07
start_time: 2019-03-07 09:00:00
end_time: 2019-03-07 10:00:00
speakers_cleaned: Leah Becerra, The Kansas City Star
session_title: PDF 1: Using free online tools
clean_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. 


name: PDF 2: Using OCR to extract data from PDFs
start_date_clean: 2019-03-08
start_time: 2019-03-08 15:30:00
end_time: 2019-03-08 16:30:00
speakers_cleaned: Chad Day, Associated Press
session_title: PDF 2: Using OCR to extract data from PDFs
clean_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 walk 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. 


name: PDF 3: Batch pdf processing
start_date_clean: 2019-03-08
start_time: 2019-03-08 16:45:00
end_time: 2019-03-08 17:45:00
speakers_cleaned: Dan Nguyen, independent journalist
session_title: PDF 3: Batch pdf processing
clean_description:
This class will cover advanced tools for working with PDF, particularly the Python library pdfplumber. Learn how you can use programming skills to unlock information from PDF files that tools like Tabula or CometDocs just won't deal with. This session is good for: People who are familiar with Python notebooks, or if you've taken the first two PDF classes in the track. 


name: Philip Meyer Award Presentation
start_date_clean: 2019-03-08
start_time: 2019-03-08 18:15:00
end_time: 2019-03-08 18:30:00
clean_description:
The presentation of the 2018 Philip Meyer Journalism Awards will take place on Friday at the 2019 CAR Conference in Newport Beach. 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. Three awards are given annually — a first, second and third place — to recognize the best work using techniques that are part of precision journalism, computer-assisted reporting and social science research. The awards are: $500 for first, $300 for second, and $200 for third. 


start_date_clean: 2019-03-08
start_time: 2019-03-08 18:30:00
end_time: 2019-03-08 19:30:00
name:
Philip Meyer Journalism Awards Reception (Co-sponsored by Reporters Committee for Freedom of the Press and IRE)

clean_description:
Join fellow CAR 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. 


name: PostgreSQL
start_date_clean: 2019-03-07
start_time: 2019-03-07 10:15:00
end_time: 2019-03-07 11:15:00
speakers_cleaned: Anthony DeBarros, The Wall Street Journal
session_title: PostgreSQL
clean_description:
This session will introduce you to PostgreSQL, a free, open source relational database system similar to MySQL and Microsoft SQL Server. We’ll cover the PostgreSQL ecosystem, from the database itself to management tools such as pgAdmin and psql. We’ll also dig into some of PostgreSQL’s unique and super-handy features, including the PostGIS spatial database extension, full-text search, and statistical functions. This session is good for: People who have some database experience, but beginners are welcome too! 


name: Preparing for the future of disinformation and deep fakes
start_date_clean: 2019-03-07
start_time: 2019-03-07 16:45:00
end_time: 2019-03-07 17:45:00
keywords: disinformation; fakes
session_title: Preparing for the future of disinformation and deep fakes
clean_description:
Recent advances in artificial intelligence make it easy to generate believable video and audio. It seems likely that these techniques will see usage in the political arena, where the ability to cheaply generate high fidelity hoaxes might be an attractive option for state and nonstate actors seeking to manipulate discourse and voter behavior. Journalists, tasked with evaluating the quality of information, will be on the front lines confronting these new threats as they emerge. Learn what tools exist to detect potential fakes, what machine learning can and can’t do, who is fighting the potential spread of synthetic videos and what we can do about it. This session was sponsored by Knight Foundation. IRE retains control of content, including the topic and speaker selection, for all conference sessions. 

speakers_cleaned:
Paul Cheung, Knight Foundation (moderator); Christine Glancey, The Wall Street Journal; Sam Gregory, Witness; Tim Hwang, Harvard University; 


name: Publish the data behind your stories with SQLite and Datasette
start_date_clean: 2019-03-08
start_time: 2019-03-08 16:45:00
end_time: 2019-03-08 17:45:00
speakers_cleaned: Simon Willison, Datasette
session_title: Publish the data behind your stories with SQLite and Datasette
clean_description:
Datasette is a tool for exploring and publishing data. It can be used on a laptop to analyze data, then publish that data to the web as an interactive website and accompanying JSON API. Datasette is part of an ecosystem of tools built on top of SQLite, a fast and flexible open-source database engine. Data that starts life as CSV, JSON or other formats can be converted to SQLite, joined against other data, analyzed, visualized and then published online. This workshop will cover: Using Datasette to explore and analyze data from a variety of sources Converting CSV data to SQLite Publishing databases online using Datasette and Heroku Using full-text search and facets to quickly analyze large and complex datasets Visualizing numeric and geographic data using Datasette plugins This session is good for: those with some familiarity with SQL. 


name: PyCAR *pre-registered attendees only
start_date_clean: 2019-03-07
start_time: 2019-03-07 09:00:00
end_time: 2019-03-07 12:30:00
session_title: PyCAR *pre-registered attendees only
clean_description:
Skill level: Intermediate This hands-on workshop will teach journalists basic programming concepts using the Python language. The daylong class will introduce language basics and useful libraries in the course of a typical reporting project: scraping data from the web, inserting it in a database and analyzing the results.?? Although the class is geared toward beginners, we'll assume that you're comfortable with databases and SQL and that you've hopefully seen a command line since the days of DOS. Preregistration is required and seating is limited. Laptops will be provided for the training.?? Workshop prerequisites: Attendees should have familiarity with the command line and be comfortable with databases and SQL. This class takes place on Thursday, March 7 from 9 a.m. - 12:30 p.m. and continues Friday, March 8, 9 a.m. - 12:30 p.m. (Registration for this session reserves your seat for both days of this workshop and attendees are expected to attend both sessions to complete the workshop.) 

speakers_cleaned:
Adriana Homolova, independent journalist; Chris Keller, Los Angeles Times; Melissa Lewis, Reveal from The Center for Investigative Reporting; Tom Meagher, The Marshall Project; Roberto Rocha, CBC News; Eric Sagara, Reveal from The Center for Investigative Reporting; Jacob Sanders, Factal; Aaron Williams, The Washington Post; Elaine Wong, CBC News 


name: Python 101: An overview for total beginners
start_date_clean: 2019-03-07
start_time: 2019-03-07 11:30:00
end_time: 2019-03-07 12:30:00
speakers_cleaned: Mindy McAdams, Florida University
session_title: Python 101: An overview for total beginners
clean_description:
Come learn how newsrooms are using the Python programming language to analyze data, scrape the web, build web applications and more. This lecture will answer basic questions about what Python is, how it's used and how you can get started learning. 


name: Python 1: The fundamentals
start_date_clean: 2019-03-07
start_time: 2019-03-07 14:15:00
end_time: 2019-03-07 15:15:00
speakers_cleaned: Sandra Fish, independent journalist
session_title: Python 1: The fundamentals
clean_description:
Learning a programming language is much like learning to write a news story. There are certain styles and conventions to follow, a standard order, etc. In this session geared toward absolute beginners, we’ll get started with some of the basics of this new language. 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. 


name: Python 2: Intro to data analysis using pandas
start_date_clean: 2019-03-07
start_time: 2019-03-07 15:30:00
end_time: 2019-03-07 16:30:00
speakers_cleaned: Lam Thuy Vo, Buzzfeed News
session_title: Python 2: Intro to data analysis using pandas
clean_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. 


name: Python 3: Data cleaning and visualization
start_date_clean: 2019-03-07
start_time: 2019-03-07 16:45:00
end_time: 2019-03-07 17:45:00
speakers_cleaned: Karrie Kehoe, International Consortium of Investigative Journalists
session_title: Python 3: Data cleaning and visualization
clean_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. 


name: Python: Basic mapping and GIS
start_date_clean: 2019-03-10
start_time: 2019-03-10 10:15:00
end_time: 2019-03-10 11:15:00
speakers_cleaned: Scott Pham, Buzzfeed News
session_title: Python: Basic mapping and GIS
clean_description:
Learn how to use GeoPandas, a lovely little Python library that will simplify your geospatial life. Manage projections, filter shapefiles, and even create publication-ready maps all from the safe haven of a Jupyter Notebook. This session is good for people who use Python in the newsroom. Some familiarity with the Pandas library is ideal, but not required. 


name: Python: Data visualization with Altair
start_date_clean: 2019-03-09
start_time: 2019-03-09 15:30:00
end_time: 2019-03-09 16:30:00
speakers_cleaned: Andrea Suozzo, Seven Days
session_title: Python: Data visualization with Altair
clean_description:
Move over, matplotlib -- a Python library called Altair is promising to make it even easier to create charts and maps for exploratory data analysis. Come learn how to use this library to bring your analysis to life with charts and maps. This session is good for: People who already have some familiarity with Python, Jupyter notebooks and using pandas for data analysis. 


name: Python: Let's scrape a website
start_date_clean: 2019-03-08
start_time: 2019-03-08 14:15:00
end_time: 2019-03-08 15:15:00
speakers_cleaned: Ryan Pitts, Knight-Mozilla OpenNews
session_title: Python: Let's scrape a website
clean_description:
This hands-on training will illustrate how Python can be used to grab a lot of data from a website at once, whether by pulling content from a page or interacting with forms. You’ll want to be comfortable writing loops in Python, though you won’t necessarily need to be able to write a function from scratch! This session is good for people who feel comfortable with Python’s data types and control flow (if/else, loops). Experience with HTML is a plus but not necessary. Note: It would be useful to attend the session " How it Works: The Internet" in advance if you’re not familiar with the topic already. 


name: Python: Let's scrape a website (repeat)
start_date_clean: 2019-03-09
start_time: 2019-03-09 09:00:00
end_time: 2019-03-09 10:00:00
speakers_cleaned: Mike Stucka, The Palm Beach Post
session_title: Python: Let's scrape a website (repeat)
clean_description:
This hands-on training will illustrate how Python can be used to grab a lot of data from a website at once, whether by pulling content from a page or interacting with forms. You’ll want to be comfortable writing loops in Python, though you won’t necessarily need to be able to write a function from scratch! This session is good for people who feel comfortable with Python’s data types and control flow (if/else, loops). Experience with HTML is a plus but not necessary. Note: It would be useful to attend the session "How it Works: The Internet" in advance if you’re not familiar with the topic already. 


name: Python: Machine learning and natural language processing
start_date_clean: 2019-03-07
start_time: 2019-03-07 09:00:00
end_time: 2019-03-07 10:00:00
speakers_cleaned: Jeff Kao, ProPublica
session_title: Python: Machine learning and natural language processing
clean_description:
How to use off-the-shelf unsupervised machine learning, natural language processing, and outlier detection algorithms to find and visualize patterns in data. Sample data includes the Internet Research Agency Facebook Ads released by the Democrats on the House Intelligence Committee. This session is good for: People who have intermediate Python knowledge. 


name: Python: Writing tests for your code
start_date_clean: 2019-03-09
start_time: 2019-03-09 16:45:00
end_time: 2019-03-09 17:45:00
speakers_cleaned: Andrew Chavez, The Dallas Morning News
session_title: Python: Writing tests for your code
clean_description:
Every programmer makes mistakes. Writing good tests can help you avoid making them in production. In this session, you will learn how to use Python's built-in tools to automate testing so you can sleep better at night. This session is good for: People who use Python regularly and want to improve their workflow. 


name: QGIS 1: Mapmaking for beginners
start_date_clean: 2019-03-09
start_time: 2019-03-09 09:00:00
end_time: 2019-03-09 10:00:00
speakers_cleaned: Dan Dunford, BBC News; Clara Guiborg, BBC News
session_title: QGIS 1: Mapmaking for beginners
clean_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. 


name: QGIS 2: Filtering and analyzing geographic data to make maps
start_date_clean: 2019-03-09
start_time: 2019-03-09 10:15:00
end_time: 2019-03-09 11:15:00
speakers_cleaned: Will Dahlgreen, BBC News; Nassos Stylianou, BBC News
session_title: QGIS 2: Filtering and analyzing geographic data to make maps
clean_description:
Build on your existing knowledge of QGIS and learn how to filter and analyze geographic datasets, before familiarising yourself with exporting the maps you have created using the print composer. We will cover techniques like merging and dissolving polygons, using Open Street Map data in QGIS as well as aggregating point data for easier analysis. This session is good for: those who attended the QGIS I workshop or already know the basics of visualizing geographic data in QGIS. 


name: R 1: Intro to R and RStudio
start_date_clean: 2019-03-07
start_time: 2019-03-07 14:15:00
end_time: 2019-03-07 15:15:00
speakers_cleaned: Meghan Hoyer, Associated Press
session_title: R 1: Intro to R and RStudio
clean_description:
Learn your way around the basics of RStudio. We’ll load basic packages to do data analysis, read in some data and explore it. This is a good class to learn the basic structure of writing R code. You’ll leave knowing how to get data into R, how to do some cleaning and formatting tasks and how to start doing basic analysis on a dataset. This will give you more confidence to take the next steps in your analyses. This session is good for: beginner to intermediate users. 


name: R 2: Data analysis and plotting in R
start_date_clean: 2019-03-07
start_time: 2019-03-07 15:30:00
end_time: 2019-03-07 16:30:00
speakers_cleaned: Ronald Campbell, NBC Owned Television Stations
session_title: R 2: Data analysis and plotting in R
clean_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. 


name: R 2: Data analysis and plotting in R (repeat)
start_date_clean: 2019-03-09
start_time: 2019-03-09 15:30:00
end_time: 2019-03-09 16:30:00
speakers_cleaned: Sarah Ryley, The Trace
session_title: R 2: Data analysis and plotting in R (repeat)
clean_description:
We'll use the tidyverse and sf packages, learning how to sort, filter, group, summarize, join, map 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. 


name: R 3: Gathering and cleaning data in R
start_date_clean: 2019-03-07
start_time: 2019-03-07 16:45:00
end_time: 2019-03-07 17:45:00
speakers_cleaned: Ronald Campbell, NBC Owned Television Stations
session_title: R 3: Gathering and cleaning data in R
clean_description:
Learn how to use R to collect information from web pages and transform the results into usable data. This session will also teach you how to clean and structure data for analysis using the tidyverse and other packages. This session is good for: People who have used R and database software. 


name: R: Intro stats (repeat)
start_date_clean: 2019-03-08
start_time: 2019-03-08 16:45:00
end_time: 2019-03-08 17:45:00
speakers_cleaned: Steve Reilly, USA Today
session_title: R: Intro stats (repeat)
clean_description:
Learn how to use R to spot trends and identify relationships in data using social science theories and methods. In this session, we will use R for statistical significance tests, cross-tabulations and linear regression. This session is good for: Anyone who is comfortable working with spreadsheets and database managers and wants to learn how to do basic statistical analysis. Some experience with R will be helpful. 


name: R: Models for clustered and correlated data
start_date_clean: 2019-03-08
start_time: 2019-03-08 09:00:00
end_time: 2019-03-08 10:00:00
speakers_cleaned: Mary Ryan, University of California, Irvine
session_title: R: Models for clustered and correlated data
clean_description:
Basic linear regression is great, but what happens when not all of your observations are independent or you have multiple observations per subject? Take your statistical analysis skills to the next level when you learn how to measure the relationships within correlated and clustered data in R using the gee package. This session is good for: Intermediate R users who are comfortable with linear and logistic regression and want to learn more complex modeling methods. 


name: Regular expressions for the rest of us
start_date_clean: 2019-03-07
start_time: 2019-03-07 09:00:00
end_time: 2019-03-07 10:00:00
speakers_cleaned: Christian McDonald, University of Texas
session_title: Regular expressions for the rest of us
clean_description:
Regular expressions are a powerful way to slice, dice and clean up dirty data — a must-know skill for anyone who works with data. They may look intimidating, but they are really just pattern-matching puzzles. We'll learn the fundamentals of "regex" so you save time cleaning your next batch of 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. 


name: Research on the beach: Deep diving
start_date_clean: 2019-03-09
start_time: 2019-03-09 09:00:00
end_time: 2019-03-09 10:00:00
speakers_cleaned: Gary Price, InfoDocket; Margot Williams, The Intercept
session_title: Research on the beach: Deep diving
clean_description:
Dive into the latest tools for public records and advanced research, sail on to online privacy tips and alerting services and see what's new on the horizon for personal web caching and archiving. 


name: Rewriting the code of ethics: New standards for digital journalism
start_date_clean: 2019-03-09
start_time: 2019-03-09 14:15:00
end_time: 2019-03-09 15:15:00
session_title: An Uncertain Future: A Code of Ethics for the Robotic Age
clean_description:
Surveillance, data breaches and misinformation: The hazards inherent in our digital landscape mandate an update to the journalist's code of ethics. Come prepared with any cases of ethical dilemmas you or your newsroom have encountered online. In this NICAR Commons session, journalists and technologists will discuss examples and work toward a new standard for online behavior. 

speakers_cleaned:
Gisela Perez de Acha Chavez, Mahmoud Hamsho, Christi Warren, Steve Trush, The University of California-Berkeley


name: Seeing the story: How to write the data-driven investigation
start_date_clean: 2019-03-08
start_time: 2019-03-08 10:15:00
end_time: 2019-03-08 11:15:00
session_title: Seeing the story: How to write the data-driven investigation
clean_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_cleaned:
Brett Murphy, USA TODAY Network; James Neff, The Philadelphia Inquirer (moderator); Paula Lavigne, ESPN; Anita Hassan, Las Vegas Review-Journal


name: Self care for journalists: A practical guide
start_date_clean: 2019-03-07
start_time: 2019-03-07 11:30:00
end_time: 2019-03-07 12:30:00
session_title: Self care for journalists: A practical guide
clean_description:
Layoffs. Climate-change disasters. Fake news. Corruption. Mass shootings. Angry sources. Vitriolic culture. Enemy of the people. Journalism has never been an easy job but in our current culture, the psychic, emotional and sometimes financial toll seems to keep mounting. So how do we thrive — or even survive — in such an atmosphere? This session will cover how to recognize signs of burnout, secondary trauma and other danger signs, as well as the research that shows what can really help, how to train your editor and how to build a support network. We'll also look at how professionals deal with constant trauma in other fields. The good news: the practices and tools you can develop to survive as a journalist – growing resilience, cultivating empathy and self-advocacy – are the same tools that can help you succeed in the rest of your life. 

speakers_cleaned:
Jodi Upton, Syracuse University (moderator) ; Linda Yaron, University of Southern California ; Kristin Hussey, independent journalist , Christine Mehta, Syracuse University 


name: Share your work: Publishing your data analysis with R
start_date_clean: 2019-03-07
start_time: 2019-03-07 10:15:00
end_time: 2019-03-07 11:15:00
speakers_cleaned: Christine Zhang, The Baltimore Sun
session_title: Share your work: Publishing your data analysis with R
clean_description:
You will save time, produce better results, create more trusted analyses, reduce risk of errors and encourage collaboration by implementing reproducible data analysis workflow techniques. We will be going over tools like RMarkdown and interactive notebooks to weave together narrative text and code to produce formatted reports for sharing with collaborators (including your future self!). We will walk through hosting these reports and raw data files on GitHub. We will discuss best practices on how to structure your projects and repos. This session is good for: R users interested in improving their workflow 


name: Shooting straight: How to use gun data and documents effectively
start_date_clean: 2019-03-08
start_time: 2019-03-08 11:30:00
end_time: 2019-03-08 12:30:00
session_title: Shooting straight: How to use gun data and documents effectively
clean_description:
In this session, we'll show you how to sort out what data and documents you can gather for reporting on guns, where you're wasting your time and when you should build from the ground up. We'll discuss common pitfalls and how to accurately and fairly cover the firearms industry, gun violence and regulatory agencies. We'll also offer tips on reliable data streams, sample data on guns and tips on finding sources. 

speakers_cleaned:
Anthony Cave, KERA News; Polly Mosendz, Bloomberg News; Daniel Nass, The Trace; Cheryl W. Thompson, NPR (moderator)


name: Spatial queries in PostGIS
start_date_clean: 2019-03-09
start_time: 2019-03-09 11:30:00
end_time: 2019-03-09 12:30:00
speakers_cleaned: Andrew Chavez & Ariana Giorgi, The Dallas Morning News
session_title: Spatial queries in PostGIS
clean_description:
In this session, you will learn how to write spatial queries in PostGIS in order to make powerful conclusions with your geodata. We’ll go over examples and tricks, while also covering importing and exporting data. This class is good for: those comfortable writing their own SQL queries, including how to write “WHERE” and “GROUP BY” statements. Familiarity with writing spatial queries isn’t required, but students should have some basic GIS understanding. 


name: Sports data viz with R
start_date_clean: 2019-03-07
start_time: 2019-03-07 09:00:00
end_time: 2019-03-07 10:00:00
speakers_cleaned: Matt Waite, University of Nebraska
session_title: Sports data viz with R
clean_description:
Sports is one area you won’t struggle to find data or a very interested audience. Learn how to turn some basic R into interesting looks into games, teams and seasons. This session is good for: Anyone interested in R, visualizing data and sports. No previous experience with R is required. 


name: Spreadsheet add-ins you can't live without
start_date_clean: 2019-03-10
start_time: 2019-03-10 10:15:00
end_time: 2019-03-10 11:15:00
speakers_cleaned: Lauren Grandestaff, IRE; Erin Mansfield, Tyler
session_title: You just survived NICAR19! Now what?
clean_description:
Need to geocode? Clean up dirty data? Combine multiple worksheets? Count data by color? Other weird things you need to do to use that one funky spreadsheet that came in through a FOIA? Let's talk about the capabilities of some of the add-ins that are out there for Google Sheets and Excel. 


name: SQL 1: Exploring data
start_date_clean: 2019-03-07
start_time: 2019-03-07 09:00:00
end_time: 2019-03-07 10:00:00
speakers_cleaned: Kendall Taggart, Buzzfeed News
session_title: SQL 1: Exploring data
clean_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 SQLite and DB Browser, 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. 


name: SQL 2: Grouping and summing data
start_date_clean: 2019-03-07
start_time: 2019-03-07 10:15:00
end_time: 2019-03-07 11:15:00
speakers_cleaned: Matt Kiefer, The Chicago Reporter
session_title: SQL 2: Grouping and summing data
clean_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. 


name: SQL 3: Joining tables
start_date_clean: 2019-03-07
start_time: 2019-03-07 11:30:00
end_time: 2019-03-07 12:30:00
speakers_cleaned: Chad Day, The Associated Press
session_title: SQL 3: Joining tables
clean_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. 


name: SQL CARwash: Cleaning dirty data
start_date_clean: 2019-03-09
start_time: 2019-03-09 11:30:00
end_time: 2019-03-09 12:30:00
speakers_cleaned: Madi Alexander, Bloomberg BNA
session_title: SQL CARwash: Cleaning dirty data
clean_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. 


name: Stats 1: An introduction using PSPP
start_date_clean: 2019-03-08
start_time: 2019-03-08 09:00:00
end_time: 2019-03-09 10:00:00
speakers_cleaned: Holly Hacker, The Dallas Morning News
session_title: Stats 1: An introduction using PSPP
clean_description:
Statisticians need to really understand their data (and so do you!) before they begin running analyses. As a result, statistical software packages such as PSPP and SPSS have many powerful tools to summarize your data. You're going to love them. We'll take a look at the structure of data in PSPP, 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. 


name: Stats 2: Linear regression using PSPP
start_date_clean: 2019-03-08
start_time: 2019-03-08 10:15:00
end_time: 2019-03-08 11:15:00
speakers_cleaned: Ryan McNeill, Reuters
session_title: Stats 2: Linear regression using PSPP
clean_description:
Go beyond counting and sorting. Learn how (and when) to measure relationships, level playing fields and make predictions. 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 PSPP or SPSS and new to stats. Familiarity with spreadsheets and database managers is recommended. 


name: Stats 3: Logistic regression using PSPP
start_date_clean: 2019-03-08
start_time: 2019-03-08 11:30:00
end_time: 2019-03-08 12:30:00
speakers_cleaned: John Perry, The Atlanta Journal Constitution
session_title: Stats 3: Logistic regression using PSPP
clean_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 session will be taught in PSPP and is good for people who took “Stats: An introduction” or are comfortable with summary statistics and PSPP or SPSS. Familiarity with spreadsheets and database managers is recommended. 


name: Stats in Excel
start_date_clean: 2019-03-07
start_time: 2019-03-07 14:15:00
end_time: 2019-03-07 15:15:00
speakers_cleaned: Steve Doig, ASU Walter Cronkite School of Journalism
session_title: Stats in Excel
clean_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. 


name: Students' roundtable
start_date_clean: 2019-03-07
start_time: 2019-03-07 15:30:00
end_time: 2019-03-07 16:30:00
speakers_cleaned: Kaitlin Washburn, University of Missouri; Orla McCaffrey, Binghamton University
session_title: Students' roundtable
clean_description:
This is a roundtable for students to have an honest, off-the-record discussion on the challenges of being a student journalist. Some of the topics that might be brought up include: learning to set aside your personal biases, gaining access to data and documents, and backlash from your university for unfavorable coverage. 


name: Surveys save the day: An old tool emerges as a cutting edge
start_date_clean: 2019-03-09
start_time: 2019-03-09 15:30:00
end_time: 2019-03-09 16:30:00
session_title: Surveys save the day: An old tool emerges as a cutting edge
clean_description:
Surveys are a familiar social science tool in newsrooms. But did you know that you can use them to break through obstacles in your investigation? In one case, powerful email programs and online surveys let reporters track down thousands of victims whose stolen identities were used to defraud the government. In another case, enterprising reporters barred from part of a foreign country used a mobile phone survey to track down human rights violations. Phil Meyer gave you the basics on newsroom surveys in "Precision Journalism." This panel will explain modern, practical methods and tools that can be adapted for investigative journalism. 

speakers_cleaned:
James Grimaldi, The Wall Street Journal (moderator); Chris Jackson, Ipsos Public Affairs; Carolyn Thompson, independent journalist 


name: Text mining in R with tidytext
start_date_clean: 2019-03-07
start_time: 2019-03-07 11:30:00
end_time: 2019-03-07 12:30:00
speakers_cleaned: Peter Aldhous, Buzzfeed News
session_title: Text mining in R with tidytext
clean_description:
Do you want to analyze the themes, sentiment, and complexity of every State of the Union address, or analyze how Members of congress responded on Twitter to @realDonaldTrump? 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 class is good for: those who are familiar with the basics of the tidyverse. 


name: The data sleuth's guide to the social web
start_date_clean: 2019-03-08
start_time: 2019-03-08 09:00:00
end_time: 2019-03-08 10:00:00
speakers_cleaned: Jane Lytvynenko, BuzzFeed News; Lam Thuy Vo, Buzzfeed News
session_title: The data sleuth's guide to the social web
clean_description:
Whether you're spotting bots by plotting their activity levels or you're analyzing the spread of hate speech or misinformation in quantitative ways — there are many ways for journalists to investigate stories on the social web. This demo will walk through various approaches to leverage social media data for different kinds of stories and talk about the kinds of tools needed to report them out. 


name: The data-driven escape room
start_date_clean: 2019-03-09
start_time: 2019-03-09 11:30:00
end_time: 2019-03-09 12:30:00
speakers_cleaned: Jennifer LaFleur, Aron Pilhofer, Temple University; Jonathan Stoneman
session_title: The data-driven escape room
clean_description:
You're an investigative reporter in London, and you have one hour to help your colleague finish a story he's been digging into involving organized crime. We'll provide some real-life data files and some background reading, and you'll work in teams to scour the data, answer questions and do some internet sleuthing to put together the story, all in under an hour. This session is good for: Anyone familiar with spreadsheets. 


name: The debt trap
start_date_clean: 2019-03-09
start_time: 2019-03-09 11:30:00
end_time: 2019-03-09 12:30:00
session_title: The debt trap
clean_description:
College students are taking on more and more debt to pay for their education. We'll walk you through a federal dataset called College Scorecard so you can make sense of the numbers and get story ideas. We'll also brainstorm ways to tell this $1.5 trillion story by focusing on students and others who are affected the most. This session was sponsored by the Lumina Foundation. IRE retains control of content, including the topic and speaker selection, for all conference sessions. 

speakers_cleaned:
Holly Hacker, The Dallas Morning News (moderator) ; Katie Beth Nichols, University of Arkansas; Annie Waldman, ProPublica 


name: The election and politics data you're not using
start_date_clean: 2019-03-08
start_time: 2019-03-08 09:00:00
end_time: 2019-03-08 10:00:00
session_title: The election and politics data you're not using
clean_description:
Beyond readily available campaign finance and elections results, there's a wealth of other election and political data that can produce stories throughout the election cycle. We'll take a closer look at congressional disclosures, election administration, Foreign Agent Registration Act (FARA) and others. 

speakers_cleaned:
Sarah Bryner, Center for Responsive Politics; Derek Willis, ProPublica (moderator); Michelle Ye He Lee, The Washington Post


name: The IRE Principles (Code of Conduct): A conversation with the IRE Board of Directors
start_date_clean: 2019-03-07
start_time: 2019-03-07 15:30:00
end_time: 2019-03-07 16:30:00
session_title: The IRE Principles (Code of Conduct): A conversation with the IRE Board of Directors
clean_description:
Several members of the IRE Board of Directors will be on hand to discuss the recent changes to the IRE Principles (Code of Conduct). This session is designed to be a conversation -- not a presentation -- so bring your questions. 

speakers_cleaned:
Matt Dempsey, Houston Chronicle; Doug Haddix, IRE & NICAR; Jennifer LaFleur, Investigative Reporting Workshop; T. Christian Miller, ProPublica; Steven Rich, The Washington Post; Jill Riepenhoff, InvestigateTV; Norberto Santana Jr., Voice of OC; Cheryl W. Thompson, NPR; Jodi Upton, Syracuse University; Nicole Vap, KUSA 9 News


name: The latest digital tools
start_date_clean: 2019-03-08
start_time: 2019-03-08 10:15:00
end_time: 2019-03-08 11:15:00
speakers_cleaned: Mike Reilley, MediaShift.org
session_title: The latest digital tools
clean_description:
Mike Reilley takes you on a deep dive round-up of breakout web tools and resources that promise to challenge conventional reporting processes and level up your journalist toolkit. From the latest data visualization and scraping techniques to sourcing tools, story discovery resources to mobile reporting apps -- this session will leave attendees with a more robust toolbelt and better prepared for sharing stories in 2019. 


name: The next 25 years of CAR
start_date_clean: 2019-03-09
start_time: 2019-03-09 16:45:00
end_time: 2019-03-09 17:45:00
session_title: The next 25 years of CAR
clean_description:
Rapid advances in technology and a shifting media landscape make it risky to predict the future of data journalism. But our intrepid panelists will venture into forecasting the tools and trends that will shape the next 25 years of data journalism. They'll also tackle emerging ethical and privacy concerns for journalists and the public alike. Come hear what may be in store for you and your newsroom in coming years! 

speakers_cleaned:
Len De Groot, Los Angeles Times, moderator; Shazna Nessa, Wall Street Journal; Latoya Peterson, ESPN


name: The state of data reporting outside major cities
start_date_clean: 2019-03-07
start_time: 2019-03-07 10:15:00
end_time: 2019-03-07 11:15:00
session_title: The state of data reporting outside major cities
clean_description:
What's life like for a data reporter who doesn't want to live in a major city? In this NICAR Commons session, talk to reporters who have been doing it for a long time and those just starting out. 

speakers_cleaned:
Erin Mansfield, Tyler Morning Telegraph; Ryan Thornburg, University of North Carolina at Chapel Hill 


name: This just in ... you can plan for breaking news
start_date_clean: 2019-03-08
start_time: 2019-03-08 14:15:00
end_time: 2019-03-08 15:15:00
speakers_cleaned: Chris Keller, Los Angeles Times (moderator); Rick Hirsch, Miami Herald; Nicole Vap, KUSA
session_title: This just in ... you can plan for breaking news
clean_description:
News breaks and journalists & editors scramble to react. Afterward shoulders are shrugged and we say "Forget it, Jake. It's breaking news." That's not how it needs to work. What if instead we could approach breaking news situations with a sense of calm and confidence? What if we considered the who, what, where, why and how of things that could happen, and simply left the when to chance?Let's have a discussion and develop a plan for covering the news that could/will happen in our market. 


name: Three open-source workflow tools that your newsroom could use today
start_date_clean: 2019-03-09
start_time: 2019-03-09 10:15:00
end_time: 2019-03-09 11:15:00
speakers_cleaned: Andrew Briz, POLITICO (moderator); Kavya Sukumar, Hearken; Allan James Vestal, Dallas Morning News
session_title: Three open-source workflow tools that your newsroom could use today
clean_description:
In this session, you will learn about three recently released open-source workflow tools and how they could be immediately useful to your newsroom: - gspan.js, a JavaScript library for transcribing and annotating CSPAN captions - Vizier, a GUI for ai2HTML projects. This app makes it easy to use the New York Times' ai2HTML plugin for turning Adobe Illustrator projects into responsive web graphics - socrata2sql, a Python library for quickly slurping data out of a Socrata portal into your database of choice 


name: Tiplines today: Techniques for secure source communications
start_date_clean: 2019-03-09
start_time: 2019-03-09 15:30:00
end_time: 2019-03-09 16:30:00
speakers_cleaned: Mike Tigas, ProPublica; Harlo Holmes, Freedom of the Press Foundation
session_title: Tiplines today: Techniques for secure source communications
clean_description:
Realizing that sources may need more secure methods of contacting journalists than the plain old telephone, modern media organizations worldwide have begun to look towards consumer-facing mobile apps (Signal, WhatsApp, Telegram, etc.) to create tiplines that can boast communications with increased confidentiality. While this switch is a welcome improvement in maintaining confidential communication with sources, it also comes with a new set of technical, logistical, and legal challenges. This session will address how major news orgs structure their tiplines; grapple with vulnerabilities while maximizing various security features; and craft proactive responses to legal, operational, and technical disasters. 


name: To manage or not: Choosing the right career path
start_date_clean: 2019-03-08
start_time: 2019-03-08 15:30:00
end_time: 2019-03-08 16:30:00
speakers_cleaned: Soo Oh, The Wall Street Journal; Kavya Sukumar, Vox Media
session_title: To manage or not: Choosing the right career path
clean_description:
Career growth is often equated with becoming a people manager. But what if people management is not your strength? Can it be learned? Let's talk about how to decide what is right for you, discuss career growth options that don't involve managing people and share tips, tricks and resources. 


name: Under pressure: Real life in real time with breaking news
start_date_clean: 2019-03-09
start_time: 2019-03-09 14:15:00
end_time: 2019-03-09 15:15:00
speakers_cleaned: Stephen Stock, NBC Bay Area
session_title: Under pressure: Real life in real time with breaking news
clean_description:
It’s become one of the hottest sessions at every CAR Conference. How would you and your newsroom fare in digging out little-known facts and information under the pressure of a breaking news deadline? One of the best ways to get better is to practice. This is a real-life scenario where you can learn to break news without leaving your computer. The skills learned in this session can also be used for turning daily general assignment stories when there’s not breaking news. This session regularly fills up and the tipsheet that comes with it is in high demand. 


name: Upping your Excel game *pre-registered attendees only
start_date_clean: 2019-03-09
start_time: 2019-03-09 09:00:00
end_time: 2019-03-09 12:30:00
speakers_cleaned: MaryJo Webster, Star Tribune
session_title: Upping your Excel game *pre-registered attendees only
clean_description:
Skill level: Intermediate 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. This is an intermediate Excel class intended for those who have mastered the basics, such as sorting, filtering, pivot tables and using functions. It is a fast-paced class intended to introduce you to these tools. You'll walk out with practice data and a 20-page tipsheet that covers in detail everything we do in class, plus other great Excel tips. 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. 


name: Using data to report on racial inequality
start_date_clean: 2019-03-07
start_time: 2019-03-07 16:45:00
end_time: 2019-03-07 17:45:00
session_title: Using data to report on racial inequality
clean_description:
Hear from journalists on the front lines of investigating racial, socioeconomic and other inequalities. Get story ideas as well as reporting and writing tips, along with advice on how best to frame stories in the proper historical context. Relevant public records and data sets also will be discussed. 

speakers_cleaned:
Bracey Harris, The Clarion-Ledger; Alden Loury, WBEZ; Emmanuel Martinez, Reveal from The Center for Investigative Reporting (moderator)


name: Using Datawrapper to quickly create charts and maps
start_date_clean: 2019-03-07
start_time: 2019-03-07 11:30:00
end_time: 2019-03-07 12:30:00
speakers_cleaned: Gus Wezerek, FiveThirtyEight
session_title: Using Datawrapper to quickly create charts and maps
clean_description:
Datawrapper is an increasingly popular online tool for visualizing data. This class will walk students through the creation of multiple types of charts and maps. **You must bring a laptop (and charger) to this session and sign up for a free account at datawrapper.de. This session is good for beginners looking for a data visualization solution that doesn't require learning to code. 


name: Using public records laws to get data
start_date_clean: 2019-03-08
start_time: 2019-03-08 11:30:00
end_time: 2019-03-08 12:30:00
session_title: Using public records laws to get data
clean_description:
A how-to on crafting the best-worded FOIA and state public records queries along with tips on how to actually get the documents you need for compelling investigations. 

speakers_cleaned:
Chris Baxter, NJ Advance Media; Norberto Santana, Voice of OC (moderator); Katie Townsend, Reporters Committee for Freedom of the Press 


name: Web scraping with Python (Saturday) *pre-registered attendees only
start_date_clean: 2019-03-09
start_time: 2019-03-09 14:15:00
end_time: 2019-03-09 17:45:00
clean_description:
Skill level: Beginner/intermediate 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 data file. We'll introduce you to the command line and show you how to write enough code to fetch, parse and analyze web content. Preregistration is required and seating is limited. Laptops will be provided for the training. Workshop prerequisites: This class is programming for beginners. Some basic familiarity with HTML and Python is helpful but not required. 


name: Welcome first-timers
start_date_clean: 2019-03-07
start_time: 2019-03-07 08:30:00
end_time: 2019-03-07 08:50:00
speakers_cleaned: Doug Haddix & Denise Malan, IRE/NICAR
session_title: Welcome first-timers
clean_description:
Welcome to the conference! 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. 


start_date_clean: 2019-03-07
start_time: 2019-03-07 18:00:00
end_time: 2019-03-07 19:00:00
name:
Welcome Reception and celebration of the 25th CAR Conference (Sponsored by<a0>Google News Initiative)

clean_description:
Join us for a special celebration of the 25th CAR conference during our welcome reception on Thursday, beginning at 6 p.m. Reconnect with longtime friends, welcome new attendees and meet special surprise guests! Each attendee will receive one drink ticket for beer, wine, soda or bottled water. Light snacks also will be served. 


name: What the hell is D3? And other questions you're afraid to ask
start_date_clean: 2019-03-07
start_time: 2019-03-07 09:00:00
end_time: 2019-03-07 10:00:00
speakers_cleaned: Disha Raychaudhuri, NJ Advance Media; Mark Walker, The New York Times
session_title: What the hell is D3? And other questions you're afraid to ask
clean_description:
Ever wondered what people are talking about at this conference? What exactly is D3 and why would you want to use it? What is the difference between Ruby, Python and Javascript? And why is there a J in front of Query? Welcome to our no-judgment, starting-at-step-zero session even NICAR veterans can use. We'll review tech concepts and jargon you'll likely hear at NICAR this year and explain what they mean, why they're useful and point you to the sessions that can teach you the terms you now understand. 


name: What<92>s new in Excel Online for analysis and visualization
start_date_clean: 2019-03-07
start_time: 2019-03-07 10:15:00
end_time: 2019-03-07 11:15:00
speakers_cleaned: Theresa Estrada, Microsoft
session_title: What’s new in Excel Online for analysis and visualization
clean_description:
Excel Online is free software that brings you features you’ve known and loved from Excel: you can now summarize your data with pivot tables, apply conditional formatting for report generation, all while collaborating with others. In addition, intelligent cloud-backed Office365 features such as Stocks and Geography data types open up Excel/Excel Online to recognize more than text and numbers and Ideas in Excel helps you identify interesting trends and patterns in your data, providing charts with formatting and titles as well as accelerating data analysis and understanding. 


name: When the data talks (but the people won't)
start_date_clean: 2019-03-08
start_time: 2019-03-08 14:15:00
end_time: 2019-03-08 15:15:00
session_title: When the data talks (but the people won't)
clean_description:
Strategies for analyzing data that sources won't explain. How to get around roadblocks and convince people to talk to you. 

speakers_cleaned:
Cary Aspinwall, The Dallas Morning News; Robert Benincasa, NPR (moderator); Sarah Rafique, KXAN/NBC Austin 


name: Which chart should I use, and why? Information design for the human brain!
start_date_clean: 2019-03-07
start_time: 2019-03-07 10:15:00
end_time: 2019-03-07 11:15:00
session_title: Which chart should I use, and why? Information design for the human brain!
clean_description:
We'll explore how research into the ways people estimate numbers will change how you think about choosing charts to tell your stories. And, no, it doesn't mean everything is a bar chart. We'll also discuss your problem charts and brainstorm improvements. Bring ideas for hard-to-visualize concepts and data. 

speakers_cleaned:
Nathaniel Lash, The Philadelphia Inquirer; Casey Miller, Mapbox , Ashlyn Still, Reuters (moderator); Troy Griggs, The New York Times


name: Which coding language should I learn?
start_date_clean: 2019-03-07
start_time: 2019-03-07 09:00:00
end_time: 2019-03-07 10:00:00
session_title: Which coding language should I learn?
clean_description:
You're pretty good at spreadsheets, sure, but maybe you're bumping up against the limits of a tool designed only to clean and analyze data. You'd like to start querying relational databases, scraping websites, making API calls, running statistical tests and/or building custom visuals to help tell your stories. If this describes you, it might be time to learn to code. But which coding language is right for you? In this session, newsroom coders who speak some of the most popular programming languages (SQL, Python, R and JavaScript) discuss common uses for each and show you how to get started. 

speakers_cleaned:
Ryan Murphy, The Texas Tribune; Caitlin Ostroff, Miami Herald; Christine Zhang, Baltimore Sun; Jennifer Peebles, Atlanta Journal-Constitution, Armand Emamdjomeh, The Washington Post (moderator)


name: Women in journalism meetup
start_date_clean: 2019-03-08
start_time: 2019-03-08 11:30:00
end_time: 2019-03-08 12:30:00
speakers_cleaned: Jenifer McKim, NECIR; Nicole Vap, KUSA; Kavya Sukumar, Hearken
session_title: Women in journalism meetup
clean_description:
This session will be an off-the-record discussion about being a woman in journalism. Some topics we'll bring up will include: negotiating your pay and the pay gap, balancing family and work, challenges and advice on climbing the ladder, dealing with sexist accusations about your reporting and pushing back when you know you have a good story. 


name: Workbench: Reproducible data work without coding
start_date_clean: 2019-03-07
start_time: 2019-03-07 15:30:00
end_time: 2019-03-07 16:30:00
speakers_cleaned: Jonathan Stray, Columbia Journalism School
session_title: Workbench: Reproducible data work without coding
clean_description:
Workbench is an open source tool that puts all stages of the data journalism process in one workspace, 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. Clean and explore data, monitor sources, create live embeddable charts that update when new data is released, or build useful queries that other journalists can use to report on a data set. Workbench is built to help make data tasks accessible to more people in the newsroom. **You must bring a laptop, with either Google Chrome or Firefox web browsers installed, to participate in this class. This session is good for journalists of all skill levels. 


name: Write better Python code *pre-registered attendees only
start_date_clean: 2019-03-09
start_time: 2019-03-09 09:00:00
end_time: 2019-03-09 12:30:00
session_title: Write better Python code *pre-registered attendees only
clean_description:
Skill level: Intermediate/advanced 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. 

speakers_cleaned:
Eric Sagara, Reveal from The Center for Investigative Reporting; Serdar Tumgoren, The Associated Press


name: Year in CAR: Local innovation
start_date_clean: 2019-03-07
start_time: 2019-03-07 09:00:00
end_time: 2019-03-07 10:00:00
speakers_cleaned: Chase Davis, Star Tribune (moderator)
session_title: Year in CAR: Local innovation
clean_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: The New York Times, The Washington Post, any number of digital-first startups — 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. 


name: Year in international CAR
start_date_clean: 2019-03-10
start_time: 2019-03-10 11:30:00
end_time: 2019-03-10 12:30:00
session_title: Year in international CAR
clean_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_cleaned:
John Bones, SKUP Norway ; Marianne Bouchart, Data Journalism Awards; Marina Walker, International Consortium for Investigative Journalism  


name: You just survived NICAR19! Now what?
start_date_clean: 2019-03-10
start_time: 2019-03-10 09:00:00
end_time: 2019-03-10 10:00:00
clean_description:
You've just spent the past three days absorbing as much information as possible and now it's time to go home and put it all to use. But where do you start? And how do you not immediately lose all that knowledge you just gained? Come to this session to get simple tips and tricks to bring it all home and put it to good use. You'll also learn how IRE can help you ride the NICAR wave long after Newport Beach. 


