guidebook_event
Data source: Schedule · About: simonw/nicar-2023
200 rows sorted by startTime
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28618884 | 191394 | Registration | <p>Conference registration will be located in Grand Ballroom 1, located on the lobby level. Name badges must be worn during the conference. </p> | 2023-03-01 16:30:00 | 2023-03-01 18:30:00 | 0 | 1 | Grand Ballroom 1, Lobby Level 4297633 | Registration 579998 | 0 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Data Dive: The 2022 Philip Meyer winners", "label": "3/3/2023 11:30 AM - 12:30 PM", "start_time": "2023-03-03T11:30:00.000000-0600", "end_time": "2023-03-03T12:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625675", "target_object_id": 28625675, "target_content_type": "schedule.session" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28618884&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28618885 | 191394 | Registration | <p>Conference registration will be located in Grand Ballroom 1, located on the lobby level. Name badges must be worn during the conference.</p> | 2023-03-02 07:30:00 | 2023-03-02 17:00:00 | 0 | 1 | Grand Ballroom 1, Lobby Level 4297633 | Registration 579998 | 2 | [ { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28618885&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28665750 | 191394 | International Meet & Greet (invite only) | <p>An opportunity for international attendees to network. A continental breakfast will be provided.</p> | 2023-03-02 07:30:00 | 2023-03-02 08:15:00 | 0 | 1 | Music City Ballroom, Hotel Level 2 4297635 | Special Events 580000 | 1 | [ { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28665750&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625695 | 191394 | Welcome first timers! How to make the most of NICAR23 | <p> Welcome to the conference! Hear from IRE staff about tips and tactics to navigate our conference like a pro. Also, you'll learn about key resources that IRE offers once you're back home. </p> | 2023-03-02 08:15:00 | 2023-03-02 08:45:00 | 0 | 1 | Broadway Ballroom 3, Meeting Space Level 1 4296409 | 3 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Lauren Grandestaff", "label": "IRE & NICAR", "image": "", "gb_url": "gb://guide/191394/poi/?id=15469495", "target_object_id": 15469495, "target_content_type": "custom_list.customlistitem" }, { "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" }, { "title": "Diana Fuentes", "label": "IRE & NICAR", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476148", "target_object_id": 15476148, "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=28625695&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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
28625771 | 191394 | Tips and techniques for handling mass records requests to local agencies | <p>Managing a FOIA request or local public record act request can be very different experiences. Local agencies may be less experienced in handling records or knowledgeable about the law. However, new tools can make it easier to make and manage requests to many places. This panel will share tools for making requests, negotiating with record managers and organizing files. We'll get into the nitty gritty of topics like NextRequest, transferring big files and arguing about definitions.</p> | 2023-03-02 09:00:00 | 2023-03-02 10:00:00 | 0 | 1 | Grand Ballroom 3, Lobby Level 4296410 | Public records 579491 | 10 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Tom Meagher", "label": "The Marshall Project", "image": "", "gb_url": "gb://guide/191394/poi/?id=15512738", "target_object_id": 15512738, "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" }, { "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=28625771&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625787 | 191394 | Teaching the teachers | <p>Some of the most highly regarded data journalism teachers will share their tips, tricks and other best practices for teaching hands-on classes at the conference, in your newsroom, other venues or even college classes. The group will discuss their secrets for things such as preparing for a session, what expectations to have about your students, how to handle difficult situations in the class, and what to think about when choosing data for the lesson. They will also offer advice for those of you who have never taught at the conference on how best to break into the teaching ranks.</p> | 2023-03-02 09:00:00 | 2023-03-02 10:00:00 | 0 | 1 | Broadway Ballroom 3, Meeting Space Level 1 4296409 | Educators 579488 | 9 | [ { "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" }, { "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" }, { "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": "Jasmine Ye Han", "label": "Industry Dive", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476159", "target_object_id": 15476159, "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=28625787&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625825 | 191394 | Accessing public records in Tennessee | <p>Join attorneys from the Reporters Committee for Freedom of the Press for a deep-dive into how to access public records in Tennessee that can inform your reporting. You’ll come away from this session with a better understanding of the state’s open records law, how to use the federal Freedom of Information Act to obtain state-specific information, strategies for navigating records denials, and practical tips you can apply when drafting your requests and engaging with records custodians.</p> <br> <p>This session was planned in collaboration with Reporters Committee for Freedom of the Press. IRE retains control of content, including the topic and speaker selection, for all conference sessions.</p> | 2023-03-02 09:00:00 | 2023-03-02 11:15:00 | 0 | 1 | SoBro, Meeting Space Level 1 4296414 | Public records 579491 | 11 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Paul McAdoo", "label": "Reporters Committee for Freedom of the Press", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476220", "target_object_id": 15476220, "target_content_type": "custom_list.customlistitem" }, { "title": "Adam Marshall", "label": "Reporters Committee for Freedom of the Press", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476216", "target_object_id": 15476216, "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=28625825&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625839 | 191394 | Journalism workflow hacks & tips | <p>Have you ever wondered how other reporters do their job? In this panel, we’ll do a show-and-tell of different tactics reporters use to streamline their days. No war stories, just the nitty-gritty of everyday reporting: filing information requests, talking to sources and researching. We'll also go into special occasions, like election coverage at a national scale.</p> | 2023-03-02 09:00:00 | 2023-03-02 10:00:00 | 0 | 1 | Grand Ballroom 2, Lobby Level 4296419 | 6 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Mike Stucka", "label": "independent journalist", "image": "", "gb_url": "gb://guide/191394/poi/?id=15509642", "target_object_id": 15509642, "target_content_type": "custom_list.customlistitem" }, { "title": "Amir Khafagy", "label": "Documented", "image": "", "gb_url": "gb://guide/191394/poi/?id=15496066", "target_object_id": 15496066, "target_content_type": "custom_list.customlistitem" }, { "title": "Natalie Lung", "label": "Bloomberg News", "image": "", "gb_url": "gb://guide/191394/poi/?id=15484922", "target_object_id": 15484922, "target_content_type": "custom_list.customlistitem" }, { "title": "Cecilia Reyes", "label": "Insider", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476260", "target_object_id": 15476260, "target_content_type": "custom_list.customlistitem" }, { "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=28625839&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | ||||||
28625846 | 191394 | The Marshall Project offers office hours | <p>The Marshall Project’s team may not always be hiring, but we’re excited to offer up a number of slots for resume/portfolio review, mock interviews, data reviews, etc. Sign up for a 25-minute conversation here: <u><a href="https://forms.gle/ikw3GadQ14QY1wCB8" target="_blank">https://forms.gle/ikw3GadQ14QY1wCB8</a></u>.</p> | 2023-03-02 09:00:00 | 2023-03-02 11:15:00 | 0 | 1 | Edgehill, Meeting Space Level 2 4296418 | 12 | [ { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625846&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | ||||||
28671351 | 191394 | Exhibitors & recruiters | <p>Stop by Grand Ballroom Foyer on the lobby level to see the exhibitors & recruiters participating in NICAR23. </p> | 2023-03-02 09:00:00 | 2023-03-02 18:00:00 | 0 | 1 | Grand Ballroom Foyer, Lobby Level 4297634 | 18 | [ { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28671351&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | ||||||
28673499 | 191394 | Quiet (NI)Car | <p>Need a quiet place to recharge, gather your thoughts, or just step away for a moment? Check out the Quiet (NI)Car room to relax and turn your brain off. Please try to refrain from talking or keep voices to a soft whisper.</p> | 2023-03-02 09:00:00 | 2023-03-02 17:45:00 | 0 | 1 | Germantown 3, Meeting Space Level 2 4301137 | 17 | [ { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28673499&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | ||||||
28673502 | 191394 | Pitch your ideas to MuckRock! | <p>Have a great investigative story idea that needs some outside help? Pitch your story to MuckRock! If selected, we'll work with you, to provide financial support, editing, data or FOIA help or some combination to get it published.<br><br>Simply fill out this form -- <a href="https://airtable.com/shroAnlsE5MvWX0Bc" target="_blank">https://airtable.com/shroAnlsE5MvWX0Bc</a> -- with your name, email, newsroom affiliation or freelance and a short, 500-word-max description of your idea. We'll reach out to journalists in March 2023 to talk about your ideas and will arrange Zoom meetings and in-person meet-ups at NICAR23 in Nashville.<br><br>Have a question? Email us at news@muckrock.com</p> | 2023-03-02 09:00:00 | 2023-03-02 17:45:00 | 0 | 1 | 16 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Derek Kravitz", "label": "Muckrock", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476192", "target_object_id": 15476192, "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=28673502&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 | |||||
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 | |||||
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 | |||||
28625749 | 191394 | Covering disparities in higher education with data | <p>The bad news: American higher education is rife with inequities along racial, socioeconomic and gender lines. The good news: there is an abundance of data reporters can use to explore these disparities. This panel will walk you through how to use large federally collected datasets and data from individual colleges to tell important stories about who benefits from higher ed. </p> <br> <p>This session is sponsored by the Lumina Foundation. IRE retains control of content, including the topic and speaker selection, for all conference sessions.</p> | 2023-03-02 10:15:00 | 2023-03-02 11:15:00 | 0 | 1 | Grand Ballroom 3, Lobby Level 4296410 | 579483|579487 | 20 | [ { "categoryTitle": "Sponsors", "links": [ { "title": "Lumina Foundation", "label": "Bronze Sponsor", "image": "", "gb_url": "gb://guide/191394/poi/?id=15267384", "target_object_id": 15267384, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Speakers", "links": [ { "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": "Sarah Butrymowicz", "label": "The Hechinger Report", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476111", "target_object_id": 15476111, "target_content_type": "custom_list.customlistitem" }, { "title": "Meredith Kolodner", "label": "The Hechinger Report", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476191", "target_object_id": 15476191, "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=28625749&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 | |||||
28625820 | 191394 | Encryption and journalism: From idea to publication | <p>Many factors come into play when considering the security of a story. The most notable is the security around conversations with sources. While this is important, this is not the only point in the process to consider the security of your interactions and information. In this training, we will overview the different types of encryption and how it comes into play when researching, writing, and communicating new stories. Attendees will walk away from this training understanding how to make informed decisions about the security of their tools and process from research to publication of a story. </p> <br> <p>The Cyber Security Track is sponsored by The Paranoids at Yahoo. IRE retains control of content, including the topic and speaker selection, for all conference sessions.</p> | 2023-03-02 10:15:00 | 2023-03-02 11:15:00 | 0 | 1 | Broadway Ballroom 3, Meeting Space Level 1 4296409 | Cyber security 579492 | 21 | [ { "categoryTitle": "Sponsors", "links": [ { "title": "The Paranoids at Yahoo", "label": "Silver Sponsor", "image": "", "gb_url": "gb://guide/191394/poi/?id=15329019", "target_object_id": 15329019, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Speakers", "links": [ { "title": "Kristen Larson", "label": "Yahoo", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476199", "target_object_id": 15476199, "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=28625820&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625835 | 191394 | Fireside chat with Meredith Broussard | <p>Join Meredith Broussard and Aron Pilhofer, two longtime NICARians, discuss Broussard's forthcoming book "<u><a href="https://mitpress.mit.edu/9780262047654/more-than-a-glitch/" target="_blank">More than a Glitch: Confronting Race, Gender, and Ability Bias in Tech</a></u>." <br><br>Broussard, a data scientist and one of the few Black female researchers in artificial intelligence, masterfully synthesizes concepts from computer science and sociology. In her book, she explores a range of examples: from facial recognition technology trained only to recognize lighter skin tones, to mortgage-approval algorithms that encourage discriminatory lending, to the dangerous feedback loops that arise when medical diagnostic algorithms are trained on insufficiently diverse data. Even when such technologies are designed with good intentions, Broussard shows, fallible humans develop programs that can result in devastating consequences.</p> | 2023-03-02 10:15:00 | 2023-03-02 11:15:00 | 0 | 1 | Broadway Ballroom 1&2, Meeting Space Level 1 4296408 | 23 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Meredith Broussard", "label": "New York University", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476107", "target_object_id": 15476107, "target_content_type": "custom_list.customlistitem" }, { "title": "Aron Pilhofer", "label": "The Tiny News Collective/Temple University", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476252", "target_object_id": 15476252, "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=28625835&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 | |||||
28625729 | 191394 | Data and digital tools for your newsroom and classroom | <p>Mike Reilley, founder of <a href="http://www.journaliststoolbox.org/">JournalistsToolbox.org</a> and co-author of "Data + Journalism" will guide you through the latest and greatest data and digital tools (most of them free!) that you can incorporate into your workflow right now! Come armed with a laptop and smartphone. Participants get a handout with links to tools, examples, tips, tricks and more.</p> | 2023-03-02 11:30:00 | 2023-03-02 12:30:00 | 0 | 1 | Grand Ballroom 2, Lobby Level 4296419 | Educators 579488 | 28 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Mike Reilly", "label": "University of Illinois Chicago", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476259", "target_object_id": 15476259, "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=28625729&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625734 | 191394 | Bringing data journalism to the sports section | <p>Sports is absolutely drowning in data and there is a large and hungry audience for sports content. Alongside that, there's a large and growing open-source sports analytics community that data journalists should be a part of. In this hands on class, speakers will take you through examples of ways to use traditonal data journalism tools like R and the Tidyverse to bring in up-to-the-moment sports data and do sophisticated analysis that you can immediately visualize to add context to seasons, leagues and sports.</p> | 2023-03-02 11:30:00 | 2023-03-02 12:30:00 | 0 | 1 | Midtown 3, Meeting Space Level 2 4296412 | 579484|579483 | 27 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Matt Waite", "label": "University of Nebraska-Lincoln", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476312", "target_object_id": 15476312, "target_content_type": "custom_list.customlistitem" }, { "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" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625734&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 | |||||
28625748 | 191394 | Defining and measuring the success of your published work | <p>How can you know if your work is reaching its intended audience, having an impact, or helping your company make money? Let's talk about the different types of analytics that newsrooms are using to quantify their investigative work.</p> | 2023-03-02 11:30:00 | 2023-03-02 12:30:00 | 0 | 1 | Edgehill, Meeting Space Level 2 4296418 | 29 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Julia Haslanger", "label": "The Philadelphia Inquirer", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476163", "target_object_id": 15476163, "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=28625748&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 | |||||
28625785 | 191394 | Use our data! | <p>On this panel, you’ll hear from three organizations that are publishing datasets you can use for investigative work, quick scoops, and community reporting. Come hear about NINA/CLIP, The Data Liberation Project, and The Accountability Project from NICAR-ians central to these efforts. You’ll learn what datasets they’ve made available, how to use them, and how to get involved.</p> | 2023-03-02 11:30:00 | 2023-03-02 12:30:00 | 0 | 1 | Broadway Ballroom 1&2, Meeting Space Level 1 4296408 | Collaboration 579489 | 34 | [ { "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" }, { "title": "Mago Torres", "label": "OpenNews", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476298", "target_object_id": 15476298, "target_content_type": "custom_list.customlistitem" }, { "title": "Aarushi Sahejpal", "label": "American University/Investigative Reporting Workshop", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476269", "target_object_id": 15476269, "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=28625785&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625823 | 191394 | A new data tool for identifying where people are losing their homes | <p>Millions of Americans are evicted each year, yet it's surprisingly difficult to know who is being evicted, where and why, because local data on evictions is either non-existent or difficult to analyze. By bringing together a repository of eviction data and a tool that allows you to analyze it, attendees of this session will be able to generate data-driven insights about housing insecurity in their communities.<br>New America’s Future of Land and Housing Program, DataKind and Eviction Lab will showcase the Foreclosure and Eviction Analysis Tool (<u><a href="https://www.newamerica.org/future-land-housing/eviction-and-foreclosure-data/about/the-foreclosure-and-eviction-analysis-tool-feat/" target="_blank">FEAT</a></u>)--an open-source data tool to help people understand where housing loss is most acute (at the census tract level), when during the year housing loss rises and falls, and who is most impacted (based on 65+ demographic variables). We will demonstrate how to use the tool using data from Eviction Lab's <u><a href="https://evictionlab.org/eviction-tracking/" target="_blank">Eviction Tracking System</a></u> (ETS), which provides regularly-updated eviction filing data for 7 states and 31 cities. <br><br>This class is good for: Intermediate/advanced users. The tool requires Python. 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 | 12 South 1&2, Meeting Space Level 1 4296411 | 579484|579487 | 26 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Sabiha Zainulbhai", "label": "New America", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476331", "target_object_id": 15476331, "target_content_type": "custom_list.customlistitem" }, { "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": "Caitlin Augustin", "label": "DataKind", "image": "", "gb_url": "gb://guide/191394/poi/?id=15496068", "target_object_id": 15496068, "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=28625823&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 | |||||
28618888 | 191394 | NICAR23 Sales (Thur) | <p>Stop by the IRE sales table located in Grand Ballroom 1, located on the lobby level to browse books and merchandise from the IRE store.</p> | 2023-03-02 13:00:00 | 2023-03-03 17:00:00 | 0 | 1 | Grand Ballroom 1, Lobby Level 4297633 | Sales 579999 | 35 | [ { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28618888&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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
28625811 | 191394 | Editing the data-driven investigation | <p>Managing a data project presents challenges for any editor. No matter your comfort level with data, this panel will give you the foundation you need to help make sure your reporters aren’t running with scissors or spinning their wheels on data projects.</p> | 2023-03-02 14:15:00 | 2023-03-02 15:15:00 | 0 | 1 | Broadway Ballroom 3, Meeting Space Level 1 4296409 | 38 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Dianna Hunt", "label": "ICT (formerly Indian Country Today)", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476172", "target_object_id": 15476172, "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" }, { "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=28625811&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | ||||||
28625819 | 191394 | Don’t play (stupid) troll games: OpSec for public events ... like NICAR | <p>How do we stay engaged with our sources, readers, colleagues and the industry when so many bad-faith groups are attempting to poison the well with false leads, subversive tactics, and outright trolling? We’ll discuss the types of actors in this space, how they operate, and how to keep your cool when someone is shoving a microphone in your face and peppering you with questions.<br><br>The Cyber Security Track is sponsored by The Paranoids at Yahoo. IRE retains control of content, including the topic and speaker selection, for all conference sessions.</p> | 2023-03-02 14:15:00 | 2023-03-02 15:15:00 | 0 | 1 | Grand Ballroom 2, Lobby Level 4296419 | Cyber security 579492 | 37 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Sara Rafsky", "label": "The New York Times", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476256", "target_object_id": 15476256, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Sponsors", "links": [ { "title": "The Paranoids at Yahoo", "label": "Silver Sponsor", "image": "", "gb_url": "gb://guide/191394/poi/?id=15329019", "target_object_id": 15329019, "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=28625819&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625833 | 191394 | Litigating FOIA denials | <p>FOIA backlogs and denials are common obstacles to reporting. Join this session to hear how panelists have litigated countless FOIA cases they'll discuss how to use litigation to break through the roadblocks.</p> | 2023-03-02 14:15:00 | 2023-03-02 15:15:00 | 0 | 1 | Broadway Ballroom 1&2, Meeting Space Level 1 4296408 | Public records 579491 | 40 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Jason Leopold", "label": "Bloomberg News", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476205", "target_object_id": 15476205, "target_content_type": "custom_list.customlistitem" }, { "title": "Matt Topic", "label": "Loevy & Loevy", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476297", "target_object_id": 15476297, "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=28625833&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625738 | 191394 | Successful project management for collaboration | <p>Collaboration is required to do ambitious work, but what does it really take to work well with others? What are the ideal ground rules for successful partnerships in and outside of your organization? Hear from leaders in nonprofit and international news organizations who have made partnerships work for them on projects big and small.</p> | 2023-03-02 15:30:00 | 2023-03-02 16:30:00 | 0 | 1 | Broadway Ballroom 1&2, Meeting Space Level 1 4296408 | Collaboration 579489 | 49 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Darla Cameron", "label": "The Texas Tribune", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476112", "target_object_id": 15476112, "target_content_type": "custom_list.customlistitem" }, { "title": "Mago Torres", "label": "OpenNews", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476298", "target_object_id": 15476298, "target_content_type": "custom_list.customlistitem" }, { "title": "Emilia D\u00edaz-Struck", "label": "The International Consortium of Investigative Journalists (ICIJ)", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476131", "target_object_id": 15476131, "target_content_type": "custom_list.customlistitem" }, { "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=28625738&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625769 | 191394 | When data assumes a male population | <p>It’s hard to make a good decision without good data. Yet there are so many instances where decisions are made without regard to how those choices will affect half the population, from body armor that gives military women stress fractures because it is designed for a male body, to medicines approved even though they have only been tested on men (regardless of whether the drug treats a disease that mostly affects women.) <br><br>Additionally, there are many ways surveys are designed and collected that often exclude women. For example, the Census and other surveys make assumptions about a person's daily commute. Women's commutes are often a lot more complicated because they don't have a to-work and from-work structure - women are statistically more likely to be the one who drops junior off at school and takes grandma to the doctor. <br><br>This panel will highlight articles that have shone a light on gendered data gaps. It will also provide tips on how to find gender and sex-aggregated numbers, practical advice on what to do with it, as well as potential strategies for determining gender/sex bias in the data, and determining who is missing.We’ll spend time looking at the way women are excluded in data, and ways to sniff that out. <br><br>How can we better report with data to account for these data collection errors? What are strategies we can use as journalists to account for women missing in data?</p> | 2023-03-02 15:30:00 | 2023-03-02 16:30:00 | 0 | 1 | Grand Ballroom 2, Lobby Level 4296419 | Equity & inclusion 579487 | 52 | [ { "categoryTitle": "Speakers", "links": [ { "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": "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" }, { "title": "Lucia Walinchus", "label": "The Ohio Center for Journalism, Eye On Ohio", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476313", "target_object_id": 15476313, "target_content_type": "custom_list.customlistitem" }, { "title": "Erin Mansfield", "label": "USA TODAY", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476214", "target_object_id": 15476214, "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=28625769&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 | |||||
28625781 | 191394 | Tools for teaching R | <p>If you're a professor or someone teaching a class in using R for journalism, there's two tools that make getting materials to students super easy: Quarto and LearnR. Quarto is a publishing system where you can write your own textbook and publish it (or, you know, fork ours and make it your own!). LearnR let's you create interactive code tutorials so students can learn in an interactive environment with live feedback. The great news: After some simple setup they're pretty easy to use, and with GitHub, you can host them for free. Attendees will need to bring their own laptop (no tablets) to participate in this class.</p> | 2023-03-02 15:30:00 | 2023-03-02 16:30:00 | 0 | 1 | SoBro, Meeting Space Level 1 4296414 | Educators 579488 | 50 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Matt Waite", "label": "University of Nebraska-Lincoln", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476312", "target_object_id": 15476312, "target_content_type": "custom_list.customlistitem" }, { "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" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625781&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 | |||||
28625818 | 191394 | Common digital attacks targeting journalists | <p>From the Pegasus spyware targeting individual journalists to ransomware attacks taking down publishing plants, many different kinds of tools and tactics are leveraged in attacks against news media. Preparing for such attacks can feel overwhelming and result in unsustainable or ineffective security practices. The purpose of this talk is to talk through common tactics used to target journalists, threat modeling exercises to understand what you should actually care about preparing for, and practical, sustainable security measures journalists can take to protect themselves.<br><br>The Cyber Security Track is sponsored by The Paranoids at Yahoo. IRE retains control of content, including the topic and speaker selection, for all conference sessions.</p> | 2023-03-02 15:30:00 | 2023-03-02 16:30:00 | 0 | 1 | Broadway Ballroom 3, Meeting Space Level 1 4296409 | Cyber security 579492 | 46 | [ { "categoryTitle": "Sponsors", "links": [ { "title": "The Paranoids at Yahoo", "label": "Silver Sponsor", "image": "", "gb_url": "gb://guide/191394/poi/?id=15329019", "target_object_id": 15329019, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Speakers", "links": [ { "title": "Neena Kapur", "label": "The New York Times", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476184", "target_object_id": 15476184, "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=28625818&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625827 | 191394 | Networking: LGBTQ+ journalists | <p>Mix and mingle, meet friends old and new, and build your professional community in this fun and informal networking session.<br><br>This session is for anyone who identifies as part of the LGBTQIA+ community or as an ally.</p> | 2023-03-02 15:30:00 | 2023-03-02 16:30:00 | 0 | 1 | Edgehill, Meeting Space Level 2 4296418 | Networking 579493 | 47 | [ { "categoryTitle": "Speakers", "links": [ { "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": "Adam Rhodes", "label": "IRE & NICAR", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476261", "target_object_id": 15476261, "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=28625827&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 | |||||
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 | |||||
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 | |||||
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 | |||||
28625795 | 191394 | Supercharge your coding workflow with Chat-GPT and GitHub Copilot | <p>Learn how to use the new batch of AI tools like GitHub Copilot and ChatGPT to supercharge your coding abilities! From eerily-smart autocomplete to explaining code you copied from StackOverflow, these tools provide an always-available buddy that's smart, infinitely patient, and (every now and again) terribly, terribly mistaken.<br><br>Whether you're tackling programming for the first time or are a seasoned pro, we'll look at ways to successfully wield these tools that are taking the world by storm. (...and how to clean up when they go astray)</p> | 2023-03-02 16:45:00 | 2023-03-02 17:45:00 | 0 | 1 | Edgehill, Meeting Space Level 2 4296418 | 56 | [ { "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=28625795&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | ||||||
28665751 | 191394 | First Timers Reception | <p>We invite all first time IRE attendees to a special reception where you can meet IRE board members and others prior to the welcome reception. We look forward to welcoming you to the conference! Light appetizers will be served. Each attendee will receive a ticket for beer, wine, soda or bottled water. Conference name tags are required for entry.</p> | 2023-03-02 17:45:00 | 2023-03-02 18:15:00 | 0 | 1 | Music City Ballroom, Hotel Level 2 4297635 | Special Events 580000 | 59 | [ { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28665751&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28665752 | 191394 | Welcome Reception | <p>Join us for our welcome reception on Thursday beginning at 6 p.m. Reconnect with longtime friends and welcome new attendees! Each attendee will receive one drink ticket for beer, wine, soda or bottled water. Light appetizers also will be served.</p> <p>Conference name tags are required for entry.</p> <br> <p>The reception is co-sponsored by The Atlanta Journal-Constitution and IRE.</p> | 2023-03-02 18:00:00 | 2023-03-02 19:15:00 | 0 | 1 | Grand Ballroom 3, Lobby Level 4296410 | Special Events 580000 | 60 | [ { "categoryTitle": "Sponsors", "links": [ { "title": "The Atlanta Journal-Constitution", "label": "Gold Sponsor", "image": "", "gb_url": "gb://guide/191394/poi/?id=15329017", "target_object_id": 15329017, "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=28665752&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28665806 | 191394 | Mentor program breakfast (invite only) | <p>If you signed up for the conference mentor program, come meet your match at this invitation-only breakfast.</p> <br> <p>The mentorship breakfast is sponsored by the Donald W.<strong> </strong>Reynolds Journalism Institute, University of Missouri.</p> | 2023-03-03 07:30:00 | 2023-03-03 08:45:00 | 0 | 1 | Music City Ballroom, Hotel Level 2 4297635 | Special Events 580000 | 61 | [ { "categoryTitle": "Sponsors", "links": [ { "title": "Donald W. Reynolds Journalism Institute, University of Missouri", "label": "Bronze Sponsor", "image": "", "gb_url": "gb://guide/191394/poi/?id=15249415", "target_object_id": 15249415, "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=28665806&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28618886 | 191394 | Registration | <p>Conference registration will be located in Grand Ballroom 1, located on the lobby level. Name badges must be worn during the conference.</p> | 2023-03-03 08:00:00 | 2023-03-03 17:00:00 | 0 | 1 | Grand Ballroom 1, Lobby Level 4297633 | Registration 579998 | 62 | [ { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28618886&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28618889 | 191394 | NICAR23 Sales (Fri) | <p>Stop by the IRE sales table located in Grand Ballroom 1, located on the lobby level to browse books and merchandise from the IRE store.</p> | 2023-03-03 08:00:00 | 2023-03-04 18:00:00 | 0 | 1 | Grand Ballroom 1, Lobby Level 4297633 | Sales 579999 | 63 | [ { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28618889&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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
28625813 | 191394 | Uncovering underground money networks | <p>In this panel, we'll explore techniques and tools to uncover complex money networks and relationships between people, companies, governments, and financial institutions. We'll use two real-world examples: a recent investigation by the Wall Street Journal that used bulk data collection and analysis in combination with AI tools to uncover a Russia-linked underground money network that intersected with the United States, and a sprawling effort by OCCRP to track down and catalog the vast wealth held outside Russia by sanctioned oligarchs and key figures close to Russian President Vladimir Putin.</p> <br> <p>We will delve into the process of data collection, management, and analysis, including the use of open-source tools, methods for collaboration, and interfaces for visualizing and analyzing the data. We’ll show how we tried (and sometimes failed) to prove ownership of yachts, luxury properties, and even racehorses across complex holding structures, how readers helped identify seaside vacation homes of Putin's associates, and which open-source data sources were the most useful.</p> <br> <p>We will also discuss the use of advanced techniques such as social network analysis, cyber forensic methods like tracing historical WHOIS records and IP addresses, and the role of AI and machine learning in helping extract meaning from vast troves of information. This panel will be particularly useful for those interested in replicating similar analysis on leaked documents and bulk corporate records, and for understanding the broader landscape of underground money networks.</p> <br> | 2023-03-03 09:00:00 | 2023-03-03 10:00:00 | 0 | 1 | Grand Ballroom 3, Lobby Level 4296410 | International 579490 | 72 | [ { "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" }, { "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" }, { "title": "Cindy Galli", "label": "ABC News", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476150", "target_object_id": 15476150, "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=28625813&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625822 | 191394 | Keeping secrets: Secure source communications | <p>Keeping your conversations with a source protected can oftentimes be overwhelming, especially with a lot of security lingo tossed in. In other cases, the advice isn’t practical because it doesn’t meet your source where they’re at. In this talk, we’ll discuss things to consider when it comes to securing your communications, what you can set up ahead of time and the benefits of different approaches.<br><br>The Cyber Security Track is sponsored by The Paranoids at Yahoo. IRE retains control of content, including the topic and speaker selection, for all conference sessions.</p> | 2023-03-03 09:00:00 | 2023-03-03 10:00:00 | 0 | 1 | Grand Ballroom 2, Lobby Level 4296419 | Cyber security 579492 | 69 | [ { "categoryTitle": "Sponsors", "links": [ { "title": "The Paranoids at Yahoo", "label": "Silver Sponsor", "image": "", "gb_url": "gb://guide/191394/poi/?id=15329019", "target_object_id": 15329019, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Speakers", "links": [ { "title": "Sarah Kate Thomas", "label": "The New York Times", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476294", "target_object_id": 15476294, "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=28625822&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 | |||||
28625848 | 191394 | Finding the story: Nursing homes data | <p>Nursing homes rightfully earned a lot of attention during the pandemic, but now, three years later, there's even more to investigate. Come to this session to learn about the data that's out there just waiting for us, and for inspiration for your own investigations into nursing homes and their operators in your communities. </p> <br> <p><strong>Attendees will need to bring their own laptop (no tablets) to participate in this class.</strong></p> | 2023-03-03 09:00:00 | 2023-03-03 10:00:00 | 0 | 1 | Midtown 2, Meeting Space Level 2 4296415 | 579482|579483 | 67 | [ { "categoryTitle": "Speakers", "links": [ { "title": "David Barer", "label": "KXAN", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476099", "target_object_id": 15476099, "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=28625848&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28671352 | 191394 | Exhibitors & recruiters | <p>Stop by Grand Ballroom Foyer on the lobby level to see the exhibitors & recruiters participating in NICAR23.</p> | 2023-03-03 09:00:00 | 2023-03-04 18:00:00 | 0 | 1 | Grand Ballroom Foyer, Lobby Level 4297634 | 77 | [ { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28671352&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | ||||||
28673185 | 191394 | Quiet (NI)Car | <p>Need a quiet place to recharge, gather your thoughts, or just step away for a moment? Check out the Quiet (NI)Car room to relax and turn your brain off. Please try to refrain from talking or keep voices to a soft whisper.</p> | 2023-03-03 09:00:00 | 2023-03-03 17:45:00 | 0 | 1 | Germantown 3, Meeting Space Level 2 4301137 | 76 | [ { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28673185&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | ||||||
28673504 | 191394 | Pitch your ideas to MuckRock! | <p>Have a great investigative story idea that needs some outside help? Pitch your story to MuckRock! If selected, we'll work with you, to provide financial support, editing, data or FOIA help or some combination to get it published. </p> <br> <p>Simply fill out this form -- <a href="https://airtable.com/shroAnlsE5MvWX0Bc">https://airtable.com/shroAnlsE5MvWX0Bc</a> -- with your name, email, newsroom affiliation or freelance and a short, 500-word-max description of your idea. We'll reach out to journalists in March 2023 to talk about your ideas and will arrange Zoom meetings and in-person meet-ups at NICAR23 in Nashville. Have a question? Email us at news@muckrock.com</p> | 2023-03-03 09:00:00 | 2023-03-03 17:45:00 | 0 | 1 | 75 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Derek Kravitz", "label": "Muckrock", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476192", "target_object_id": 15476192, "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=28673504&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 | |||||
28625701 | 191394 | Finding the story: Providing context to the equity and inclusion debate using education data | <p>Over the past two years, public education has been flooded by a national debate on "controversial" topics such as lessons and books about race and racism, accurate history lessons that highlight marginalized voices and most recently, LGBTQ people, gender and sexual identity. There's various different ways to keep track of these challenges to public education, whether they're happening at the state level or within districts. This is a session that'll demonstrate how to stay on top of covering this culture war within K-12 education.<br><br>This session is good for people with basic experience working with data. 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 | 12 South 1&2, Meeting Space Level 1 4296411 | 579482|579487 | 79 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Eesha Pendharkar", "label": "Education Week", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476245", "target_object_id": 15476245, "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=28625701&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 | |||||
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 | |||||
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 | |||||
28625764 | 191394 | How to retain the NICAR spirit year-round | <p>NICAR is one of the best ways to learn new tools and get motivated. But what about the other 362 days of the year? This session will give you tips, tricks and tools for staying connected to the data journalism community and keeping your skills sharp year-round. We’ll also talk about problem-solving strategies for the “lonely coders” out there.</p> | 2023-03-03 10:15:00 | 2023-03-03 11:15:00 | 0 | 1 | Edgehill, Meeting Space Level 2 4296418 | 82 | [ { "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=28625764&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | ||||||
28625775 | 191394 | Quick turn data stories: Using the quick turn to your advantage | <p>How to do quicker data stories that don’t suck or drain you of your will to do journalism. Participants will learn how to take a new dataset and break down their ideas into short-term, mid-term, and long-term projects</p> | 2023-03-03 10:15:00 | 2023-03-03 11:15:00 | 0 | 1 | Broadway Ballroom 3, Meeting Space Level 1 4296409 | 85 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Ryan Serpico", "label": "San Antonio Express-News", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476278", "target_object_id": 15476278, "target_content_type": "custom_list.customlistitem" }, { "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" } ] }, { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28625775&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | ||||||
28625782 | 191394 | How to propose an accessibility team or role in your newsroom: What they do and why they are needed | <p>A day in the life of an accessibility specialist may not be what you expect. And it can differ between companies. I'll go over some of the models out there and demo a bit of what I do as the first-ever Accessibility Engineer at The Washington Post. I'll outline how I pitched my job at The Post after starting an informal accessibility working group at the company. I'll also share insights on how you can advocate for similar roles in newsrooms of any size (they don't have to be engineering roles).<br><br>The goal is for you to learn:<br>- a variety of accessibility considerations, especially those less discussed in media today<br>- what an accessibility specialist actually does (my job at The Post is just one model)<br>- strategies on making a business case for accessibility roles in newsrooms<br><br>Not all newsrooms have the same resources. This session will take that into account. Accessibility can and should be the job of someone (or an entire team!) in your newsroom.</p> | 2023-03-03 10:15:00 | 2023-03-03 11:15:00 | 0 | 1 | Broadway Ballroom 1&2, Meeting Space Level 1 4296408 | Equity & inclusion 579487 | 81 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Holden Foreman", "label": "The Washington Post", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476146", "target_object_id": 15476146, "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=28625782&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 | |||||
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 | |||||
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 | |||||
28625679 | 191394 | Finding the story: Parole boards | <p>Criminal justice data can be really messy! But isn't it tempting to ask questions from it? We will work with parole data to answer a straightforward question: How do Nebraska Parole Board members vote or miss votes? Flatwater Free Press reporter Yanqi Xu will show you how to reshape datasets to make them ready for analysis, and how to use data as a guide to identify impacted “real people.”<br><br>This session would be good for people with basic experience with R.</p> | 2023-03-03 11:30:00 | 2023-03-03 12:30:00 | 0 | 1 | Midtown 3, Meeting Space Level 2 4296412 | 579484|579483 | 93 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Yanqi Xu", "label": "Flatwater Free Press", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476328", "target_object_id": 15476328, "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=28625679&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 | |||||
28625727 | 191394 | Finding the story: Inflation data | <p>This class for beginners will use basic concepts and data on inflation to show how data journalism lets us find and tell stories. Simple spreadsheet exercises will show how to calculate inflation rates for various periods, areas, people and types of goods and services. We'll use the results to find and sharpen potential stories.<br><br>This session is good for anyone.<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 11:30:00 | 2023-03-03 12:30:00 | 0 | 1 | Midtown 2, Meeting Space Level 2 4296415 | 92 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Paul Overberg", "label": "The Wall Street Journal", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476243", "target_object_id": 15476243, "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=28625727&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | ||||||
28625728 | 191394 | Analyze large datasets in Google Sheets via Google Cloud | <p>Connect large data sets to Google Sheets, which has UI patterns, querying tools and other affordances that more newsroom collaborators are comfortable with. <br><br>This session is good for: people comfortable with csv, cloud services, spreadsheets and some SQL familiarity. </p> <br> <p>Attendees will need to bring their own laptop (no tablets) to participate in this class.</p> | 2023-03-03 11:30:00 | 2023-03-03 12:30:00 | 0 | 1 | 5 Points 1&2, Meeting Space Level 1 4296417 | 89 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Jasmine Cui", "label": "NBC News", "image": "", "gb_url": "gb://guide/191394/poi/?id=15484918", "target_object_id": 15484918, "target_content_type": "custom_list.customlistitem" }, { "title": "Tiff Fehr", "label": "The New York Times", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476141", "target_object_id": 15476141, "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=28625728&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | ||||||
28625752 | 191394 | 30 places to find data to cover issues in your community | <p>A lightning-paced survey of datasets that can help reporters no matter what area of the country you cover. Come ready to take quick notes — we’ll have a timer going to make sure we hit as many datasets as possible! Some will be more well known, some you’ll never have heard of, and we’ll show examples of what you can do with them.</p> | 2023-03-03 11:30:00 | 2023-03-03 12:30:00 | 0 | 1 | Broadway Ballroom 1&2, Meeting Space Level 1 4296408 | Public records 579491 | 88 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Sean McMinn", "label": "POLITICO", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476224", "target_object_id": 15476224, "target_content_type": "custom_list.customlistitem" }, { "title": "Willoughby Mariano", "label": "Atlanta Journal-Constitution", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476215", "target_object_id": 15476215, "target_content_type": "custom_list.customlistitem" }, { "title": "Kevin Uhrmacher", "label": "The Washington Post", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476303", "target_object_id": 15476303, "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=28625752&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625766 | 191394 | How to produce Long COVID coverage informed by data, public records and patient experiences | <p>Long COVID is a public health crisis: Millions of Americans have been impacted by this debilitating condition, many of them facing lost work, hard-to-access medical care and other challenges. This session will introduce you to the basics of covering Long COVID from a data/investigative perspective, including recommendations for data sources, records requests and patient interviews. We’ll also spend time brainstorming Long COVID story ideas that are relevant to your coverage areas, whether you're a general-assignment local reporter or on a (non-science!) beat.</p> | 2023-03-03 11:30:00 | 2023-03-03 12:30:00 | 0 | 1 | 12 South 1&2, Meeting Space Level 1 4296411 | 94 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Betsy Ladyzhets", "label": "MuckRock", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476193", "target_object_id": 15476193, "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=28625766&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 | |||||
28625821 | 191394 | Reporting Tools: Security research for reporters | <p>Examples of stories made possible by radio spycraft and cybersecurity auditing tools. Flight tracking, finding iBeacon ad tracking, decompiling smartphone apps / analyzing network traffic from smartphone apps (to find things like healthcare/abortion apps sending info to Facebook or data brokers).<br><br>The Cyber Security Track is sponsored by The Paranoids at Yahoo. IRE retains control of content, including the topic and speaker selection, for all conference sessions.</p> | 2023-03-03 11:30:00 | 2023-03-03 12:30:00 | 0 | 1 | Grand Ballroom 3, Lobby Level 4296410 | Cyber security 579492 | 97 | [ { "categoryTitle": "Sponsors", "links": [ { "title": "The Paranoids at Yahoo", "label": "Silver Sponsor", "image": "", "gb_url": "gb://guide/191394/poi/?id=15329019", "target_object_id": 15329019, "target_content_type": "custom_list.customlistitem" } ] }, { "categoryTitle": "Speakers", "links": [ { "title": "Mike Tigas", "label": "ProPublica", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476296", "target_object_id": 15476296, "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=28625821&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28625828 | 191394 | Networking: Journalists of color | <p>Mix and mingle, meet friends old and new, and build your professional community in this fun and informal networking session. <br> <br> This session is for journalists of color.</p> | 2023-03-03 11:30:00 | 2023-03-03 12:30:00 | 0 | 1 | Edgehill, Meeting Space Level 2 4296418 | Networking 579493 | 96 | [ { "categoryTitle": "Speakers", "links": [ { "title": "Lucio Villa", "label": "The Washington Post", "image": "", "gb_url": "gb://guide/191394/poi/?id=15487173", "target_object_id": 15487173, "target_content_type": "custom_list.customlistitem" }, { "title": "Lam Thuy Vo", "label": "Independent journalist", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476309", "target_object_id": 15476309, "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=28625828&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28665753 | 191394 | Media Lawyer Q&A | <p>Does your investigation contain complex legal questions? Unsure of how to proceed? Bring your lunch and your questions for a personal discussion with some prominent media law experts. We'll provide drinks and dessert.</p> | 2023-03-03 12:45:00 | 2023-03-03 13:45:00 | 0 | 1 | SoBro, Meeting Space Level 1 4296414 | Special Events 580000 | 98 | [ { "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" }, { "title": "Katie Townsend", "label": "Reporters Committee for Freedom of the Press", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476300", "target_object_id": 15476300, "target_content_type": "custom_list.customlistitem" }, { "title": "Matt Topic", "label": "Loevy & Loevy", "image": "", "gb_url": "gb://guide/191394/poi/?id=15476297", "target_object_id": 15476297, "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=28665753&content_type=schedule.session", "target_content_type": "survey.survey" } ] } ] |
0 | -1 | -1 | 0 | 0 | [] |
0 | |||||
28665754 | 191394 | IRE Board of Directors Meeting | <p>The IRE Board of Directors will meet at the 2023 NICAR conference. All current IRE members are invited to attend in-person or virtually (<a href="https://www.ire.org/event/2023-march-3-ire-board-of-directors-meeting/" target="_blank">register here for Zoom link</a>).</p> <br> <p>The agenda can be found <a href="https://bit.ly/3I6caCF" target="_blank">here</a>.</p> | 2023-03-03 13:00:00 | 2023-03-03 16:00:00 | 0 | 1 | Germantown 1, Meeting Space Level 2 4297640 | Special Events 580000 | 99 | [ { "categoryTitle": "Forms", "links": [ { "title": "NICAR23 Session Evaluation", "label": "Please complete this session evaluation", "image": "", "gb_url": "gb://guide/191394/survey/?id=20962&object_id=28665754&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]) );