data

Custom SQL query returning 263 rows (show)

event_uidevent_nameevent_descriptionevent_dtstartevent_dtendevent_tzid
2489 Conference registration Conference registration will be located on the 2nd floor in Preservation Foyer. Be sure to stop by and pick up your conference name badge. Name badges must be worn during the conference. Preservation Foyer - 2nd 2020-03-04T15:00:00 2020-03-04T18:00:00 America/Chicago
2489 Conference registration Conference registration will be located on the 2nd floor in Preservation Foyer. Be sure to stop by and pick up your conference name badge. Name badges must be worn during the conference. Preservation Foyer - 2nd 2020-03-05T07:30:00 2020-03-05T18:00:00 America/Chicago
2490 Conference sales Stop by the NICAR sales table located in Preservation Foyer on the 2nd floor to browse books from the IRE store, IRE merchandise and shirts with the winning design from the T-shirt contest. Studio Foyers - 2nd 2020-03-05T07:30:00 2020-03-05T18:00:00 America/Chicago
2491 International meet and greet An opportunity for international attendees to network. Carondelet - 3rd 2020-03-05T07:30:00 2020-03-05T08:15:00 America/Chicago
1129 Welcome first timers! How to make the most of NICAR20 Welcome to the conference! Get a special button for first-time attendees and hear from IRE staff about tips and tactics to navigate our conference like a pro. Also, you'll learn about key resources that IRE offers once you're back home. Acadia - 3rd Doug Haddix, IRE & NICAR;Denise Malan, IRE & NICAR 2020-03-05T08:30:00 2020-03-05T08:50:00 America/Chicago
1000 PyCAR This hands-on workshop will teach journalists basic programming concepts using the Python language. The class, spread over two half-days, will introduce language basics and useful libraries in the course of a typical reporting project: scraping data from the web, analyzing a spreadsheet and visualizing the results. Preregistration is required and seating is limited. Laptops will be provided for the training. Workshop prerequisites: Although the class is geared toward programming beginners, attendees should have familiarity with the command line and be comfortable with databases and SQL. Studio 3 - 2nd Tom Meagher, The Marshall Project;Jacob Quinn Sanders, Factal;Elaine Wong, CBC/Radio-Canada 2020-03-05T09:00:00 2020-03-05T12:30:00 America/Chicago
1008 Upping your Excel game If you've found yourself struggling in a spreadsheet, thinking that whatever you were trying to achieve seemed harder than it should've been, then this is the class for you. We’ll learn about various tools and functions in Excel that come in handy when you need to re-structure or otherwise get your data ready for analysis. We'll cover string functions, logical functions, date functions, reshaping data, merging data using lookup functions and perhaps a few other nifty tricks if time allows. We’ll do some “drills” introducing you to these concepts, then put your new skills to work in a sort of “scrimmage,” fixing up some real-life data. You’ll also walk out with practice data and a 30-page tipsheet that covers, in detail, everything from the class, plus more that we won’t have time for. Preregistration is required and seating is limited. Laptops will be provided for the training. Workshop prerequisites: You should have prior experience using Excel or Google Sheets, and be comfortable with introductory-level spreadsheet skills, such as sorting, filtering, SUM and AVERAGE functions, calculations such as percentage change or percent of total, and how to use pivot tables. Studio 2 - 2nd MaryJo Webster, The Star Tribune 2020-03-05T09:00:00 2020-03-05T12:30:00 America/Chicago
1013 Interviewing your data with SQL If you flip over pivot tables, but wish you had more data tools, this session is for you. Structured Query Language, or SQL, can help you use powerful filtering functions, find patterns in millions of records and join multiple data tables. This class will be taught by two experienced data reporters and former IRE trainers, and materials will include the IRE data boot camp binder, full of exercises, cheat sheets and tips to help you boost your data analysis and storytelling skills. We will use a free database manager that can be easily installed and used on any computer. Preregistration is required and seating is limited. Laptops will be provided for the training. Workshop prerequisites: The only prerequisites are a reasonable comfort level with using a spreadsheet. No previous SQL skills necessary. Studio 4 - 2nd Elizabeth Lucas, Kaiser Health News;Megan Luther, InvestigateTV 2020-03-05T09:00:00 2020-03-05T17:45:00 America/Chicago
1016 Master class: Editing the data story Managing a data project presents challenges for any editor. No matter your comfort level with data, this half-day workshop will give you the foundation you need to help make sure your reporters aren’t running with scissors or spinning their wheels on data projects. Two veteran editors, Jennifer LaFleur of The Investigative Reporting Workshop and Maud Beelman of the Howard Center for Investigative Journalism at Arizona State University, will guide you through the ins and outs of data journalism from an editor’s point of view, including: * How to help reporters find focus for their data stories * Being skeptical of data and finding potential pitfalls * Verifying analyses and bulletproofing data stories and apps * Using data to find human sources and characters for stories * Planning the best data workflows for your newsroom No data experience is necessary for this workshop. Editors/producers and those interested in newsroom management are welcome. Please bring your own laptop. Galerie 5 - 2nd Maud Beelman, Howard Center for Investigative Reporting;Jennifer LaFleur, Investigative Reporting Workshop 2020-03-05T09:00:00 2020-03-05T12:30:00 America/Chicago
1038 👋 Hello world! Choose your data adventure How do you want to NICAR? The options can be overwhelming, but at this session we can help you chart a path, whether you're looking to pick up some basic spreadsheet skills or learn how to use a fancy machine learning algorithm. Acadia - 3rd Simone Weichselbaum, The Marshall Project;Cody Winchester, IRE & NICAR 2020-03-05T09:00:00 2020-03-05T10:00:00 America/Chicago
1064 Excel 1: Getting started with spreadsheets 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. Studio 8 - 2nd Stephanie Lamm, The Houston Chronicle 2020-03-05T09:00:00 2020-03-05T10:00:00 America/Chicago
1137 Data Dive 1: The 2019 Philip Meyer winners A data deep dive into the 2019 Philip Meyer Award winners. Hear from reporters how they gathered, cleaned, analyzed and visualized the data behind some of the year's biggest stories. Bissonet - 3rd Sarah Cohen, Walter Cronkite School of Journalism, Arizona State University;Ren Larson, The Arizona Republic;Benjamin Lesser, Reuters;Sean McMinn, NPR;Janet Roberts, Reuters;Carolyn Thompson, Independent journalist 2020-03-05T09:00:00 2020-03-05T10:00:00 America/Chicago
2045 Regular expressions for the rest of us Regular expressions are a powerful tool when working with data. They're supported by a variety of text editors, databases and programming languages, but they can be intimidating. Get familiar with the basics of regular expressions and how they can help with your next batch of dirty data. This session is good for: People who have ever done more than two search/replace actions to clean a data set, or had to split a ZIP code from an address or otherwise want to conquer their fears of regex. Studio 10 - 2nd Justin Myers, The Associated Press 2020-03-05T09:00:00 2020-03-05T10:00:00 America/Chicago
2061 Finding needles in haystacks with fuzzy matching Fuzzy matching is a process for linking up names that are similar but not quite the same. It has become an increasingly important part of data-led investigations as a way to identify connections between public figures, key people and companies that are relevant to a story. This class will cover how fuzzy matching typically fits into the investigative process, with some story examples. Max Harlow, who developed the CSV Match command line tool, will show you how to run some of the different types of fuzzy matching on some real datasets, including the pros and cons of each. This session is good for: People who feel comfortable using the command line. Studio 9 - 2nd Max Harlow, The Financial Times 2020-03-05T09:00:00 2020-03-05T10:00:00 America/Chicago
2091 Introduction to VisiData VisiData is a fast, powerful, keyboard-driven tool for quickly exploring datasets. It's often the first piece of software I use to examine new data. In this hands-on session, you'll learn VisiData's essentials commands — including how to sort, filter, summarize and aggregate. This session is good for: People who have a basic familiarity with your computer's command line interface. No programming knowledge necessary, but some knowledge of Python is a plus. Studio 6 - 2nd Jeremy Singer-Vine, BuzzFeed News 2020-03-05T09:00:00 2020-03-05T10:00:00 America/Chicago
2170 Tracking money spent on candidates up and down the ballot in 2020 The 2020 election will see record levels of spending. This panel will provide a host of useful tips and advice on how to best track the money spent on candidates up and down the ballot. Experts will explain how to use FEC.gov, OpenSecrets.org, FollowTheMoney.org and other sources to find the patterns — and anomalies — that will help you uncover relationships hidden in campaign finance data. Galerie 3 - 2nd Sandra Fish, Independent journalist;Denise Roth Barber, National Institute On Money In Politics;Ben Wieder, McClatchy 2020-03-05T09:00:00 2020-03-05T10:00:00 America/Chicago
2240 How I learn to tell stories with data With a dizzying number of tools and methods to learn data, what works best for journalism students learning how to tell good and accurate stories with data? In this session, we'll ask the students! Journalism educators and students alike should benefit from this discussion of methods that help students learn sound data principles and continue adapting to new tools. Galerie 4 - 2nd Sophia Brown, Boston University;Kimberly Cataudella, Investigative Reporting Workshop;Theresa Diffendal, University of Maryland Philip Merrill College of Journalism;Maggie Mulvihill, Boston University 2020-03-05T09:00:00 2020-03-05T10:00:00 America/Chicago
2326 How the internet works (so you can scrape the web!) Need to scrape a web page? Using tools included with modern browsers, you will learn how to inspect the code behind a website and monitor network traffic to help you target information for extraction. Galerie 6 - 2nd Andrew Chavez, The New York Times 2020-03-05T09:00:00 2020-03-05T10:00:00 America/Chicago
2430 Negotiating for data at scale Negotiating a single public records request for data can be challenging, so how do you scale that up when you are requesting data from multiple agencies? This panel will discuss strategies and tools for handling requests sent out to dozens, hundreds and even thousands of agencies. We will cover the entire process from making initial requests to negotiating with agencies to finally receiving results. Galerie 2 - 2nd Ellen Gabler, The New York Times;Cheryl Phillips, Stanford University 2020-03-05T09:00:00 2020-03-05T10:00:00 America/Chicago
2471 Finding the story: Census data Census data can bring context and depth to stories on practically any beat. It can also be overwhelming to sift through and find what you need. This hands-on session will walk you through a real census dataset to help you find stories hidden in all that demographic data. This session is good for: Those who have some experience with spreadsheets. Studio 7 - 2nd Joe Germuska, Northwestern University Knight Lab 2020-03-05T09:00:00 2020-03-05T10:00:00 America/Chicago
2481 "Scrollytelling" with MapBox Build a scrollytelling experience using Mapbox Studio and the new Storytelling Solution by Mapbox with little to no code. In this session, you’ll learn to quickly create a scrollytelling map using Mapbox’s new template and publish the results on Glitch. This session is good for: Those who are familiar with mapping concepts. Studio 1 - 2nd Lo Bénichou, Mapbox 2020-03-05T09:00:00 2020-03-05T10:00:00 America/Chicago
2488 Exhibitors and recruiters Be sure to stop by the Studio foyers on the 2nd floor and visit with the exhibitors/recruiters. Studio Foyers - 2nd 2020-03-05T09:00:00 2020-03-05T17:00:00 America/Chicago
1065 Excel 2: Formulas & sorting 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. Studio 8 - 2nd Carli Brosseau, The News & Observer 2020-03-05T10:15:00 2020-03-05T11:15:00 America/Chicago
1119 GitHub for journalists We'll cover Github's basic features — repositories, commits, branches, pull requests and issues — using a recent data-driven story as a case study. The goal is for you to leave the class and be able to use GitHub on your own for your next story. Please note: You will need to bring your own laptop to participate in this class. You will also need to have created an account at GitHub.com and install GitHub Desktop prior to the class. This session is good for: Journalists who want to collaborate on data analyses, back up their work and share their methodology with (nerdy) readers. Studio 1 - 2nd Brent Jones, St. Louis Public Radio 2020-03-05T10:15:00 2020-03-05T11:15:00 America/Chicago
1135 Mining data into TV gold You see numbers; we see compelling television. Stuck looking at interminable spreadsheets and numbers that make your head swim? In this session you’ll learn how to use data to find good stories and then turn that data and all those “boring numbers” into compelling, visual television that will make your bosses and your audience sit up and take notice. We’ll even have examples of stories you can take home and do in your community. Galerie 2 - 2nd Jodie Fleischer, WRC-TV NBC4 Washington;A.J. Lagoe, KARE11;Stephen Stock, NBC Bay Area 2020-03-05T10:15:00 2020-03-05T11:15:00 America/Chicago
2058 Finding the story: Using natural language processing in social media research Ever felt lost poring over a massive archive? Want to churn up interesting stories from social networks, chat archives, or forums with (relative) ease? Why not try using a little natural language processing (NLP)! This session will give you a taste of how to apply a blend of linguistics and AI to the text-based world of the internet. You will learn some basic NLP concepts, and how to apply them to online texts using the Python package Spacy. You'll be able to walk out of this session ready to start digging through data of your own. This session is good for: People who are comfortable working in Python. Studio 9 - 2nd Madeleine Varner, The Markup 2020-03-05T10:15:00 2020-03-05T11:15:00 America/Chicago
2124 How to negotiate for data and records The struggle is real. We'll discuss how to wrench the data/records out of agencies who don’t want to make it easy on you. Learn how to negotiate, sweet talk and strong-arm when you need to. Bissonet - 3rd Cary Aspinwall, The Marshall Project;Matt Dempsey, Houston Chronicle;Matthew Topic, Loevy & Loevy;Jodi Upton, Syracuse University 2020-03-05T10:15:00 2020-03-05T11:15:00 America/Chicago
2158 How to make charts less bad Good data visualization design helps maximize your story's impact by making it easier to understand and more engaging. This session covers the basic dos and don'ts for data visualization. We will discuss how different design strategies can help or hurt your story, with plenty of examples from leading journalism outlets. We will also share a tipsheet of design resources (books, online/offline communities, documentaries, podcasts) to help attendees explore further post-NICAR. Galerie 6 - 2nd Anna Flagg, The Marshall Project;Sean McMinn, NPR;Moiz Syed, ProPublica 2020-03-05T10:15:00 2020-03-05T11:15:00 America/Chicago
2169 My own worst enemy: Overcoming impostor syndrome Did you ever get the feeling that you're a fraud and it's only a matter of time before someone finds out? Congratulations! You may have impostor syndrome. We will explore the causes of impostor syndrome, including the systemic factors that drive it, and provide evidence-based strategies for coping. Galerie 4 - 2nd Melissa Lewis, Reveal from The Center for Investigative Reporting;Kate Martin, Carolina Public Press 2020-03-05T10:15:00 2020-03-05T11:15:00 America/Chicago
2197 Newsroom web scraping with JavaScript If you want to scrape websites, crawl them, extract their data, take screenshots and deal with any interactive elements, this class will show you how. A great way to scrape websites that rely heavily on JavaScript is to scrape them using JavaScript. Cypress and Puppeteer are great tools to use; Puppeteer is a Node project which provides an API to control the Chrome browser, and Cypress is normally used for site testing. We'll show you how these tools can be used to gather data for your stories, and how they fit into a newsroom data pipeline. This session will provide demos of how to scrape with both. This session is good for: People with intermediate knowledge of JavaScript and Node. Studio 6 - 2nd Alison Benjamin, BBC News;Jon Keegan, The Markup 2020-03-05T10:15:00 2020-03-05T11:15:00 America/Chicago
2258 Covering immigration with data 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. Acadia - 3rd Sophie Chou, ProPublica;Kristian Hernández, Fort Worth Star-Telegram;Tanvi Misra, CQ Roll Call 2020-03-05T10:15:00 2020-03-05T11:15:00 America/Chicago
2322 Newsroom open-source tool showcase A lightning-round showcase of innovative newsroom tools that can help you manage mass FOIAs, automate web scraping, analyze large document dumps with artificial intelligence and track how special interests influence statehouse legislation. Galerie 3 - 2nd Justin Mayo, Big Local News 2020-03-05T10:15:00 2020-03-05T11:15:00 America/Chicago
2483 Data cleaning with OpenRefine 1: The basics Learn how to use OpenRefine, a powerful tool for quickly cleaning up dirty data. You'll learn about faceting, simple clustering, applying common data transformations and more. This session is good for people with basic experience working with data. Studio 10 - 2nd Tommy Kaas, Kaas & Mulvad;Nils Mulvad, Kaas & Mulvad 2020-03-05T10:15:00 2020-03-05T11:15:00 America/Chicago
2485 Create interactive demographic maps in minutes with ArcGIS Online 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. Studio 7 - 2nd Robby Deming, Esri;Christopher Vaillancourt, Esri 2020-03-05T10:15:00 2020-03-05T11:15:00 America/Chicago
1040 Investigating natural disasters: What to do before, during and after We'll talk about databases you need to be prepared before a disaster occurs, how to gather data in real-time, and long-range strategies for reporting on recovery efforts. Galerie 3 - 2nd Jeff Adelson, The Times-Picayune | The New Orleans Advocate;Laura Moscoso, Centro de Periodismo Investigativo ;Eric Sagara, Big Local News 2020-03-05T11:30:00 2020-03-05T12:30:00 America/Chicago
1054 Data and docs for your arsenal 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. Bissonet - 3rd Samah Assad, CBS Chicago/WBBM;Kate Martin, Carolina Public Press 2020-03-05T11:30:00 2020-03-05T12:30:00 America/Chicago
1066 Excel 3: Filtering & pivot tables 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. Studio 8 - 2nd Mark Walker, The New York Times 2020-03-05T11:30:00 2020-03-05T12:30:00 America/Chicago
1105 Python: Let's scrape a website This session will show you how to use the Python programming language to scrape data from websites. This session is good for: People who already feel comfortable writing simple Python scripts and understand basic syntax (data types, if/else statements, for loops, etc.). Experience with HTML is a plus but not necessary. Note: It would be useful to attend the demo session "How the internet works (so you can scrape the web!)" at 9 a.m. Thursday if you’re not familiar with the topic already. Studio 9 - 2nd Ryan Pitts, OpenNews 2020-03-05T11:30:00 2020-03-05T12:30:00 America/Chicago
1107 Google Sheets: Scraping without coding Yes, you can scrape data without using code -- in fact, all you need is Google Sheets! We'll be using Excel-type formulas (don't worry if you don't know what those are, either) to make simple scrapers that automatically pull data into Google Sheets. It’s the best way to get around clunky websites and unhelpful PIOs! This session is good for: Beginners who want to start using data for their stories. Studio 1 - 2nd Samantha Sunne, Independent journalist 2020-03-05T11:30:00 2020-03-05T12:30:00 America/Chicago
2144 Covering polls and understanding best polling practices for 2020 The 2020 presidential election is in full swing and with it comes the steady stream of horse race numbers. So which polls are methodologically sound? What’s the difference between an online poll and a telephone poll? What’s a “topline,” and why is it important? What’s an “n-size” and how much should it be? But most importantly: when is a dip or rise in vote choice worth writing about? Acadia - 3rd Joanna Piacenza, Morning Consult 2020-03-05T11:30:00 2020-03-05T12:30:00 America/Chicago
2160 Datasette: An ecosystem of tools for exploring data and collaborating on data projects Datasette is a growing ecosystem of tools for exploring and publishing data. With Datasette you can take raw data from a variety of different formats, import it into a SQLite-backed web interface, explore it, visualize it, map it and then publish it along with an API to enable further custom development. This workshop will introduce Datasette using Datasette Cloud, a new hosted service that allows you to run the tools and collaborate on data projects with members of your team. Topics covered will include: * Using Datasette Cloud to upload, explore and analyze data from a variety of sources * Using full-text search and facets to quickly analyze large and complex datasets * Visualizing numeric and geographic data using Datasette plugins * Running Datasette and associated tools on your own machine using the command line This session is good for anyone. Basic familiarity with SQL and the command line is helpful but not necessary. Studio 6 - 2nd Simon Willison, JSK Fellowships at Stanford 2020-03-05T11:30:00 2020-03-05T12:30:00 America/Chicago
2456 Bringing data journalism to your student newsroom Many journalists and journalism educators run from numbers and data because the words are scary without an understanding of real-world applications. At Loyola University New Orleans we have had success making data come alive for our students by partnering with InvestigateTV on projects so students can relate to the numbers and see how data is used professionally. We will discuss our projects and give ideas for finding partners so you can do the same whether you are an educator looking to enhance classroom learning, a student who wants to intern or work on a newsroom data project, or a professional eager for data help from a nearby university. Galerie 4 - 2nd Laura Jayne, Loyola University New Orleans;Anum Siddiqui, Loyola New Orleans University;Erin Snodgrass, Loyola University New Orleans 2020-03-05T11:30:00 2020-03-05T12:30:00 America/Chicago
2461 Covering the Coronavirus: Reporting on local emergency preparedness Details coming soon! Galerie 2 - 2nd Sarah A. Babcock, New Orleans Health Department;Anna Maria Barry-Jester, Kaiser Health News;Caroline Chen, ProPublica 2020-03-05T11:30:00 2020-03-05T12:30:00 America/Chicago
2479 Making graphics with R It’s easy to make slick data visualizations with R’s ggplot library. But ggplot also has all the capacity you need to build sophisticated, production-ready charts without ever leaving R. Come break away from theme_grey() and learn how you can make your ggplots shine. This class is best for: People who are comfortable with Excel and looking for something more powerful; beginner knowledge of R is good but not required. Studio 7 - 2nd David Montgomery, Minnesota Public Radio News 2020-03-05T11:30:00 2020-03-05T12:30:00 America/Chicago
2484 Data cleaning with OpenRefine 2: More advanced uses This class will cover more advanced techniques for cleaning data using OpenRefine, including regular expressions and writing custom cleaning scripts. The session is good for people who are comfortable using the basic functions of OpenRefine. Studio 10 - 2nd Tommy Kaas, Kaas & Mulvad;Nils Mulvad, Kaas & Mulvad 2020-03-05T11:30:00 2020-03-05T12:30:00 America/Chicago
2503 Introduction to Google Data Studio Data Studio helps you tell beautiful stories with data. Using this free tool from Google, you can: *Visualize your data through highly configurable charts and tables *Easily connect to a variety of data sources *Share your insights with your team or with the world *Collaborate on reports with your team. *Speed up your report creation process with built-in sample reports. This presentation will cover the basics of connecting to data and creating and customizing a report, and demonstrate some of the more advanced features. We'll also take a look at some of the many public reports that have been created using Data Studio. Galerie 6 - 2nd Rick Elliott, Google 2020-03-05T11:30:00 2020-03-05T12:30:00 America/Chicago
1025 Journalists of color in the newsroom meetup Grab some lunch and join other journalists of color for a networking and discussion session. IRE & NICAR will provide snacks, drinks and dessert. Carondelet - 3rd Caroline Chen, ProPublica 2020-03-05T12:45:00 2020-03-05T14:00:00 America/Chicago
1002 Intro to R We'll introduce you to R, a free, powerful open-source programming language that will take your data reporting to the next level. By the end of this three-hour session, you will be able to read data from common file types into R, clean and explore it, create visualizations, and make your entire data workflow reproduceable. We'll also talk about how to find help when you're stuck. Preregistration is required and seating is limited. Laptops will be provided for the training. Workshop prerequisites: This session will be most helpful if you’re comfortable working with data and you’re ready to take your skills to the next level. Studio 2 - 2nd Hannah Fresques, ProPublica;Agnel Philip, ProPublica 2020-03-05T14:15:00 2020-03-05T17:45:00 America/Chicago
1014 Introduction to web development This session will introduce you to how the web works and the building blocks of web development: HTML, CSS and (a tiny bit of) JavaScript. By the end of the class, you will have built a simple web page and published it on the internet. Preregistration is required and seating is limited. Laptops will be provided for the training. Workshop prerequisites: This session is good for beginners -- no experience necessary. Studio 9 - 2nd Sisi Wei, OpenNews 2020-03-05T14:15:00 2020-03-05T17:45:00 America/Chicago
1015 First Observable notebook: Prototyping with polish Alex Garcia, Ellis Simani, Ben Welsh and Aaron Williams teach you how to rapidly prototype a complex data visualization with JavaScript, D3.js and an interactive Observable notebook. This three-hour, hands-on course will show you how journalists are putting Observable’s powerful potential to work. Using nothing but your web browser, you will sketch, refine and publish an interactive graphic like one that appeared in The New York Times. Along the way, you’ll see how Observable’s groundbreaking approach to coding can help you be more creative, ambitious and efficient. Preregistration is required and seating is limited. Laptops will be provided. Workshop prerequisites: If you’ve used JavaScript once or twice, have a good attitude and know how to take a few code crashes in stride, you are qualified for this class. If you’re suspicious and think we might be Internet hipsters, we welcome the challenge of winning you over. This stuff is cool. Studio 3 - 2nd Alex Garcia, University of California San Diego;Ellis Simani, ProPublica;Ben Welsh, Los Angeles Times 2020-03-05T14:15:00 2020-03-05T17:45:00 America/Chicago
1021 Master class: Statistics for journalists Statistical methods can help you go beyond counting, sorting and filtering data to look at relationships, make predictions and level the playing fields. Statistical analyses can provide hard evidence to back up (or discredit) a theory. This master class will help you understand the concepts and methods most often used by journalists, including: * Linear regression * Correlation * Statistical significance * Describing and visualizing your data This master class is aimed at those already familiar with basic data analysis using spreadsheets and ready to add statistical analysis to their toolkits. Please bring your laptop to the training. Before the conference, please install R and R Studio (free, open-source software) on your computers. Galerie 5 - 2nd Steve Doig, Arizona State University;Holly Hacker, The Dallas Morning News 2020-03-05T14:15:00 2020-03-05T17:45:00 America/Chicago
1049 Free and easy data viz 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. Galerie 2 - 2nd Jamie Grey, InvestigateTV;Erin Mansfield, USA Today Network 2020-03-05T14:15:00 2020-03-05T15:15:00 America/Chicago
1070 Excel: Advanced pivot tables 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. Studio 8 - 2nd Kimbriell Kelly, Los Angeles Times 2020-03-05T14:15:00 2020-03-05T15:15:00 America/Chicago
1083 R 1: Intro to R and RStudio Jump into statistics with R, the powerful open-source programming language. In this class we’ll cover R fundamentals and learn our way around the RStudio interface for using R. This session is good for: People with a basic understanding of code who are ready to go beyond Excel. Studio 7 - 2nd Rob Wells, University of Arkansas 2020-03-05T14:15:00 2020-03-05T15:15:00 America/Chicago
1099 Python 1: The fundamentals An introduction to the Python programming language for absolute beginners. This session will cover the fundamentals and basic syntax to prepare you for more advanced classes. This session is good for: People who are comfortable working with data in spreadsheets or database managers and want to make the leap to programming. Studio 6 - 2nd Caitlin Ostroff, The Wall Street Journal 2020-03-05T14:15:00 2020-03-05T15:15:00 America/Chicago
2050 Finding the story: Using DNS search for investigative journalism Every online interaction begins with a lookup in the Domain Name System (DNS), the backbone of the Internet. As a result, there are digital footprints left behind in the DNS. With the demise of Whois, investigative reporters are looking for new tools to uncover these footprints. Learn how to use DNSDB Scout, a tool to query DNSDB, a historical passive Domain Name System (DNS) database, to discover previously unknown online connections and gain new information to advance your ongoing and breaking news investigations. Basic knowledge of the Domain Name System (DNS) is helpful, but not required. Studio 1 - 2nd Paul Vixie, Farsight Security, Inc. 2020-03-05T14:15:00 2020-03-05T15:15:00 America/Chicago
2161 Campaign finance questions people ask … plus yours! Join four veterans of working with campaign finance data as they take you through a series of common (and uncommon but good) questions journalists are likely to ask when using it. We’ll have a list of questions to answer; bring yours and we’ll try to answer them, too! Galerie 4 - 2nd Sheila Krumholz, Center for Responsive Politics;Anna Massoglia, Center for Responsive Politics;Derek Willis, ProPublica;Chris Zubak-Skees, Center for Public Integrity 2020-03-05T14:15:00 2020-03-05T15:15:00 America/Chicago
2378 Using open crime and policing data Open data provides unique insights into crime, policing and criminal justice activity within a city and creates a new opportunity to tell complex, interactive stories in dashboard format. These data are a terrific source for identifying changing crime trends, evaluating policy effectiveness, and providing transparency to the public on issues of critical importance. In this presentation Jeff Asher of AH Datalytics will go over the different types of available data throughout the criminal justice spectrum and give examples of how these data can be used both in terms of analyzing crime trends as well as building dashboards to better illustrate a story. Galerie 3 - 2nd Jeff Asher, AH Datalytics 2020-03-05T14:15:00 2020-03-05T15:15:00 America/Chicago
2423 Year in CAR: Local innovation So often the most celebrated examples of innovation in digital, visual and interactive journalism come from teams with uncommon access to resources and talent. You know the ones, often on the coasts, that continually set the industry standard for digital innovation. This panel isn't about those newsrooms. Instead, it will showcase the creative digital storytelling happening in local and regional newsrooms, where time and resources are scarce. The panel will be framed as a series of short talks and examples and will include an ability for journalists who cannot attend NICAR to present their work as well. Acadia - 3rd Chase Davis, Minneapolis Star Tribune 2020-03-05T14:15:00 2020-03-05T15:15:00 America/Chicago
2451 Diverse newsrooms can produce better journalism: Let's make it happen 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. Bissonet - 3rd Anna Flagg, The Marshall Project;David McKie, National Observer;Kae Petrin, St. Louis Public Radio;Paul Cheung, Knight Foundation 2020-03-05T14:15:00 2020-03-05T15:15:00 America/Chicago
2462 Finding and researching international connection How do we follow people, money and assets when they cross borders? How do we find the hidden cash of Kleptocrats? We’ll discuss sources, tools and communities being used by investigative reporters to find personal, company and government information around the world. Galerie 6 - 2nd Leila Haddou, Independent journalist;Friedrich Lindenberg, Organized Crime and Corruption Reporting Project;Margot Williams, The Intercept 2020-03-05T14:15:00 2020-03-05T15:15:00 America/Chicago
2495 Mastering Google Sheets: Web scraping, running scripts and other tricks (Thursday) Google Sheets is more than just free spreadsheet software to organize and store data. This hands-on session will start with pivot tables and conditional formatting, and through examples, we'll also learn how to scrape data in seconds without code, automate menial tasks with macros, write custom spreadsheet formulas as well as how to send emails, geocode addresses, translate text and more – all through the power of Google Sheets. Come with a laptop and leave with the knowledge of a Google Sheets power user. Preregistration is required and seating is limited. You musthave a Google account. Computers will be provided. Workshop prerequisites: You should be familiar with using spreadsheets and formulas. Studio 10 - 2nd Frank Bi, Vox Media 2020-03-05T14:15:00 2020-03-05T17:45:00 America/Chicago
1084 R 2: Data analysis and plotting 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. Studio 7 - 2nd Maureen Linke, Wall Street Journal 2020-03-05T15:30:00 2020-03-05T16:30:00 America/Chicago
1100 Python 2: Intro to data analysis using Pandas 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. Studio 6 - 2nd Cody Winchester, IRE & NICAR 2020-03-05T15:30:00 2020-03-05T16:30:00 America/Chicago
1111 PDF 1: How to extract text and tables from PDFs like a boss This class will cover basic approaches for getting text out of PDF documents using online tool Cometdocs. IRE members have free subscriptions, which means no limit to the number of documents to convert. (No attendance is necessary, just email cometdocs@ire.org). For extracting tables, you'll play with Tabula in a step-by-step demo. In addition, you'll learn how to use a text editor and the import feature in Excel if neither of these approaches work. Lastly, if time allows, you'll see a demo of PDFtk, used for merging, splitting, and rotating a large batch of PDFs. Note that we will not cover Optical Character Recognition as it will be addressed in PDF2. This session is good for: Non-coders without access to Adobe Acrobat Pro/DC and people who are unfamiliar with PDF-to-text tools or would like to learn how these tools can be used for extracting difficult text from images embedded in a PDF document. Studio 8 - 2nd Kevin Crowe, USA Today 2020-03-05T15:30:00 2020-03-05T16:30:00 America/Chicago
2077 Uncloaked: Flight tracking for investigating people, planes and patterns Reporters might track private aircraft a CEO or head coach is using to scope out a new headquarters or hire, uncover patterns of surveillance by law enforcement or military aircraft, or detect planes or people possibly involved in illegal activity. This session will help you understand how flight tracking works and what tools and organizations are available to help you take off, including how to set up your own feeder with a simple device and an antenna. Get beyond efforts to block identifying aircraft with solutions from representatives of ADS-B Exchange and C4ADS. Galerie 2 - 2nd Patrick Baine, C4ADS;Jake Glass, C4ADS;Paula Lavigne, ESPN;James Stanford, ADSBexchange.com 2020-03-05T15:30:00 2020-03-05T16:30:00 America/Chicago
2165 Tracking dark money in the 2020 elections Dark money is already playing a major role in 2020 elections. This panel will provide an overview of what you need to know to uncover dark money activity and try to find out who is behind it. Learn how to follow the money trails with tools and techniques to track secretive groups, piece together opaque spending networks, and uncover donors through political ad records, corporate records, and campaign finance data as well as filings with the Internal Revenue Service, Department of Labor, Congress, and more. Bissonet - 3rd Michael Beckel, Issue One;Robert Maguire, Citizens for Responsibility and Ethics in Washington;Anna Massoglia, Center for Responsive Politics 2020-03-05T15:30:00 2020-03-05T16:30:00 America/Chicago
2216 Investigating bias: From housing to policing Racial biases are pervasive in many of our public systems, from policing to housing to education. Learn how you can pinpoint potential bias on your beat, and how to use additional reporting methods to make sure the evidence is there. Acadia - 3rd Ko Bragg, FRONTLINE/PBS;Topher Sanders, ProPublica;Olivia Winslow, Newsday 2020-03-05T15:30:00 2020-03-05T16:30:00 America/Chicago
2295 DataKit: Workflow automation for the newsroom and classroom Managing a data analysis project, from story idea to publication, shouldn't be so hard. The Associated Press will demonstrate how it uses DataKit, an open-source tool, to tame the tangles of your data analysis projects. Speakers will highlight features for producing standardized project structures, easily sharing code and data, and publishing data as part of a story package. The session will also show how Stanford University's journalism program is using DataKit in the classroom. For help installing DataKit, attend the install party immediately following this session in Galerie 4. Galerie 3 - 2nd Larry Fenn, The Associated Press;Serdar Tumgoren, Stanford University 2020-03-05T15:30:00 2020-03-05T16:30:00 America/Chicago
2425 A demo of the Big Local News platform Come explore the Big Local News platform. You will learn how Big Local News fosters and supports collaborative data journalism. Log in to the BLN platform, create projects, upload and share data with individual users and entire groups (such an investigative team or a newsroom), use Datasette to open your data and analyze it. Learn about our Open Projects where the Big Local News team, the Accountability Project and others share data for the benefit of the journalism community. And hear about archiving your project data with the Stanford Digital Repository. You archive and then receive back a link that will never expire or change — perfect for sharing data with your readers, and for making sure that you don’t lose your work over time. Galerie 4 - 2nd Justin Mayo, Big Local News;Cheryl Phillips, Stanford University;Eric Sagara, Big Local News 2020-03-05T15:30:00 2020-03-05T16:30:00 America/Chicago
2453 International year in CAR 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. Galerie 6 - 2nd John Bones, SKUP;Momi Peralta Ramos, La Nación 2020-03-05T15:30:00 2020-03-05T16:30:00 America/Chicago
2458 "Scrollytelling" with Mapbox (repeat) Build a scrollytelling experience using Mapbox Studio and the new Storytelling Solution by Mapbox with little to no code. In this session, you’ll learn to quickly create a scrollytelling map using Mapbox’s new template and publish the results on Glitch. Studio 1 - 2nd Lo Bénichou, Mapbox 2020-03-05T15:30:00 2020-03-05T16:30:00 America/Chicago
1085 R 3: Gathering and cleaning data Learn how to use R to scrape data from web pages, access APIs and transform the results into usable data. This session will also focus on how to clean and structure the data you've gathered in preparation for analysis using tidyverse packages. This session is good for: People who have used R and have a basic understanding of how to retrieve data from APIs. Studio 7 - 2nd Matt Waite, University of Nebraska-Lincoln 2020-03-05T16:45:00 2020-03-05T17:45:00 America/Chicago
1101 Python 3: Data cleaning and visualization Now that you’ve got a handle on Pandas, it’s time to jump into some advanced topics. You know how to import a dataset, but what happens when you load the data and nothing looks right? We’ll walk through cleaning up a dirty dataset with Pandas. Then we’ll jump into the fun part: visualizing the data you’ve analyzed. This session is good for: People who can load and perform basic summary and grouping functions in Pandas. Studio 6 - 2nd Alexandra Kanik, Louisville Public Media 2020-03-05T16:45:00 2020-03-05T17:45:00 America/Chicago
1121 Finding the story: Campaign finance in Excel Learn how to decipher federal campaign finance filings, how to find stories and how to navigate the limitations of the data. This session is good for: People who are comfortable with Excel, but no specific campaign finance knowledge is required. Studio 8 - 2nd Chad Day, The Wall Street Journal 2020-03-05T16:45:00 2020-03-05T17:45:00 America/Chicago
2055 Countdown to the big count: Getting ready for Census 2020 Census 2020 has already begun, and it's already creating data — and stories. This session, anchored to the timeline of the coming year, will get you up to speed: key dates, lingo and what stories are possible when. We'll also offer a compendium of Census 2010 stories and local data like 2010 response and undercount rates. You'll also get a clear explanation of the unprecedented plan to add statistical noise to most Census 2020 results, and how that will affect your stories. Also: Late updates on the plan to use the census to bootstrap a controversial new data set: a count of citizens and non-citizens in every neighborhood. Acadia - 3rd Paul Overberg, Wall Street Journal;Gerson Vasquez, U.S. Census Bureau;MaryJo Webster, The Star Tribune 2020-03-05T16:45:00 2020-03-05T17:45:00 America/Chicago
2096 The wrong things we all do Embarrassing naming conventions. Bad filing systems. Hacky collections of varied datasets. Zooming in on or tossing outliers. It's not easy to find the line between using less-than-perfect data to get a story, or not doing a story because there's less-than-perfect data. Part brass tacks, part group therapy, this session highlights some of the bad practices we all share, and practical ways to improve. Bissonet - 3rd Emily Le Coz, GateHouse Media;Matt Wynn, USA Today;Joe Yerardi, The Center for Public Integrity 2020-03-05T16:45:00 2020-03-05T17:45:00 America/Chicago
2117 Encryption and journalism: From idea to publication Many factors come into play when considering the security of a story. The most notable is the security around conversations with sources. While this is important, this is not the only point in the process to consider the security of your interactions and information. In this training, we will overview the different types of encryption and how it comes into play when researching, writing, and communicating new stories. Attendees will walk away from this training understanding how to make informed decisions about the security of their tools and process from research to publication of a story. Galerie 3 - 2nd Kristen Kozinski, The New York Times 2020-03-05T16:45:00 2020-03-05T17:45:00 America/Chicago
2225 Advanced data journalism through a browser Every journalist has faced down the dreaded install of a new tool that doesn't go well — or even go at all. Maybe it's led to inscrutable Python error messages that no one can help you diagnose. Perhaps you work for an organization that won't (or can't) grant admin rights on company hardware. Or it could be that you're trying to teach command-line tools to a bunch of college students without having them brick their machines. To get around some of these pitfalls, new tools/platforms like Binder, RStudio Cloud and others have come online, offering to serve up Python and R like the second coming of the Google Suite. But which services work best? What are the limits? What do they cost, if anything? How much work do you have to put in to get them functioning properly? Galerie 6 - 2nd Alex Richards, Syracuse University 2020-03-05T16:45:00 2020-03-05T17:45:00 America/Chicago
2236 Covering housing from A-Z: Localizing affordable housing stories and data Stories about redlining and the inequities among home loan recipients from big banks have dominated housing coverage in recent years. But homeownership is just one part of the affordable housing conversation that needs coverage. Public housing authorities, federal disinvestment in public housing/the Section 8 program, county/city first-time homeowner loan programs, evictions at housing courts, slumlord landlords, tenant protection ordinances, and localizing coverage of how Secretary Ben Carson's HUD is affecting communities is vital, and this panel would show attendees how to do it. This workshop is for people interested in amping up housing coverage as a side beat, their main beat or a one-time project. We'll discuss data they should be requesting from their local agencies for quick turn stories or to find trends, including from housing courts, public housing authorities and more. This workshop goes beyond the redlining projects to help journalists find data-driven affordable housing stories no matter where they are. Galerie 2 - 2nd Marissa Evans, The Star Tribune;Jessica Williams, The New Orleans Advocate 2020-03-05T16:45:00 2020-03-05T17:45:00 America/Chicago
2294 DataKit install party Looking for a way to tame the tangles of your data analysis projects? Try kicking the tires on DataKit, an open-source command-line tool designed to help journalists standardize project structures, easily share code and data, and publish data as part of story packages. Get up and running with existing workflows for the newsroom and classroom, or ask for help creating a customized workflow built around your own ecosystem of tools and services. Developers from The Associated Press and Stanford University will be on hand to help journalists install DataKit. To learn more about DataKit and how it could work for your newsroom, attend the demo immediately before this session in Galerie 3. Galerie 4 - 2nd Larry Fenn, The Associated Press;Meghan Hoyer, The Associated Press;Michelle Minkoff, The Associated Press;Serdar Tumgoren, Stanford University 2020-03-05T16:45:00 2020-03-05T17:45:00 America/Chicago
2452 Workbench: Reproducible data work without coding Workbench is an open-source tool that puts all stages of the data journalism process in one place, including scraping, cleaning, monitoring, and visualization -- all without coding, and all reproducible. In this hands-on tutorial, you'll learn how to use Workbench for several different newsroom tasks. Scrape and clean data, monitor public sources, create live embeddable charts that update when new data is released, or share and automate useful workflows that other journalists can use to report. Workbench is built to help make data tasks accessible to more people in the newsroom. This session is good for journalists of all skill levels. Studio 1 - 2nd Pierre Forcioli-Conti, Workbench;Adam Hooper, Workbench 2020-03-05T16:45:00 2020-03-05T17:45:00 America/Chicago
2496 Welcome reception Join us for our welcome reception on Thursday, beginning at 6 p.m. Reconnect with longtime friends and welcome new attendees! Each attendee will receive one drink ticket for beer, wine, soda or bottled water. Light snacks also will be served. Carondelet - 3rd 2020-03-05T18:00:00 2020-03-05T19:15:00 America/Chicago
2487 Mentor program breakfast If you signed up for the conference mentor program, come meet your match at this invitation-only breakfast. The mentorship breakfast is sponsored by the Donald W. Reynolds Journalism Institute. Carondelet - 3rd 2020-03-06T07:30:00 2020-03-06T08:45:00 America/Chicago
2489 Conference registration Conference registration will be located on the 2nd floor in Preservation Foyer. Be sure to stop by and pick up your conference name badge. Name badges must be worn during the conference. Preservation Foyer - 2nd 2020-03-06T08:00:00 2020-03-06T17:00:00 America/Chicago
2490 Conference sales Stop by the NICAR sales table located in Preservation Foyer on the 2nd floor to browse books from the IRE store, IRE merchandise and shirts with the winning design from the T-shirt contest. Studio Foyers - 2nd 2020-03-06T08:00:00 2020-03-06T17:00:00 America/Chicago
1000 PyCAR This hands-on workshop will teach journalists basic programming concepts using the Python language. The class, spread over two half-days, will introduce language basics and useful libraries in the course of a typical reporting project: scraping data from the web, analyzing a spreadsheet and visualizing the results. Preregistration is required and seating is limited. Laptops will be provided for the training. Workshop prerequisites: Although the class is geared toward programming beginners, attendees should have familiarity with the command line and be comfortable with databases and SQL. Studio 3 - 2nd Tom Meagher, The Marshall Project;Jacob Quinn Sanders, Factal;Elaine Wong, CBC/Radio-Canada 2020-03-06T09:00:00 2020-03-06T12:30:00 America/Chicago
1005 First Python notebook: Data analysis on deadline James Gordon, Cheryl Phillips, Andrea Suozzo and Ben Welsh guide you through a six-hour, hands-on investigation of money in politics. You will learn: * just enough Python to execute an analysis with pandas, one of the most popular open-source tools for working with data tables * how to record, remix and republish your work using Jupyter, a browser-based tool emerging as the standard for reproducible research * and how these tools can increase the speed and veracity of your journalism. Along the way you’ll conduct your own investigation of California campaign donors using the California Civic Data Coalition’s open-source database archive. Preregistration is required and seating is limited. Laptops will be provided. Prerequisites: If you've tried Python once or twice, have good attitude and know how to take a few code crashes in stride, you are qualified. We want you. Studio 6 - 2nd James Gordon, Reynolds Journalism Institute/Unversity of Missouri;Cheryl Phillips, Stanford University;Andrea Suozzo, Seven Days;Ben Welsh, Los Angeles Times 2020-03-06T09:00:00 2020-03-06T17:45:00 America/Chicago
1006 Digging into data for stories: A crash course in Excel Get started using data in your stories with IRE's original mini-boot camp. In this 7-hour, hands-on workshop, IRE’s experienced trainers will start with the basics of navigating Excel and using formulas, then walk you through sorting, filtering and aggregating data with pivot tables to find story ideas. You'll come away with a solid base for using data analysis in your newsroom, including how to find and request data, identify and clean dirty data, find story ideas and bulletproof your work. We’ll also provide you with our detailed boot camp materials to help keep you on track long after you leave the conference. Preregistration is required and seating is limited. Laptops will be provided for the training. Workshop prerequisites: There are no prerequisites for this workshop and beginners are welcome. This workshop is good for those wanting to get started analyzing data for stories. Studio 2 - 2nd Patti DiVincenzo, IRE & NICAR;Sarah Hutchins, IRE & NICAR;Francisco Vara-Orta, IRE & NICAR 2020-03-06T09:00:00 2020-03-06T12:30:00 America/Chicago
1017 Master class: Election 2020 data This year brings important elections from local school boards to statehouses and the White House. This class, taught by two veteran political reporters, will help you gear up for Election 2020 coverage at any level of government, including: * Tools and strategies for campaign finance data, from local to federal candidates * Following the money and the messaging from campaigns * Tracking the players beyond candidates, from super PACs to special interests and nonprofits * Story ideas to help you plan election coverage for your newsroom No previous data experience is necessary for this workshop, though familiarity with spreadsheets will help. Please bring your own laptop. Galerie 5 - 2nd Carrie Levine, Center for Public Integrity;Derek Willis, ProPublica 2020-03-06T09:00:00 2020-03-06T12:30:00 America/Chicago
1028 Victims, villains and heroes: Turning data into characters Data helps bolster our investigations and find the right anecdotes through which to tell them. Our panel will help you think about how to turn data into compelling human stories that drive a narrative, create tension and make people care. We'll talk about how to find a perfect example in all that data and what to do if you can't. Galerie 3 - 2nd Jennifer Forsyth, The Wall Street Journal;Ellen Gabler, The New York Times;Sarah Rafique, KTRK-ABC 13 2020-03-06T09:00:00 2020-03-06T10:00:00 America/Chicago
1074 Excel: Basic stats 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. Studio 8 - 2nd Norm Lewis, University of Florida 2020-03-06T09:00:00 2020-03-06T10:00:00 America/Chicago
1089 JavaScript 1: Fundamentals and syntax Functions, "for loops" and objects: They can be confusing at first, but once you master these and other JavaScript coding conventions, you'll be on your way to building fancy data visualizations and more. In this class, you will learn the basic syntax of the JavaScript programming language. This session is good for: Beginners who have been exposed to HTML at some point. Studio 9 - 2nd Erin Petenko, VTDigger 2020-03-06T09:00:00 2020-03-06T10:00:00 America/Chicago
1124 Finding the story: Business data What is the economic output of your county? What are the most common local occupations? How important are sectors like tourism or health care or manufacturing? Where can you find data on recent layoffs? We’ll explain and explore a few key data sets to understand your local economy and use them to find stories tailored to your audiences. This session is good for: Those with basic spreadsheet skills and curiosity about your local economy. Studio 10 - 2nd Paul Overberg, Wall Street Journal;Cezary Podkul, The Wall Street Journal 2020-03-06T09:00:00 2020-03-06T10:00:00 America/Chicago
1138 Data Dive 2: Senior care, access to clean water, the probation trap A data deep dive into some of the best data journalism of 2019. Hear from reporters how they gathered, cleaned, analyzed and visualized the data behind some of the year's biggest stories. Bissonet - 3rd Cindy Galli, ABC News;Jeff Kelly Lowenstein, Grand Valley State University;Dylan Purcell, The Philadelphia Inquirer 2020-03-06T09:00:00 2020-03-06T10:00:00 America/Chicago
1224 Navigating data.census.gov The 2020 Census is coming, and journalists need to be prepared! Come learn how to use Census Bureau data in your reporting with data.census.gov, the new site to access Census data. In this live demo, we will share tips and tricks while showing how to download data, customize the table view, and map your results. Acadia - 3rd Tyson Weister, U.S. Census Bureau 2020-03-06T09:00:00 2020-03-06T10:00:00 America/Chicago
2063 Getting started with Tableau Public Tableau Public is a popular visualization software that allows users to create great visuals and publish them in a few easy steps. This session will walk you through the basics, teach a few tricks, and set you up for the more advanced session to follow immediately afterwards. This session is good for: People who are comfortable working with spreadsheets and are ready to start with data visualization. Studio 7 - 2nd David McKie, National Observer 2020-03-06T09:00:00 2020-03-06T10:00:00 America/Chicago
2097 Encryption tools for journalists This session will review and provide practical training in the installation, configuration, and implementation of the best encryption tools for journalists to protect their privacy and sources from malicious hackers. This session was planned in collaboration with the Border Center for Journalists and Bloggers. Studio 4 - 2nd Jorge Luis Sierra, Border Center for Journalists and Bloggers 2020-03-06T09:00:00 2020-03-06T10:00:00 America/Chicago
2235 Exploring the radio spectrum for news Once the exclusive domain of scientists, engineers and HAM radio operators, a new generation of cheap hardware and open source software have cracked open the radio spectrum for hackers, hobbyists — and journalists — to explore. Radios are built into dozens of devices we use every day, and the radio spectrum is a tightly regulated, poorly understood invisible national asset. There are stories flying around in the air around you, and it’s time you started looking for them. We'll give an overview of how this all works, and walk you through the tools you can use to start poking around the radio spectrum. We’ll also look at some interesting examples of how the radio spectrum has been used in reporting the news. Galerie 2 - 2nd Jon Keegan, The Markup 2020-03-06T09:00:00 2020-03-06T10:00:00 America/Chicago
2282 Code buddies: Get help on your project Have some data and ideas but you're not sure what to do next? Trying something new you learned at NICAR and need someone to doublecheck your math? OpenNews and the Lonely Coder's Club* want to help you get past whatever's blocking your next data or code project. Bring your laptop and we'll work together to move your project forward. Everyone is welcome! If you let us know a little about your project in advance, we'll reach out to some peer experts who have just the right experience to help you out. Ryan Pitts - twitter: @ryanpitts; email: ryan@opennews.org Alexandra Kanik - twitter: @act_rational; email: akanik@louisvillepublicmedia.org *The Lonely Coder's Club is a Slack community of newsroom data nerds and programmers who run solo or on small teams. Galerie 4 - 2nd Alexandra Kanik, Louisville Public Media;Ryan Pitts, OpenNews 2020-03-06T09:00:00 2020-03-06T10:00:00 America/Chicago
2455 Free, powerful tools for analyzing document dumps Finding needles in a haystack of documents is getting easier, thanks to tools aimed at helping journalists sort through pdfs to find names, dates and patterns. This session will demo two free and powerful tools — MuckRock's DocumentCloud, and Google's Backlight — that can help you manage and find stories in massive document dumps. Galerie 6 - 2nd Pam Dempsey, Midwest Center for Investigative Reporting;Dylan Freedman, DocumentCloud;Michael Grant, Google News Lab 2020-03-06T09:00:00 2020-03-06T10:00:00 America/Chicago
2488 Exhibitors and recruiters Be sure to stop by the Studio foyers on the 2nd floor and visit with the exhibitors/recruiters. Studio Foyers - 2nd 2020-03-06T09:00:00 2020-03-06T17:00:00 America/Chicago
2493 Master Class: Writing the investigative narrative (Friday morning) You’ve gathered data, docs and human sources. Now it’s time to turn your reporting into a story — or a series — that packs a punch. If you’re new to investigative storytelling or a data nerd hoping to better blend numbers into compelling prose, this workshop is for you. Reporter J. David McSwane has worked in all media, always chasing that perfect marriage of investigative and narrative. Computational journalist Andrew Chavez will also lead some of the discussion. Topics include: * Understanding narrative * Reporting for story: how to gather the details and scenes that will give your piece emotional power * Organization and framing * Self-editing tips and techniques: do you need this character, this piece of data? * Making the data work for you: adding scope and precision to a human story We’ll look at examples of successful stories, pulling back the curtain to see how they came together. Studio 1 - 2nd Andrew Chavez, The New York Times;J. David McSwane, ProPublica 2020-03-06T09:00:00 2020-03-06T12:30:00 America/Chicago
1039 Census: Numbers in the news From inequality to poverty to commute times, the census supplies hard numbers behind the big stories. We’ll show you how to use the Census Bureau’s surveys for breaking stories as well as projects. We’ll also help you prepare for the deluge of stories coming with Census 2020. Acadia - 3rd Ronald Campbell, NBC Owned Television Stations;Tim Henderson, Pew Stateline 2020-03-06T10:15:00 2020-03-06T11:15:00 America/Chicago
1090 JavaScript 2: Hello, D3! We’ll cover the basics of getting started with D3, even if you’ve never used it before. Then we’ll take use some real data to create a few basic charts. This session is good for: People with a basic grasp of JavaScript syntax. Studio 9 - 2nd 2020-03-06T10:15:00 2020-03-06T11:15:00 America/Chicago
1133 Google Sheets: Custom formulas and automating tasks with the script editor Add versatility to your Google Sheets with the script editor, a transformative feature that allows you to write your own custom formulas, automate tasks and even send emails on your behalf (think FOIA requests). With a little JavaScript knowhow, you can make Google Sheets work exactly to your specifications and needs as a journalist. This session is good for: Beginners and intermediate users who know a little bit of JavaScript. Studio 4 - 2nd Frank Bi, Vox Media 2020-03-06T10:15:00 2020-03-06T11:15:00 America/Chicago
1214 How to find -- and forget -- data for your environment stories Whether you’re covering oil spills in the Gulf, industrial farming in the Midwest or sea level rise on the coasts, data can help contextualize what you see on the ground. In this session, we’ll discuss datasets that will help you tell a broader story about the environment where you’ll live. We’ll also talk about the pitfalls of that data, and how it can distract from the social and cultural impacts of environmental degradation and climate change. Galerie 2 - 2nd Emily Hopkins, The Indianapolis Star;Sara Sneath, The Times-Picayune, The New Orleans Advocate;Tegan Wendland, WWNO-New Orleans Public Radio 2020-03-06T10:15:00 2020-03-06T11:15:00 America/Chicago
1217 Advanced Tableau In this lesson, you will learn how to weave charts and maps created in Tableau Desktop into an interactive dashboard. Also, you will publish it on the Tableau Public website. This session is good for: People who have taken the intro to Tableau class Studio 7 - 2nd David Herzog, IRE & NICAR 2020-03-06T10:15:00 2020-03-06T11:15:00 America/Chicago
2001 Scraping in R Python has been considered the go-to for scraping websites. But did you know it's really easy to do in R? Using the R library rvest, and a tool called "Selector Gadget" that lets you select elements by clicking, I hacked my way into scraping after multiple attempts in learning scraping the traditional way (BeautifulSoup and Inspect element). One of the advantages of R is that you can do everything in one environment, so why not include scraping into your R workflow? This session is good for: R users looking for another tool or coding beginners struggling to learn scraping in Python. Studio 8 - 2nd Jasmine (Ye) Han, Bloomberg Industry Group 2020-03-06T10:15:00 2020-03-06T11:15:00 America/Chicago
2092 Data Blitz Like Lightning Talks, but for data. Five presenters will guide you through their favorite datasets. Galerie 3 - 2nd Jeremy Singer-Vine, BuzzFeed News 2020-03-06T10:15:00 2020-03-06T11:15:00 America/Chicago
2191 Beyond the horserace of election results graphics We all love making political graphics, and election night can be a fun exercise in showing off our data graphics prowess. But is there any point to these graphics beyond just showing election results, especially since there’s so many news outlets doing the same iterations of the exact same data? Is there any way to contextualize our graphics so we stop explaining WHO has power, but instead focus on HOW that power is used FOR or AGAINST who? In the lead-up to 2020, let’s thoughtfully discuss why we do election results graphics and how can we make it better so that we can move beyond the “horserace” aspect of data journalism. Galerie 6 - 2nd Carla Astudillo, Texas Tribune;Ella Koeze, FiveThirtyEight;Allison McCartney, Bloomberg News;Sara Simon, Spotlight PA 2020-03-06T10:15:00 2020-03-06T11:15:00 America/Chicago
2229 Build your own collaborative documentation site: An introduction to Library Writing and maintaining good documentation is hard. After trying several other approaches at the New York Times, we built Library, a collaborative site powered by Google Docs. Library is an open-source documentation tool released by the New York Times in collaboration with Northwestern University’s Knight Lab in 2019. Because every page in Library is a Google Doc, you already know how to use it! In this, we’ll show you how to set up a copy of Library for your own organization, following the Deploy to Heroku steps outlined in the open source release. Prior experience working with the command line will be helpful, but is not required. Galerie 4 - 2nd Isaac White, The New York Times 2020-03-06T10:15:00 2020-03-06T11:15:00 America/Chicago
2418 Interviewing your data You’ve learned how to use formulas and make pivot tables in Excel or maybe you've dabbled in a SQL program or R, but too often when you sit down in front of your own data, you find yourself staring at the computer screen, unsure how to proceed. This session will give you a framework for a process you can follow with every new dataset you work with and set you up with some best practices that will make you more efficient and less likely to make a mistake, regardless of what tool you are using for your analysis. At the heart of this framework is the idea that you are “interviewing” data in much the same way you would a human source. Many of the same steps you take in preparing for and conducting a human interview can be applied to your data work. Beyond that, the framework will help you navigate common issues with data that you need to find and deal with before you even start your analysis. Bissonet - 3rd MaryJo Webster, The Star Tribune 2020-03-06T10:15:00 2020-03-06T11:15:00 America/Chicago
2482 Finding the story: Data-driven disaster coverage Floods, fire, a shooting or an explosion have occurred in your area. We know a lot about that in Houston. We had major flooding three years in a row, chemical fires or explosions every six weeks and a school shooting last year. We'll show you how you can use data to find in-depth stories about the disaster in your community. This session is good for: those who are comfortable with Excel and relational database concepts. Studio 10 - 2nd Matt Dempsey, Houston Chronicle 2020-03-06T10:15:00 2020-03-06T11:15:00 America/Chicago
1048 Everything we know about covering guns, in one hour At the intersection of Americans and firearms is an ever-shifting business, regulatory, legal and political landscape. In this fast-paced session, we'll walk through the most reliable sources, the best data, common pitfalls, biggest players, game-changing court cases, and the basic mechanics of guns. You'll leave the session with story ideas, useful datasets you've never heard of, a gun guide, and an understanding of why caliber counts. Galerie 6 - 2nd Brian Freskos, The Trace;Kristin Hussey, Independent journalist 2020-03-06T11:30:00 2020-03-06T12:30:00 America/Chicago
1091 JavaScript 3: Making a map in D3 Learn how to create an easy D3 map by turning shapefiles into nice, reusable TopoJSON, then turning it into a map and connecting it to your data. You can then have these maps ready for future use by just switching out a few variables. This session is good for: People who have a basic grasp of JavaScript syntax and have been exposed to the D3 library at some point. Studio 9 - 2nd Al Shaw, ProPublica 2020-03-06T11:30:00 2020-03-06T12:30:00 America/Chicago
1115 Hitchhikers guide to APIs In this hands-on session, you will learn the ins and outs of working with APIs, a flexible way for computers to communicate and share data. We'll cover working with public APIs as well as using APIs protected behind keys and other authentication methods. After this session you'll have the tools to dig deeper into your city's open data portal, scrape "unscrapeable" websites, convert addresses to coordinates, send texts or emails on command, grab data from Twitter or even handle payments! Note: You will need a Google account for this session. This session is good for: Everyone. We'll be working with tools non-coders can appreciate, but also wrangling the Python code that can take us to the next level. Studio 7 - 2nd Jonathan Soma, Columbia Journalism School 2020-03-06T11:30:00 2020-03-06T12:30:00 America/Chicago
2051 Finding the story: Using DNS search for investigative journalism (repeat) Every online interaction begins with a lookup in the Domain Name System (DNS), the backbone of the Internet. As a result, there are digital footprints left behind in the DNS. With the demise of Whois, investigative reporters are looking for new tools to uncover these footprints. Learn how to use DNSDB Scout, a tool to query DNSDB, a historical passive Domain Name System (DNS) database, to discover previously unknown online connections and gain new information to advance your ongoing and breaking news investigations. Basic knowledge of the Domain Name System (DNS) is helpful, but not required. Studio 4 - 2nd Paul Vixie, Farsight Security, Inc. 2020-03-06T11:30:00 2020-03-06T12:30:00 America/Chicago
2130 Making interactive maps with R Exploratory data analysis sometimes involves quickly iterating through visualizations to see patterns that stand out, particularly when working with spatial data. In this workshop, we'll be creating interactive maps using R packages that work on top of Leaflet and Mapbox using real life data while coming close to reproducing maps from The Washington Post in the process. This class is good for: People who are familar with RStudio and want to add interactive mapping in R to their toolbox. Studio 8 - 2nd Peter Aldhous, BuzzFeed News 2020-03-06T11:30:00 2020-03-06T12:30:00 America/Chicago
2164 Investigating sexual assault, for newsrooms big and small Learn effective approaches to investigating the justice system’s response to sexual assault from reporters who conducted their own investigations into police procedures around sexual assault, exposed problematic loopholes in state laws and delved into a national nonprofit's child sex abuse secrets. From digging through federal statistics and case files to parsing a difficult dataset with code, you’ll leave this session with strategies to launch an investigation of your own. Bissonet - 3rd Hannah Dellinger, Houston Chronicle;Kate Martin, Carolina Public Press;Brandon Stahl, KARE 11 2020-03-06T11:30:00 2020-03-06T12:30:00 America/Chicago
2232 Data on the wildfire beat As wildfires have become more frequent and more intense, newsrooms have opportunities to raise the bar of their reporting by bringing data into their coverage of these disasters. Over the past year, media outlets have increasingly incorporated data into their wildfire coverage, whether to track fires while they happen, provide new context or by digging into data about contributing factors and fallout. We will highlight some of the best examples, review how projects we worked on came together, discuss how data-driven wildfire reporting could be improved in the future and go through sources and ideas that newsrooms can put into use for their own wildfire coverage. Galerie 2 - 2nd Ren Larson, The Arizona Republic;Casey Miller, Los Angeles Times;Evan Wyloge, Colorado Springs Gazette 2020-03-06T11:30:00 2020-03-06T12:30:00 America/Chicago
2248 Digital sleuthing with Bellingcat Learn advanced tricks and tips for mining Facebook, Twitter, Telegram, and other sites with Robert Evans of Bellingcat, the international collective of researchers and citizen journalists specializing in digital sleuthing. Learn how to do geographic searches to find sources, visuals and other material near a specific address or in a particular city. You will leave this session armed with tools and tricks to quickly find information about both public and private figures. Acadia - 3rd Robert Evans, Bellingcat 2020-03-06T11:30:00 2020-03-06T12:30:00 America/Chicago
2250 FOIA from the flip side A panel of state and local officials offer advice on how to wring the best responses out of open records requests. They’ll identify common pitfalls that bog down or doom requests and offer advice on work you can do before you file your FOI request to give it the best chance of succeeding. They’ll place special emphasis on data requests. Galerie 3 - 2nd Meg Casper Sunstrom, Louisiana Board of Regents;Deborah Spiess Henton, 22nd Judicial District Attorney's Office - Parish of St. Tammany;Benjamin Lesser, Reuters;J.B. Slaton, Louisiana State Police 2020-03-06T11:30:00 2020-03-06T12:30:00 America/Chicago
2384 Excel tricks you've never used Excel has so many tips, tricks and time-saving tools you might not know about, even if you're a whiz at CONCATENATE functions and PivotTables. You should pick up a few new tricks in this fast-paced and fun session. This session is best for: Those with intermediate knowledge of spreadsheets. Studio 10 - 2nd Denise Malan, IRE & NICAR 2020-03-06T11:30:00 2020-03-06T12:30:00 America/Chicago
2438 Breaking through coding plateaus There are plenty of tutorials and training sessions to help a new coder get started. And there are plenty of awards lists and conference sessions that will wow you with some amazing advanced work. But once you've done the tutorials and experimented with what you've learned in the hands-on sessions, you'll likely find yourself stuck — you're no longer a beginner, but you're also not an expert, and you don’t really understand how to take the next step on that journey. You've hit a classic learning plateau, and there aren't many resources to help you break through and take your coding to the next level. In this session, we'll discuss key concepts that bridge the gap between beginner and expert coder and present strategies for leveling-up — while still meeting your deadlines. Galerie 4 - 2nd Serdar Tumgoren, Stanford University 2020-03-06T11:30:00 2020-03-06T12:30:00 America/Chicago
1004 ArcGIS: From spreadsheets to StoryMaps Interested in mapping your data but aren't sure where to start? In this half-day workshop, we’ll walk attendees through an investigation into short-term rentals in New Orleans and their potential impacts on the community. Along the way, we’ll focus on the tools, workflows and best practices to help you transform public data into compelling maps and narrative stories. This workshop will specifically address: * Creating interactive maps directly within Excel from a spreadsheet of public data with ArcGIS Maps for Office * Publishing spreadsheet data as an interactive layer * Styling and configuring interactive maps with ArcGIS Online * Filtering, analyzing, aggregating and enriching geospatial data * Performing on-the-fly calculations and customization with Arcade scripts * Finding and using authoritative data from the Living Atlas * Creating interactive maps that fuse narrative elements and maps using ArcGIS StoryMaps Preregistration is required and seating is limited. Laptops will be provided for the training. Class attendees will receive free licenses of ArcGIS from Esri. Workshop prerequisites: No data or mapping experience required. Studio 7 - 2nd Robby Deming, Esri;Christopher Vaillancourt, Esri 2020-03-06T14:15:00 2020-03-06T17:45:00 America/Chicago
1010 Write better Python code 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. Studio 9 - 2nd Serdar Tumgoren, Stanford University 2020-03-06T14:15:00 2020-03-06T17:45:00 America/Chicago
1019 Master class: Writing the investigative narrative (Friday afternoon) You’ve gathered data, docs and human sources. Now it’s time to turn your reporting into a story -- or a series -- that packs a punch. If you’re new to investigative storytelling or want to up your writing game, this workshop is for you. Veteran editor Maria Carrillo has led some of the best narrative teams in the country. In this half-day workshop, she’ll cover the entire story lifecycle, from reporting to writing to planning for publication. Topics include: * Understanding narrative * Reporting for story -- How to gather the details and scenes that will give your piece emotional power * Focus and framing – Finding your way through all that material * Self-editing tips and techniques * Developing a story team -- How to get photographers, artists, designers, digital producers and editors unified behind a common vision We’ll look at examples of successful stories, pulling back the curtain to see how they came together. Galerie 5 - 2nd Maria Carrillo, Tampa Bay Times 2020-03-06T14:15:00 2020-03-06T17:45:00 America/Chicago
1026 Career paths in data journalism Data journalism encompasses many different kinds of work, whether you work full time with data, manage a data team, use data to cover a beat, or use data visualization and interactivity to tell visual stories. It's not always clear what professional options may be available, or how you might go about growing into new opportunities. In this session, we'll hear from a newspaper reporter whose focus on data eventually took them into academia, a designer/developer/journalist who ended up moving into leadership to help bring together her newsroom's visual storytelling departments, as well as a veteran TV journalist who forged her own path when there wasn't a data job in the newsroom. Bissonet - 3rd Patti DiVincenzo, IRE & NICAR;Alex Richards, Syracuse University;Sisi Wei, OpenNews 2020-03-06T14:15:00 2020-03-06T15:15:00 America/Chicago
1067 Excel 1: Getting started with spreadsheets (repeat) 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. Studio 8 - 2nd Carlie Procell, USA Today Network 2020-03-06T14:15:00 2020-03-06T15:15:00 America/Chicago
1075 SQL 1: Exploring data Learning to manipulate data is a bit like learning a new language. Actually, it is a language, called Structured Query Language (SQL). This session is an introduction to using SQL to zero in on your data by viewing slices and chunks of it and putting it into a useful order so you can spot the stuff you need to get started toward a story. We'll use DB Browser for SQLite, a free database manager. This session is good for: People with some experience working with data in columns and rows, in spreadsheets or database managers. Studio 10 - 2nd Lucia Walinchus, Eye on Ohio, the Ohio Center for Investigative Journalism 2020-03-06T14:15:00 2020-03-06T15:15:00 America/Chicago
1094 Stats 1: An introduction Statisticians need to really understand their data (and so do you!) before they begin running analyses. As a result, stats software like RStudio has many powerful tools to summarize your data. You're going to love them. We'll take a look at the structure of data in RStudio, do data transformations and run some basic statistical tests. This session is good for: People who have familiarity with Excel and some database software. We've got a *lot* of ground to cover in this hour. Studio 4 - 2nd Ryann Grochowski Jones, ProPublica 2020-03-06T14:15:00 2020-03-06T15:15:00 America/Chicago
1108 Google Sheets: Scraping without coding (repeat) Yes, you can scrape data without using code -- in fact, all you need is Google Sheets! We'll be using Excel-type formulas (don't worry if you don't know what those are, either) to make simple scrapers that automatically pull data into Google Sheets. It’s the best way to get around clunky websites and unhelpful PIOs! This session is good for: Beginners who want to start using data for their stories. Studio 1 - 2nd Samantha Sunne, Independent journalist 2020-03-06T14:15:00 2020-03-06T15:15:00 America/Chicago
1120 Finding the story: Census data (repeat) Census data can bring context and depth to stories on practically any beat. It can also be overwhelming to sift through and find what you need. This hands-on session will walk you through a real census dataset to help you find stories hidden in all that demographic data. This session is good for: Those who have some experience with spreadsheets. Studio 2 - 2nd Robert Gebeloff, The New York Times 2020-03-06T14:15:00 2020-03-06T15:15:00 America/Chicago
2176 An automated election twitterbot using R and Python In 2019 the BBC used R and Python to take live election results, draw graphics and tweet them out. We will show you how we did it. The session will give an insight into automatically turning live election results into graphics with R and tweeting them out using Python, providing a live election results service. This session is good for people with experience coding in R or Python. Studio 3 - 2nd Alison Benjamin, BBC News;Wesley Stephenson, BBC 2020-03-06T14:15:00 2020-03-06T15:15:00 America/Chicago
2182 Quick-turn data stories We’ve all disappeared down the data rabbit hole on occasion or become embroiled in huge projects. But what about data stories that need a fast turnaround? This panel session will cover tips for getting stories out quickly and keeping clarity (and sanity) along the way. Acadia - 3rd Anthony Cave, KXAN News;Christine Jeavans, BBC News;Lauryn Schroeder, San Diego Union-Tribune 2020-03-06T14:15:00 2020-03-06T15:15:00 America/Chicago
2300 Avant garde data viz 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. Galerie 6 - 2nd Agnes Chang, ProPublica;Jan Diehm, The Pudding;Scott Klein, ProPublica 2020-03-06T14:15:00 2020-03-06T15:15:00 America/Chicago
2387 Covering disparities in education with data State and federal governments hold treasure troves of education data that reporters and news nerds can dig into to find great stories and hold schools accountable. Come learn how to parse the latest iteration of federal civil rights data (CRDC), which reveals resource and discipline inequities across the nation’s +96,000 schools. Dive deep into school segregation data and mapping data. Find out how to use federal College Scorecard data to showcase debt and tuition inequities across the nation’s +7,000 colleges. And hear an overview of the other great data sources that are available for education stories. This session was sponsored by the Lumina Foundation. IRE retains control of content, including the topic and speaker selection, for all conference sessions. Galerie 2 - 2nd Andrea Fuller, The Wall Street Journal;Bracey Harris, The Hechinger Report;Annie Waldman, ProPublica 2020-03-06T14:15:00 2020-03-06T15:15:00 America/Chicago
2454 State of newsroom diversity reports In recent years, a handful of news organizations have published diversity reports to educate people in the industry about their challenges with diversity and to indicate that they are taking newsroom diversity seriously. This has also led to conversations about the effectiveness of diversity reports, what they should cover and how we can convince management to publish more revelatory indicators of diversity. This will be a working session around all these questions. We will start with a quick survey of recent diversity reports published by prominent journalism outlets and then move to a discussion/group activity to work out what measures should be included in diversity reports to further the actual goals of increasing diversity in newsrooms. Galerie 4 - 2nd Moiz Syed, ProPublica 2020-03-06T14:15:00 2020-03-06T15:15:00 America/Chicago
2500 Tracking health misinformation across social media Learn how to track and investigate health misinformation across social media using a host of data tools and dashboards, including CrowdTangle, TCAT, and 4CAT. While the training will focus on health misinformation, you can use the same methods to investigate all types of online mis- and disinformation. An intermediate level of Python is recommended for this workshop. Galerie 3 - 2nd Rory Smith, First Draft 2020-03-06T14:15:00 2020-03-06T15:15:00 America/Chicago
1047 Covering undercovered communities 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. Bissonet - 3rd Jan Diehm, The Pudding;Nausheen Husain, Chicago Tribune;Mark Walker, The New York Times 2020-03-06T15:30:00 2020-03-06T16:30:00 America/Chicago
1068 Excel 2: Formulas & sorting (repeat) 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. Studio 8 - 2nd Emily Hopkins, The Indianapolis Star 2020-03-06T15:30:00 2020-03-06T16:30:00 America/Chicago
1076 SQL 2: Grouping and summing data 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. Studio 10 - 2nd Jessica Huseman, ProPublica 2020-03-06T15:30:00 2020-03-06T16:30:00 America/Chicago
1095 Stats 2: Linear regression Go beyond counting and sorting. Learn how (and when) to measure relationships, level playing fields and make predictions. This class will be taught in R. This session is good for: People who took “Stats 1: An introduction” and want to know how to apply what they learned, or are comfortable with summary statistics and RStudio and new to stats. Familiarity with spreadsheets and database managers is recommended. Studio 4 - 2nd Olga Pierce, University of Nebraska - Lincoln 2020-03-06T15:30:00 2020-03-06T16:30:00 America/Chicago
1112 PDF 2: Using OCR to extract data from PDFs This class will cover basic approaches for getting text out of PDF documents using powerful and freely available tools. Participants will be introduced to basic concepts and walked-through tackling common challenges encountered with tricky PDF documents. This session is good for: People who are unfamiliar with the PDF to text tools or would like to learn how optical character recognition (OCR) tools can be used for extracting difficult text from images embedded in PDF document. Studio 3 - 2nd Chad Day, The Wall Street Journal 2020-03-06T15:30:00 2020-03-06T16:30:00 America/Chicago
1131 Power BI 1: Create interactive data visualizations Create interactive charts and maps to analyze your data and let your audience play with the numbers in embeddable interactives. This hands-on workshop will introduce you Microsoft Power BI, a free data visualization tool that requires no coding. This session is good for journalists who already know how to use Excel and have dreamed of turning spreadsheets into beautiful, interactive visuals. Studio 2 - 2nd Cathleen Crowley, Times Union 2020-03-06T15:30:00 2020-03-06T16:30:00 America/Chicago
1218 Data visualization & storytelling with Flourish Learn how to use Flourish, a free, online tool to build custom visualizations from your spreadsheets, no coding required. The tool has created templates for a huge range of visualisations. Flourish grew out of Kiln, the award-winning data studio that has helped dozens of organizations to visualize and tell stories with data. All newsrooms have access to a full enterprise account supported by Google. **You must bring a laptop and sign up for a free account at flourish.studio to participate in this class. This session is good for: Anyone familiar with spreadsheets. No visualization experience required. Studio 1 - 2nd Michael Grant, Google News Lab 2020-03-06T15:30:00 2020-03-06T16:30:00 America/Chicago
2000 CANCELED - Communicating statistical significance Statistical significance and inference are hard to interpret correctly and harder to communicate clearly. Print “we fail to reject the null hypothesis at 95% level” and you’ll be looking for a job but say “the chance we got it wrong is 5%” and you should be. Unfortunately, that difficulty of staying interesting while being precise keeps useful declarations of what is and isn’t likely off pages where they’re needed. But it is possible to do and do well. Statisticians and science communicators across disciplines interest readers in correct but casual versions of their inferences all the time. What techniques help them get the point across? Are p-value statements even necessary? This panel of statisticians, science communicators, and journalists will discuss how to take the hidden model you worked so hard on and make it something worthy of the front page. Acadia - 3rd 2020-03-06T15:30:00 2020-03-06T16:30:00 America/Chicago
2013 Being a better ally We know the stats. We hear the stories. What can we do to retain journalists from underrepresented groups? In this safe space, we’ll discuss questions you can ask management and tips on how to support your colleagues from marginalized communities. All are welcome, white people especially encouraged to attend. Galerie 4 - 2nd Madi Alexander, The Dallas Morning News;Megan Luther, InvestigateTV;Jon Schleuss, NewsGuild;Moiz Syed, ProPublica 2020-03-06T15:30:00 2020-03-06T16:30:00 America/Chicago
2073 Day-turn investigations From the morning meeting to the 4 p.m. deadline, how to take a day-turn story and add an investigative angle to it with tools you already have. Galerie 6 - 2nd Christopher Heath, WFTV;Josh Hinkle, KXAN;Nicole Vap, KUSA 9NEWS 2020-03-06T15:30:00 2020-03-06T16:30:00 America/Chicago
2141 Machine learning for the rest of us How your newsroom can use machine learning techniques to solve practical reporting problems — even if you don't have a team of experts on staff. Galerie 3 - 2nd Anatoly Bondarenko, Texty.org;Simon Rogers, Google News Lab;Madeleine Varner, The Markup 2020-03-06T15:30:00 2020-03-06T16:30:00 America/Chicago
2243 Beyond pictures: Turning satellite imagery into data Satellite imagery has become easier to obtain, process and analyze, and journalists have increasingly turned to pictures from space to show burned land, eroding coastline and storm-ravaged landscapes. But there’s data in those pixels that journalists might not have considered that can be used to tell stories about the world around them — ethnic cleansing, tribal clashes, the health of forests, pollution and more. We turn to a panel of leading geospatial experts to explain how we could use remote sensing methods and tools like Google Earth Engine to lend authority to stories that otherwise might rely on anecdotes or worse yet, never get told at all. Galerie 2 - 2nd Jessica McCarty, Miami University;Ryan McNeill, Reuters;Odean Serrano, Countering Wildlife Trafficking Institute 2020-03-06T15:30:00 2020-03-06T16:30:00 America/Chicago
1069 Excel 3: Filtering & pivot tables (repeat) 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. Studio 8 - 2nd Aimee Edmondson, Ohio University 2020-03-06T16:45:00 2020-03-06T17:45:00 America/Chicago
1077 SQL 3: Joining tables 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. Studio 10 - 2nd Rosie Cima, E.W. Scripps 2020-03-06T16:45:00 2020-03-06T17:45:00 America/Chicago
1096 Stats 3: Logistic regression Linear regression helps you find relationships between two or more variables, but when an outcome has only two possibilities, you need a different tool. That, my friends, is where logistic regression comes in. This class will be taught in R. This session is good for: People who took "Stats: An introduction" or are comfortable with summary statistics and spreadsheets. Experience with R is recommended. Studio 4 - 2nd Hannah Fresques, ProPublica 2020-03-06T16:45:00 2020-03-06T17:45:00 America/Chicago
1113 PDF 3: Batch pdf processing Practice processing multiple documents with the open-source Python tool pdfplumber. Dan Keemahill will walk through the steps that helped reporters collaboratively count issues at immigration detention facilities. The class will discuss techniques for working with thousands or millions of documents, but the hands-on component will involve a smaller batch. The class will also discuss Optical Character Recognition, but see the PDF2 class for more hands-on examples of OCR. This session is good for: People with some programming experience who are able to install third-party software. Studio 3 - 2nd Dan Keemahill, Austin American-Statesman 2020-03-06T16:45:00 2020-03-06T17:45:00 America/Chicago
1126 Geocoding using online tools 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. Studio 1 - 2nd Jack Gillum, ProPublica 2020-03-06T16:45:00 2020-03-06T17:45:00 America/Chicago
1132 Power BI 2: Clean, join and visualize data Tired of losing track of the steps you took to clean a dirty dataset in Excel? Can’t figure out how to combine two datasets that are related but are in different files? This hands-on workshop will delve deeper into the advanced features of Microsoft Power BI, a free data visualization tool that does not require coding skills. This is a great tool for journalists who use Excel to clean and analyze data, but want to build dashboards with charts that interact. This workshop is good for people who have strong Excel skills. Studio 2 - 2nd Cathleen Crowley, Times Union 2020-03-06T16:45:00 2020-03-06T17:45:00 America/Chicago
1130 Lightning Talks Moderated by Brittany Mayes, The Washington Post Sometimes you don't need 45 minutes to explain a useful technique or interesting resource. Join your colleagues for a session of short (5-minute) talks about doing data journalism, web development or other related topics. The NICAR20 talks will be: 1. "Fade In: What Data Journalism Can Learn from Screenwriting," by Phi Do 2. "Life Lessons from Filing 75,000 FOIA Requests," by Michael Morisy 3. "Easy Ways to Become More Secure Online in Under an Hour," by K. Sophie Will 4. "The Three Kinds of Code You'll Write in the Newsroom," by Chris Amico 5. "Covering Immigration as an Immigrant," by Sinduja Rangarajan 6. "The Secret History of Pokémon as Told Through Metadata," by Elliot Bentley 7. "5 Things You Can Learn From Court Records," by Jenn Topper 8. "Investigating Our Own Institutions," by Steven Rich 9. "25 Newsrooms, 1 Baby Data Journalist," by Julie Christie 10. "What Rocket Science Can Teach Us About Designing for Humans," by Justin Myers Lightning Talks are sponsored by Knight Foundation. Acadia - 3rd 2020-03-06T17:00:00 2020-03-06T18:15:00 America/Chicago
2498 Philip Meyer Award presentation The presentation of the 2019 Philip Meyer Journalism Awards will take place on Friday evening, directly following Lightning Talks. The awards recognize the best uses of social research methods in journalism and are named in honor of Philip Meyer, author of “Precision Journalism” and retired Knight Chair in Journalism and UNC School of Journalism and Mass Communications. Acadia - 3rd 2020-03-06T18:15:00 2020-03-06T18:30:00 America/Chicago
2497 Philip Meyer reception Join fellow NICAR attendees and award winners at a reception with light appetizers and a cash bar immediately following the awards presentation beginning at 6:30 p.m. Friday. Carondelet - 3rd 2020-03-06T18:30:00 2020-03-06T19:30:00 America/Chicago
2489 Conference registration Conference registration will be located on the 2nd floor in Preservation Foyer. Be sure to stop by and pick up your conference name badge. Name badges must be worn during the conference. Preservation Foyer - 2nd 2020-03-07T08:30:00 2020-03-07T18:00:00 America/Chicago
2490 Conference sales Stop by the NICAR sales table located in Preservation Foyer on the 2nd floor to browse books from the IRE store, IRE merchandise and shirts with the winning design from the T-shirt contest. Studio Foyers - 2nd 2020-03-07T08:30:00 2020-03-07T18:00:00 America/Chicago
1003 Mastering Google Sheets: Web scraping, running scripts and other tricks (Saturday) Google Sheets is more than just free spreadsheet software to organize and store data. This hands-on session will start with pivot tables and conditional formatting, and through examples, we'll also learn how to scrape data in seconds without code, automate menial tasks with macros, write custom spreadsheet formulas as well as how to send emails, geocode addresses, translate text and more – all through the power of Google Sheets. Come with a laptop and leave with the knowledge of a Google Sheets power user. Preregistration is required and seating is limited. You must bring your own laptop (no tablets) to this training and have a Google account. Workshop prerequisites: You should be familiar with using spreadsheets and formulas. Studio 1 - 2nd Frank Bi, Vox Media;Samantha Sunne, Independent journalist 2020-03-07T09:00:00 2020-03-07T12:30:00 America/Chicago
1006 Digging into data for stories: A crash course in Excel Get started using data in your stories with IRE's original mini-boot camp. In this 7-hour, hands-on workshop, IRE’s experienced trainers will start with the basics of navigating Excel and using formulas, then walk you through sorting, filtering and aggregating data with pivot tables to find story ideas. You'll come away with a solid base for using data analysis in your newsroom, including how to find and request data, identify and clean dirty data, find story ideas and bulletproof your work. We’ll also provide you with our detailed boot camp materials to help keep you on track long after you leave the conference. Preregistration is required and seating is limited. Laptops will be provided for the training. Workshop prerequisites: There are no prerequisites for this workshop and beginners are welcome. This workshop is good for those wanting to get started analyzing data for stories. Studio 2 - 2nd Patti DiVincenzo, IRE & NICAR;Sarah Hutchins, IRE & NICAR;Francisco Vara-Orta, IRE & NICAR 2020-03-07T09:00:00 2020-03-07T12:30:00 America/Chicago
1009 Exploring the tidyverse in R Learn how to use the tidyverse, a collection of R packages, to help you make your data journalism more efficient, stronger and more fun. Learn how to import, clean, analyze and plot data for your stories. If you want to modernize your R workflow with dplyr, tidyr, readr, ggplot2, tibble and purr, this class is for you. This workshop assumes some familiarity with R and RStudio, or programming experience in another language (e.g., Python or JavaScript), but will start from the beginning with tidyverse principles. Preregistration is required and seating is limited. Laptops will be provided for the training. Workshop prerequisites: You should be comfortable working with R and RStudio and be familiar with basic data analysis. Studio 7 - 2nd Aaron Kessler, Bloomberg Industry Group;Amelia McNamara, University of St. Thomas 2020-03-07T09:00:00 2020-03-07T17:45:00 America/Chicago
1011 First graphics app: Node.js in the newsroom Armand Emamdjomeh, Elbert Wang and Ben Welsh teach you how America’s top news organizations escape rigid content-management systems to publish custom graphics on deadline. Take this six-hour class to get hands-on experience in every stage of the development process, writing JavaScript, HTML and CSS within a Node.js framework. You’ll start with data from a real-life Los Angeles Times analysis. You won’t stop until you’ve crafted a custom presentation and deployed a working application on the World Wide Web. Preregistration is required and seating is limited. Laptops will be provided. Workshop prerequisites: If you have a good attitude and know how to take a few code crashes in stride, you are qualified for this class. If you’re a little scared, that’s a good thing. You’re ready for this. Studio 3 - 2nd Elbert Wang, The Wall Street Journal;Ben Welsh, Los Angeles Times 2020-03-07T09:00:00 2020-03-07T17:45:00 America/Chicago
1012 Web scraping with Python If you need data that's trapped on a website, writing some code to scrape the page could be your solution. This entry-level class will show you how to use the Python programming language to harvest information from websites into a spreadsheet. We'll introduce you to the command line and show you how to write enough code to fetch and parse web content. Preregistration is required and seating is limited. Laptops will be provided. Workshop prerequisites: This class is programming for beginners. Some basic familiarity with Python and HTML is helpful but not required. Studio 9 - 2nd Hannah Cushman Garland, DataMade 2020-03-07T09:00:00 2020-03-07T12:30:00 America/Chicago
1020 Master class: Finding and telling stories with earth imagery Satellites, planes, drones — thanks to these and other planetary-sensors, we know more about our earth, its oceans, landscapes and cityscapes than ever before. With heaps of new data and tools at our disposal, journalists are among the many people accessing this wellspring of source data and using it to show changes at global and local scales at an ever-increasing rate, from the disappearing polar ice caps to monitoring local port shipments. This workshop will provide an introduction to practical geographic journalism through concrete case studies. It will then offer tools and skills that can help you start infusing earth imagery into your stories. You will leave this workshop with a new way of thinking about earth imagery and how to use it. Prerequisites: There are no prerequisites but it would be helpful to have some experience with QGIS, bash (imagemagick, ffmpeg, gdal), and Photoshop. Galerie 5 - 2nd Tim Wallace, Descartes Labs 2020-03-07T09:00:00 2020-03-07T12:30:00 America/Chicago
1023 Educators meetup If you teach data journalism, investigative reporting or any journalism course, join your fellow instructors for a discussion about what works, what doesn’t, and what’s new in the classroom. We’ll include a preview of the upcoming edition of IRE’s Investigative Reporters Handbook and the related resources it will offer, coming out in June. Galerie 4 - 2nd Mark Horvit, University of Missouri;Brant Houston, University of Illinois 2020-03-07T09:00:00 2020-03-07T10:00:00 America/Chicago
1081 Advanced SQL: Update queries, sub-queries and more If you feel comfortable with the Structured Query Language basics that IRE teaches in its bootcamps — SELECT, FROM, WHERE, GROUP BY — but are ready to see what else SQL can do, this session is for you. We will cover more advanced ways of manipulating and questioning data, such as UPDATE queries, joins, writing sub-queries and other neat tricks. We will use SQLite in the class. This session will be most helpful if: You are comfortable with counting and summing in SQL. Studio 10 - 2nd Madi Alexander, The Dallas Morning News 2020-03-07T09:00:00 2020-03-07T10:00:00 America/Chicago
1139 Data Dive 3: Cancer Alley, H-1B Visas, sexual abuse and assault A data deep dive into some of the best data journalism of 2019. Hear from reporters how they gathered, cleaned, analyzed and visualized the data behind some of the year's biggest stories. Bissonet - 3rd Lise Olsen, Texas Observer;Sinduja Rangarajan, Mother Jones;Lucia Walinchus, Eye on Ohio, the Ohio Center for Investigative Journalism;Lylla Younes, ProPublica 2020-03-07T09:00:00 2020-03-07T10:00:00 America/Chicago
2026 Command line for reporters (Mac) 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. Studio 6 - 2nd AJ Vicens, Mother Jones 2020-03-07T09:00:00 2020-03-07T10:00:00 America/Chicago
2095 Enriched census data from IPUMS IPUMS provides census and survey data from around the world integrated across time and space. In this session, we’ll take a tour of IPUMS data collections and resources, focusing on unique U.S. census data products and how to access them. We have U.S. census data from 1790 through the present and for all geographic levels down to blocks, including microdata (individual-level responses), summary data, time series, and GIS files. Users can download customized data files, generate microdata summaries online, or access geographic data through a new API. Whether you’re an IPUMS newbie or a regular, this session will get you caught up with the latest IPUMS has to offer. Galerie 6 - 2nd Jonathan Schroeder, IPUMS 2020-03-07T09:00:00 2020-03-07T10:00:00 America/Chicago
2111 Mobile, data and desktop reporting tools for your newsroom Trainer Mike Reilley returns to NICAR to share the latest and greatest mobile and desktop tools to create data viz, handle digital workflow and fact-check information. This workshop is fast-paced, so bring a fully charged laptop, smartphone and a double espresso. You'll leave with some cool projects, digital handouts and other resources you can take back to your newsroom or classroom. Acadia - 3rd Mike Reilley, University of Illinois-Chicago 2020-03-07T09:00:00 2020-03-07T10:00:00 America/Chicago
2172 QGIS 1: Mapmaking for beginners 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. Studio 8 - 2nd John Walton, BBC News 2020-03-07T09:00:00 2020-03-07T10:00:00 America/Chicago
2246 How researchers and journalists work together and why it sometimes falls apart A discussion between three researchers/scientists and a journo, exploring how the press can best work with academic communities, both as a source of wisdom and knowledge and also data. What are each side’s complementary interests, and why do they sometimes collide? How do scientists and journos use data, and how those uses sometimes differ? And why journos often focus on outliers, the statistical tails, and why scientists usually don’t. Galerie 3 - 2nd Michael Polito, Louisiana State University, Department of Oceanography and Coastal Sciences;Nancy Rabalais, Louisiana Universities Marine Consortium;Edward Shihadeh, Louisiana State University;Maurice Tamman, Reuters 2020-03-07T09:00:00 2020-03-07T10:00:00 America/Chicago
2488 Exhibitors and recruiters Be sure to stop by the Studio foyers on the 2nd floor and visit with the exhibitors/recruiters. Studio Foyers - 2nd 2020-03-07T09:00:00 2020-03-07T17:00:00 America/Chicago
2492 FOIA on the fly The promise of the Freedom of Information Act often falls short of expectations, and the process can be long and drawn-out. For a beat reporter, FOIA can be particularly daunting. This panel will provide concrete strategies for conceptualizing, drafting, filing and employing strategies to get records on deadline. It also will offer a realistic guide to filing and managing your FOIA requests, how to use FOIA when you're swamped or busy, how to strategize to get materials more quickly, and where to look for already-FOIA'd information that might be in the public domain. Galerie 2 - 2nd James Grimaldi, The Wall Street Journal;Daniel Jeon, Reporters Committee for Freedom of the Press;Katie LaGrone, E.W. Scripps Company 2020-03-07T09:00:00 2020-03-07T10:00:00 America/Chicago
2494 Practical machine learning for investigations with fast.ai (Saturday morning) Get hands-on experience using this accessible, open-source Python library to classify images, text, and rows of data -- potentially saving you hours or days of work poring through the data. In the process, you'll also get a feel for the power -- and limits -- of machine learning. This session with John Keefe and Jeremy Merrill of the Quartz investigations team will introduce you to the concept of machine learning and several practical uses for it in your newsroom. Preregistration is required and seating is limited. Computers will be provided. Prerequisites: A Google (aka Gmail) account. Basic understanding of Python is recommended but not required. Studio 4 - 2nd John Keefe, Quartz;Jeremy Merrill, Quartz 2020-03-07T09:00:00 2020-03-07T12:30:00 America/Chicago
1036 Finding and using international data You find yourself having to find data in a country you've never dealt with before, or you'd like to explore the data available in your own country. Where do you even start? This panel will take you through a tried and tested path which will help unearth data in unfamiliar territory around the world. If you already have experience of this, come along and share. Galerie 6 - 2nd Winny de Jong, NOS;Louis Goddard, Global Witness;Giannina Segnini, Columbia University 2020-03-07T10:15:00 2020-03-07T11:15:00 America/Chicago
1128 MySQL 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 Studio 10 - 2nd 2020-03-07T10:15:00 2020-03-07T11:15:00 America/Chicago
2027 Voter file data, from toplines to deep dives to breaches Voter file data can be an important reporting tool, but the data is so fragmented it's difficult to find, standardize and aggregate. In addition, readers are often shocked that this level of data is available. We will discuss practical tips for when voter data is useful, how to find and process it, what it can't do, and how to report accurately and responsibly on voter data breaches, and leave lots of time for voter data questions! Bissonet - 3rd Carla Astudillo, Texas Tribune;Jessica Huseman, ProPublica;Caitlin Ostroff, The Wall Street Journal;Rachel Shorey, The New York Times 2020-03-07T10:15:00 2020-03-07T11:15:00 America/Chicago
2070 Exploring networks with graph databases 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. Studio 6 - 2nd Leila Haddou, Independent journalist 2020-03-07T10:15:00 2020-03-07T11:15:00 America/Chicago
2105 Dear diary: Best practices for keeping a data diary Data diaries are absolutely necessary and very hard to do right. They're an honest description of your steps and missteps, a way to recover from errors and a critical guide to self-learning. What formats do people use to keep track of their data, their queries, etc.? Galerie 3 - 2nd Ally Jarmanning, WBUR;Emmanuel Martinez, The Markup;Ken Sweet, The Associated Press 2020-03-07T10:15:00 2020-03-07T11:15:00 America/Chicago
2175 QGIS 2: Analyzing geographic data Build on your existing knowledge of QGIS and learn how to filter and analyze geographic datasets, before familiarising yourself with labelling and exporting publication-ready maps using the print composer. This session is good for: Those who attended the QGIS I workshop or already know the basics of visualizing geographic data in QGIS. Studio 8 - 2nd Christine Jeavans, BBC News 2020-03-07T10:15:00 2020-03-07T11:15:00 America/Chicago
2209 CANCELED - Burner profiles: Using virtual machines to protect yourself from doxxing Acadia - 3rd 2020-03-07T10:15:00 2020-03-07T11:15:00 America/Chicago
2212 Unpacking AI’s influence in society From shopping to dating, many companies are already using AI technology to shape our everyday life. But what about our most trusted community institutions? This panel will unpack how AI is being deployed and adapted by our institutions from police to courts to news outlets and more. Galerie 2 - 2nd Nicholas Diakopoulos, Northwestern University;Karen Hao, MIT Technology Review;Melissa Hellmann, The Seattle Times;Andrea Hickerson, University of South Carolina 2020-03-07T10:15:00 2020-03-07T11:15:00 America/Chicago
2237 Introducing and implementing security protocols in your reporting process Opening secure communication channels is a great way to establish trust and offer confidentially to sources. But setting up secure tip lines costs time and money, and it can be a challenge if you have limited resources. This will be a space to talk about different ways to include security measures in your reporting process, whether you're a local reporter, student journalist, freelancer, etc. No digital security experience required! We'll discuss the different tools available (e.g. encrypted messaging apps), resources you can start with, what protocols you can set up if you and/or your newsroom have a limited budget, and common security challenges. Let's brainstorm ideas and help you find solutions that work best for you and/or your newsroom! Galerie 4 - 2nd Phi Do, Los Angeles Times 2020-03-07T10:15:00 2020-03-07T11:15:00 America/Chicago
1061 Building and telling a bulletproof data story 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. Galerie 3 - 2nd Helena Bengtsson, Sveriges Television;Matt Dempsey, Houston Chronicle;Kimbriell Kelly, Los Angeles Times 2020-03-07T11:30:00 2020-03-07T12:30:00 America/Chicago
1221 Reasoning for data visualization Visualization is often taught as a set of rules that are set in stone — "pie charts are dumb!", "make all your graphs start at 0!", "increase data-ink ratio!" — but what if those rules have shaky foundations, being based just on the very personal aesthetic preferences of a handful of influential authors? This talk suggests that visualization is more similar to writing that we think: It's constrained by the limitations of the human brain but, beyond that, it's as flexible as written language, if not more. Instead of thinking of rules, then, visualization designers should learn how to make justified and informed decisions instead. Bissonet - 3rd Alberto Cairo, University of Miami 2020-03-07T11:30:00 2020-03-07T12:30:00 America/Chicago
2113 Text mining in R with tidytext Do you want to analyze the themes, sentiment, and complexity of every State of the Union address, or analyze @realDonaldTrump's use of Twitter? This session will introduce you to the tools needed to tackle these and other challenges in text analysis in R, using the tidytext package. This session is good for: People familiar with the basics of R. Studio 6 - 2nd Peter Aldhous, BuzzFeed News 2020-03-07T11:30:00 2020-03-07T12:30:00 America/Chicago
2247 Beyond formulas: A statistical world view For years, we’ve been talking to each other about how to think about numbers and statistical tools. Now hear from a leading applied statistician and get views from outside our world on how journalists should be thinking about data and numbers. We’ll talk about methods new and old --- and how to avoid mistakes that give statisticians heartburn. Galerie 6 - 2nd James Cochran, The University of Alabama;Sarah Cohen, Walter Cronkite School of Journalism, Arizona State University 2020-03-07T11:30:00 2020-03-07T12:30:00 America/Chicago
2268 Making graphics with R (repeat) Numbers tell stories. Charts and maps bring those stories alive. We’ll use R and some of its libraries to find and visualize stories in census data about New Orleans and Louisiana. This class is best for: People who are comfortable with Excel and looking for something more powerful; beginner knowledge of R is good but not required. Studio 8 - 2nd Ronald Campbell, NBC Owned Television Stations 2020-03-07T11:30:00 2020-03-07T12:30:00 America/Chicago
2380 Art of the interview Learn proven strategies for managing the investigative interview, with tips on preparation, approaching difficult subjects and keeping the conversation on track. Galerie 2 - 2nd Lauren McGaughy, The Dallas Morning News;Tisha Thompson, ESPN;Lee Zurik, WVUE-TV 2020-03-07T11:30:00 2020-03-07T12:30:00 America/Chicago
2400 Finding data for local investigations Local investigations present unique opportunities and challenges for journalists working with data. Local data is often thought of as sparse since smaller localities do not always have the resources necessary to document and open source their information. Similarly, small newsrooms don’t always have the bandwidth to sponsor long-term and expensive data-collection initiatives. However, working with data at the local level also presents advantages. Local reporters have the opportunity to grow intimately familiar with the various types of information aggregated in their jurisdictions. Also working at a smaller scale can make a greater number of investigations possible. This talk will shed light on how to find data for local investigations, and take advantage of the seemingly limited resource environment that local reporters draw from when seeking aggregate information for their stories. Acadia - 3rd Tyler Dukes, WRAL News;Jenifer McKim, New England Center for Investigative Reporting;Lylla Younes, ProPublica 2020-03-07T11:30:00 2020-03-07T12:30:00 America/Chicago
2457 CANCELED - Consolidate, shape, and re-use web data with Excel Power Query There is extremely valuable data available to anyone on the web. However, it is often published in ways that make it laborious to use. During this hands-on training session we will consolidate historic women’s soccer data from the past 54 years. We will be using a tool you most likely already have access to: Microsoft Excel and the Power Query functionality built into it. Power Query is Microsoft’s Data Connectivity and Data Preparation technology that lets you seamlessly access data stored in hundreds of sources and reshape it to fit your needs — all with an easy to use, engaging, no-code experience. This technology is also used in Power BI, so the skills you’ll learn will be applicable there. This session is good for: Those who are familiar with spreadsheets. Studio 10 - 2nd 2020-03-07T11:30:00 2020-03-07T12:30:00 America/Chicago
2459 Using the Public Accountability Project to boost your reporting The Accountability Project from The Investigative Reporting Workshop lets you search more than half a billion records from federal, state and local government data. We'll give you a tour of the site, show you the latest features and send you home with data you can turn into stories. Galerie 4 - 2nd Jacob Fenton, PublicAccountability.org;Jennifer LaFleur, Investigative Reporting Workshop 2020-03-07T11:30:00 2020-03-07T12:30:00 America/Chicago
1001 Interactive data viz with D3 Bring your data to life with elegant and intelligent visualizations with the D3 JavaScript library. We'll start with some Scalable Vector Graphics (SVG) basics and learn what makes the D3 library so powerful, then use real-world datasets to build your first D3 chart. We will build on D3 basics by exploring more complex chart forms, covering functions for fetching and manipulating data, and introducing transitions and interaction. We will write working code together, break down how some of our favorite examples of D3 charts work and practice reading documentation so you can gain expertise on your own. Preregistration is required and seating is limited. Laptops will be provided for the training. Workshop prerequisites: Attendees should have some knowledge of HTML/CSS and JavaScript. Previous D3 experience is not required. Studio 9 - 2nd Darla Cameron, Texas Tribune 2020-03-07T14:15:00 2020-03-07T17:45:00 America/Chicago
1018 CANCELED - Master class: Interviewing Learn how to master the interview to hold your sources accountable. This workshop will move from getting the interview, to conducting the interview, to capitalizing on the interview when it’s time to write. This master class by investigative reporters Monica Rhor and Audra Burch is designed to teach you: * how — and when — to land a tough interview * how to prepare before an interview and also adapt on the spot * the power of silence * the power of sincerity * interviewing people who have been hurt, and interviewing the people who hurt them Galerie 5 - 2nd 2020-03-07T14:15:00 2020-03-07T17:45:00 America/Chicago
1051 Research gumbo: Redux Williams and Gray engineer a stew out of the latest in public records research and advanced search techniques. Galerie 6 - 2nd Barbara Gray, Craig Newmark Graduate School of Journalism, CUNY;Margot Williams, The Intercept 2020-03-07T14:15:00 2020-03-07T15:15:00 America/Chicago
1071 Excel: Importing data Don't give up if your data isn't presented in a neat Excel file. This session will teach you how to clean and format data to get it into Excel. We will look at how to import text files and get a table on a web page into Excel. This session is good for: Anyone comfortable working in Excel. Studio 8 - 2nd Jeff Kelly Lowenstein, Grand Valley State University 2020-03-07T14:15:00 2020-03-07T15:15:00 America/Chicago
1078 SQL 1: Exploring data (repeat) Learning to manipulate data is a bit like learning a new language. Actually, it is a language, called Structured Query Language (SQL). This session is an introduction to using SQL to zero in on your data by viewing slices and chunks of it and putting it into a useful order so you can spot the stuff you need to get started toward a story. We'll use DB Browser for SQLite, a free database manager. This session is good for: People with some experience working with data in columns and rows, in spreadsheets or database managers. Studio 10 - 2nd Emmanuel Martinez, The Markup 2020-03-07T14:15:00 2020-03-07T15:15:00 America/Chicago
1086 R 1: Intro to R and RStudio (repeat) Jump into statistics with R, the powerful open-source programming language. In this class we’ll cover R fundamentals and learn our way around the RStudio interface for using R. This session is good for: People with a basic understanding of code who are ready to go beyond Excel. Studio 2 - 2nd Ryan Thornburg, UNC-Chapel Hill 2020-03-07T14:15:00 2020-03-07T15:15:00 America/Chicago
2030 Practical machine learning for investigations with fast.ai (Saturday afternoon) Get hands-on experience using this accessible, open-source Python library to classify images, text, and rows of data -- potentially saving you hours or days of work poring through the data. In the process, you'll also get a feel for the power -- and limits -- of machine learning. This session with John Keefe and Jeremy Merrill of the Quartz investigations team will introduce you to the concept of machine learning and several practical uses for it in your newsroom. Preregistration is required and seating is limited. You must bring your own laptop (no tablets) to this training. Prerequisites: A Google (aka Gmail) account. Basic understanding of Python is recommended but not required. Studio 1 - 2nd John Keefe, Quartz;Jeremy Merrill, Quartz 2020-03-07T14:15:00 2020-03-07T17:45:00 America/Chicago
2083 Using csvkit to wrangle data without Excel Ever had data too large to open in Excel? Or need to quickly join or merge datasets without the benefit of a database? We will show you how to harness the awesome power of csvkit to wrangle large datasets on the command line. It's easy to use, fast and powerful. It's a must in every data journalist's toolbox. This session is good for: People who want a solution for working with multiple CSV files without having to open Excel or to join or merge files without a database. Studio 6 - 2nd Christian McDonald, University of Texas at Austin 2020-03-07T14:15:00 2020-03-07T15:15:00 America/Chicago
2166 Tracking 2020 digital ads: Learn the secrets of new political ad databases In summer 2018, Facebook, Google and Twitter created new political ad archives to help the public and the press track political ads on their platforms, bringing more transparency to the sponsors of digital ads. These databases and data sets are not widely known or widely utilized, but they can be used for stories about candidates and dark money groups. Here’s what you need to know about these new political ad databases. Galerie 2 - 2nd Laura Edelson, New York University;Erika Franklin Fowler, Wesleyan Media Project;Sheila Krumholz, Center for Responsive Politics;Nancy Watzman, Lynx LLC 2020-03-07T14:15:00 2020-03-07T15:15:00 America/Chicago
2254 The life of a data story: Going from data to narrative 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. Acadia - 3rd Ariana Giorgi, The Dallas Morning News;Anita Hassan, NBC News Digital;Brooke Williams, Boston University 2020-03-07T14:15:00 2020-03-07T15:15:00 America/Chicago
2285 Being scrappy: Doing data journalism as a team of one How can solo journalists pull off ambitious data projects without the resources of a newsroom team? In this session, two journalists dive into their data world to offer support and ideas for real stories you can turn, organizational tips, and how/where to dig in order to successfully produce impactful pieces. Galerie 4 - 2nd Samah Assad, CBS Chicago/WBBM;Carolyn Thompson, Independent journalist 2020-03-07T14:15:00 2020-03-07T15:15:00 America/Chicago
2395 Finding the story in property records “Who owns what” is a classic reporting problem with a broad range of applications, whether you’re breaking news or during investigative work. In this workshop, we’d go over common types of property records that are likely kept by your local, county, and state governments—including corporation filings that are useful for peeking behind pesky LLCs. We’ll also point out a few common issues with this type of data (assessors and recorders usually don’t share data!), pose general solutions to them (both with and without knowledge of coding languages), and walk through a sample scraper. Bissonet - 3rd Haru Coryne, ProPublica Illinois 2020-03-07T14:15:00 2020-03-07T15:15:00 America/Chicago
2463 Career roundtable: Making big moves Whether it's a new investigation, a new beat or a new job, the choices we make early on can set us on the path to success — or ruin. This panel of four reporters will offer practical tips on changing gears or media, source-development and finding the story others have missed. Galerie 3 - 2nd Caitlin Ostroff, The Wall Street Journal;Brian Rosenthal, The New York Times;Brandon Stahl, KARE 11;Cheryl W. Thompson, National Public Radio 2020-03-07T14:15:00 2020-03-07T15:15:00 America/Chicago
2501 Excel tricks you've never used (repeat) Excel has so many tips, tricks and time-saving tools you might not know about, even if you're a whiz at CONCATENATE functions and PivotTables. You should pick up a few new tricks in this fast-paced and fun session. This session is best for: Those with intermediate knowledge of spreadsheets. Studio 4 - 2nd Denise Malan, IRE & NICAR 2020-03-07T14:15:00 2020-03-07T15:15:00 America/Chicago
1072 Excel CARwash: Cleaning dirty data Dirty data lurk everywhere. We'll walk through some integrity checks to help diagnose problems with your data and learn how to deal with some of the most common problems, including standardizing misspelled names. This session is good for: People with some experience working with data in columns and rows, in spreadsheets or database managers. Studio 8 - 2nd Jennifer Smith Richards, Chicago Tribune 2020-03-07T15:30:00 2020-03-07T16:30:00 America/Chicago
1079 SQL 2: Grouping and summing data (repeat) 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. Studio 10 - 2nd Pam Dempsey, Midwest Center for Investigative Reporting 2020-03-07T15:30:00 2020-03-07T16:30:00 America/Chicago
1087 R 2: Data analysis and plotting (repeat) 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. Studio 2 - 2nd Meghan Hoyer, The Associated Press 2020-03-07T15:30:00 2020-03-07T16:30:00 America/Chicago
1222 Using data viz to explore data and find stories Details coming soon! Galerie 3 - 2nd Mark Hansen, Columbia University;Stephanie Lamm, The Houston Chronicle;CJ Sinner, The Star Tribune 2020-03-07T15:30:00 2020-03-07T16:30:00 America/Chicago
2171 How to build a live data-driven application that never crashes One of the hardest parts about building a live data-driven application is building one that both responds to new data quickly and doesn't crash under the load of traffic. In this session, you will learn how to build resilient services that make traffic no longer a concern. This session is good for: People with experience deploying web applications. Studio 6 - 2nd Tyler Fisher, News Catalyst 2020-03-07T15:30:00 2020-03-07T16:30:00 America/Chicago
2222 How to make data findings come to life on radio It's always been tricky to make data findings come to life on radio. Radio producers appreciate the role of data in investigative findings, but often producers and data reporters have to come up with creative and innovative solutions. This session will take the audience through some successful award-winning examples and unpack the different kinds of datasets that can lend themselves to the different strategies whether it is programmatic data sonification, creative use of narration or using a live church choir. Galerie 6 - 2nd Robert Benincasa, National Public Radio;Michael Corey, The Star Tribune;Jenifer McKim, New England Center for Investigative Reporting;Sinduja Rangarajan, Mother Jones 2020-03-07T15:30:00 2020-03-07T16:30:00 America/Chicago
2402 Digital security hygiene and threat modeling for journalists Details coming soon! Bissonet - 3rd Kristen Kozinski, The New York Times;Rowen S, Freedom of the Press Foundation;Mike Tigas, ProPublica 2020-03-07T15:30:00 2020-03-07T16:30:00 America/Chicago
2437 Leading the data team, or how to get the best from your newsroom’s brightest people This panel will discuss the non-technical side of data team management and share ideas for handling some of the thornier issues most teams face. How to work with other teams in the newsroom. Avoiding the dreaded “service desk” mentality. Creating a supportive environment for learning while also holding folks accountable for the work they do. How to manage team members who are more technically skilled than you are. Galerie 2 - 2nd Matt Dempsey, Houston Chronicle;Emily Le Coz, GateHouse Media 2020-03-07T15:30:00 2020-03-07T16:30:00 America/Chicago
2450 How to squeeze court records to get the most juice Whether you're on a beat, on an investigative team or at a research desk, court records are a resource you can't ignore. They are as valuable as they are difficult to access and analyze en masse. In this panel we'll talk about our myriad experiences getting these tricky troves to bear fruit for stories, as well as tips for finding and using them. Acadia - 3rd Jaimi Dowdell, Reuters;Elizabeth Lucas, Kaiser Health News;Brett Murphy, USA TODAY 2020-03-07T15:30:00 2020-03-07T16:30:00 America/Chicago
2460 Census Reporting 2.0 With the decennial census approaching, the Census Reporter team is thinking again about making tools to help journalists use Census data. We want to hear from journalists of all experience levels about what they want to do with Census data, especially decennial and American Community Survey. We don’t have funding right now, but we’re hoping that you all can help us paint an irresistible picture of a system that could be built, and use it to help build the support we need to make it happen. This will be a structured session designed to capture “step,” “stretch,” and “leap” improvements to the experience of finding and making sense of Census data. Galerie 4 - 2nd Joe Germuska, Northwestern University Knight Lab 2020-03-07T15:30:00 2020-03-07T16:30:00 America/Chicago
2476 Finding the story: Campaign finance in SQL Learn how to decipher federal campaign finance filings, how to find stories and how to navigate the limitations of the data. This session is good for: People who are comfortable with SQL, but no specific campaign finance knowledge is required. Studio 4 - 2nd Charles Minshew, IRE & NICAR 2020-03-07T15:30:00 2020-03-07T16:30:00 America/Chicago
1073 Excel: Using string functions to manipulate data 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. Studio 8 - 2nd Doug Haddix, IRE & NICAR 2020-03-07T16:45:00 2020-03-07T17:45:00 America/Chicago
1080 SQL 3: Joining tables (repeat) 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. Studio 10 - 2nd Janelle O’Dea, St. Louis Post-Dispatch 2020-03-07T16:45:00 2020-03-07T17:45:00 America/Chicago
1088 R 3: Gathering and cleaning data (repeat) Learn how to use R to scrape data from web pages, access APIs and transform the results into usable data. This session will also focus on how to clean and structure the data you've gathered in preparation for analysis using tidyverse packages. This session is good for: People who have used R and have a basic understanding of how to retrieve data from APIs. Studio 2 - 2nd Sean Mussenden, Howard Center for Investigative Journalism 2020-03-07T16:45:00 2020-03-07T17:45:00 America/Chicago
1216 Exploratory data viz: A tool for collaborative data reporting As data reporters, we can find that our skills are in demand across the newsroom, making it essential that we are able to collaborate effectively with more traditional beat reporters. We may find ourselves working with a non-data reporter who needs to be able to explore a large dataset herself, securely and on deadline. This workshop will present a selection of Python-based methods for producing exploratory visualizations at speed from medium- to large-sized and geographic datasets. This session uses web-based tools such as Colaboratory and Vega Editor, and no coding experience is required (though Google and GitHub accounts are required to be able to follow the tutorial). Studio 4 - 2nd David Blood, Financial Times 2020-03-07T16:45:00 2020-03-07T17:45:00 America/Chicago
1223 Work-life balance Details coming soon! Acadia - 3rd Rebecca Catalanello, Politifact;Steve Myers, USA TODAY 2020-03-07T16:45:00 2020-03-07T17:45:00 America/Chicago
2150 Using data in your reporting as a student Join a discussion to learn how you can use data in your reporting as a student journalist. Bring tips on how you reported with data in your newsroom and questions if you're looking to break into data journalism. Galerie 4 - 2nd Taylor Johnston, Ohio University;Abigail Mercer, Daytona Beach News-Journal;Yue Stella Yu, Independent journalist 2020-03-07T16:45:00 2020-03-07T17:45:00 America/Chicago
2218 News automation is booming: How newsrooms are embracing automation Join us to discuss how automation is changing newsrooms and journalism roles. Some newsrooms are vanguards for automating parts of news production, from information gathering and storytelling to data-driven tools that help journalists to do their jobs. Our panelists will share insights about how the industry has adopted automation techniques. Where are these tools heading next? What could other newsrooms learn from their experience? Also, what kind of new skills do journalists need when newsrooms embrace this kind of technology? Galerie 6 - 2nd Nicholas Diakopoulos, Northwestern University;Tiff Fehr, The New York Times;Casey Miller, Los Angeles Times;Brad Skillman, Bloomberg News 2020-03-07T16:45:00 2020-03-07T17:45:00 America/Chicago
2399 Using IRS nonprofit data and decoding 990s Learn how to use nonprofit data from the IRS, including how to read a 990. This session will cover how to read key parts of the 990 for news and research purposes, how to use some of the IRS’ own data files to learn more about how nonprofits in your state rank (including the filing extracts file, which contains a wealth of information and many people don’t know about), and how to use Nonprofit Explorer’s new full-text search. Bissonet - 3rd Andrea Fuller, The Wall Street Journal;Ken Schwencke, ProPublica 2020-03-07T16:45:00 2020-03-07T17:45:00 America/Chicago
2405 Collaborate tool Learn about open-source tools for making data projects involving multiple teams or newsrooms easier. ProPublica's Collaborate tool can help organize, sort, assign, label and redact data sets, either within a newsroom or between organizations. Galerie 2 - 2nd Rachel Glickhouse, ProPublica 2020-03-07T16:45:00 2020-03-07T17:45:00 America/Chicago
2410 Community-powered data collection: Enlisting your audience to help power investigations This panel will walk through key considerations in doing “community-powered” data journalism, in which the public is enlisted to build tools, collect data, share records or dig through documents. We will look at large and small scale projects with big impact. Galerie 3 - 2nd Ally Levine, Reuters;Maya Miller, ;Deborah Nelson, University of Maryland Philip Merrill College of Journalism;Krishnan Vasudevan, Philip Merrill College of Journalism, University of Maryland, College Park 2020-03-07T16:45:00 2020-03-07T17:45:00 America/Chicago
2475 Geocoding using programming Sometimes, you need more firepower than what you can get using online geocoding tools. This session will show you how to access a geocoding API to retrieve location data using the Python programming language. This session is good for people whose geocoding needs have outgrown point-and-click tools and who have basic experience writing Python. Studio 6 - 2nd Jonathan Soma, Columbia Journalism School 2020-03-07T16:45:00 2020-03-07T17:45:00 America/Chicago
2499 Closing reception Head to the New Orleans Audubon Aquarium of the Americas for a closing reception hosted by The Times-Picayune and The Advocate. Enjoy the aquarium while networking with fellow attendees. Light hors d’ oeuvres will be served, and each conference attendee will receive one drink ticket for a soft drink, beer, wine, call liquor or water. Audubon Aquarium of the Americas is located at 1 Canal Street, New Orleans, approximately 0.4 miles from the New Orleans Marriott. New Orleans Audubon Aquarium of the Americas - 2020-03-07T18:30:00 2020-03-07T19:30:00 America/Chicago
1092 JavaScript 2: Hello D3! (repeat) We’ll cover the basics of getting started with D3, even if you’ve never used it before. Then we’ll take use some real data to create a few basic charts. This session is good for: People with a basic grasp of JavaScript syntax. Studio 3 - 2nd Ellis Simani, ProPublica 2020-03-08T09:00:00 2020-03-08T10:00:00 America/Chicago
1097 Stats 1: An introduction (repeat) Statisticians need to really understand their data (and so do you!) before they begin running analyses. As a result, stats software like RStudio has many powerful tools to summarize your data. You're going to love them. We'll take a look at the structure of data in RStudio, do data transformations and run some basic statistical tests. This session is good for: People who have familiarity with Excel and some database software. We've got a *lot* of ground to cover in this hour. Studio 2 - 2nd Sara Stoudt, University of California Berkeley 2020-03-08T09:00:00 2020-03-08T10:00:00 America/Chicago
1102 Python 1: The fundamentals (repeat) An introduction to the Python programming language for absolute beginners. This session will cover the fundamentals and basic syntax to prepare you for more advanced classes. This session is good for: People who are comfortable working with data in spreadsheets or database managers and want to make the leap to programming. Studio 6 - 2nd Mindy McAdams, University of Florida 2020-03-08T09:00:00 2020-03-08T10:00:00 America/Chicago
1114 PDF 1: Using free online tools (repeat) 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. Studio 7 - 2nd Adelaide Chen, Orlando Sentinel 2020-03-08T09:00:00 2020-03-08T10:00:00 America/Chicago
1123 CANCELED - Finding the story: Opioid data As the opioid epidemic morphs in communities across the country, this session will help you identify data sources to cover opioid prescribing, hospitalizations, overdoses and treatment options, as well as strategies to cover an ever-changing problem. This session is good for: Those with basic spreadsheet skills. Studio 4 - 2nd 2020-03-08T09:00:00 2020-03-08T10:00:00 America/Chicago
2052 TL;DR: What to remember when you forget everything else There is so much to take away from this conference and so many data tools available that it can be hard to remember just what to remember when you head home, especially if you're newer to the data world. This session will be in everyone's favorite viral format: The listicle! You'll get these tips — and plenty more: The five most important SQL tips, five random (but helpful) Excel functions, and 10 ways to fact-check your analysis. Galerie 2 - 2nd Jamie Grey, InvestigateTV;Bracey Harris, The Hechinger Report;Tisha Thompson, ESPN 2020-03-08T09:00:00 2020-03-08T10:00:00 America/Chicago
2067 Election 2020 hackathon Details coming soon! Galerie 4 - 2nd Derek Willis, ProPublica 2020-03-08T09:00:00 2020-03-08T12:30:00 America/Chicago
2308 Master class: Getting ready to cover Census 2020 The 2020 census has already begun. In mid-March, it ramps up with a blizzard of millions of mailed invitations to respond. The data and story possibilities will follow almost immediately and continue through at least 2022. Are you ready? Especially if you have not covered a census, this workshop will prepare you to make a plan, gather the data, understand it and turn it into compelling stories. D'Vera Cohn and Paul Overberg have each been writing about the census since 1990. Dee, who covered census topics for The Washington Post before working for Pew Research, led five Poynter Institute 2020 census workshops for journalists over the past year. Paul led IRE-sponsored census training workshops and panels since 2000, and covered demographics for USA Today and The Wall Street Journal for more than 25 years. This three-hour workshop will include: * What numbers are coming when? * Census-speak: Concepts and definitions to unlock the data and avoid newbie errors * Geography: Understanding the "where" to find stories from neighborhood to national * Seven stories any newsroom can do * Examples of great 2010 census stories * How census numbers can be used on every beat * Making a newsroom plan: How to pick your spots and get outside help too Galerie 5 - 2nd D’Vera Cohn, Pew Research Center;Paul Overberg, Wall Street Journal 2020-03-08T09:00:00 2020-03-08T12:30:00 America/Chicago
2473 Finding the story: Using natural language processing in social media research (repeat) Ever felt lost poring over a massive archive? Want to churn up interesting stories from social networks, chat archives, or forums with (relative) ease? Why not try using a little natural language processing (NLP)! This session will give you a taste of how to apply a blend of linguistics and AI to the text-based world of the internet. You will learn some basic NLP concepts, and how to apply them to online texts using the Python package Spacy. You'll be able to walk out of this session ready to start digging through data of your own. This session is good for: People who are comfortable working in Python. Studio 9 - 2nd Garance Burke, JSK Fellow at Stanford University;Matt Kiefer, Stanford University 2020-03-08T09:00:00 2020-03-08T10:00:00 America/Chicago
2490 Conference sales Stop by the NICAR sales table located in Preservation Foyer on the 2nd floor to browse books from the IRE store, IRE merchandise and shirts with the winning design from the T-shirt contest. Studio Foyers - 2nd 2020-03-08T09:00:00 2020-03-08T10:30:00 America/Chicago
2504 Storyboarding and perfecting your pitch What does it take to tackle a data-driven story while covering your beat? We'll talk about tools and strategies for managing your time, storyboarding your ideas, keeping up with data and documents, rolling quick-hit investigations and pitching story ideas to your editor. Galerie 3 - 2nd Patti DiVincenzo, IRE & NICAR;Sarah Hutchins, IRE & NICAR 2020-03-08T09:00:00 2020-03-08T10:00:00 America/Chicago
1093 CANCELED - JavaScript 3: Making a map in D3 (repeat) Learn how to create an easy D3 map by turning shapefiles into nice, reusable TopoJSON, then turning it into a map and connecting it to your data. You can then have these maps ready for future use by just switching out a few variables. This session is good for: People who have a basic grasp of JavaScript syntax and have been exposed to the D3 library at some point. Studio 3 - 2nd 2020-03-08T10:15:00 2020-03-08T11:15:00 America/Chicago
1098 Stats 2: Linear regression (repeat) Go beyond counting and sorting. Learn how (and when) to measure relationships, level playing fields and make predictions. This class will be taught in R. This session is good for: People who took “Stats 1: An introduction” and want to know how to apply what they learned, or are comfortable with summary statistics and RStudio and new to stats. Familiarity with spreadsheets and database managers is recommended. Studio 2 - 2nd Ryan McNeill, Reuters 2020-03-08T10:15:00 2020-03-08T11:15:00 America/Chicago
1103 Python 2: Intro to data analysis using Pandas (repeat) 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. Studio 6 - 2nd Sandra Fish, Independent journalist 2020-03-08T10:15:00 2020-03-08T11:15:00 America/Chicago
1106 Python: Let's scrape a website (repeat) This session will show you how to use the Python programming language to scrape data from websites. This session is good for: People who already feel comfortable writing simple Python scripts and understand basic syntax (data types, if/else statements, for loops, etc.). Experience with HTML is a plus but not necessary. Note: It would be useful to attend the demo session "How the internet works (so you can scrape the web!)" at 9 a.m. Thursday if you’re not familiar with the topic already. Studio 9 - 2nd Matt Wynn, USA Today 2020-03-08T10:15:00 2020-03-08T11:15:00 America/Chicago
2187 Turning your stack of documents into structured data By using public records from an actual investigation, we will teach people how to think through turning their reams and reams of paper records into structured data. We want reporters to read through the documents and actively think about what information they need, how they can structure the data, and how they would need to fact-check data entry. We want attendees to leave feeling ready and willing to do heavy-hitting data investigations in their own newsrooms. Galerie 6 - 2nd Will Craft, APM Reports;Lisa Pickoff-White, KQED 2020-03-08T10:15:00 2020-03-08T12:30:00 America/Chicago
2239 Where'd I put that file? You know you downloaded that data, but now that you need it for your story, where'd it go? Or did your source send it to you in an email? Oh well. Now it's time to send that feature to your editor, but you can't remember if it's my-great-story-thisone.doc or my great-story-final-final.doc. Come hear about how to keep from feeling overwhelmed by disorganization when juggling multiple projects. We'll cover file naming and folder structures, apps that can help you manage files, and even some tips for organizing things like email and FOIA requests. Galerie 2 - 2nd Brent Jones, St. Louis Public Radio;Sarah Rafique, KTRK-ABC 13 2020-03-08T10:15:00 2020-03-08T11:15:00 America/Chicago
2477 PDF 2: Using OCR to extract data from PDFs (repeat) This class will cover basic approaches for getting text out of PDF documents using powerful and freely available tools. Participants will be introduced to basic concepts and walked-through tackling common challenges encountered with tricky PDF documents. This session is good for: People who are unfamiliar with the PDF to text tools or would like to learn how optical character recognition (OCR) tools can be used for extracting difficult text from images embedded in PDF document. Studio 7 - 2nd Geoff Hing, APM Reports 2020-03-08T10:15:00 2020-03-08T11:15:00 America/Chicago
2480 Advanced SQL: Update queries, sub-queries and more (repeat) If you feel comfortable with the Structured Query Language basics that IRE teaches in its bootcamps — SELECT, FROM, WHERE, GROUP BY — but are ready to see what else SQL can do, this session is for you. We will cover more advanced ways of manipulating and questioning data, such as UPDATE queries, joins, writing sub-queries and other neat tricks. We will use SQLite in the class. This session will be most helpful if: You are comfortable with counting and summing in SQL. Studio 4 - 2nd Troy Thibodeaux, The Associated Press 2020-03-08T10:15:00 2020-03-08T11:15:00 America/Chicago
2506 Accessing political ad data from the Facebook and Google ad libraries Mozilla is releasing a data integration tool for those looking to better understand online political advertising in the upcoming U.S. elections. The tool pulls the political ad data available from the Facebook and Google ad libraries. This is the same tool that helped discover that paid political ads were disappearing in the Facebook Ad Library during the EU and UK elections. We plan to continue to improve this tool, and build more functionality by working directly with those who are using and relying on the tool. Galerie 3 - 2nd Jason Chuang, Mozilla 2020-03-08T10:15:00 2020-03-08T11:15:00 America/Chicago
1082 SQL CARwash: Cleaning dirty data 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. Studio 4 - 2nd David Herzog, IRE & NICAR 2020-03-08T11:30:00 2020-03-08T12:30:00 America/Chicago
1104 Python 3: Data cleaning and visualization (repeat) 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. Studio 6 - 2nd Michael Corey, The Star Tribune 2020-03-08T11:30:00 2020-03-08T12:30:00 America/Chicago
2230 How and why to Dockerize your project Docker simplifies the development and deployment of projects by bundling application code with everything it needs to run, including languages, libraries, and services. In this panel, we’ll discuss the many ways in which Docker has made our programming lives easier. We’ll also share tips for getting started with Docker and tease more advanced applications. If you’ve ever struggled to maintain a legacy news app, manage a rogue software installation, or collaborate on projects with complex dependencies, this session is for you! Galerie 3 - 2nd Alexander Cohen, Independent journalist;Hannah Cushman Garland, DataMade;Pratheek Rebala, The Center for Public Integrity 2020-03-08T11:30:00 2020-03-08T12:30:00 America/Chicago
2472 GitHub for journalists (repeat) We'll cover Github's basic features — repositories, commits, branches, pull requests and issues — using a recent data-driven story as a case study. The goal is for you to leave the class and be able to use GitHub on your own for your next story. Please note: You will need to have created an account at GitHub.com prior to the class. This session is good for: Journalists who want to collaborate on data analyses, back up their work and share their methodology with (nerdy) readers. Studio 3 - 2nd Jeremy C.F. Lin, Bloomberg News;Allison McCartney, Bloomberg News 2020-03-08T11:30:00 2020-03-08T12:30:00 America/Chicago
2474 Finding the story: Scripting your census analysis Writing a little code can speed up your census analysis and set you up for success down the line. Come to this hands-on workshop to explore some sample scripts written in Python that you can take home and tweak to answer your own reporting questions. This session is good for people who are comfortable writing basic Python. Studio 2 - 2nd Joe Germuska, Northwestern University Knight Lab 2020-03-08T11:30:00 2020-03-08T12:30:00 America/Chicago
2478 PDF 3: Batch pdf processing (repeat) Practice processing dozens of documents with open-source tools like the Python library pdfplumber. The class will discuss techniques for working with thousands or millions of documents, but the hands-on component will involve a smaller batch. The class will also discuss Optical Character Recognition, but see the PDF2 class for more hands-on examples of OCR. This session is good for: People with some programming experience who are able to install third-party software. Studio 7 - 2nd Jacob Fenton, PublicAccountability.org 2020-03-08T11:30:00 2020-03-08T12:30:00 America/Chicago
2486 Mapping in Python Learn how to use GeoPandas, a handy Python library that lets you do powerful geospatial analysis from the comfort of a Jupyter Notebook. We'll cover mapping, filtering and merging datasets, changing between projections and formatting publication-ready maps. This session is good for: Those with intermediate to advanced knowledge of Python. Studio 9 - 2nd Allan James Vestal, POLITICO 2020-03-08T11:30:00 2020-03-08T12:30:00 America/Chicago
2505 🤓 Install party! Need help installing that cool piece of software you learned about in another session? Bring your laptop and we'll help you get set up. Galerie 2 - 2nd Alexandra Kanik, Louisville Public Media;Charles Minshew, IRE & NICAR;Cody Winchester, IRE & NICAR 2020-03-08T11:30:00 2020-03-08T12:30:00 America/Chicago
Powered by Datasette · Query took 2.13ms