This data as JSON, CSV (advanced)
Suggested facets: location_room, start_date_clean, start_time, end_time, pre_reg_flag, paid_flag, session_type
| Link | rowid | event_id | name | clean_description | location_room | start_date_clean | start_time | end_time | pre_reg_flag | paid_flag | laptop_flag | speakers_cleaned | session_type | keywords | skill_level | session_title |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5 | 5 | 4301 | Adding a text editor to your CAR toolkit | A good text editor is an essential tool for data journalists, allowing you to inspect and tidy data and seamlessly import into other programs (Excel, a database GUI, your CMS). Stop by this demo session for examples of how a text editor can round out your CAR toolkit. | Salon A&B 1 | 2019-03-10 | 2019-03-10 10:15:00 | 2019-03-10 11:15:00 | 0 | 0 | 0 | Agustin Armendariz, The New York Times | Demo 2 | Intermediate 2 | Adding a text editor to your CAR toolkit | |
| 6 | 6 | 4250 | Advanced OpenRefine: Intro to GREL | There is so much more to OpenRefine than the clustering and faceting feature. This session is a deep dive to GREL, OpenRefine expression language (the equivalent of Excel formulas). After a thorough introduction to GREL syntax, we will review the most common functions to explore and clean up your dataset. Functions covered in this session include replace, split, concatenate, string comparison, if, cell.cross (to join multiple projects together), and forEach. This session is good for: People who are familiar with OpenRefine or with at least some Excel experience. For an introduction to OpenRefine, check out the scheduled demo session. | Diamond Cove - conference level 4 | 2019-03-08 | 2019-03-08 11:30:00 | 2019-03-08 12:30:00 | 0 | 0 | 0 | Martin Magdinier, OpenRefine Foundation | Hands-on 3 | Intermediate 2 | Advanced OpenRefine: Intro to GREL | |
| 14 | 14 | 4224 | ArcGIS Online: Connect the where and the why with interactive demographic maps | 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. | Diamond Cove - conference level 4 | 2019-03-08 | 2019-03-08 16:45:00 | 2019-03-08 17:45:00 | 0 | 0 | 0 | Robby Deming, Esri; Christopher Vaillancourt, Esri | Hands-on 3 | Intermediate 2 | ArcGIS Online: Connect the where and the why with interactive demographic maps | |
| 39 | 39 | 4223 | Command line on Macs | 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. | Salon 5 13 | 2019-03-09 | 2019-03-09 09:00:00 | 2019-03-09 10:00:00 | 0 | 0 | 0 | AJ Vicens, Mother Jones | Hands-on 3 | Intermediate 2 | Command line on Macs | |
| 47 | 47 | 4233 | csvkit | Ever struggled with large data sets? Or need to quickly join or merge datasets without the benefit of a database? We will show you how to harness the awesome power of csvkit to wrangle large datasets on the command line. It's easy to use, fast and powerful. It's a must in every data journalist's toolbox. This session is good for: People who want a solution for working with multiple CSV files without having to open Excel or to join or merge files without a database. | Salon 5 13 | 2019-03-09 | 2019-03-09 11:30:00 | 2019-03-09 12:30:00 | 0 | 0 | 0 | Leila Haddou, The Times of London | Hands-on 3 | Intermediate 2 | csvkit | |
| 52 | 52 | 4354 | Data visualization and storytelling with Flourish | Learn how to use Flourish, a free, online tool to build custom visualizations from your spreadsheets, no coding required. Flourish grew out of Kiln, the award-winning data studio that has helped dozens of organizations to visualize and tell stories with data. **You must bring a laptop and sign up for a free account at flourish.studio to participate in this class. This session is good for: Anyone familiar with spreadsheets. No visualization experience required. | Mariner Cove - conference level 11 | 2019-03-08 | 2019-03-08 15:30:00 | 2019-03-08 16:30:00 | 0 | 0 | 0 | Marco Tulio Pires | Hands-on 3 | Intermediate 2 | Data visualization and storytelling with Flourish | |
| 64 | 64 | 4252 | 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, sorting and filtering in Excel or another spreadsheet program. | Salon 3 5 | 2019-03-07 | 2019-03-07 11:30:00 | 2019-03-07 12:30:00 | 0 | 0 | 0 | Crina Boros, independent journalist | Hands-on 3 | Intermediate 2 | Excel 3: Filtering & pivot tables | |
| 68 | 68 | 4253 | 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. | Salon 3 5 | 2019-03-08 | 2019-03-08 09:00:00 | 2019-03-08 10:00:00 | 0 | 0 | 0 | Kimbriell Kelly, The Washington Post | Hands-on 3 | Intermediate 2 | Excel: Advanced pivot tables | |
| 71 | 71 | 4092 | Exploring the tidyverse in R *pre-registered attendees only | Skill level: Intermediate Learn how to use the tidyverse, a collection of R packages will help you make your data journalism more efficient, stronger and fun. Learn how to import, clean, analyze and plot data for your stories. If you've used packages like dplyr, tidyr, readr, ggplot2, tibble and purr, or would like to learn more about how these work together, this class is for you. Preregistration is required and seating is limited. Laptops will be provided for the training.? ? Workshop prerequisites: You should be comfortable working with R and RStudio. You should also be familiar with basic data analysis. | Sapphire Cove - conference level 17 | 2019-03-09 | 2019-03-09 09:00:00 | 2019-03-09 17:45:00 | 1 | 1 | 0 | Aaron Kessler, CNN; Olga Pierce, University of Nebraska-Lincoln; Andrew Tran, The Washington Post | Hands-on 3 | Intermediate 2 | Exploring the tidyverse in R *pre-registered attendees only | |
| 74 | 74 | 4205 | 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 anyone looking for a better way to identify individuals or companies of interest within dirty data. | Copper Cove - conference level 14 | 2019-03-09 | 2019-03-09 14:15:00 | 2019-03-09 15:15:00 | 0 | 0 | 0 | Max Harlow, Financial Times | Hands-on 3 | Intermediate 2 | Finding needles in haystacks with fuzzy matching | |
| 80 | 80 | 4220 | Finding the story: Using DNS search for investigative journalism | Learn how to use DNSDB Scout, a tool to query DNSDB, a historical passive Domain Name System (DNS) database, to discover previously unknown online connections and gain new information to advance your investigations. DNSDB Scout is available for both Google Chrome and Mozilla Firefox. Dr. Paul Vixie, an internet pioneer who was inducted into the Internet Hall of Fame in 2014 for his work related to DNS, will provide a brief DNS primer before providing the journalists a hands-on opportunity, using DNSDB, to examine the online footprint of a well-known political network to uncover dozens of its affiliated organizations. **You must bring a laptop with Firefox and Google Chrome installed for this workshop. Logins will be provided to use DNSDB. Basic knowledge of the Domain Name System (DNS) is helpful, but not required. | Mariner Cove - conference level 11 | 2019-03-08 | 2019-03-08 14:15:00 | 2019-03-08 15:15:00 | 0 | 0 | 0 | Paul Vixie, Farsight Security | Hands-on 3 | Intermediate 2 | Finding the story: Using DNS search for investigative journalism | |
| 85 | 85 | 4094 | First Python notebook: Data analysis on deadline *pre-registered attendees only | Skill level: Beginner/intermediate Ben Welsh, James Gordon and Cheryl Phillips teach data analysis with Python. Their 6-hour, hands-on tutorial will guide you through an investigation of money in politics. You will learn: 1) Just enough Python to execute an analysis with the powerful pandas data analysis library, one of the most popular open-source tools for working with large data files. 2) How to record, remix and republish your work using the Jupyter Notebook, a browser-based tool emerging as the standard for reproducible research in the sciences. 3) Most important of all, how these tools increase the speed and veracity of your journalism.?? Preregistration is required and seating is limited. Laptops will be provided for the training.?? Workshop prerequisites: If you've tried Python once or twice, have good attitude and know how to take a few code crashes in stride, you are qualified for this class. | Coral Cove - conference level 8 | 2019-03-08 | 2019-03-08 09:00:00 | 2019-03-08 17:45:00 | 1 | 1 | 0 | James Gordon, Reynolds Journalism Institute; Cheryl Phillips, Stanford University; Ben Welsh, Los Angeles Times | Hands-on 3 | Intermediate 2 | First Python notebook: Data analysis on deadline *pre-registered attendees only | |
| 86 | 86 | 4142 | Free, 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. | Salon A&B 1 | 2019-03-08 | 2019-03-08 15:30:00 | 2019-03-08 16:30:00 | 0 | 0 | 0 | Jamie Grey, Raycom Media | Demo 2 | Intermediate 2 | Free, easy data viz | |
| 88 | 88 | 4339 | From messy data to insightful story: Cleaning data using Tableau (Hosted by Tableau) | Skill level: Some experience working with data and is necessary; knowledge of Tableau Desktop/Tableau Public would be ideal. Participants will get a crash-course in the fundamentals of Tableau Prep. We will work with a couple of messy real-world data sets. We will clean, shape, and merge our data in Tableau Prep with the aim of analyzing it in Tableau Desktop and finally publishing an interactive chart with Tableau Public. Software, data files and laptops are provided for the duration of the class. The session is designed to follow the sessions “An introduction to Data Visualization with Tableau” and “Finding your data story: Visual analytics best practices using Tableau” but can also be taken on its own by participants who have some experience in working with data. Participants are expected to create a free account on Tableau Public before or at the beginning of the session. | Coral Cove - conference level 8 | 2019-03-07 | 2019-03-07 11:30:00 | 2019-03-07 12:30:00 | 0 | 0 | 0 | Florian Ramseger & Jonni Walker, Tableau Software | Hands-on 3 | Intermediate 2 | From messy data to insightful story: Cleaning data using Tableau (Hosted by Tableau) | |
| 91 | 91 | 4247 | Geocoding and avoiding pitfalls | 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. | Diamond Cove - conference level 4 | 2019-03-07 | 2019-03-07 10:15:00 | 2019-03-07 11:15:00 | 0 | 0 | 0 | Michael Corey, Reveal from the Center for Investigative Reporting | Hands-on 3 | Intermediate 2 | Geocoding and avoiding pitfalls | |
| 92 | 92 | 4269 | GitHub for journalists | We'll cover Github's basics features — repositories, commits, branches, pull requests and issues — using a recent data-driven story as a case study. The goal is for you to leave the class and be able to use GitHub on your own for your next story. **You must bring a laptop to participate in this class. You will also need to create an account at GitHub.com and install GitHub Desktop prior to the class. This session is good for: Journalists who want to collaborate on data analyses, back up their work and share their methodology with (nerdy) readers | Mariner Cove - conference level 11 | 2019-03-07 | 2019-03-07 16:45:00 | 2019-03-07 17:45:00 | 0 | 0 | 0 | Brent Jones, St. Louis Public Radio | Hands-on 3 | Intermediate 2 | GitHub for journalists | |
| 95 | 95 | 4237 | 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! **You must have a Google account for this session. This session is good for: Beginners who want to start using data for their stories. | Salon 3 5 | 2019-03-08 | 2019-03-08 11:30:00 | 2019-03-08 12:30:00 | 0 | 0 | 0 | Samantha Sunne, independent journalist | Hands-on 3 | Intermediate 2 | Google Sheets: Scraping without coding (repeat) | |
| 103 | 103 | 4172 | How it works: APIs | What is an Application Programming Interface (API), and how are journalists using them to power newsroom projects? Come to this session to get an overview of how APIs work and some ideas for integrating them into your own data projects. This session is ideal for API beginners to attend before the hands-on class "A hitchhiker's guide to APIs." | Salon A&B 1 | 2019-03-07 | 2019-03-07 16:45:00 | 2019-03-07 17:45:00 | 0 | 0 | 0 | Jonathan Soma, Columbia Journalism School | Panel 1 | Intermediate 2 | How it works: APIs | |
| 106 | 106 | 4173 | How it works: The internet (for journalists who want to scrape it) | If you want to scrape a website, it helps to understand a little bit about how the internet works under the hood. In this session, we’ll talk a little bit about the internet works, how it differs from the web and how to examine source code and network traffic to target and scrape newsworthy information. There will be an optional component where you can run commands from your computer that help illustrate these points, but you’ll also just be able to follow the presentation. | Salon A&B 1 | 2019-03-07 | 2019-03-07 14:15:00 | 2019-03-07 15:15:00 | 0 | 0 | 0 | Melissa Lewis, Reveal | Panel 1 | Intermediate 2 | How it works: The internet (for journalists who want to scrape it) | |
| 107 | 107 | 4174 | How it works: Version control for journalists (git/GitHub) | Branching, forking, merging and cloning. Version control can be a complicated issue, but this session for beginners will show you how newsrooms are using this technology to solve real-world problems. This session is ideal to attend before the hands-on class in GitHub. | Cardiff 10 | 2019-03-07 | 2019-03-07 14:15:00 | 2019-03-07 15:15:00 | 0 | 0 | 0 | Dan Nguyen, independent journalist | Panel 1 | Intermediate 2 | How it works: Version control for journalists (git/GitHub) | |
| 110 | 110 | 4295 | How to follow the dark money in politics | Nearly $1 billion has been spent by dark money groups since the U.S. Supreme Court's Citizens United decision in 2010. These opaque organizations generally aren't required to disclose their donors, but obscure public records can help you shine a light on their activities and their funders. OpenSecrets.org and MapLight.org have numerous resources available for reporters interested in following the dark money in politics, and Issue One recently published a database of nearly 1,200 transactions detailing contributions from more than 400 unique donors to the leading dark money groups — a database that is searchable online (bit.ly/DarkMoneyData) and on ProPublica's FEC Itemizer tool. As the 2020 election cycle ramps up, come learn tips from some of the top dark money sleuths in the country for scouring filings with the Federal Election Commission, Internal Revenue Service, Department of Labor, Congress, corporate websites and other sources. | Salon 1&2 6 | 2019-03-08 | 2019-03-08 15:30:00 | 2019-03-08 16:30:00 | 0 | 0 | 0 | Michael Beckel, Issue One (moderator); Anna Massoglia, Center for Responsive Politics; Andrew Perez, MapLight | Demo 2 | Intermediate 2 | How to follow the dark money in politics | |
| 125 | 125 | 4113 | Interviewing your data with SQL **pre-registered attendees only | Skill level: Intermediate If you flip over pivot tables, but wish you had more data tools, this session is for you. Structured Query Language, or SQL, can help you use powerful filtering functions, find patterns in millions of records and join multiple data tables. This class will be taught by two experienced data reporters and former IRE trainers, and materials will include the IRE Computer-Assisted Reporting boot camp binder, full of exercises, cheat sheets and tips to help you boost your data analysis and storytelling skills. We will use a free database manager that can be easily installed and used on any computer. Preregistration is required and seating is limited. Laptops will be provided for the training. Workshop prerequisites: The only prerequisites are a reasonable comfort level with using a spreadsheet. No previous SQL skills necessary. This class takes place on Thursday, March 7 from 2:15-5:45 p.m. and continues Friday, March 8, 9 a.m. - 12:30 p.m. (Registration for this session reserves your seat for both days of this workshop and attendees are expected to attend both sessions to complete the workshop.) | Salon 4 15 | 2019-03-07 | 2019-03-07 14:15:00 | 2019-03-07 17:45:00 | 1 | 1 | 0 | Liz Lucas, Kaiser Health News; Megan Luther, InvestigateTV | Hands-on 3 | Intermediate 2 | Interviewing your data with SQL *pre-registered attendees only | |
| 134 | 134 | 4350 | Investigating nonprofits with data | We'll show reporters at all levels how to work with nonprofit data. We'll walk you through spreadsheets and databases that contain information on how nonprofits are spending their money and give you tips for identifying red flags. We'll also talk about digitized 990 filings and how you or other programmers in your newsroom can parse the data and root out corruption. | Salon 1&2 6 | 2019-03-07 | 2019-03-07 16:45:00 | 2019-03-07 17:45:00 | 0 | 0 | 0 | Todd Wallack, The Boston Globe; Andrea Fuller, The Wall Street Journal | Demo 2 | Intermediate 2 | Investigating nonprofits with data | |
| 135 | 135 | 4263 | 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 able to build fancy data visualizations and more. In this class, you will learn the basic fundamentals and syntax of the JavaScript programming language. No coding experience is necessary. This session is good for: Beginners who want to start building things for the web. | Copper Cove - conference level 14 | 2019-03-08 | 2019-03-08 09:00:00 | 2019-03-08 10:00:00 | 0 | 0 | 0 | Allison McCartney, Bloomberg | Hands-on 3 | Intermediate 2 | JavaScript 1: Fundamentals and syntax | |
| 137 | 137 | 4264 | 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 several real datasets and use them to create a few basic charts. This session is good for: People with a basic grasp of JavaScript syntax who are interested in building data visualizations for the web. | Copper Cove - conference level 14 | 2019-03-08 | 2019-03-08 10:15:00 | 2019-03-08 11:15:00 | 0 | 0 | 0 | Ashlyn Still, Reuters | Hands-on 3 | Intermediate 2 | JavaScript 2: Hello D3! | |
| 143 | 143 | 4169 | Lessons learned from building a database with colleagues | Building your own database takes some effort. Doing it with a team of other people takes it up a few notches. Panelists will share best practices and some of the nitty-gritty details you need to know before you build your own database, plus the extra things you need to plan for when it’s a group effort. We’ll talk about software options, how you can have multiple people entering data at the same time, ensuring you end up with standardized data and other details you’ll be glad to know before you start your own project. | Salon 1&2 6 | 2019-03-08 | 2019-03-08 11:30:00 | 2019-03-08 12:30:00 | 0 | 0 | 0 | Todd Wallack, The Boston Globe; MaryJo Webster, The Star Tribune (moderator); Dana Amihere, KPCC | Panel 1 | Intermediate 2 | Lessons learned from building a database with colleagues | |
| 146 | 146 | 4150 | Machine learning and investigative reporting | Has your editor ever asked for a couple of examples? What if you could use machine learning to find some of those examples and investigate a real phenomenon? Join reporters who have used machine learning as a tool in investigative reporting. You’ll hear about how we used machine learning to find patients whose deaths were potentially linked to medical devices; tracked fake news and identified illegal ads on Facebook; investigated potential campaign finance fraud; and did financial muckraking in the tax records of a global financial corporation. We’ll answer important questions like: What is machine learning? What kind of stories could it help with? and What do you need to take into account to get started? | Salon D 3 | 2019-03-07 | 2019-03-07 15:30:00 | 2019-03-07 16:30:00 | 0 | 0 | 0 | Meredith Broussard, New York University (moderator); Emilia Diaz Struck, International Consortium of Investigative Journalists, Jeff Ernsthausen, ProPublica | Panel 1 | Intermediate 2 | Machine learning and investigative reporting | |
| 148 | 148 | 4138 | Making the leap from Excel to R | R might sound intimidating because it’s a programming language, but you might be surprised to learn that the leap from Excel to R isn’t as big as you might think, thanks to the RStudio interface and lots of simple-to-use R packages. We’ll go through the pros and cons between the two software tools and give you tips on how to make the transition as smooth as possible, should you decide to go that route. This will be for those who are comfortable in Excel but have no experience with R and would just like to get a taste of it before diving into a hands-on class. | Salon C 7 | 2019-03-07 | 2019-03-07 11:30:00 | 2019-03-07 12:30:00 | 0 | 0 | 0 | MaryJo Webster, Star Tribune | Panel 1 | Intermediate 2 | Making the leap from Excel to R | |
| 153 | 153 | 4128 | Master class: Leading the data team **pre-registered attendees only | Experienced data journalists will share practical tips on how they've led their teams and convinced higher-ups to integrate data into the newsroom. Our instructors will show how they made it into leadership and how they excelled once they got there. Topics will include: How to lead a team to create their best work Handling expectations from management Carving out a career path in leadership when you're known for your data skills Making data journalism a core principle in your newsroom Managing your time and the time of your team This class is ideal for data journalists who are looking to break into leadership and need guidance on how to get there or existing leaders who need tips on how to lead effectively. Preregistration is required and seating is limited. | Crystal Cove - conference level 20 | 2019-03-07 | 2019-03-07 09:00:00 | 2019-03-07 12:30:00 | 1 | 1 | 0 | Janet Roberts, Reuters; Troy Thibodeaux, Associated Press | Master Class 6 | Intermediate 2 | Master class: Leading the data team *pre-registered attendees only | |
| 155 | 155 | 4129 | Master class: Self-editing & bulletproofing the data **pre-registered attendees only | Data-driven stories can overwhelm a writer juggling data and storytelling and leave even the best editors feeling out of their depth. In this half-day workshop, we’ll focus on the core data editing and bulletproofing skills every journalist should have, whether you are a hands-on data journalist or an editor supervising this work. Two data journalists, Atlanta Journal Constitution’s deputy managing editor Shawn McIntosh and Washington Post investigative reporter Kimbriell Kelly, will share lessons they have learned writing and presenting data-driven stories. You will receive tips and strategies from an editor's and reporter's point of view, including: Common data errors -- How to spot and fix them Using a data diary to track your methodology Practical strategies for bulletproofing and fact-checking your data analysis and findings Going beyond numbers -- Using data to find human sources and characters for stories Untangling the writing and avoiding reader turnoffs Managing up -- Working with an editor who doesn’t speak data Managing the numbers as deadline approaches Whether you want to get better at editing yourself or others, we’ll have tips and resources for you. No data experience is required for this workshop. Bring questions and examples as there will be plenty of time for discussion. Preregistration is required and seating is limited. | Crystal Cove - conference level 20 | 2019-03-07 | 2019-03-07 14:15:00 | 2019-03-07 17:45:00 | 1 | 1 | 0 | Kimbriell Kelly, The Washington Post; Shawn McIntosh, The Atlanta Journal Constitution | Master Class 6 | Intermediate 2 | Master class: Self-editing & bulletproofing the data story *pre-registered attendees only | |
| 157 | 157 | 4133 | Master class: Writing the data-driven narrative **pre-registered attendees only | You’ve gathered and analyzed data, talked to human sources and now you’re ready to write. If you’re new to data-driven storytelling, this workshop is for you. Sarah Cohen is the Knight Chair in Journalism at ASU’s Walter Cronkite School of Journalism and a former editor at The New York Times and The Washington Post. T. Christian Miller is a reporter at ProPublica, where his coverage of sexual assault was recognized with a 2016 Pulitzer Prize. Together they’ll share tips and techniques for writing data-driven stories that pack an emotional punch. Topics include: Understanding narrative Reporting for story — How to gather the details and scenes that will make your numbers come to life. Focus and framing – Finding your way through all that material Communicating data – Deciding how many numbers to include and putting them in context Self-editing tips and techniques We’ll look at examples of successful stories, pulling back the curtain to see how they came together. Preregistration is required and seating is limited. | Crystal Cove - conference level 20 | 2019-03-09 | 2019-03-09 14:15:00 | 2019-03-09 17:45:00 | 1 | 1 | 0 | T. Christian Miller, ProPublica; Sarah Cohen, ASU | Master Class 6 | Intermediate 2 | Master class: Writing the data-driven narrative *pre-registered attendees only | |
| 161 | 161 | 4259 | 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. | Diamond Cove - conference level 4 | 2019-03-08 | 2019-03-08 14:15:00 | 2019-03-08 15:15:00 | 0 | 0 | 0 | Jack Gillum, ProPublica | Hands-on 3 | Intermediate 2 | MySQL | |
| 163 | 163 | 4355 | No code required: Create compelling interactive data visualizations with Microsoft Power BI | Join Microsoft's Modern Journalism Team for a hands-on workshop where you'll learn to use Microsoft’s free Power BI software and cloud service (Excel’s data visualization cousin) to quickly create and publish engaging interactives that uncover the story hidden in the data. The session will also show how to style your interactive for your publication or station. You’ll learn to: Connect a data set Clean up the data Drag-and-drop existing data visualization options onto the canvas Customize colors and fonts to create a style-consistent visualization Publish the visualization to your website or big screen for in-studio use …all through powerful, menu-driven software that readily connects to numerous data sources. This session is good for: Anyone, including data beginners. | Emerald Cove - conference level 16 | 2019-03-09 | 2019-03-09 11:30:00 | 2019-03-09 12:30:00 | 0 | 0 | 0 | Cathleen Crowley, Albany Times Union; Vera Chan & Lukasz Pawlowski, Microsoft | Hands-on 3 | Intermediate 2 | No code required: Create compelling interactive data visualizations with Microsoft Power BI | |
| 165 | 165 | 4348 | One map, no code: The power of Mapbox Studio | Think you need code to make a highly customized data-driven map? We’re here to show you that you don’t. In this session, we’re going to make a choropleth map and show you how to fine-tune the smallest details with Mapbox Studio. **You must bring a laptop to participate in this class. You will also need Mapbox and GitHub accounts. This session is good for: All skill levels. No JavaScript knowledge required, but basic computer literacy is necessary. | Mariner Cove - conference level 11 | 2019-03-09 | 2019-03-09 14:15:00 | 2019-03-09 15:15:00 | 0 | 0 | 0 | Lo Benichou, Mapbox; Casey Miller, Los Angeles Times | Hands-on 3 | Intermediate 2 | One map, no code: The power of Mapbox Studio | |
| 170 | 170 | 4226 | 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 walk through tackling common challenges encountered with tricky PDF documents. This session is good for: People who are unfamiliar with the PDF-to-text tools or would like to learn how optical character recognition (OCR) tools can be used for extracting difficult text from images embedded in PDF document. | Salon 5 13 | 2019-03-08 | 2019-03-08 15:30:00 | 2019-03-08 16:30:00 | 0 | 0 | 0 | Chad Day, Associated Press | Hands-on 3 | Intermediate 2 | PDF 2: Using OCR to extract data from PDFs | |
| 179 | 179 | 4192 | Python 101: An overview for total beginners | Come learn how newsrooms are using the Python programming language to analyze data, scrape the web, build web applications and more. This lecture will answer basic questions about what Python is, how it's used and how you can get started learning. | Salon D 3 | 2019-03-07 | 2019-03-07 11:30:00 | 2019-03-07 12:30:00 | 0 | 0 | 0 | Mindy McAdams, Florida University | Panel 1 | Intermediate 2 | Python 101: An overview for total beginners | |
| 180 | 180 | 4239 | Python 1: The fundamentals | Learning a programming language is much like learning to write a news story. There are certain styles and conventions to follow, a standard order, etc. In this session geared toward absolute beginners, we’ll get started with some of the basics of this new language. This session is good for: People who are comfortable working with data in spreadsheets or database managers and want to make the leap to programming. | Salon 5 13 | 2019-03-07 | 2019-03-07 14:15:00 | 2019-03-07 15:15:00 | 0 | 0 | 0 | Sandra Fish, independent journalist | Hands-on 3 | Intermediate 2 | Python 1: The fundamentals | |
| 182 | 182 | 4240 | 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. | Salon 5 13 | 2019-03-07 | 2019-03-07 15:30:00 | 2019-03-07 16:30:00 | 0 | 0 | 0 | Lam Thuy Vo, Buzzfeed News | Hands-on 3 | Intermediate 2 | Python 2: Intro to data analysis using pandas | |
| 188 | 188 | 4246 | Python: Let's scrape a website | This hands-on training will illustrate how Python can be used to grab a lot of data from a website at once, whether by pulling content from a page or interacting with forms. You’ll want to be comfortable writing loops in Python, though you won’t necessarily need to be able to write a function from scratch! This session is good for people who feel comfortable with Python’s data types and control flow (if/else, loops). Experience with HTML is a plus but not necessary. Note: It would be useful to attend the session " How it Works: The Internet" in advance if you’re not familiar with the topic already. | Copper Cove - conference level 14 | 2019-03-08 | 2019-03-08 14:15:00 | 2019-03-08 15:15:00 | 0 | 0 | 0 | Ryan Pitts, Knight-Mozilla OpenNews | Hands-on 3 | Intermediate 2 | Python: Let's scrape a website | |
| 192 | 192 | 4217 | 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. | Emerald Cove - conference level 16 | 2019-03-09 | 2019-03-09 09:00:00 | 2019-03-09 10:00:00 | 0 | 0 | 0 | Dan Dunford, BBC News; Clara Guiborg, BBC News | Hands-on 3 | Intermediate 2 | QGIS 1: Mapmaking for beginners | |
| 193 | 193 | 4222 | QGIS 2: Filtering and analyzing geographic data to make maps | Build on your existing knowledge of QGIS and learn how to filter and analyze geographic datasets, before familiarising yourself with exporting the maps you have created using the print composer. We will cover techniques like merging and dissolving polygons, using Open Street Map data in QGIS as well as aggregating point data for easier analysis. This session is good for: those who attended the QGIS I workshop or already know the basics of visualizing geographic data in QGIS. | Emerald Cove - conference level 16 | 2019-03-09 | 2019-03-09 10:15:00 | 2019-03-09 11:15:00 | 0 | 0 | 0 | Will Dahlgreen, BBC News; Nassos Stylianou, BBC News | Hands-on 3 | Intermediate 2 | QGIS 2: Filtering and analyzing geographic data to make maps | |
| 194 | 194 | 4242 | R 1: Intro to R and RStudio | Learn your way around the basics of RStudio. We’ll load basic packages to do data analysis, read in some data and explore it. This is a good class to learn the basic structure of writing R code. You’ll leave knowing how to get data into R, how to do some cleaning and formatting tasks and how to start doing basic analysis on a dataset. This will give you more confidence to take the next steps in your analyses. This session is good for: beginner to intermediate users. | Sapphire Cove - conference level 17 | 2019-03-07 | 2019-03-07 14:15:00 | 2019-03-07 15:15:00 | 0 | 0 | 0 | Meghan Hoyer, Associated Press | Hands-on 3 | Intermediate 2 | R 1: Intro to R and RStudio | |
| 196 | 196 | 4243 | R 2: Data analysis and plotting in R | 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. | Sapphire Cove - conference level 17 | 2019-03-07 | 2019-03-07 15:30:00 | 2019-03-07 16:30:00 | 0 | 0 | 0 | Ronald Campbell, NBC Owned Television Stations | Hands-on 3 | Intermediate 2 | R 2: Data analysis and plotting in R | |
| 203 | 203 | 4231 | Regular expressions for the rest of us | Regular expressions are a powerful way to slice, dice and clean up dirty data — a must-know skill for anyone who works with data. They may look intimidating, but they are really just pattern-matching puzzles. We'll learn the fundamentals of "regex" so you save time cleaning your next batch of data. This session is good for: People who have ever done more than two search/replace actions to clean a data set or had to split a ZIP code from an address or otherwise want to conquer their fears of regex. | Diamond Cove - conference level 4 | 2019-03-07 | 2019-03-07 09:00:00 | 2019-03-07 10:00:00 | 0 | 0 | 0 | Christian McDonald, University of Texas | Hands-on 3 | Intermediate 2 | Regular expressions for the rest of us | |
| 208 | 208 | 4208 | Share your work: Publishing your data analysis with R | You will save time, produce better results, create more trusted analyses, reduce risk of errors and encourage collaboration by implementing reproducible data analysis workflow techniques. We will be going over tools like RMarkdown and interactive notebooks to weave together narrative text and code to produce formatted reports for sharing with collaborators (including your future self!). We will walk through hosting these reports and raw data files on GitHub. We will discuss best practices on how to structure your projects and repos. This session is good for: R users interested in improving their workflow | Emerald Cove - conference level 16 | 2019-03-07 | 2019-03-07 10:15:00 | 2019-03-07 11:15:00 | 0 | 0 | 0 | Christine Zhang, The Baltimore Sun | Hands-on 3 | Intermediate 2 | Share your work: Publishing your data analysis with R | |
| 211 | 211 | 4272 | Sports data viz with R | Sports is one area you won’t struggle to find data or a very interested audience. Learn how to turn some basic R into interesting looks into games, teams and seasons. This session is good for: Anyone interested in R, visualizing data and sports. No previous experience with R is required. | Emerald Cove - conference level 16 | 2019-03-07 | 2019-03-07 09:00:00 | 2019-03-07 10:00:00 | 0 | 0 | 0 | Matt Waite, University of Nebraska | Hands-on 3 | Intermediate 2 | Sports data viz with R | |
| 213 | 213 | 4254 | 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 SQLite and DB Browser, a free database manager. This session is good for: People with some experience working with data in columns and rows, in spreadsheets or database managers. | Salon 4 15 | 2019-03-07 | 2019-03-07 09:00:00 | 2019-03-07 10:00:00 | 0 | 0 | 0 | Kendall Taggart, Buzzfeed News | Hands-on 3 | Intermediate 2 | SQL 1: Exploring data | |
| 215 | 215 | 4255 | 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. | Salon 4 15 | 2019-03-07 | 2019-03-07 10:15:00 | 2019-03-07 11:15:00 | 0 | 0 | 0 | Matt Kiefer, The Chicago Reporter | Hands-on 3 | Intermediate 2 | SQL 2: Grouping and summing data | |
| 217 | 217 | 4256 | 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. | Salon 4 15 | 2019-03-07 | 2019-03-07 11:30:00 | 2019-03-07 12:30:00 | 0 | 0 | 0 | Chad Day, The Associated Press | Hands-on 3 | Intermediate 2 | SQL 3: Joining tables | |
| 218 | 218 | 4270 | 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. | Salon 4 15 | 2019-03-09 | 2019-03-09 11:30:00 | 2019-03-09 12:30:00 | 0 | 0 | 0 | Madi Alexander, Bloomberg BNA | Hands-on 3 | Intermediate 2 | SQL CARwash: Cleaning dirty data | |
| 219 | 219 | 4228 | Stats 1: An introduction using PSPP | Statisticians need to really understand their data (and so do you!) before they begin running analyses. As a result, statistical software packages such as PSPP and SPSS have many powerful tools to summarize your data. You're going to love them. We'll take a look at the structure of data in PSPP, do data transformations and run some basic statistical tests. This session is good for: People who have familiarity with Excel and some database software. We've got a *lot* of ground to cover in this hour. | Sapphire Cove - conference level 17 | 2019-03-08 | 2019-03-08 09:00:00 | 2019-03-09 10:00:00 | 0 | 0 | 0 | Holly Hacker, The Dallas Morning News | Hands-on 3 | Intermediate 2 | Stats 1: An introduction using PSPP | |
| 222 | 222 | 4232 | Stats in Excel | 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. | Diamond Cove - conference level 4 | 2019-03-07 | 2019-03-07 14:15:00 | 2019-03-07 15:15:00 | 0 | 0 | 0 | Steve Doig, ASU Walter Cronkite School of Journalism | Hands-on 3 | Intermediate 2 | Stats in Excel | |
| 224 | 224 | 4143 | Surveys save the day: An old tool emerges as a cutting edge | Surveys are a familiar social science tool in newsrooms. But did you know that you can use them to break through obstacles in your investigation? In one case, powerful email programs and online surveys let reporters track down thousands of victims whose stolen identities were used to defraud the government. In another case, enterprising reporters barred from part of a foreign country used a mobile phone survey to track down human rights violations. Phil Meyer gave you the basics on newsroom surveys in "Precision Journalism." This panel will explain modern, practical methods and tools that can be adapted for investigative journalism. | Cardiff 10 | 2019-03-09 | 2019-03-09 15:30:00 | 2019-03-09 16:30:00 | 0 | 0 | 0 | James Grimaldi, The Wall Street Journal (moderator); Chris Jackson, Ipsos Public Affairs; Carolyn Thompson, independent journalist | Panel 1 | Intermediate 2 | Surveys save the day: An old tool emerges as a cutting edge | |
| 229 | 229 | 4298 | The election and politics data you're not using | Beyond readily available campaign finance and elections results, there's a wealth of other election and political data that can produce stories throughout the election cycle. We'll take a closer look at congressional disclosures, election administration, Foreign Agent Registration Act (FARA) and others. | Salon D 3 | 2019-03-08 | 2019-03-08 09:00:00 | 2019-03-08 10:00:00 | 1 | 0 | 0 | Sarah Bryner, Center for Responsive Politics; Derek Willis, ProPublica (moderator); Michelle Ye He Lee, The Washington Post | Demo 2 | Intermediate 2 | The election and politics data you're not using | |
| 239 | 239 | 4088 | Upping your Excel game *pre-registered attendees only | Skill level: Intermediate If you've found yourself struggling in a spreadsheet, thinking that whatever you were trying to achieve seemed harder than it should've been, then this is the class for you. We’ll learn about various tools and functions in Excel that come in handy when you need to re-structure or otherwise get your data ready for analysis. We'll cover string functions, logical functions, date functions, reshaping data, merging data using lookup functions and perhaps a few other nifty tricks if time allows. This is an intermediate Excel class intended for those who have mastered the basics, such as sorting, filtering, pivot tables and using functions. It is a fast-paced class intended to introduce you to these tools. You'll walk out with practice data and a 20-page tipsheet that covers in detail everything we do in class, plus other great Excel tips. Preregistration is required and seating is limited. Laptops will be provided for the training. Workshop prerequisites: You should have prior experience using Excel or Google Sheets, and be comfortable with introductory-level spreadsheet skills, such as sorting, filtering, SUM and AVERAGE functions, calculations such as percentage change or percent of total, and how to use Pivot Tables. | Salon 3 5 | 2019-03-09 | 2019-03-09 09:00:00 | 2019-03-09 12:30:00 | 1 | 1 | 0 | MaryJo Webster, Star Tribune | Hands-on 3 | Intermediate 2 | Upping your Excel game *pre-registered attendees only | |
| 251 | 251 | 4168 | Which coding language should I learn? | You're pretty good at spreadsheets, sure, but maybe you're bumping up against the limits of a tool designed only to clean and analyze data. You'd like to start querying relational databases, scraping websites, making API calls, running statistical tests and/or building custom visuals to help tell your stories. If this describes you, it might be time to learn to code. But which coding language is right for you? In this session, newsroom coders who speak some of the most popular programming languages (SQL, Python, R and JavaScript) discuss common uses for each and show you how to get started. | Salon D 3 | 2019-03-07 | 2019-03-07 09:00:00 | 2019-03-07 10:00:00 | 0 | 0 | 0 | Ryan Murphy, The Texas Tribune; Caitlin Ostroff, Miami Herald; Christine Zhang, Baltimore Sun; Jennifer Peebles, Atlanta Journal-Constitution, Armand Emamdjomeh, The Washington Post (moderator) | Panel 1 | Intermediate 2 | Which coding language should I learn? |
JSON shape: default, array, newline-delimited
CREATE TABLE "sessions" (
"event_id" INTEGER,
"name" TEXT,
"clean_description" TEXT,
"location_room" INTEGER,
"start_date_clean" TEXT,
"start_time" TEXT,
"end_time" TEXT,
"pre_reg_flag" INTEGER,
"paid_flag" INTEGER,
"laptop_flag" INTEGER,
"speakers_cleaned" TEXT,
"session_type" INTEGER,
"keywords" REAL,
"skill_level" INTEGER,
"session_title" TEXT
,
FOREIGN KEY ("skill_level") REFERENCES [skill_level](id),
FOREIGN KEY ("location_room") REFERENCES [location_room](id),
FOREIGN KEY ("session_type") REFERENCES [session_type](id))