guidebook_event
Data source: Schedule · About: simonw/nicar-2023
200 rows sorted by tracks
This data as json, copyable, CSV (advanced)
Suggested facets: locations, tracks, startTime (date), endTime (date)
id | guide_id | import_id | name | description | image | startTime | endTime | allowRating | addToSchedule | deleted | last_updated | locations | tracks ▼ | rank | links | allday | max_capacity | registered_attendees | waitlist | require_login | registration_start_date | cog_details | session_discussion_posting_disabled |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28625675 | 191394 | Data Dive: The 2022 Philip Meyer winners | <p>A data deep dive into the 2022 Philip Meyer Award winners. Hear from reporters on how they gathered, cleaned, analyzed and visualized the data behind some of the year's biggest stories.</p> | 2023-03-03 11:30:00 | 2023-03-03 12:30:00 | 0 | 1 | Broadway Ballroom 3, Meeting Space Level 1 4296409 | Behind the story 579481 | 91 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Michael Biesecker", "label": "Associated Press", "image": "", "gb_url": "gb://guide/191394/poi/?id=15496146", "target_object_id": 15496146, "target_content_type": "custom_list.customlistitem" }, { "title": "Sarah Cohen", "label": "Arizona State University", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476120", "target_object_id": 15476120, "target_content_type": "custom_list.customlistitem" }, { "title": "Emily Corwin", "label": "independent journalist", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476123", "target_object_id": 15476123, "target_content_type": "custom_list.customlistitem" }, { "title": "Ilica Mahajan", "label": "The Marshall Project", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476212", "target_object_id": 15476212, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625675&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625676 | 191394 | Behind the story: Covering cops, courts and crime | <p>Hear from reporters on how they gathered, cleaned, analyzed, visualized and told stories on covering cops, courts, crime and the intersections that connect them</p> | 2023-03-04 16:45:00 | 2023-03-04 17:45:00 | 0 | 1 | Grand Ballroom 3, Lobby Level 4296410 | Behind the story 579481 | 178 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Dylan Purcell", "label": "The Philadelphia Inquirer", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476255", "target_object_id": 15476255, "target_content_type": "custom_list.customlistitem" }, { "title": "Josh McGhee", "label": "MindSite News", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476221", "target_object_id": 15476221, "target_content_type": "custom_list.customlistitem" }, { "title": "Rachel Polansky", "label": "WANF CBS Atlanta News First", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476253", "target_object_id": 15476253, "target_content_type": "custom_list.customlistitem" }, { "title": "Lisa Pickoff-White", "label": "The California Reporting Project", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476250", "target_object_id": 15476250, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625676&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625677 | 191394 | Behind the story: Using data to report on (and for) your communities | <p>Hear from reporters on how they gathered, cleaned, analyzed, visualized and told stories about, and for, the communities they serve. </p> <br> | 2023-03-05 09:00:00 | 2023-03-05 10:00:00 | 0 | 1 | Broadway Ballroom 3, Meeting Space Level 1 4296409 | Behind the story 579481 | 186 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Suhail Bhat", "label": "THE CITY", "image": "", "gb_url": "gb://guide/191394/poi/?id=15487175", "target_object_id": 15487175, "target_content_type": "custom_list.customlistitem" }, { "title": "A.J. Lagoe", "label": "KARE-TV", "image": "", "gb_url": "gb://guide/191394/poi/?id=15484923", "target_object_id": 15484923, "target_content_type": "custom_list.customlistitem" }, { "title": "Natasha Senjanovic", "label": "Independent journalist", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476335", "target_object_id": 15476335, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625677&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625678 | 191394 | Digging into data for stories: A crash course in spreadsheets - pre-registered attendees only | <p>Get started using data in your stories with IRE's mini-boot camp. In this 6-hour, hands-on workshop, IRE’s experienced trainers will start with the basics of navigating Google Sheets 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 analyzing data in your newsroom, including how to find and request data, identify and clean dirty data, find story ideas and make your work ironclad. We’ll also provide you with our detailed boot camp materials to help keep you on track long after you leave the conference.<br><br>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.<br><br><a href="https://www.ire.org/product/nicar23-digging-into-data/" target="_blank">Preregistration is required and seating is limited</a>. Attendees will need to bring their own laptop for the training and must have a Google account.</p> | 2023-03-04 09:00:00 | 2023-03-04 17:45:00 | 0 | 1 | 12 South 1&2, Meeting Space Level 1 4296411 | Beginner 579482 | 135 | [ { "categoryTitle": "Speakers", "links": [ { "title": "David Herzog", "label": "University of Missouri/IRE", "image": "", "gb_url": "gb://guide/191394/poi/?id=15487174", "target_object_id": 15487174, "target_content_type": "custom_list.customlistitem" }, { "title": "Adam Rhodes", "label": "IRE & NICAR", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476261", "target_object_id": 15476261, "target_content_type": "custom_list.customlistitem" }, { "title": "Laura Moscoso", "label": "IRE & NICAR", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476231", "target_object_id": 15476231, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625678&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625688 | 191394 | Master Class: Managing investigators… or how to lead journalists born to challenge authority | <p>Being a news manager is already tough, but what if you supervise investigative journalists? They come with an extra layer of challenges, because their very job (and likely their personality) makes them hyper-alert to authority figures.<br><br>This course is designed to give you some tools and tactics to lead individuals and entire teams of investigators in a more effective way. Learn from four investigative managers from different media at different stages of their leadership careers. How did they launch into their roles, and what experience have they gained along the way? This course is for current investigative managers and anyone aspiring to step into such a position in the future.<br><br>Topics will include: managing compassionately, hiring challenges, transitioning to management, forging partnerships, building relationships, handling resource cuts, organization/structure, tough decisions/conversations, in-house training/growth, delivering feedback, creating inclusive opportunities, and juggling responsibilities/projects/work.<br><br><a href="https://www.ire.org/product/nicar23-managing-investigators/" target="_blank">Preregistration is required</a> and seating is limited. Attendees will need to bring their own laptop (no tablets) to participate in this class.</p> | 2023-03-03 09:00:00 | 2023-03-03 12:30:00 | 0 | 1 | SoBro, Meeting Space Level 1 4296414 | Beginner 579482 | 73 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Mc Nelly Torres", "label": "Center for Public Integrity", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476299", "target_object_id": 15476299, "target_content_type": "custom_list.customlistitem" }, { "title": "Josh Hinkle", "label": "KXAN/St. Edward's University", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476167", "target_object_id": 15476167, "target_content_type": "custom_list.customlistitem" }, { "title": "Jodie Fleischer", "label": "Cox Media Group", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476145", "target_object_id": 15476145, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625688&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625689 | 191394 | Mastering Google Sheets: Web scraping, running scripts and other tricks - pre-registered attendees only (repeat) | <p>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.<br><br>Preregistration is required and seating is limited. You must bring your own laptop (no tablets) to this training and have a Google account.<br><br>Workshop prerequisites: You should be familiar with using spreadsheets and formulas.</p> | 2023-03-02 14:15:00 | 2023-03-02 17:45:00 | 0 | 1 | 5 Points 1&2, Meeting Space Level 1 4296417 | Beginner 579482 | 45 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Frank Bi", "label": "Star Tribune", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476103", "target_object_id": 15476103, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625689&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625690 | 191394 | Mastering Google Sheets: Web scraping, running scripts and other tricks - pre-registered attendees only | <p>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.<br><br>Preregistration is required and seating is limited. You must bring your own laptop (no tablets) to this training and have a Google account.<br><br>Workshop prerequisites: You should be familiar with using spreadsheets and formulas.</p> | 2023-03-02 09:00:00 | 2023-03-02 12:30:00 | 0 | 1 | 5 Points 1&2, Meeting Space Level 1 4296417 | Beginner 579482 | 14 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Frank Bi", "label": "Star Tribune", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476103", "target_object_id": 15476103, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625690&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625697 | 191394 | Google Sheets 1: Getting started with spreadsheets | <p>In this introduction to spreadsheets, you'll begin analyzing data with Google Sheets, a simple but powerful tool. You'll learn how to enter data, navigate spreadsheets and conduct simple calculations like sum, average and median.</p> <br> <p>This session is good for: Data beginners. </p> <br> <p>You must bring your own laptop (no tablets) to participate in this class, and you will need a free Google account to participate.</p> | 2023-03-02 09:00:00 | 2023-03-02 10:00:00 | 0 | 1 | Midtown 2, Meeting Space Level 2 4296415 | Beginner 579482 | 5 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Shirsho Dasgupta", "label": "Miami Herald/McClatchy DC Bureau", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476124", "target_object_id": 15476124, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625697&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625700 | 191394 | Google Sheets 2: Formulas & sorting | <p>Much of Google Sheets' 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.<br><br>This session is good for: Anyone who has taken Google Sheets 1 or has been introduced to spreadsheets.<br><br>You must bring your own laptop (no tablets) to participate in this class, and you will need a free Google account to participate.</p> | 2023-03-02 10:15:00 | 2023-03-02 11:15:00 | 0 | 1 | Midtown 2, Meeting Space Level 2 4296415 | Beginner 579482 | 24 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Tisha Thompson", "label": "ESPN", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476295", "target_object_id": 15476295, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625700&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625702 | 191394 | Using OpenRefine to powerwash your data | <p>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.<br><br>This session is good for people with basic experience working with data. </p> | 2023-03-03 10:15:00 | 2023-03-03 11:15:00 | 0 | 1 | Midtown 3, Meeting Space Level 2 4296412 | Beginner 579482 | 87 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Susie Neilson", "label": "San Francisco Chronicle", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476240", "target_object_id": 15476240, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625702&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625704 | 191394 | Google Sheets 3: Filtering & pivot tables | <p>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.<br><br>This session is good for: Anyone familiar with formulas, sorting and filtering in a spreadsheet program.<br><br>You must bring your own laptop (no tablets) to participate in this class, and you will need a free Google account to participate.</p> | 2023-03-02 11:30:00 | 2023-03-02 12:30:00 | 0 | 1 | Midtown 2, Meeting Space Level 2 4296415 | Beginner 579482 | 30 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Matt Dempsey", "label": "Spotlight PA", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476127", "target_object_id": 15476127, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625704&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625708 | 191394 | Google Sheets 4: Advanced pivot tables | <p>You've done a few pivot tables and are getting curious about 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.<br><br>This session is good for: People familiar with spreadsheets and aggregating data with pivot tables, or anyone who has taken Sheets 1-3.<br><br>You must bring your own laptop (no tablets) to participate in this class, and you will need a free Google account to participate.</p> | 2023-03-03 09:00:00 | 2023-03-03 10:00:00 | 0 | 1 | 12 South 1&2, Meeting Space Level 1 4296411 | Beginner 579482 | 68 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Helena Bengtsson", "label": "Gota Media", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476102", "target_object_id": 15476102, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625708&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625709 | 191394 | Working with PDFs using off-the-shelf tools | <p>Join this class to learn how to “liberate” trapped data locked inside of PDF’s. 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.<br><br>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.<br><br>Prerequisites: Attendees should have access to a CometDocs account, which you can access through your IRE membership, the free software Tabula and access to Google Drive.</p> | 2023-03-02 16:45:00 | 2023-03-02 17:45:00 | 0 | 1 | Midtown 3, Meeting Space Level 2 4296412 | Beginner 579482 | 58 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Maggie Mulvihill", "label": "Boston University", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476233", "target_object_id": 15476233, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625709&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625718 | 191394 | Google Sheets: Using string functions to manipulate data | <p>Maybe you converted a PDF or imported a table into a spreadsheet -- 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. <br><br>This session is good for: Anyone comfortable with using formulas and functions in Google Sheets.<br><br>You must bring your own laptop (no tablets) to participate in this class, and you will need a free Google account to participate.</p> | 2023-03-03 14:15:00 | 2023-03-03 15:15:00 | 0 | 1 | Midtown 2, Meeting Space Level 2 4296415 | Beginner 579482 | 104 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Madi Alexander", "label": "POLITICO", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476096", "target_object_id": 15476096, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625718&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625719 | 191394 | Google Sheets: Importing and data prep | <p>Don't give up if your data isn't presented in a neat spreadsheet. This session will teach you how to get data into a spreadsheet and prepare it for analysis. We will look at how to import text files, deal with data in a PDF, and get a table on a web page into a spreadsheet.<br><br>This session is good for: Anyone comfortable working in Google Sheets.<br><br>You must bring your own laptop (no tablets) to participate in this class, and you will need a free Google account to participate.</p> | 2023-03-03 15:30:00 | 2023-03-03 16:30:00 | 0 | 1 | Midtown 2, Meeting Space Level 2 4296415 | Beginner 579482 | 115 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Paula Lavigne", "label": "ESPN", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476200", "target_object_id": 15476200, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625719&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625723 | 191394 | Finding the story: The American Community Survey | <p>Data from the U.S. Census Bureau's American Community Survey can help you tell all kinds of important stories about your community. In this session, you will learn how to find and analyze this data in Google Sheets, and you'll leave with some ideas about how to incorporate these survey results into your coverage.<br><br>This session is good for anyone, no data experience necessary.<br><br>You must bring your own laptop (no tablets) to participate in this class, and you will need a free Google account to participate.</p> | 2023-03-03 10:15:00 | 2023-03-03 11:15:00 | 0 | 1 | Midtown 2, Meeting Space Level 2 4296415 | Beginner 579482 | 80 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Tim Henderson", "label": "Pew Charitable Trusts", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476164", "target_object_id": 15476164, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625723&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625730 | 191394 | Scraping without programming | <p>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!<br><br>This session is good for: Beginners who want to start using data for their stories. </p> <br> <p>Attendees will need to bring their own laptop (no tablets) for the training and must have a Google account.</p> | 2023-03-04 10:15:00 | 2023-03-04 11:15:00 | 0 | 1 | 5 Points 1&2, Meeting Space Level 1 4296417 | Beginner 579482 | 143 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Samantha Sunne", "label": "Independent journalist", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476290", "target_object_id": 15476290, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625730&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625735 | 191394 | Scraping without programming (repeat) | <p>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!<br><br>This session is good for: Beginners who want to start using data for their stories. </p> <br> <p>Attendees will need to bring their own laptop (no tablets) for the training and must have a Google account.</p> | 2023-03-04 15:30:00 | 2023-03-04 16:30:00 | 0 | 1 | 5 Points 1&2, Meeting Space Level 1 4296417 | Beginner 579482 | 173 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Samantha Sunne", "label": "Independent journalist", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476290", "target_object_id": 15476290, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625735&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625793 | 191394 | Introduction to DataWrapper | <p>Datawrapper is an increasingly popular online tool for visualizing data. This class will introduce you to the process of creating some basic charts and maps.<br><br>This session is good for beginners looking for a data visualization solution that doesn't require learning to code. Attendees will need to bring their own laptop (no tablets) to participate in this class.</p> | 2023-03-03 14:15:00 | 2023-03-03 15:15:00 | 0 | 1 | 12 South 1&2, Meeting Space Level 1 4296411 | Beginner 579482 | 105 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Jeff Hargarten", "label": "Star Tribune", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476160", "target_object_id": 15476160, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625793&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625799 | 191394 | Making redistricting data your friend: Finding out what information is out there and how you can use it | <p>While redistricting happens every ten years, the redistricting data is readily available annually and can prove essential in reporting. From demographical information on race, sex, and age to more detailed looks at median household income and languages spoken at home– redistricting data can give provide context to your reporting and create new stories for you to explore. In this session, we’ll explore what data is accessible and how it can be used to bolster your reporting. Come with story ideas you want to explore!<br><br>This session is good for: Beginners who want to know what data is available and how you can use it.</p> | 2023-03-03 09:00:00 | 2023-03-03 10:00:00 | 0 | 1 | Midtown 3, Meeting Space Level 2 4296412 | Beginner 579482 | 70 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Kate Huangpu", "label": "Spotlight PA", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476171", "target_object_id": 15476171, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625799&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625737 | 191394 | Data on the business and economics beat | <p>No matter what beat you cover, business and finance are increasingly becoming key areas to understand and mine. Get story ideas, learn where to find data, and get advice on how to track down information on essential topics, from banking and finance to worker's issues and consumer protection.</p> | 2023-03-03 14:15:00 | 2023-03-03 15:15:00 | 0 | 1 | Broadway Ballroom 3, Meeting Space Level 1 4296409 | On the beat 579483 | 103 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Karen K. Ho", "label": "ARTnews", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476168", "target_object_id": 15476168, "target_content_type": "custom_list.customlistitem" }, { "title": "Megan Squire", "label": "Southern Poverty Law Center", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476285", "target_object_id": 15476285, "target_content_type": "custom_list.customlistitem" }, { "title": "Matt Drange", "label": "Business Insider", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476135", "target_object_id": 15476135, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625737&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625739 | 191394 | It’s freezing! Investigating the climate crisis | <p>The climate crisis is the most defining and crucial issue of the contemporary age. As such, it is also one of the biggest challenges for journalists all over the world. The aim of this workshop is to show best practices and some of the best recent investigative work in this area.</p> | 2023-03-02 11:30:00 | 2023-03-02 12:30:00 | 0 | 1 | Broadway Ballroom 3, Meeting Space Level 1 4296409 | On the beat 579483 | 32 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Niall Sargent", "label": "Noteworthy", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476271", "target_object_id": 15476271, "target_content_type": "custom_list.customlistitem" }, { "title": "Elfredah Kevin-Alerechi", "label": "Independent journalist", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476188", "target_object_id": 15476188, "target_content_type": "custom_list.customlistitem" }, { "title": "Andrew Lehren", "label": "NBC News/City University New York", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476204", "target_object_id": 15476204, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625739&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625740 | 191394 | Beyond the fire perimeter — data for wildfire investigations | <p>Wildfire prevention and response are massive endeavors stretching across local, state and federal agencies — they're complex, high stakes, big budget, and rarely covered in deep dives. They also generate lots of data, but knowing where to look and what you're looking at can be challenging as a reporter. This session will cover how metrics are tracked, how to approach wildfire data with an investigative mindset, and some of the panelists' favorite databases.</p> | 2023-03-03 09:00:00 | 2023-03-03 10:00:00 | 0 | 1 | Broadway Ballroom 3, Meeting Space Level 1 4296409 | On the beat 579483 | 64 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Adiel Kaplan", "label": "NBC News", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476183", "target_object_id": 15476183, "target_content_type": "custom_list.customlistitem" }, { "title": "Veronica Penney", "label": "Colorado Public Radio", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476246", "target_object_id": 15476246, "target_content_type": "custom_list.customlistitem" }, { "title": "Emily Zentner", "label": "California Newsroom", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476332", "target_object_id": 15476332, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625740&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625746 | 191394 | Demystifying cryptocurrency data: How to find stories on ransoms, insider trading and fraud | <p>Cryptocurrencies and the technology powering them are no longer something journalists can dismiss as a passing fad. Even if you don't think Bitcoin is going to replace the dollar, you should get familiar with how to report on crypto. It has created massive fortunes, allowed criminal gangs to extort local and national businesses in new ways and enabled the transfer of money outside of government supervision. The world of crypto often feels opaque and jargony, but Bitcoin, Ethereum and NFTs all work off of public databases, called blockchains–an area ripe for DIY FOIAs, if only journalists knew how. <br><br>Three experienced data journalists will share stories, story ideas, and concrete tips for chasing those stories for mainstream journalists to test their hypotheses and extract publishable facts from the blockchain. Their stories have run the gamut from investigating a widespread life-altering financial fraud dependent on a quirk of the Ethereum network, tracking ransomware, examining potential sanctions violations and possible insider trading.</p> | 2023-03-02 16:45:00 | 2023-03-02 17:45:00 | 0 | 1 | Grand Ballroom 2, Lobby Level 4296419 | On the beat 579483 | 54 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Jeremy Merrill", "label": "The Washington Post", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476226", "target_object_id": 15476226, "target_content_type": "custom_list.customlistitem" }, { "title": "Stacy Elliott", "label": "Decrypt", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476139", "target_object_id": 15476139, "target_content_type": "custom_list.customlistitem" }, { "title": "Rob Barry", "label": "The Wall Street Journal", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476100", "target_object_id": 15476100, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625746&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625754 | 191394 | Making sense of criminal justice data | <p>Reporters who cover criminal justice are bound to encounter lots of numbers: Incarceration rates, crime rates, racial disparities, clearance rates, use of force statistics and so on. Unfortunately, making sense of these figures can be a minefield of potential misinterpretations thanks to antiquated data collection programs, intentional manipulation by law enforcement agencies, and the politically charged nature of the topic. This panel will introduce reporters to common pitfalls, best practices for presenting information to readers, and tools for identifying unreliable statistics.</p> | 2023-03-02 09:00:00 | 2023-03-02 10:00:00 | 0 | 1 | Broadway Ballroom 1&2, Meeting Space Level 1 4296408 | On the beat 579483 | 7 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Ethan Corey", "label": "The Appeal", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476122", "target_object_id": 15476122, "target_content_type": "custom_list.customlistitem" }, { "title": "Cheryl Phillips", "label": "Big Local News", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476249", "target_object_id": 15476249, "target_content_type": "custom_list.customlistitem" }, { "title": "Weihua Li", "label": "The Marshall Project", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476207", "target_object_id": 15476207, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625754&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625755 | 191394 | Using public data to uncover the hidden costs of the housing crisis | <p>Almost half of Americans surveyed by the Pew Research Center say that housing is a significant problem where they live. Rental prices have gone up and, for many, homelessness is just an accident or health issue away. But, despite the importance of the problem and many sources of data available, some of the key questions regarding housing and homelessness remain unanswered. <br><br>One of the biggest challenges is understanding the role of landlords in rapidly gentrifying markets. San Francisco Chronicle’s Susie Neilson worked for months to uncover some of the biggest property owners in her city and will share the lessons of this work.<br><br>Gathering reliable data on homelessness is another major challenge facing journalists today. Amy DiPierro worked to explain what we know about how homelessness impacts children and schools, a side of this issue that many times is overlooked.</p> | 2023-03-04 10:15:00 | 2023-03-04 11:15:00 | 0 | 1 | Broadway Ballroom 1&2, Meeting Space Level 1 4296408 | On the beat 579483 | 147 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Juan Pablo Garnham", "label": "Eviction Lab", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476152", "target_object_id": 15476152, "target_content_type": "custom_list.customlistitem" }, { "title": "Susie Neilson", "label": "San Francisco Chronicle", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476240", "target_object_id": 15476240, "target_content_type": "custom_list.customlistitem" }, { "title": "Amy DiPierro", "label": "Center for Public Integrity", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476132", "target_object_id": 15476132, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625755&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625758 | 191394 | How much does school spending matter for outcomes in education? | <p>In 2019, government spending on K-12 public schools was the highest it’s been since 2008. But what kind of impact do those dollars have on education outcomes like reading and math proficiency? <br><br>Thanks to new data mandated by the feds and collected by Edunomics, it's possible to find the answers. <br><br>Learn more from top education reporters and analysts on how to translate this into stories for your community.</p> | 2023-03-02 14:15:00 | 2023-03-02 15:15:00 | 0 | 1 | Grand Ballroom 3, Lobby Level 4296410 | On the beat 579483 | 39 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Sara Chernikoff", "label": "USAFacts", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476117", "target_object_id": 15476117, "target_content_type": "custom_list.customlistitem" }, { "title": "Ash Dhammani", "label": "Edunomics Lab at Georgetown University", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476130", "target_object_id": 15476130, "target_content_type": "custom_list.customlistitem" }, { "title": "Matt Dempsey", "label": "Spotlight PA", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476127", "target_object_id": 15476127, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625758&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625759 | 191394 | Beyond the Dobbs story: Public health coverage in a post-Roe America | <p>In this session, panelists will share key data that they’ve relied on while reporting on the aftermath of the Dobbs decision to ultimately tell a larger story about public health, including from the CDC and WHO on maternal mortality, the AMA on OB/GYN training and workforces, and more. Speakers will point reporters to those sources and encourage them to think about new ways to tell the post-Dobbs story, with angles that go beyond abortion.</p> | 2023-03-04 09:00:00 | 2023-03-04 10:00:00 | 0 | 1 | Broadway Ballroom 3, Meeting Space Level 1 4296409 | On the beat 579483 | 124 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Annette Choi", "label": "CNN", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476118", "target_object_id": 15476118, "target_content_type": "custom_list.customlistitem" }, { "title": "Kristen Hwang", "label": "CalMatters", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476175", "target_object_id": 15476175, "target_content_type": "custom_list.customlistitem" }, { "title": "Elizabeth Nash", "label": "Guttmacher Institute", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476239", "target_object_id": 15476239, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625759&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625762 | 191394 | Tracking nursing home data amid state and federal staffing reforms | <p>In this panel, speakers will provide an overview of the big reform discussions happening as well as key datasets reporters can use to investigate the extent of nursing home staffing problems in their state, as well as the campaign influence of the nursing home industry that has routinely fought reforms.</p> | 2023-03-05 10:15:00 | 2023-03-05 11:15:00 | 0 | 1 | Broadway Ballroom 3, Meeting Space Level 1 4296409 | On the beat 579483 | 195 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Jayme Fraser", "label": "USA TODAY", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476147", "target_object_id": 15476147, "target_content_type": "custom_list.customlistitem" }, { "title": "Caitlin McGlade", "label": "Arizona Republic", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476222", "target_object_id": 15476222, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625762&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625763 | 191394 | Reporting on a military base near you using courts-martial records | <p>The United States has three systems of justice: civilian, tribal and military.<br><br>Across the country and the globe, when service members commit a crime the offense largely goes unreported. <br><br>While the Uniform Code of Military Justice means each branch shares the same legal code, data is separately kept by each branch and records may need to be requested from individual bases, an appellate court or the public information officers. Hear from experienced military reporters discuss data and records available to report on a military post near you, the common pitfalls, story ideas and terminology crucial to this topic.</p> | 2023-03-03 15:30:00 | 2023-03-03 16:30:00 | 0 | 1 | Grand Ballroom 2, Lobby Level 4296419 | On the beat 579483 | 117 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Ren Larson", "label": "The Assembly", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476198", "target_object_id": 15476198, "target_content_type": "custom_list.customlistitem" }, { "title": "Davis Winkie", "label": "Military Times", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476326", "target_object_id": 15476326, "target_content_type": "custom_list.customlistitem" }, { "title": "Vianna Davila", "label": "ProPublica/Texas Tribune", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476125", "target_object_id": 15476125, "target_content_type": "custom_list.customlistitem" }, { "title": "Geoff Ziezulewicz", "label": "Military Times", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476333", "target_object_id": 15476333, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625763&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625765 | 191394 | 311: The 411 on how to report on your city’s infrastructure issues — and how this data can uncover stories on gentrification | <p>311 data, or “customer service” data from your city’s citizen complaints department, can help you feed the daily/online beast while also feeding into bigger-picture stories. In this end-of-day Saturday session, you won’t have to lift a mouse finger: We’ll go through examples of stories done using this data, talk about how you can do the same, and you’ll leave with a long list of potential story ideas.<br><br>This session is good for: People comfortable with Python and Jupyter notebook. Taking or having taken "introduction to Python for data analysis" or "first Python notebook" is strongly recommended. </p> <br> <p>Attendees will need to bring their own laptop (no tablets) and have a free Google account to participate in this class.</p> | 2023-03-04 16:45:00 | 2023-03-04 17:45:00 | 0 | 1 | 5 Points 1&2, Meeting Space Level 1 4296417 | On the beat 579483 | 177 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Janelle O'Dea", "label": "Center for Public Integrity", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476242", "target_object_id": 15476242, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625765&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625772 | 191394 | Gearing up for the 2024 election | <p>Get a head start on your 2024 election coverage by learning about the campaign finance data you need to be looking at now. We'll also cover the wealth of information to dig into what goes beyond the traditional election data.</p> | 2023-03-04 16:45:00 | 2023-03-04 17:45:00 | 0 | 1 | Broadway Ballroom 1&2, Meeting Space Level 1 4296408 | On the beat 579483 | 183 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Aaron Mendelson", "label": "Center for Public Integrity", "image": "", "gb_url": "gb://guide/191394/poi/?id=15512724", "target_object_id": 15512724, "target_content_type": "custom_list.customlistitem" }, { "title": "Sandra Fish", "label": "Colorado Sun", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476144", "target_object_id": 15476144, "target_content_type": "custom_list.customlistitem" }, { "title": "Jessica Huseman", "label": "Votebeat", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476174", "target_object_id": 15476174, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625772&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625776 | 191394 | Tools for statehouse reporting | <p>Providing journalists who write on the statehouse/state level with the best and most useful data tools & public records requests to crack open statehouses. We'll explore national tools like <a href="FollowTheMoney.org" target="_blank">FollowTheMoney.org</a>, and also do quick tutorials of different states' lobbying, campaign finance and financial disclosure websites. We'll recommend helpful datasets, offer examples of data-based stories, and talk about ways to make data/the investigative mindset a central focus of your statehouse coverage.</p> | 2023-03-04 15:30:00 | 2023-03-04 16:30:00 | 0 | 1 | Broadway Ballroom 1&2, Meeting Space Level 1 4296408 | On the beat 579483 | 176 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Yue Stella Yu", "label": "Bridge Michigan", "image": "", "gb_url": "gb://guide/191394/poi/?id=15511228", "target_object_id": 15511228, "target_content_type": "custom_list.customlistitem" }, { "title": "Jeremy Finley", "label": "WSMV-TV", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476142", "target_object_id": 15476142, "target_content_type": "custom_list.customlistitem" }, { "title": "Phil Williams", "label": "WTVF", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476322", "target_object_id": 15476322, "target_content_type": "custom_list.customlistitem" }, { "title": "Sandra Fish", "label": "Colorado Sun", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476144", "target_object_id": 15476144, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625776&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625777 | 191394 | Mining financial disclosures | <p>Seasoned data and investigative journalists from Bloomberg, Futuro Media and The Wall Street Journal discuss the wealth of financial disclosures that can shed light on how wealthy individuals, companies and government officials abuse their positions to become even wealthier. Get an inside view on investigations into a multibillion-dollar charity being used as a tax dodge, regulators who trade stocks of companies they oversee, and the spoils of policing the Mexican drug trade. Panelists offer tips for using IRS, federal employment and SEC data, and offer tips in handling data and extracting financial data, both qualitative and quantitative, from company filings and property records. We also discuss what financial training journalists need to dig into data that can hold the private sector to account as we do the public sector.</p> | 2023-03-04 09:00:00 | 2023-03-04 10:00:00 | 0 | 1 | Grand Ballroom 2, Lobby Level 4296419 | On the beat 579483 | 130 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Sara Silver", "label": "Quinnipiac University", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476280", "target_object_id": 15476280, "target_content_type": "custom_list.customlistitem" }, { "title": "Peniley Ramirez", "label": "Futuro Investigates/Futuro Media", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476257", "target_object_id": 15476257, "target_content_type": "custom_list.customlistitem" }, { "title": "John West", "label": "The Wall Street Journal", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476319", "target_object_id": 15476319, "target_content_type": "custom_list.customlistitem" }, { "title": "Noah Buhayar", "label": "Bloomberg News", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476110", "target_object_id": 15476110, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625777&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625788 | 191394 | Investigating the big business of medical marijuana cards: questionable health claims, weak oversight, unfair rules and 1 million certification records | <p>The investigative series Cannabis Card Game from Spotlight PA revealed serious flaws with Pennsylvania's medical marijuana program and deceptive practices by businesses that offer to connect patients to physicians. Reporter Ed Mahon will offer a behind-the-scenes look at how he investigated medical claims on more than 60 business websites, analyzed more than 1 million records of medical marijuana certifications, reviewed thousands of pages of public records and lawsuits and won a court battle against his state's health department. This reporting had an impact, but it was also possible with relatively simple data tools, which Mahon will discuss. </p> <br> <p>Attendees will need to bring their own laptop (no tablets) to participate in this class.</p> | 2023-03-04 11:30:00 | 2023-03-04 12:30:00 | 0 | 1 | 5 Points 1&2, Meeting Space Level 1 4296417 | On the beat 579483 | 151 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Edward Mahon", "label": "Spotlight PA", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476213", "target_object_id": 15476213, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625788&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625798 | 191394 | Data for redistricting and election coverage | <p>The nonpartisan Redistricting Data Hub was founded to support civil rights and good government groups organizing around redistricting. But the data has been used more broadly, including for in-depth coverage and analysis of redistricting, as well as related work on elections and democracy. In this session, you'll see how news organizations are already using our data to cover important stories, and learn how you can use our free data and resources in your own work. Attendees will need to bring their own laptop (no tablets) to participate in this class.</p> | 2023-03-02 14:15:00 | 2023-03-02 15:15:00 | 0 | 1 | SoBro, Meeting Space Level 1 4296414 | On the beat 579483 | 36 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Kate Donovan", "label": "Redistricting Data Hub", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476133", "target_object_id": 15476133, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625798&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625801 | 191394 | Finding criminal justice data in public records | <p>Lucy Parsons Labs and the Chicago Incarcerated Workers Organizing Committee have spent the last six years beginning to understand how police departments, jails and prisons rely on opacity to shield from public criticism harmful and often dangerous practices. Using Muckrock to send targeted and automated requests and DocumentCloud to store, annotate, and analyze documents using their many features and Add-Ons, Lucy Parsons Labs, IWOC and the Muckrock Foundation have begun to chip away at the secrecy.<br>The goal of this session is to help reporters understand the Muckrock and DocumentCloud platforms and how both offer great research opportunities, avenues for collaboration, and built in tools for document analysis to pull back the veil of secrecy as it relates to the treatment of those who are policed and incarcerated. Public data and records help us advocate for the policed & incarcerated and continue on our pathway to abolition. Attendees will need to bring their own laptop (no tablets) to participate in this class.</p> | 2023-03-04 11:30:00 | 2023-03-04 12:30:00 | 0 | 1 | SoBro, Meeting Space Level 1 4296414 | On the beat 579483 | 149 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Sanjin Ibrahimovic", "label": "MuckRock", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476176", "target_object_id": 15476176, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625801&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625680 | 191394 | First Observable Notebook: Prototyping with polish - pre-registered attendees only | <p>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 interactive graphics and data analysis notebooks like those created by The Marshall Project and Los Angeles Times. Along the way, you’ll see how Observable’s groundbreaking approach to coding can help you be more creative, ambitious, efficient, and collaborative. You will learn how to rapidly explore a dataset and share insights and data visualizations with JavaScript, Observable Plot and an interactive Observable notebook. Preregistration is required and seating is limited. You must bring your own laptop (no tablets) to participate in this class, and you'll need a free Observable account: observablehq.com.<br><br>Workshop prerequisites: Beginner to intermediate experience with Javascript, with basic knowledge of other web technologies like HTML, CSS, and SVGs. As long as you have a web browser, a working attitude, and willingness to ask for help, you’ll be golden!</p> | 2023-03-02 14:15:00 | 2023-03-02 17:45:00 | 0 | 1 | 12 South 1&2, Meeting Space Level 1 4296411 | Intermediate 579484 | 42 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Alex Garcia", "label": "Independent journalist", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476151", "target_object_id": 15476151, "target_content_type": "custom_list.customlistitem" }, { "title": "David Eads", "label": "The Marshall Project", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476137", "target_object_id": 15476137, "target_content_type": "custom_list.customlistitem" }, { "title": "Ilica Mahajan", "label": "The Marshall Project", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476212", "target_object_id": 15476212, "target_content_type": "custom_list.customlistitem" }, { "title": "Weihua Li", "label": "The Marshall Project", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476207", "target_object_id": 15476207, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625680&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625681 | 191394 | First Python Notebook - pre-registered attendees only | <p>In this session, experienced journalists will guide you through a six-hour, hands-on investigation of money in politics.<br><br>You will learn:<br><br>* just enough Python to execute an analysis with pandas, one of the most popular open-source tools for working with data tables<br>* how to record, remix and republish your work using Jupyter, a browser-based tool emerging as the standard for reproducible research<br>* how to explore your data using the Altair data visualization library, a Python package that offers a simple, structured grammar for generating graphics.<br><br>Along the way you’ll conduct your own investigation of California campaign donors using the Big Local News open-source database archive.<br>Preregistration is required and seating is limited. Laptops will be provided.<br>Prerequisites: If you've tried Python once or twice, have a good attitude and know how to take a few code crashes in stride, you are qualified.</p> | 2023-03-03 09:00:00 | 2023-03-03 17:45:00 | 0 | 1 | Midtown 1, Meeting Space Level 2 4296413 | Intermediate 579484 | 74 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Ben Welsh", "label": "Reuters", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476318", "target_object_id": 15476318, "target_content_type": "custom_list.customlistitem" }, { "title": "Andrea Suozzo", "label": "ProPublica", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476291", "target_object_id": 15476291, "target_content_type": "custom_list.customlistitem" }, { "title": "Gabrielle LaMarr LeMee", "label": "Los Angeles Times", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476196", "target_object_id": 15476196, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625681&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625684 | 191394 | Introduction to R - pre-registered attendees only | <p>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. <br><br>Preregistration is required and seating is limited. Attendees will need to bring their own laptop for the training and have <u><a href="https://docs.google.com/document/d/1W7WIIW9UyqOec7rU36EsQqrRvgLJGRf3_dwTcy4YvJM/edit?usp=share_link" target="_blank">R and RStudio installed</a></u>. <br><br>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.</p> | 2023-03-02 14:15:00 | 2023-03-02 17:45:00 | 0 | 1 | Midtown 2, Meeting Space Level 2 4296415 | Intermediate 579484 | 44 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Charles Minshew", "label": "Atlanta Journal-Constitution", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476228", "target_object_id": 15476228, "target_content_type": "custom_list.customlistitem" }, { "title": "Stephanie Lamm", "label": "Atlanta Journal-Constitution", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476197", "target_object_id": 15476197, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625684&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625685 | 191394 | Introduction to web development - pre-registered attendees only | <p>This daylong crash course for beginners will give you the confidence you need to start building things for the web. You'll start from scratch and learn about HTML, CSS and JavaScript, then dive into some more advanced tools used by modern web developers around the world. Along the way, you'll learn about how and where to host your creations, the importance of accessibility-first development and other key topics.<br><br>Preregistration is required and seating is limited. Laptops will be provided for the training. <br><br>Workshop prerequisites: Some experience working with data in general. Knowledge of web development concepts is helpful but not required.</p> | 2023-03-02 09:00:00 | 2023-03-02 17:45:00 | 0 | 1 | Sylvan Park, Meeting Space Level 2 4296416 | Intermediate 579484 | 15 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Carla Astudillo", "label": "The Texas Tribune", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476098", "target_object_id": 15476098, "target_content_type": "custom_list.customlistitem" }, { "title": "Na\u00ebl Shiab", "label": "CBC", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476279", "target_object_id": 15476279, "target_content_type": "custom_list.customlistitem" }, { "title": "Andrew Briz", "label": "POLITICO", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476106", "target_object_id": 15476106, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625685&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625692 | 191394 | Let's make mapping better! - pre-registered attendees only | <p>More and more, newsrooms embrace mapping and spatial analysis as ways to highlight patterns and trends in data — and more and more, we might find ourselves frustrated in working with and visualizing geographic data. In this session, we'll discuss some ways that mapping falls short and ways we can improve it, and we'll get hands-on experience optimizing the mapping process in order to make it more collaborative, cohesive and repeatable. We will share our own tips, tricks and tools as well as encourage feedback from attendees so we can all take something new back to our own newsrooms! </p> <br> <p>Preregistration is required and seating is limited. Laptops will be provided.</p> | 2023-03-02 09:00:00 | 2023-03-02 12:30:00 | 0 | 1 | Midtown 1, Meeting Space Level 2 4296413 | Intermediate 579484 | 13 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Alexandra Kanik", "label": "Houston Chronicle / San Antonio Express-News", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476181", "target_object_id": 15476181, "target_content_type": "custom_list.customlistitem" }, { "title": "Cam Rodriguez", "label": "Chalkbeat", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476265", "target_object_id": 15476265, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625692&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625693 | 191394 | Upping your Excel game - pre-registered attendees only | <p>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.<br><br>Preregistration is required and seating is limited. Laptops will be provided for the training. <br><br>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.</p> | 2023-03-03 14:15:00 | 2023-03-03 16:30:00 | 0 | 1 | Midtown 3, Meeting Space Level 2 4296412 | Intermediate 579484 | 109 | [ { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625693&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625694 | 191394 | Web scraping with Python - pre-registered attendees only | <p>If you need data that's trapped on a website, writing some code to scrape the page could be your solution. This entry-level class will show you how to use the Python programming language to harvest information from websites into a data file. We'll introduce you to the command line and show you how to write enough code to fetch and parse content on the web.<br><br>Preregistration is required and seating is limited. Laptops will be provided.<br><br>Workshop prerequisites: This class is programming for beginners. Some basic familiarity with Python and HTML is helpful but not required.</p> | 2023-03-05 09:00:00 | 2023-03-05 12:30:00 | 0 | 1 | Midtown 3, Meeting Space Level 2 4296412 | Intermediate 579484 | 191 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Cody Winchester", "label": "IRE & NICAR", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476325", "target_object_id": 15476325, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625694&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625696 | 191394 | Command line for reporters on a Mac | <p>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. We will run through some simple commands, dive into working with spreadsheets and show you some handy tools he frequently uses at work.<br><br>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.</p> | 2023-03-03 11:30:00 | 2023-03-03 12:30:00 | 0 | 1 | Sylvan Park, Meeting Space Level 2 4296416 | Intermediate 579484 | 90 | [ { "categoryTitle": "Speakers", "links": [ { "title": "AJ Vicens", "label": "CyberScoop", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476307", "target_object_id": 15476307, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625696&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625698 | 191394 | Finding needles in haystacks with fuzzy matching | <p> 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-driven investigations as a way to identify connections between public figures, key people and companies that are </p> | 2023-03-03 09:00:00 | 2023-03-03 10:00:00 | 0 | 1 | Sylvan Park, Meeting Space Level 2 4296416 | Intermediate 579484 | 66 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Max Harlow", "label": "Financial Times", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476161", "target_object_id": 15476161, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625698&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625699 | 191394 | R 1: Intro to R and RStudio | <p>Jump into data analysis 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.<br> <br>This session is good for: People with a basic understanding of data analysis who are ready to go beyond spreadsheets.</p> | 2023-03-04 09:00:00 | 2023-03-04 10:00:00 | 0 | 1 | Midtown 3, Meeting Space Level 2 4296412 | Intermediate 579484 | 132 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Ryann Jones", "label": "ProPublica", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476180", "target_object_id": 15476180, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625699&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625703 | 191394 | R 2: Data analysis and plotting | <p>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. <br><br>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. </p> | 2023-03-04 10:15:00 | 2023-03-04 11:15:00 | 0 | 1 | Midtown 3, Meeting Space Level 2 4296412 | Intermediate 579484 | 142 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Sean Mussenden", "label": "University of Maryland", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476236", "target_object_id": 15476236, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625703&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625705 | 191394 | R 3: Gathering and cleaning data | <p>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.<br><br>This session is good for: People who have used R and have a basic understanding of how to retrieve data from APIs.</p> | 2023-03-04 11:30:00 | 2023-03-04 12:30:00 | 0 | 1 | Midtown 3, Meeting Space Level 2 4296412 | Intermediate 579484 | 154 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Sean Mussenden", "label": "University of Maryland", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476236", "target_object_id": 15476236, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625705&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625710 | 191394 | PDF processing with command-line tools | <p>This class seeks to help you solve a common problem in journalism: Data stored in PDFs. We'll first walk through extracting text from a computer-generated PDF using a command-line tool. Then we'll step up to Optical Character Recognition, or OCR, to work on freeing data from image files.<br><br>This session is good for: People with experience using their computer's command-line interface.</p> | 2023-03-04 14:15:00 | 2023-03-04 15:15:00 | 0 | 1 | Sylvan Park, Meeting Space Level 2 4296416 | Intermediate 579484 | 159 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Chad Day", "label": "The Wall Street Journal", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476126", "target_object_id": 15476126, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625710&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625711 | 191394 | R: Introduction to statistics - pre-registered attendees only | <p>Statistics can help you find newsworthy patterns by measuring relationships. This class will help you correctly interpret and report using methods such as correlation, linear regression, and t-test. It will help you visualize data and apply statistical significance. This class is for anyone with some spreadsheet knowledge and a little exposure to R Studio.</p> <br> <p><a href="https://www.ire.org/product/nicar23-intro-stats/" target="_blank">Preregistration is required and seating is limited.</a></p> | 2023-03-04 14:15:00 | 2023-03-04 17:45:00 | 0 | 1 | Midtown 1, Meeting Space Level 2 4296413 | Intermediate 579484 | 166 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Norm Lewis", "label": "University of Florida", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476206", "target_object_id": 15476206, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625711&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625712 | 191394 | Gathering data with APIs | <p>In this hands-on session, we'll learn how to use data from Application Programming Interfaces (APIs) to enhance reporting and augment data from other sources. This session will cover how APIs fit in with other sources of data, a basic understanding of the web technologies that make them work, using some desktop tools to fetch data from API endpoints and sharing useful APIs and tools for journalism.<br><br>Some basic data analysis skills and knowledge of coding concepts is helpful, but not required.</p> | 2023-03-04 16:45:00 | 2023-03-04 17:45:00 | 0 | 1 | Sylvan Park, Meeting Space Level 2 4296416 | Intermediate 579484 | 182 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Geoff Hing", "label": "The Marshall Project", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476166", "target_object_id": 15476166, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625712&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625716 | 191394 | First GitHub Scraper - pre-registered attendees only | <p>Iris Lee and Aadit Tambe will guide you through a three-hour, hands-on introduction to free, automated web scraping with GitHub’s powerful Actions framework.<br><br>You will learn how to:<br><br>* Create a GitHub repository to store your code online<br>* Write just enough Python to scrape a simple data file<br>* Configure GitHub Actions to schedule the scrape<br>* Log the results to the repository and make it publicly accessible<br>* Send a Slack notification when new data is logged<br><br><a href="https://www.ire.org/product/nicar23-github-scraper/" target="_blank">Preregistration is required and seating is limited</a>. You must bring your own laptop (no tablets) to participate in this class, and prior to the class you should sign up for a free GitHub account prior to the class. If you have a good attitude and know how to take a few code crashes in stride, you are qualified. We want you.</p> | 2023-03-03 14:15:00 | 2023-03-03 17:45:00 | 0 | 1 | SoBro, Meeting Space Level 1 4296414 | Intermediate 579484 | 110 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Iris Lee", "label": "Los Angeles Times", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476201", "target_object_id": 15476201, "target_content_type": "custom_list.customlistitem" }, { "title": "Aadit Tambe", "label": "The Washington Post", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476292", "target_object_id": 15476292, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625716&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625717 | 191394 | Regular expressions for the rest of us | <p>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.<br><br>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. Attendees will need to bring their own laptop (no tablets) to participate in this class.</p> | 2023-03-03 14:15:00 | 2023-03-03 15:15:00 | 0 | 1 | 5 Points 1&2, Meeting Space Level 1 4296417 | Intermediate 579484 | 107 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Justin Myers", "label": "Associated Press", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476237", "target_object_id": 15476237, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625717&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625720 | 191394 | Excel: Basic stats | <p>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.<br><br>This session is good for: People who already are comfortable with using functions in Excel.</p> | 2023-03-02 10:15:00 | 2023-03-02 11:15:00 | 0 | 1 | Midtown 3, Meeting Space Level 2 4296412 | Intermediate 579484 | 22 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Todd Wallack", "label": "WBUR", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476315", "target_object_id": 15476315, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625720&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625722 | 191394 | Finding the story: Digging into nonprofits for fun and, um, profit | <p>The IRS collects vast amounts of data on millions of hospitals, universities, cultural organizations and other nonprofit organizations. Most of that information is public. You can find it in IRS Form 990. We’ll use R to import and analyze some 990s, so bring your laptop. But you don’t need to know any R for this session and you’ll learn plenty about the nonprofit world.<br><br>This session is good for anyone who has some experience working with data. Attendees will need to bring their own laptop (no tablets) to participate in this class.</p> | 2023-03-04 09:00:00 | 2023-03-04 10:00:00 | 0 | 1 | Midtown 2, Meeting Space Level 2 4296415 | Intermediate 579484 | 125 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Ronald Campbell", "label": "NBCUniversal Owned TV Stations", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476113", "target_object_id": 15476113, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625722&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625725 | 191394 | Command line data analysis with VisiData | <p>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. </p> <br> <p>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.</p> | 2023-03-03 14:15:00 | 2023-03-03 15:15:00 | 0 | 1 | Sylvan Park, Meeting Space Level 2 4296416 | Intermediate 579484 | 101 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Jeremy Singer-Vine", "label": "The Data Liberation Project", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476281", "target_object_id": 15476281, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625725&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625732 | 191394 | Datasette: An ecosystem of tools for exploring data and collaborating on data projects | <p>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.<br>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:<br>- Using Datasette Cloud to upload, explore and analyze data from a variety of sources<br>- Using full-text search and facets to quickly analyze large and complex datasets<br>- Visualizing numeric and geographic data using Datasette plugins<br>- Running Datasette and associated tools on your own machine using the command line<br></p> <p>This session is good for anyone. Basic familiarity with SQL and the command line is helpful but not necessary.</p> | 2023-03-04 15:30:00 | 2023-03-04 16:30:00 | 0 | 1 | Sylvan Park, Meeting Space Level 2 4296416 | Intermediate 579484 | 170 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Simon Willison", "label": "Independent journalist", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476324", "target_object_id": 15476324, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625732&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625733 | 191394 | Findings and using undocumented APIs | <p>This tutorial will introduce reporters to an exciting and often overlooked data source found on every website. You will learn how to find and use hidden APIs as a reporting resource, and hear about how this data source has been used in past reporting.<br><br>This session is for reporters who want to diversify their data sources. You don't need to write code: we'll teach participants to find hidden APIs in your web browser, but knowing some coding will let you to unlock detailed and rich datasets hidden in plain sight. Attendees will need to bring their own laptop (no tablets) to participate in this class.</p> <br> <p><a href="https://inspectelement.org/apis">We'll be working off this scripted documented</a>.</p> | 2023-03-04 09:00:00 | 2023-03-04 10:00:00 | 0 | 1 | 5 Points 1&2, Meeting Space Level 1 4296417 | Intermediate 579484 | 126 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Leon Yin", "label": "The Markup", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476329", "target_object_id": 15476329, "target_content_type": "custom_list.customlistitem" }, { "title": "Dhruv Mehrotra", "label": "WIRED", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476225", "target_object_id": 15476225, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625733&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625797 | 191394 | Introduction to Python for data analysis - pre-registered attendees only | <p>Caitlin McGlade and Sahana Jayaraman will guide you through using Python to find stories in data. We will use Jupyter Notebooks to execute commands, a popular opensource tool commonly used to explore data tables and organize code.<br><br>You’ll learn:<br><br>- How to pull data from both a CSV saved locally on your computer and directly from a website<br>- How to find “the most” or “the least” by sorting<br>- How to isolate or exclude variables with filtering<br>- How to compare variables with groupbys<br>- How to merge datasets<br><br>This session would be good for people who have crunched numbers in Excel, or understand the concept of filtering, sorting and pivot tables /groupbys through other programs, and want to start analyzing data with Python so their work is more easily reproducible. Also for those who have tried a little Python before and couldn’t get the hang of it but want to keep trying.</p> | 2023-03-02 14:15:00 | 2023-03-02 17:45:00 | 0 | 1 | Midtown 1, Meeting Space Level 2 4296413 | Intermediate 579484 | 43 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Caitlin McGlade", "label": "Arizona Republic", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476222", "target_object_id": 15476222, "target_content_type": "custom_list.customlistitem" }, { "title": "Sahana Jayaraman", "label": "Arizona Republic", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476177", "target_object_id": 15476177, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625797&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625804 | 191394 | QGIS 1: Mapmaking for beginners | <p>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.<br><br>This session is good for: Beginners looking to learn the basics of visualizing geographic data.</p> | 2023-03-02 14:15:00 | 2023-03-02 15:15:00 | 0 | 1 | Midtown 3, Meeting Space Level 2 4296412 | Intermediate 579484 | 41 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Christine Jeavens", "label": "BBC News", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476178", "target_object_id": 15476178, "target_content_type": "custom_list.customlistitem" }, { "title": "Libby Rogers", "label": "BBC News", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476266", "target_object_id": 15476266, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625804&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625805 | 191394 | QGIS 2: Analyzing geographic data | <p>Build on your existing knowledge of QGIS and learn how to explore, manipulate and analyze geographic datasets to gain new insights.<br><br>This session is good for: Those who attended the QGIS I workshop or already know the basics of visualizing geographic data in QGIS.</p> | 2023-03-02 15:30:00 | 2023-03-02 16:30:00 | 0 | 1 | Midtown 3, Meeting Space Level 2 4296412 | Intermediate 579484 | 48 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Christine Jeavens", "label": "BBC News", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476178", "target_object_id": 15476178, "target_content_type": "custom_list.customlistitem" }, { "title": "Libby Rogers", "label": "BBC News", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476266", "target_object_id": 15476266, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625805&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625808 | 191394 | Data analysis in JavaScript | <p> Learn how to crunch your data with JavaScript. Journalist Nael Shiab will teach you how to use the Simple-Data-Analysis library (<a href="http://github.com/nshiab/simple-data-analysis">github.com/nshiab/simple-data-analysis</a>) to retrieve, clean, analyze and visualize data. </p> <br> <p>You must bring your own laptop (no tablets) to participate in this class. Prior to the class, you should sign up for an Observable account: <a href="observablehq.com" target="_blank">observablehq.com</a>. </p> <br> <p>This session is good for: People with some coding experience (JavaScript, R, Python, etc.). Attendees will need to bring their own laptop (no tablets) to participate in this class.</p> | 2023-03-03 10:15:00 | 2023-03-03 11:15:00 | 0 | 1 | 5 Points 1&2, Meeting Space Level 1 4296417 | Intermediate 579484 | 78 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Na\u00ebl Shiab", "label": "CBC", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476279", "target_object_id": 15476279, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625808&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625809 | 191394 | First Visual Story - pre-registered attendees only | <p>Learn how America’s top news organizations escape rigid content-management systems to publish custom graphics on deadline. <br><br>Take this 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.<br><br><a href="https://www.ire.org/product/nicar23-first-viz-story/" target="_blank">Preregistration is required and seating is limited</a>. Laptops will be provided.<br><br>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.</p> | 2023-03-04 09:00:00 | 2023-03-04 12:30:00 | 0 | 1 | Sylvan Park, Meeting Space Level 2 4296416 | Intermediate 579484 | 134 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Ben Welsh", "label": "Reuters", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476318", "target_object_id": 15476318, "target_content_type": "custom_list.customlistitem" }, { "title": "Aida Ylanan", "label": "Los Angeles Times", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476330", "target_object_id": 15476330, "target_content_type": "custom_list.customlistitem" }, { "title": "James Thomas", "label": "The New York Times", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476293", "target_object_id": 15476293, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625809&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625682 | 191394 | Exploring data in R with the Tidyverse - pre-registered attendees only (first half) | <p>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. <br><br><a href="https://www.ire.org/product/nicar23-tidyverse/" target="_blank">Preregistration is required and seating is limited</a>. Laptops will be provided for the training. <br><br>Workshop prerequisites: You should be comfortable working with R and RStudio and be familiar with basic data analysis.</p> | 2023-03-04 09:00:00 | 2023-03-04 12:30:00 | 0 | 1 | Midtown 1, Meeting Space Level 2 4296413 | Advanced 579485 | 133 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Liz Lucas", "label": "IRE & NICAR", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476210", "target_object_id": 15476210, "target_content_type": "custom_list.customlistitem" }, { "title": "Andrew Ba Tran", "label": "The Washington Post", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476301", "target_object_id": 15476301, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625682&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625691 | 191394 | Practical machine learning for everyone - pre-registered attendees only | <p>Whether you're interested in classifying images, sorting documents, summarizing text, transcribing audio, or a million other topics, machine learning is here to help!<br><br>Learn to set up practical machine learning pipelines in minutes: we'll train custom models, build easy-to-use web apps, host private APIs and more through the adorably-named Hugging Face. Whatever your level of technical comfort, we'll set you up with a system that works perfectly just for you.<br><br>Beyond showing off all our fun new tricks, we'll also look at the tradeoffs between ease-of-use versus diving deep into the innards of the machine. What nuance do we miss when we shovel the details off to a convenient tool?<br><br>You'll leave this session with a dozen new tools in your toolbox – at all levels of the tech tree – along with the confidence (or necessary suspicion) in wielding these tools in the newsroom.<br><br><a href="https://www.ire.org/product/nicar23-python-ml/" target="_blank">Preregistration is required and seating is limited</a>. You must bring your own laptop (no tablets) to this training.</p> | 2023-03-04 14:15:00 | 2023-03-04 17:45:00 | 0 | 1 | Midtown 2, Meeting Space Level 2 4296415 | Advanced 579485 | 165 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Jonathan Soma", "label": "Columbia University", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476284", "target_object_id": 15476284, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625691&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625706 | 191394 | Mapping and geographic data analysis with the simple features package in R | <p>The sf (Simple Features) package in R represents vector geodata as data frames with the geometry held in a single list-column. As such, it allows you to process geodata in pipelines that consistent with the syntax of dplyr and other tidyverse packages. This session will provide an introduction to the Simple Features in R package, show how to draw maps from sf objects with ggplot2, and how to run spatial queries on geodata much as you would in PostGIS. This session is good for anyone who is comfortable working in R and the Tidyverse packages.</p> | 2023-03-02 09:00:00 | 2023-03-02 10:00:00 | 0 | 1 | Midtown 3, Meeting Space Level 2 4296412 | Advanced 579485 | 8 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Peter Aldhous", "label": "University of California - Berkeley", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476095", "target_object_id": 15476095, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625706&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625713 | 191394 | R: Making fancieR graphics | <p>Come check out some new packages created by members of the R community that may inspire you to try out some new exploratory data viz techniques with R. Creating small multiples for regions in a spatially meaningful way. Easy text annotations for exploratory charts. Animated data viz GIFs for social media. Fancy bivariate choropleth maps! Turn your headshot into a ridgeplot. Disclaimer: “fancier” doesn’t necessarily mean useful.<br><br>This session is good for anyone who is comfortable working in R, and some experience with ggplot2 is helpful. Attendees will need to bring their own laptop (no tablets) to participate in this class.</p> | 2023-03-02 10:15:00 | 2023-03-02 11:15:00 | 0 | 1 | 12 South 1&2, Meeting Space Level 1 4296411 | Advanced 579485 | 25 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Andrew Ba Tran", "label": "The Washington Post", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476301", "target_object_id": 15476301, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625713&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625721 | 191394 | Hands-On with Neo4j: Introduction to graph databases, graph algorithms, and graph data visualization for data journalism | <p>This hands-on session will cover how graph databases (specifically the open-source graph database Neo4j) can be used to analyze data as part of data journalism investigations. We will learn how to import and model data in a graph database, how to query the data using the Cypher query language, and how to use graph algorithms like centrality, community detection, and graph embeddings alongside graph data visualization in the context of data journalism.<br><br>This session is good for anyone who is comfortable working with data. Some experience with SQL or coding would be helpful. Attendees will need to bring their own laptop (no tablets) to participate in this class.</p> | 2023-03-03 15:30:00 | 2023-03-03 16:30:00 | 0 | 1 | 5 Points 1&2, Meeting Space Level 1 4296417 | Advanced 579485 | 116 | [ { "categoryTitle": "Speakers", "links": [ { "title": "William Lyon", "label": "Neo4j", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476211", "target_object_id": 15476211, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625721&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625726 | 191394 | Python: Working with PDFs using pdfplumber | <p>Wonderful tools such as Tabula have made it easier to extract tabular data from PDFs. But what if your pile of PDFs is more complex than that? Maybe there are a few bits of info that you need to grab outside the tables, or maybe the information isn't tabular at all?<br><br>In this session, we'll use pdfplumber, an open-source Python library, to demonstrate some techniques. We'll also demystify some aspects of the PDF file format, which will come in handy no matter what tools you use.<br><br>This session would be good for: People with some prior experience using Python.</p> | 2023-03-03 10:15:00 | 2023-03-03 11:15:00 | 0 | 1 | Sylvan Park, Meeting Space Level 2 4296416 | Advanced 579485 | 84 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Jeremy Singer-Vine", "label": "The Data Liberation Project", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476281", "target_object_id": 15476281, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625726&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625731 | 191394 | Making maps with command-line tools | <p>This class will be a hands-on walkthrough of the methods used by Milligan to make the map files that power live, interactive election results maps, inspired heavily by <u><a href="https://medium.com/@mbostock/command-line-cartography-part-1-897aa8f8ca2c" target="_blank">Mike Bostock's Command-Line Cartography Series</a></u>. (bit.ly/cli-carto)<br><br>We'll dig into some popular JSON-based map formats, ways to convert between them, and, ultimately, how to bend them to your will. By the end we'll be able to take a Census shapefile, extract from it exactly what we need, project it, and turn it into either a static image or a TopoJSON ready for your interactive web app. And we'll do it all from the command line using open-source tools, so you can wrap it up in a script and run it again and again!<br><br>This session would be good for people with some command-line experience who are comfortable getting knee-deep in some JSON.</p> | 2023-03-03 16:45:00 | 2023-03-03 17:45:00 | 0 | 1 | Sylvan Park, Meeting Space Level 2 4296416 | Advanced 579485 | 118 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Andrew Milligan", "label": "POLITICO", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476227", "target_object_id": 15476227, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625731&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625792 | 191394 | Stats in R | <p>Learn how to use R to spot trends and identify relationships in data using social science theories and methods. In this session, we will use R for statistical significance tests, cross-tabulations and linear regression.<br><br>This session is good for: Anyone who is comfortable working with spreadsheets and database managers and wants to learn how to do basic statistical analysis. Some experience with R will be helpful.</p> | 2023-03-04 14:15:00 | 2023-03-04 15:15:00 | 0 | 1 | Midtown 3, Meeting Space Level 2 4296412 | Advanced 579485 | 161 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Holly Hacker", "label": "Kaiser Health News", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476158", "target_object_id": 15476158, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625792&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625796 | 191394 | Creating and serving vector map tiles using open source tools | <p>Maps are a core component of digital journalism, but what are the options for newsrooms on a budget? In this session, we’ll cover how to use open source tools to generate vector map tiles, apply a custom style, and serve them to readers without breaking the bank.<br><br>By the end of this session, you’ll have the tools to:<br>- Commission a cloud computer to download and process map tiles<br>- Create a custom style to display the data exactly the way you want<br>- Publish the final result on an online service that can power your interactive maps<br><br>This session is good for: Those who are comfortable with JavaScript and the command line.</p> | 2023-03-03 15:30:00 | 2023-03-03 16:30:00 | 0 | 1 | Sylvan Park, Meeting Space Level 2 4296416 | Advanced 579485 | 112 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Evan Wagstaff", "label": "San Francisco Chronicle", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476311", "target_object_id": 15476311, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625796&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28668959 | 191394 | Exploring data in R with the Tidyverse - pre-registered attendees only (second half) | <p>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. </p> <br> <p><a href="https://www.ire.org/product/nicar23-tidyverse/">Preregistration is required and seating is limited</a>. Laptops will be provided for the training. </p> <br> <p>Workshop prerequisites: You should be comfortable working with R and RStudio and be familiar with basic data analysis.</p> | 2023-03-05 09:00:00 | 2023-03-05 12:30:00 | 0 | 1 | Midtown 1, Meeting Space Level 2 4296413 | Advanced 579485 | 190 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Liz Lucas", "label": "IRE & NICAR", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476210", "target_object_id": 15476210, "target_content_type": "custom_list.customlistitem" }, { "title": "Andrew Ba Tran", "label": "The Washington Post", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476301", "target_object_id": 15476301, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28668959&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625683 | 191394 | How to analyze freely-available real estate data to tell your community's story | <p>The housing market has come to dominate the news lately, as mortgage rates have risen in an attempt to fight inflation, and having the additional effect of cooling off the real estate market after years of meteoric rises in home values. This came after decades of a widespread housing shortage, which had driven up values already, all working together to push home affordability—and in many ways the American Dream—out of reach for many. Making sense of this through data is where we can help. Realtor.com provides free, near-realtime housing market data that can be used to tell this story at any level, from national or statewide trends, down to the real estate dynamics at city or even ZIP code level. In this session, we will show NICAR attendees how to get and use Realtor.com's data, so they can immediately begin producing thorough, data-driven reporting on the housing market. Attendees will be able to take what they learn in this session and generate analyses that use time-series data, supply-and-demand metrics and even pairing Realtor.com's data with Census Bureau data to produce correlations between the housing market and demographics, as well as creating maps that illustrate the data. <br><br>Attendees will need to bring their own laptop (no tablets) to participate in this class.</p> | 2023-03-05 10:15:00 | 2023-03-05 11:15:00 | 0 | 1 | SoBro, Meeting Space Level 1 4296414 | Tools & tech 579486 | 194 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Evan Wyloge", "label": "Realtor.com", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476327", "target_object_id": 15476327, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625683&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625687 | 191394 | Large-scale scraping projects | <p>It's easier and cheaper than ever to do large-scale scraping projects with a small team. In this session, speakers will discuss code, cloud computing infrastructure, and lessons learned while we worked on our scraping projects.</p> | 2023-03-03 10:15:00 | 2023-03-03 11:15:00 | 0 | 1 | Grand Ballroom 3, Lobby Level 4296410 | Tools & tech 579486 | 83 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Leon Yin", "label": "The Markup", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476329", "target_object_id": 15476329, "target_content_type": "custom_list.customlistitem" }, { "title": "Jeff Kao", "label": "ProPublica", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476182", "target_object_id": 15476182, "target_content_type": "custom_list.customlistitem" }, { "title": "Ilica Mahajan", "label": "The Marshall Project", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476212", "target_object_id": 15476212, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625687&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625714 | 191394 | Finding the story: Using DNS search for investigative journalism | <p>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 DNS database, to discover previously unknown online connections and gain new information to advance your ongoing and breaking news investigations.</p> <br> <p>Basic knowledge of the Domain Name System (DNS) is helpful, but not required. Attendees will need to bring their own laptop (no tablets) to participate in this class.</p> | 2023-03-02 09:00:00 | 2023-03-02 10:00:00 | 0 | 1 | 12 South 1&2, Meeting Space Level 1 4296411 | Tools & tech 579486 | 4 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Kelly Molloy", "label": "Domain Tools", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476230", "target_object_id": 15476230, "target_content_type": "custom_list.customlistitem" }, { "title": "Daniel Schwalbe", "label": "Domain Tools", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476276", "target_object_id": 15476276, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625714&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625756 | 191394 | Beyond checking the facts: Tracing the spread of misinformation to the source | <p>Discuss ongoing research to trace and group pieces of misinformation to their source. Fact-checkers tend to focus on the pieces of misinformation as individual pieces of content, however, it has been shown in previous research that most misinformation originates from a small number of malicious sources who then actively spread it to a wider audience.</p> | 2023-03-04 15:30:00 | 2023-03-04 16:30:00 | 0 | 1 | Broadway Ballroom 3, Meeting Space Level 1 4296409 | Tools & tech 579486 | 168 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Christopher Guess", "label": "Duke University Reporters' Lab", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476157", "target_object_id": 15476157, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625756&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625767 | 191394 | Who's behind that website? | <p>Reporting online today, journalists must battle with astroturf campaigns, fake news sites and sketchy shell companies to find out who is behind the story. Usually it leads to a frustratingly common question: Who is behind this website?<br>Using a range of tools (free and otherwise), we walk you through how to investigate the provenance and ownership of websites: how can you identify the scope and scale of the network it belongs to — if any? Who’s behind the site, now and in the past? Who are the main actors promoting this website? Where else does this site crop up?<br>While it is not always possible to fully unmask the owner of a site, using a thorough checklist of tools and techniques that we have used in real-world investigations, we can help you make sure to reveal as much as possible about a website, and potentially uncover important clues.</p> | 2023-03-04 14:15:00 | 2023-03-04 15:15:00 | 0 | 1 | Broadway Ballroom 1&2, Meeting Space Level 1 4296408 | Tools & tech 579486 | 164 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Jon Keegan", "label": "The Markup", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476185", "target_object_id": 15476185, "target_content_type": "custom_list.customlistitem" }, { "title": "Pri Bengani", "label": "Tow Center for Digital Journalism at Columbia Journalism School", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476101", "target_object_id": 15476101, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625767&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625768 | 191394 | Come learn about the Data-Driven Reporting Project | <p>The Data-Driven Reporting Project was founded to support newsrooms who might otherwise lack the tools, training or capacity to do more technically-focused investigative reporting. These are often smaller newsrooms with fewer resources. In June 2022 the DDRP announced 22 newsrooms will receive a financial award and additional support in trainings, mentorship, and access to technology to develop local data and document-based investigative projects. Come to this session to hear critical lessons learned from three published projects. Attendees will be able to understand the impact of these projects and learn how can others can get motivated to work on document/data-powered investigations.</p> | 2023-03-02 10:15:00 | 2023-03-02 11:15:00 | 0 | 1 | Grand Ballroom 2, Lobby Level 4296419 | Tools & tech 579486 | 19 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Pam Dempsey", "label": "The Data-Driven Reporting Project", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476128", "target_object_id": 15476128, "target_content_type": "custom_list.customlistitem" }, { "title": "Stephannie Stokes", "label": "WABE", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476288", "target_object_id": 15476288, "target_content_type": "custom_list.customlistitem" }, { "title": "Emilie Munson", "label": "Albany Times Union", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476234", "target_object_id": 15476234, "target_content_type": "custom_list.customlistitem" }, { "title": "Karina Brown", "label": "Underscore", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476109", "target_object_id": 15476109, "target_content_type": "custom_list.customlistitem" }, { "title": "Inori Roy", "label": "The Local (Toronto)", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476267", "target_object_id": 15476267, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625768&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625779 | 191394 | Using DocumentCloud & DocumentCloud AddOns | <p>In five minutes, you can create an automated, 24/7 digital watchdog that alerts you if a government agency ever posts documents mentioning keywords you care about. With a little more time, you can create workflows that turn those documents into cleaned-up datasets piped right into your inbox or even self-updating visualizations that highlight key trends. Earlier this year, DocumentCloud launched Add-Ons, our new extension system that gives users access to a wide range of machine learning, data extractions, and automation, all within the familiar DocumentCloud interface. Learn how to tap into these new capabilities with a wide range of practical examples and useful tricks that everyone can take back to their beat, with no programming skills required.</p> | 2023-03-02 15:30:00 | 2023-03-02 16:30:00 | 0 | 1 | Grand Ballroom 3, Lobby Level 4296410 | Tools & tech 579486 | 51 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Sanjin Ibrahimovic", "label": "MuckRock", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476176", "target_object_id": 15476176, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625779&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625780 | 191394 | Sharing your rapid Python analysis with the newsroom using Google Sheets | <p>Want to have fast analysis ready for reporters right when an anticipated data set is released? Learn how to connect your python analysis to reporter-friendly Google Sheets. At The Texas Tribune, we created a pipeline that quickly cleans and analyses data to create Google Sheets for reporters to use in their breaking news stories the minute the data is released. I'll share tips and tricks on how you can adapt it for your newsroom. </p> <br> | 2023-03-04 14:15:00 | 2023-03-04 15:15:00 | 0 | 1 | SoBro, Meeting Space Level 1 4296414 | Tools & tech 579486 | 160 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Carla Astudillo", "label": "The Texas Tribune", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476098", "target_object_id": 15476098, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625780&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625783 | 191394 | Building your own AI editors | <p>We spend a lot of time trying to replace journalists with machines, but maybe it's time we let editors in on the fun, too?<br><br>In this session, we'll look at several examples of building custom AI-assisted tools that play the editor for style and content in news stories. This might be as simple as encouraging a more accessible reading level, as deep as analyzing gender balance in sourcing, or as complex as managing editorial "anti-patterns" when reporting on crime or other hot-button issues.</p> | 2023-03-05 10:15:00 | 2023-03-05 11:15:00 | 0 | 1 | Broadway Ballroom 1&2, Meeting Space Level 1 4296408 | Tools & tech 579486 | 192 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Jonathan Soma", "label": "Columbia University", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476284", "target_object_id": 15476284, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625783&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625784 | 191394 | Introducing moneyinpolitics.wtf, a new campaign-finance dictionary made by and for data journalists | <p><a href="https://moneyinpolitics.wtf/" target="_blank">moneyinpolitics.wtf</a> is an open-source website that aims to be America's most comprehensive glossary of political fundraising jargon. Come check it out and tell us how it could improve — and maybe even be useful one day. </p> <br> | 2023-03-04 15:30:00 | 2023-03-04 16:30:00 | 0 | 1 | SoBro, Meeting Space Level 1 4296414 | Tools & tech 579486 | 172 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Derek Willis", "label": "University of Maryland", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476323", "target_object_id": 15476323, "target_content_type": "custom_list.customlistitem" }, { "title": "Ben Welsh", "label": "Reuters", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476318", "target_object_id": 15476318, "target_content_type": "custom_list.customlistitem" }, { "title": "Agustin Armendariz", "label": "International Consortium of Investigative Journalists", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476097", "target_object_id": 15476097, "target_content_type": "custom_list.customlistitem" }, { "title": "Anu Narayanswamy", "label": "The Washington Post", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476238", "target_object_id": 15476238, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625784&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625786 | 191394 | The Serverless.js framework for Amazon Web Services | <p>Serverless.js makes it easy to deploy applications such as web scrapers and data APIs to Amazon Web Services without the need of a server. Attendees will need to bring their own laptop (no tablets) to participate in this class.</p> | 2023-03-02 16:45:00 | 2023-03-02 17:45:00 | 0 | 1 | SoBro, Meeting Space Level 1 4296414 | Tools & tech 579486 | 57 | [ { "categoryTitle": "Speakers", "links": [ { "title": "John Perry", "label": "The Atlanta Journal-Constitution", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476247", "target_object_id": 15476247, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625786&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625789 | 191394 | Let's talk data memos! | <p>It's an important and often underappreciated step in every data project. Let's talk about how we've tackled it in the past and share tips on how to make it both comprehensive AND understandable to reporters. Possible topics to discuss: Organization and formatting tips, how to best update data over time, any alternatives to Google Docs, etc. Bring examples if you have any to share and discuss what you've learned from the process.</p> | 2023-03-03 11:30:00 | 2023-03-03 12:30:00 | 0 | 1 | Grand Ballroom 2, Lobby Level 4296419 | Tools & tech 579486 | 95 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Carla Astudillo", "label": "The Texas Tribune", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476098", "target_object_id": 15476098, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625789&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625794 | 191394 | CANCELED: Introduction to Flourish | <p><strong>THIS SESSION HAS BEEN CANCELED</strong></p> <br> <p>Learn how to build customized visualizations without coding in this demonstration on Flourish: a free online tool. <br><br>This session is good for anyone familiar with spreadsheets. No dataviz experience is required. Attendees will need to bring their own laptop (no tablets) to participate in this class.</p> | 2023-03-05 11:30:00 | 2023-03-05 12:30:00 | 0 | 1 | SoBro, Meeting Space Level 1 4296414 | Tools & tech 579486 | 196 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Laura Moscoso", "label": "IRE & NICAR", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476231", "target_object_id": 15476231, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625794&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625803 | 191394 | Showcase: Big Local Data tools | <p>A lightning-round showcase by Big Local News of innovative newsroom tools that can help you collaborate on data projects, manage FOIAs, receive alerts about local government decisions and more.</p> | 2023-03-04 10:15:00 | 2023-03-04 11:15:00 | 0 | 1 | SoBro, Meeting Space Level 1 4296414 | Tools & tech 579486 | 144 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Serdar Tumgoren", "label": "Stanford University", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476302", "target_object_id": 15476302, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625803&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625807 | 191394 | OCCRP Aleph: Learn the data tool that enables large cross-border investigations | <p>Kickstart your investigations with OCCRP Aleph, the leak taming, company registry matching, huge dataset wrangling tool that enables the Organized Crime Corruption Reporting Project (OCCRP) to launch multiple cross-border projects a year. Come learn about how to conduct advanced searches, cross-reference data across multiple leaks, and create your own investigation workspace — including building network diagrams and timelines. Make use of the billions of records that OCCRP Aleph hosts for your next investigation.<br><br>This session is going to be a demo, there's a deep dive hands-on session directly following.</p> | 2023-03-04 09:00:00 | 2023-03-04 10:00:00 | 0 | 1 | SoBro, Meeting Space Level 1 4296414 | Tools & tech 579486 | 131 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Jan Strozyk", "label": "Organized Crime and Corruption Reporting Project", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476289", "target_object_id": 15476289, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625807&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625824 | 191394 | Mining social media, without depending on the sites' owners goodwill | <p>Social media is as important as ever to politics, from the local level to the international, but researchers fear that owners of social media sites have become more hostile to the press and will make it harder for us to access the tools we use to track politicians' activities and monitor disinformation.<br><br>Junkipedia is a project run by the non-profit Algorithmic Transparency Institute which helps journalists and civil society groups gather, track, search and monitor social media sites.<br><br>Junkipedia exists to gather data for journalists, even if platform tools go away. In a sense, you can replace the social media scrapers you don't have time to maintain with Junkipedia's.<br><br>Learn how you can (for free!) monitor politicians and online influencers relevant to your region or beat and gather data from previously opaque data sources like right-wing alt-tech social media sites and podcast transcripts.</p> | 2023-03-03 09:00:00 | 2023-03-03 10:00:00 | 0 | 1 | Broadway Ballroom 1&2, Meeting Space Level 1 4296408 | Tools & tech 579486 | 71 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Jeremy Merrill", "label": "The Washington Post", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476226", "target_object_id": 15476226, "target_content_type": "custom_list.customlistitem" }, { "title": "Andrea Fuller", "label": "The Wall Street Journal", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476149", "target_object_id": 15476149, "target_content_type": "custom_list.customlistitem" }, { "title": "Cam Hickey", "label": "NCOC", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476165", "target_object_id": 15476165, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625824&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625830 | 191394 | Reporting with Google Trends | <p>What is Google Trends data and how do you make sense of it? Learn how to use Trends data to understand what people are interested through searches. Discover new ways to leverage the tool for your writing and find story inspiration.</p> | 2023-03-03 10:15:00 | 2023-03-03 11:15:00 | 0 | 1 | Grand Ballroom 2, Lobby Level 4296419 | Tools & tech 579486 | 86 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Jenny Lee", "label": "Google", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476203", "target_object_id": 15476203, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625830&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625831 | 191394 | Sneak peek of Google's new PDF-busting reporting tool | <p>Have you ever received a 300-page PDF containing a large table, printed from a spreadsheet and then scanned? Have you ever had a large pile of similarly-structured scanned documents (for example, police incident reports) and wondered “I wish I could get all this data into a spreadsheet”? Well, a new feature of Google Journalist Studio’s Pinpoint helps you do just that. Learn what it’s good for, how to use it, and how to get access to its beta program.</p> | 2023-03-04 10:15:00 | 2023-03-04 11:15:00 | 0 | 1 | Grand Ballroom 2, Lobby Level 4296419 | Tools & tech 579486 | 145 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Shlomo Urbach", "label": "Google", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476304", "target_object_id": 15476304, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625831&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625836 | 191394 | Under pressure: Real life in real time with breaking news | <p>It’s become one of the hottest sessions at every IRE Conference. How would you and your newsroom fare in digging out little-known facts and information under the pressure of a breaking news deadline? One of the best ways to get better is to practice. <br><br>This is a real-life scenario where you can learn to break news without leaving your computer. The skills learned in this session can also be used for turning daily general assignment stories when there’s not breaking news. This session regularly fills up and the tipsheet that comes with it is in high demand. If you’re interested, get there early to get a seat. <br><br>No data experience is necessary for this class. Attendees will need to bring their own laptop (no tablets) to participate in this class.</p> | 2023-03-02 11:30:00 | 2023-03-02 12:30:00 | 0 | 1 | SoBro, Meeting Space Level 1 4296414 | Tools & tech 579486 | 33 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Stephen Stock", "label": "CBS News and Stations", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476287", "target_object_id": 15476287, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625836&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625840 | 191394 | Which data viz should I use and why? | <p>We'll explore ways to think about choosing charts to tell your data's story and some best practices about what works best. And, no, that doesn't mean everything is a bar chart. In fact, we'll bring examples of inspirational data visualizations we guarantee Datawrapper can't do.</p> <br> | 2023-03-04 14:15:00 | 2023-03-04 15:15:00 | 0 | 1 | Broadway Ballroom 3, Meeting Space Level 1 4296409 | Tools & tech 579486 | 163 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Erin Petenko", "label": "VT Digger", "image": "", "gb_url": "gb://guide/191394/poi/?id=15484924", "target_object_id": 15484924, "target_content_type": "custom_list.customlistitem" }, { "title": "Scott Klein", "label": "THE CITY", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476190", "target_object_id": 15476190, "target_content_type": "custom_list.customlistitem" }, { "title": "Emilia Ruzicka", "label": "Stacker", "image": "", "gb_url": "gb://guide/191394/poi/?id=15480290", "target_object_id": 15480290, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625840&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625842 | 191394 | Extracting data from PDFs | <p>Learn how to use tools for extracting text from documents. The seminar will discuss the fundamentals of knowing the best tool for the job, a walk-through using free applications, and an introduction to cracking tough cases using Optical Character Recognition (OCR). <br></p> <p>Attendees will need to bring their own laptop (no tablets) to participate in this class.</p> | 2023-03-03 15:30:00 | 2023-03-03 16:30:00 | 0 | 1 | 12 South 1&2, Meeting Space Level 1 4296411 | Tools & tech 579486 | 114 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Scott Pham", "label": "Independent journalist", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476248", "target_object_id": 15476248, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625842&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625707 | 191394 | Data of divides | <p>Doing data-driven inequality stories often means using statistical tools. <br><br>Attendees will need to bring their own laptop (no tablets) to participate in this class.<br><br>Basic familiarity with R is a plus,<br>Download and install R and the free open-source version of R Studio for your operating system. <br>We'll be focusing on some basic statistical tools in R.<br><br>Please make sure you have installed the following packages:<br><br>install.packages(""tidyverse"") #Working with data<br>install.packages(""knitr"") #make code files<br>install.packages(""psych"") #stats<br>install.packages(""tidycensus"") #it will change your life<br>install.packages(""lme4"") #for logistic regression<br>install.packages(""boot"") #for logistic regression<br>install.packages(""ggeffects"") #for logistic regression<br>install.packages(""DescTools"") #for logistic regression<br>install.packages(""varhandle"") #for creating dummy variables</p> | 2023-03-03 09:00:00 | 2023-03-03 10:00:00 | 0 | 1 | 5 Points 1&2, Meeting Space Level 1 4296417 | Equity & inclusion 579487 | 65 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Jennifer LaFleur", "label": "Center for Public Integrity", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476194", "target_object_id": 15476194, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625707&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625745 | 191394 | How to use investigative techniques to hold algorithms and artificial intelligence accountable | <p>Algorithms are everywhere, but for many journalists, it's hard to question the accuracy of the developer's data and PR. When journalists use investigative methods to test the tools themselves, in stories for the Guardian, MIT Technology Review and The Dallas Morning News, many AI products underperformed, or led to dangerous and discriminatory outcomes. In this panel, we will discuss what methods journalists can use to hold AI accountable - even those who work as freelance reporters.</p> | 2023-03-04 09:00:00 | 2023-03-04 10:00:00 | 0 | 1 | Grand Ballroom 3, Lobby Level 4296410 | Equity & inclusion 579487 | 129 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Arijit Sen", "label": "The Dallas Morning News", "image": "", "gb_url": "gb://guide/191394/poi/?id=15487172", "target_object_id": 15487172, "target_content_type": "custom_list.customlistitem" }, { "title": "Hilke Schellmann", "label": "New York University", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476274", "target_object_id": 15476274, "target_content_type": "custom_list.customlistitem" }, { "title": "Maddy Varner", "label": "The Markup", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476305", "target_object_id": 15476305, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625745&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625753 | 191394 | Investigative reporting for everyone WITH DATA: A quick-start guide | <p>Want to hit consistent home runs? Here’s how to punch way above your job title or shore up your existing reporting practice with tighter organization and careful data analysis. We’ll talk instant-impact, intro-level tips for new reporters and advanced-level tools for seasoned pros (hello, Gantt charts).</p> | 2023-03-02 11:30:00 | 2023-03-02 12:30:00 | 0 | 1 | Grand Ballroom 3, Lobby Level 4296410 | Equity & inclusion 579487 | 31 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Andrew Ford", "label": "Arizona Republic", "image": "", "gb_url": "gb://guide/191394/poi/?id=15487204", "target_object_id": 15487204, "target_content_type": "custom_list.customlistitem" }, { "title": "Simone Weichselbaum", "label": "NBC News", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476317", "target_object_id": 15476317, "target_content_type": "custom_list.customlistitem" }, { "title": "Jos\u00e9 Martinez", "label": "The Connecticut Mirror", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476217", "target_object_id": 15476217, "target_content_type": "custom_list.customlistitem" }, { "title": "Alexandra Chaidez", "label": "NBC News", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476116", "target_object_id": 15476116, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625753&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625760 | 191394 | Dataviz accessibility matters — here's what you can do to improve it | <p>News organizations have long struggled with publishing online for all audiences, whether that's captionless videos, cluttered websites, or inaccessible graphics. We will touch on the technical and cultural pitfalls newsrooms and the people in them face when publishing graphics and interactives online, and dive into what we all can do to improve the accessibility of our data visualizations.</p> | 2023-03-02 16:45:00 | 2023-03-02 17:45:00 | 0 | 1 | Broadway Ballroom 1&2, Meeting Space Level 1 4296408 | Equity & inclusion 579487 | 53 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Joe Murphy", "label": "NBC News", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476235", "target_object_id": 15476235, "target_content_type": "custom_list.customlistitem" }, { "title": "Frank Elavsky", "label": "Carnegie Mellon University", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476138", "target_object_id": 15476138, "target_content_type": "custom_list.customlistitem" }, { "title": "Jasmine Mithani", "label": "The 19th*", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476229", "target_object_id": 15476229, "target_content_type": "custom_list.customlistitem" }, { "title": "Thomas Wilburn", "label": "Chalkbeat", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476320", "target_object_id": 15476320, "target_content_type": "custom_list.customlistitem" }, { "title": "Patrick Garvin", "label": "Independent journalist", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476153", "target_object_id": 15476153, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625760&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625761 | 191394 | How to investigate pay inequities at your workplace | <p>Andrew Ba Tran and Steven Rich of the Washington Post will discuss how they investigated pay disparities at their newspaper, Sarah Blaskey of the Miami Herald will share some of the difficulties in using pay data for individual newsrooms, and Andrew Pantazi of The Tributary will discuss how a team of unionized journalists across Gannett gathered pay data from newsrooms across the country to hold their own company to account for its gender and racial pay inequities. Join this discussion to learn how to gather, clean and present the data, along with reported stories of how pay inequity holds back our newsrooms.</p> <br> | 2023-03-02 16:45:00 | 2023-03-02 17:45:00 | 0 | 1 | Broadway Ballroom 3, Meeting Space Level 1 4296409 | Equity & inclusion 579487 | 55 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Sarah Blaskey", "label": "Miami Herald", "image": "", "gb_url": "gb://guide/191394/poi/?id=15511227", "target_object_id": 15511227, "target_content_type": "custom_list.customlistitem" }, { "title": "Andrew Pantazi", "label": "The Tributary", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476244", "target_object_id": 15476244, "target_content_type": "custom_list.customlistitem" }, { "title": "Steven Rich", "label": "The Washington Post", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476262", "target_object_id": 15476262, "target_content_type": "custom_list.customlistitem" }, { "title": "Andrew Ba Tran", "label": "The Washington Post", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476301", "target_object_id": 15476301, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625761&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "guidebook_event" ( [id] INTEGER PRIMARY KEY, [guide_id] INTEGER, [import_id] TEXT, [name] TEXT, [description] TEXT, [image] TEXT, [startTime] TEXT, [endTime] TEXT, [allowRating] INTEGER, [addToSchedule] INTEGER, [deleted] TEXT, [last_updated] TEXT, [locations] INTEGER, [tracks] INTEGER, [rank] INTEGER, [links] TEXT, [allday] INTEGER, [max_capacity] INTEGER, [registered_attendees] INTEGER, [waitlist] INTEGER, [require_login] INTEGER, [registration_start_date] TEXT, [cog_details] TEXT, [session_discussion_posting_disabled] INTEGER, FOREIGN KEY([locations]) REFERENCES [guidebook_location]([id]), FOREIGN KEY([tracks]) REFERENCES [guidebook_schedule]([id]) );