guidebook_poi
Data source: Schedule · About: simonw/nicar-2023
281 rows sorted by id descending
This data as json, copyable, CSV (advanced)
Suggested facets: image, allowRating, locations, categories, thumbnail, contact_email
id ▲ | guide_id | import_id | name | description | image | label | allowRating | addToDo | deleted | last_updated | rank | locations | categories | links | subimage | link_image | thumbnail | cog_details | contact_email | meeting_url |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15532030 | 191394 | NICAR 2023 tipsheets | <p><a href="https://www.ire.org/training/conferences/nicar-2023/nicar-2023-tipsheets/" target="_blank">https://www.ire.org/training/conferences/nicar-2023/nicar-2023-tipsheets/</a></p> | 1 | 0 | 280 | Tipsheets & Resources 1049246 | [] |
[] |
|||||||||||
15512738 | 191394 | Tom Meagher | The Marshall Project | 0 | 0 | 265 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Tips and techniques for handling mass records requests to local agencies", "label": "3/2/2023 9:00 AM - 10:00 AM", "start_time": "2023-03-02T09:00:00.000000-0600", "end_time": "2023-03-02T10:00:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625771", "target_object_id": 28625771, "target_content_type": "schedule.session" } ] } ] |
[] |
|||||||||||
15512734 | 191394 | Brian Rosenthal | The New York Times | 0 | 0 | 60 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Navigating the federal FOIA long game", "label": "3/4/2023 11:30 AM - 12:30 PM", "start_time": "2023-03-04T11:30:00.000000-0600", "end_time": "2023-03-04T12:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625816", "target_object_id": 28625816, "target_content_type": "schedule.session" } ] } ] |
[] |
|||||||||||
15512724 | 191394 | Aaron Mendelson | Center for Public Integrity | 0 | 0 | 21 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Gearing up for the 2024 election", "label": "3/4/2023 4:45 PM - 5:45 PM", "start_time": "2023-03-04T16:45:00.000000-0600", "end_time": "2023-03-04T17:45:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625772", "target_object_id": 28625772, "target_content_type": "schedule.session" } ] } ] |
[] |
|||||||||||
15512347 | 191394 | Meghan Hoyer | The Washington Post | 0 | 0 | 195 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Census 2020: Get ready for Round 2", "label": "3/4/2023 3:30 PM - 4:30 PM", "start_time": "2023-03-04T15:30:00.000000-0600", "end_time": "2023-03-04T16:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625743", "target_object_id": 28625743, "target_content_type": "schedule.session" } ] } ] |
[] |
meghan.hoyer@washpost.com | ||||||||||
15511228 | 191394 | Yue Stella Yu | Bridge Michigan | 0 | 0 | 276 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Tools for statehouse reporting", "label": "3/4/2023 3:30 PM - 4:30 PM", "start_time": "2023-03-04T15:30:00.000000-0600", "end_time": "2023-03-04T16:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625776", "target_object_id": 28625776, "target_content_type": "schedule.session" } ] } ] |
[] |
|||||||||||
15511227 | 191394 | Sarah Blaskey | Miami Herald | 0 | 0 | 236 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "How to investigate pay inequities at your workplace", "label": "3/2/2023 4:45 PM - 5:45 PM", "start_time": "2023-03-02T16:45:00.000000-0600", "end_time": "2023-03-02T17:45:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625761", "target_object_id": 28625761, "target_content_type": "schedule.session" } ] } ] |
[] |
|||||||||||
15509642 | 191394 | Mike Stucka | <p>Mike Stucka (he/him) set a personal record of more than 1 million words in a month sent to editors, because computers let you do repetitive stuff quickly. He has worked for a few hundred newspapers, built interdependent data pipelines to the XKCD 2054 standard, and failed to become the person his dog thinks he is. He is now Florida Man.</p> | independent journalist | 0 | 0 | 201 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Journalism workflow hacks & tips", "label": "3/2/2023 9:00 AM - 10:00 AM", "start_time": "2023-03-02T09:00:00.000000-0600", "end_time": "2023-03-02T10:00:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625839", "target_object_id": 28625839, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15496153 | 191394 | AmyJo Brown | <p>AmyJo Brown’s work centers on the specific organizational challenges of doing good journalism at the local level. As an independent editor and founder of War Streets Media, she consults with news leaders on sustainability issues and editorial strategies, and helps stand up new initiatives and develop talent.</p> <p>Recent clients have included the American Press Institute, Spotlight PA, and the Texas Tribune, with project work related to<u><a href="https://www.americanpressinstitute.org/publications/api-updates/api-launches-journalism-inclusion-index/" target="_blank"> diversity and inclusion efforts</a></u>, designing and facilitating<u><a href="https://www.spotlightpa.org/news/2022/02/spotlight-pa-state-college-bureau-ajp-lenfest/" target="_blank"> stakeholder listening sessions</a></u>, and helping to manage<u><a href="https://apps.texastribune.org/features/2022/texas-2022-election-results/" target="_blank"> elections-related coverage</a></u>. Other recent notable work includes developing and launching the<u><a href="https://static1.squarespace.com/static/627c29c0bcb7f5543e9f8ed1/t/627d35687db3d00c1c66b432/1652372841540/072621_2020_PMP_report.pdf" target="_blank"> Pittsburgh Media Partnership</a></u>, a grant-funded collaborative of about two dozen local news organizations, and leading it through its first two years as its members grappled with the business challenges of the COVID-19 pandemic.</p> <p>A veteran journalist with a background in local government and investigative reporting, her focus on improving processes and changing systems is rooted in the experience she gained in the first half of her career working as a reporter and editor at local news publications of all sizes in widely different settings. Her work was then more fully informed by lessons learned designing and leading editorial and revenue strategies, in various capacities within those local newsrooms.</p> <p>AmyJo is currently a 2022-2023 Knight Lab Professional Fellow at Northwestern University’s Medill School. She has been a member of… | War Streets Media | 0 | 0 | 38 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "What's next? Career advice for those looking for the next move", "label": "3/5/2023 11:30 AM - 12:30 PM", "start_time": "2023-03-05T11:30:00.000000-0600", "end_time": "2023-03-05T12:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625838", "target_object_id": 28625838, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15496152 | 191394 | Tony Gonzalez | <p>Tony Gonzalez oversees investigations and special projects at WPLN News and produces the Curious Nashville podcast. He’s worked in print, radio, and podcasting and has long been a mentor to collegiate and early-career journalists. He strives to tell memorably weird stories.</p> | Nashville Public Radio | 0 | 0 | 266 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "What's next? Career advice for those looking for the next move", "label": "3/5/2023 11:30 AM - 12:30 PM", "start_time": "2023-03-05T11:30:00.000000-0600", "end_time": "2023-03-05T12:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625838", "target_object_id": 28625838, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15496146 | 191394 | Michael Biesecker | <p>Michael Biesecker is a global investigative reporter for The Associated Press, based in Washington, D.C. He reports on a wide range of topics, including human conflict, climate change, political corruption and deaths in government custody. Over the years, Biesecker’s investigations have led directly to legal reforms and criminal convictions. He also teaches graduate courses in investigative journalism and climate reporting at Georgetown University.</p> | Associated Press | 0 | 0 | 198 | Speakers 1045976 | [ { "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" } ] } ] |
[] |
||||||||||
15496069 | 191394 | Linly Lin | <p>Linly Lin is a data journalist with Bloomberg News, now based in San Francisco. She enjoys being creative and leveraging technology to achieve journalistic goals.</p> | Bloomberg News | 0 | 0 | 177 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Networking: Women journalists", "label": "3/4/2023 4:45 PM - 5:45 PM", "start_time": "2023-03-04T16:45:00.000000-0600", "end_time": "2023-03-04T17:45:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625829", "target_object_id": 28625829, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15496068 | 191394 | Caitlin Augustin | <p>Caitlin Augustin is DataKind's Vice President, Product and Programs. In this role, Caitlin is responsible for delivering DataKind's core offerings, ensuring that high quality, impactful data science interventions are created in partnership with social sector leaders. Prior to DataKind, Caitlin worked as a research scientist at a digital education company and as an engineering professor at NYU. Caitlin holds a BSIE and a PhD from the University of Miami.</p> | DataKind | 0 | 0 | 61 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "A new data tool for identifying where people are losing their homes", "label": "3/2/2023 11:30 AM - 12:30 PM", "start_time": "2023-03-02T11:30:00.000000-0600", "end_time": "2023-03-02T12:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625823", "target_object_id": 28625823, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15496066 | 191394 | Amir Khafagy | <p>Amir Khafagy is an award-winning New York City-based journalist. He is currently a labor reporter with Documented as a Report for America corps member as well as a Type Investigations Ida B. Wells Fellow.</p> | Documented | 0 | 0 | 35 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Journalism workflow hacks & tips", "label": "3/2/2023 9:00 AM - 10:00 AM", "start_time": "2023-03-02T09:00:00.000000-0600", "end_time": "2023-03-02T10:00:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625839", "target_object_id": 28625839, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15488848 | 191394 | Rosie Cima | Scripps Washington Bureau | 0 | 0 | 227 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "How to make your data story pop on TV", "label": "3/4/2023 10:15 AM - 11:15 AM", "start_time": "2023-03-04T10:15:00.000000-0600", "end_time": "2023-03-04T11:15:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625802", "target_object_id": 28625802, "target_content_type": "schedule.session" } ] } ] |
[] |
|||||||||||
15487204 | 191394 | Andrew Ford | <p>Andrew Ford is an investigative reporter for the Arizona Republic. He recently published a narrative investigation on a chain of clinics that was quoted by the U.S. Department of Justice in a complaint against the company. Learn more at www.AndrewFordNews.com, @AndrewFordNews. Ford is happy to take questions and partner on stories: aford@arizonarepublic.com.</p> | Arizona Republic | 0 | 0 | 43 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Investigative reporting for everyone WITH DATA: A quick-start guide", "label": "3/2/2023 11:30 AM - 12:30 PM", "start_time": "2023-03-02T11:30:00.000000-0600", "end_time": "2023-03-02T12:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625753", "target_object_id": 28625753, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15487179 | 191394 | Julie Christie | <p>Julie is the Director of Data and Special Projects at Resolve Philly where she focuses on local government accountability, foster care, and supporting more than 29 Philly newsrooms with their data journalism. She’s passionate about pasta, solutions journalism, early career development, and data ethics.</p> | Resolve Philly | 0 | 0 | 153 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Google Sheets 2: Formulas & sorting (repeat)", "label": "3/5/2023 10:15 AM - 11:15 AM", "start_time": "2023-03-05T10:15:00.000000-0600", "end_time": "2023-03-05T11:15:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625843", "target_object_id": 28625843, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15487175 | 191394 | Suhail Bhat | <p>Suhail is THE CITY’s data reporter, responsible for bringing numbers to life. Previously, he was a data and graphics reporter at Louisville Public Media, where he covered the Ohio Valley and received the “Best Use of Data” award for his COVID-19 coverage from the Society of Professional Journalists, Louisville. Suhail is an engineer turned journalist, a graduate of Columbia Journalism School, and a former Reuters News correspondent.</p> | THE CITY | 0 | 0 | 258 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Behind the story: Using data to report on (and for) your communities", "label": "3/5/2023 9:00 AM - 10:00 AM", "start_time": "2023-03-05T09:00:00.000000-0600", "end_time": "2023-03-05T10:00:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625677", "target_object_id": 28625677, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15487174 | 191394 | David Herzog | <p>David Herzog is a veteran investigative reporter, data journalist, and educator. He's a professor at the Missouri School of Journalism, where he serves as the director of data services and research for IRE.</p> | University of Missouri/IRE | 0 | 0 | 80 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Digging into data for stories: A crash course in spreadsheets - pre-registered attendees only", "label": "3/4/2023 9:00 AM - 5:45 PM", "start_time": "2023-03-04T09:00:00.000000-0600", "end_time": "2023-03-04T17:45:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625678", "target_object_id": 28625678, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15487173 | 191394 | Lucio Villa | The Washington Post | 0 | 0 | 181 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Networking: Journalists of color", "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=28625828", "target_object_id": 28625828, "target_content_type": "schedule.session" } ] } ] |
[] |
|||||||||||
15487172 | 191394 | Arijit Sen | <p>Arijit (Ari) Sen, is a computational journalist on the investigative team at The Dallas Morning News. He uses the tools of data science to investigate technology and the criminal justice system. Sen has a master's degree in journalism and a certificate in applied data science from UC Berkeley and a Bachelor's in journalism from UNC Chapel Hill.</p> | The Dallas Morning News | 0 | 0 | 51 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "How to use investigative techniques to hold algorithms and artificial intelligence accountable", "label": "3/4/2023 9:00 AM - 10:00 AM", "start_time": "2023-03-04T09:00:00.000000-0600", "end_time": "2023-03-04T10:00:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625745", "target_object_id": 28625745, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15486762 | 191394 | Donate a book to support literacy for Nashville kids | <p>IRE is proud to partner with local charity Book'em to help share the joy and value of reading with low-income youth in the Nashville area.</p> <br> <p>Learn more at <a href="bookem-kids.org/give-books" target="_blank">bookem-kids.org/give-books</a></p> <br> <p>Donate books online by clicking <a href="https://www.amazon.com/hz/wishlist/ls/1CCZN1XCLBVUA?ref_=wl_share" target="_blank">here</a>.</p> | 0 | 0 | 279 | Donate a Book 1046848 | [] |
img-E4RjQ57ayj3hlvvluVQJZ9qyX6YZHR7hzLJX.jpeg.jpg | [] |
||||||||||
15484924 | 191394 | Erin Petenko | <p>Erin is the data and graphics reporter for VTDigger, bringing Vermont’s stories to life with data. She's also worked as a data reporter for NJ.com.</p> | VT Digger | 0 | 0 | 99 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Which data viz should I use and why?", "label": "3/4/2023 2:15 PM - 3:15 PM", "start_time": "2023-03-04T14:15:00.000000-0600", "end_time": "2023-03-04T15:15:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625840", "target_object_id": 28625840, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15484923 | 191394 | A.J. Lagoe | <p>A.J. Lagoe is an investigative reporter for KARE-TV in Minneapolis. His data-driven reporting routinely leads to criminal convictions and legislative hearings and has prompted numerous new federal and state laws. A.J. is a 2x IRE Award winner and has received many of journalism’s other highest honors including the George Polk, Peabody, National Murrow, and four Alfred I. duPont-Columbia University awards.</p> | KARE-TV | 0 | 0 | 28 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Behind the story: Using data to report on (and for) your communities", "label": "3/5/2023 9:00 AM - 10:00 AM", "start_time": "2023-03-05T09:00:00.000000-0600", "end_time": "2023-03-05T10:00:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625677", "target_object_id": 28625677, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15484922 | 191394 | Natalie Lung | Bloomberg News | 0 | 0 | 204 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Journalism workflow hacks & tips", "label": "3/2/2023 9:00 AM - 10:00 AM", "start_time": "2023-03-02T09:00:00.000000-0600", "end_time": "2023-03-02T10:00:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625839", "target_object_id": 28625839, "target_content_type": "schedule.session" } ] } ] |
[] |
|||||||||||
15484918 | 191394 | Jasmine Cui | <p>Jasmine is a data journalist with NBC News. She reports out of Atlanta.</p> | NBC News | 0 | 0 | 127 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Analyze large datasets in Google Sheets via Google Cloud", "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=28625728", "target_object_id": 28625728, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15480290 | 191394 | Emilia Ruzicka | <p>Emilia Ruzicka is a data journalist and designer. They currently live in Washington, D.C. and work for Stacker. Throughout their career, Emilia has worked for print news, radio stations, and digital media organizations to produce both written and multimedia stories with a focus on data-driven narratives. To learn more, please visit emiliaruzicka.com.</p> | Stacker | 0 | 0 | 93 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Which data viz should I use and why?", "label": "3/4/2023 2:15 PM - 3:15 PM", "start_time": "2023-03-04T14:15:00.000000-0600", "end_time": "2023-03-04T15:15:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625840", "target_object_id": 28625840, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15480286 | 191394 | Francisco Vara-Orta | <p>Francisco Vara-Orta brings 17 years of newsroom experience to his role as IRE's first director of diversity and inclusion. Vara-Orta joined the IRE staff in February 2019 as a training director. While working as a trainer, he has conducted sessions on managing data and investigative reporting for journalists across the United States and internationally. He has worked for a variety of online and print publications, including Chalkbeat, Education Week, the San Antonio Express-News, Austin Business Journal, Los Angeles Business Journal and the Los Angeles Times. He earned a master’s degree in investigative/data journalism at the University of Missouri and a bachelor’s degree from St. Mary’s University in San Antonio.</p> | IRE & NICAR | 0 | 0 | 104 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Quick-hit investigations", "label": "3/5/2023 11:30 AM - 12:30 PM", "start_time": "2023-03-05T11:30:00.000000-0600", "end_time": "2023-03-05T12:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625841", "target_object_id": 28625841, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476336 | 191394 | Justin Hicks | Louisville Public Media | 0 | 0 | 155 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Telling data stories in audio", "label": "3/4/2023 11:30 AM - 12:30 PM", "start_time": "2023-03-04T11:30:00.000000-0600", "end_time": "2023-03-04T12:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625742", "target_object_id": 28625742, "target_content_type": "schedule.session" } ] } ] |
[] |
|||||||||||
15476335 | 191394 | Natasha Senjanovic | <p> Natasha Senjanovic is an award-winning journalist covering vulnerable populations from a data- and trauma-informed perspective. She spent 15 years in Italy and since returning to the US has served as a host/reporter for Nashville Public Radio (2016-19), produced a Pulitzer Center-backed project (2021) and was a temporary editor with MPR News (2021-22). Her work has appeared on NPR, WPLN, APM, and MPR. She speaks four languages and her awards include a Regional Murrow. </p> | Independent journalist | 0 | 0 | 205 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Behind the story: Using data to report on (and for) your communities", "label": "3/5/2023 9:00 AM - 10:00 AM", "start_time": "2023-03-05T09:00:00.000000-0600", "end_time": "2023-03-05T10:00:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625677", "target_object_id": 28625677, "target_content_type": "schedule.session" }, { "title": "Telling data stories in audio", "label": "3/4/2023 11:30 AM - 12:30 PM", "start_time": "2023-03-04T11:30:00.000000-0600", "end_time": "2023-03-04T12:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625742", "target_object_id": 28625742, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476334 | 191394 | Nicole Vap | CBS News | 0 | 0 | 210 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Early career roundtable", "label": "3/5/2023 9:00 AM - 10:00 AM", "start_time": "2023-03-05T09:00:00.000000-0600", "end_time": "2023-03-05T10:00:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625674", "target_object_id": 28625674, "target_content_type": "schedule.session" } ] } ] |
[] |
|||||||||||
15476333 | 191394 | Geoff Ziezulewicz | <p> Geoff has published FOIA-fueled investigations into the military services, and the Navy in particular, for the past five or so years with the Military Times, and he has written extensively about the military justice system. Before that, he cut his watchdog teeth at the Chicago Tribune and spent several years overseas earlier in his career covering the Arab Spring and the wars in Iraq and Afghanistan. Geoff's guiding journalistic light is to comfort the afflicted and afflict the comfortable. </p> | Military Times | 0 | 0 | 110 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Reporting on a military base near you using courts-martial records", "label": "3/3/2023 3:30 PM - 4:30 PM", "start_time": "2023-03-03T15:30:00.000000-0600", "end_time": "2023-03-03T16:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625763", "target_object_id": 28625763, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476332 | 191394 | Emily Zentner | <p>Emily Zentner is the investigative data reporter for the California Newsroom focusing on climate change. She previously worked as a data reporter at Capital Public Radio in Sacramento, where she reported on wildfires, police handling of sexual assault cases, the COVID-19 pandemic and more.</p> | California Newsroom | 0 | 0 | 96 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Beyond the fire perimeter \u2014 data for wildfire investigations", "label": "3/3/2023 9:00 AM - 10:00 AM", "start_time": "2023-03-03T09:00:00.000000-0600", "end_time": "2023-03-03T10:00:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625740", "target_object_id": 28625740, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476331 | 191394 | Sabiha Zainulbhai | <p> Sabiha Zainulbhai joined New America's Future of Land and Housing program as a senior policy analyst in January 2021. Zainulbhai's work focuses on ensuring that housing and land use policy in the U.S. advances racial and economic justice. Zainulbhai holds a master of public policy degree from the Gerald R. Ford School at the University of Michigan and a BA from the George Washington University. </p> | New America | 0 | 0 | 230 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "A new data tool for identifying where people are losing their homes", "label": "3/2/2023 11:30 AM - 12:30 PM", "start_time": "2023-03-02T11:30:00.000000-0600", "end_time": "2023-03-02T12:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625823", "target_object_id": 28625823, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476330 | 191394 | Aida Ylanan | <p> Aida is a journalist at the Los Angeles Times. She works on the data and graphics desk, specializing in data analysis and visualization. A SoCal native, she graduated from UCLA, where she studied statistics and English. </p> | Los Angeles Times | 0 | 0 | 27 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "First Visual Story - pre-registered attendees only", "label": "3/4/2023 9:00 AM - 12:30 PM", "start_time": "2023-03-04T09:00:00.000000-0600", "end_time": "2023-03-04T12:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625809", "target_object_id": 28625809, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476329 | 191394 | Leon Yin | <p> Leon Yin is an investigative data journalist at The Markup. He uses interdisciplinary methods and bespoke datasets to report on technology and monopolies. In 2022, he received a Gerald Loeb Award for the series "Amazon's Advantage." Before journalism, he was a research scientist at The Center for Social Media and Politics at New York University. Leon started his career writing Fortran scripts at NASA. </p> | The Markup | 0 | 0 | 174 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Large-scale scraping projects", "label": "3/3/2023 10:15 AM - 11:15 AM", "start_time": "2023-03-03T10:15:00.000000-0600", "end_time": "2023-03-03T11:15:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625687", "target_object_id": 28625687, "target_content_type": "schedule.session" }, { "title": "Findings and using undocumented APIs", "label": "3/4/2023 9:00 AM - 10:00 AM", "start_time": "2023-03-04T09:00:00.000000-0600", "end_time": "2023-03-04T10:00:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625733", "target_object_id": 28625733, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476328 | 191394 | Yanqi Xu | <p> Yanqi Xu is a reporter at the Flatwater Free Press in Nebraska. She uses data to cover accountability stories and recently completed a project about nitrate contamination of groundwater in Nebraska. </p> | Flatwater Free Press | 0 | 0 | 275 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Finding the story: Parole boards", "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=28625679", "target_object_id": 28625679, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476327 | 191394 | Evan Wyloge | <p> Evan Wyloge is a data journalist at <a href="http://Realtor.com">Realtor.com</a>, where he covers real estate trends. </p> | Realtor.com | 0 | 0 | 103 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "How to analyze freely-available real estate data to tell your community's story", "label": "3/5/2023 10:15 AM - 11:15 AM", "start_time": "2023-03-05T10:15:00.000000-0600", "end_time": "2023-03-05T11:15:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625683", "target_object_id": 28625683, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476326 | 191394 | Davis Winkie | <p> Davis Winkie is a senior reporter covering the Army for Military Times, specializing in accountability reporting, personnel issues and military justice. He joined Military Times in 2020. Davis studied history at Vanderbilt University and UNC-Chapel Hill, writing a master's thesis about how the Cold War-era Defense Department influenced Hollywood's WWII movies. </p> | Military Times | 0 | 0 | 81 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Reporting on a military base near you using courts-martial records", "label": "3/3/2023 3:30 PM - 4:30 PM", "start_time": "2023-03-03T15:30:00.000000-0600", "end_time": "2023-03-03T16:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625763", "target_object_id": 28625763, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476325 | 191394 | Cody Winchester | <p> Cody was a newspaper reporter, data specialist and web developer before joining IRE as a training director in 2017. He became the organization's tech director in 2022. </p> | IRE & NICAR | 0 | 0 | 75 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Welcome first timers! How to make the most of NICAR23", "label": "3/2/2023 8:15 AM - 8:45 AM", "start_time": "2023-03-02T08:15:00.000000-0600", "end_time": "2023-03-02T08:45:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625695", "target_object_id": 28625695, "target_content_type": "schedule.session" }, { "title": "Web scraping with Python - pre-registered attendees only", "label": "3/5/2023 9:00 AM - 12:30 PM", "start_time": "2023-03-05T09:00:00.000000-0600", "end_time": "2023-03-05T12:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625694", "target_object_id": 28625694, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476324 | 191394 | Simon Willison | Independent journalist | 0 | 0 | 252 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Datasette: An ecosystem of tools for exploring data and collaborating on data projects", "label": "3/4/2023 3:30 PM - 4:30 PM", "start_time": "2023-03-04T15:30:00.000000-0600", "end_time": "2023-03-04T16:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625732", "target_object_id": 28625732, "target_content_type": "schedule.session" } ] } ] |
[] |
|||||||||||
15476323 | 191394 | Derek Willis | <p> Derek is a lecturer in data and computational journalism at the Philip Merrill College of Journalism at the University of Maryland and co-founder of OpenElections. He is an IRE member since 1995 and alumnus of lots of great news organizations. </p> | University of Maryland | 0 | 0 | 83 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Bringing data journalism to the sports section", "label": "3/2/2023 11:30 AM - 12:30 PM", "start_time": "2023-03-02T11:30:00.000000-0600", "end_time": "2023-03-02T12:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625734", "target_object_id": 28625734, "target_content_type": "schedule.session" }, { "title": "Tools for teaching R", "label": "3/2/2023 3:30 PM - 4:30 PM", "start_time": "2023-03-02T15:30:00.000000-0600", "end_time": "2023-03-02T16:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625781", "target_object_id": 28625781, "target_content_type": "schedule.session" }, { "title": "Best practices when teaching investigative and data journalism classes", "label": "3/4/2023 11:30 AM - 12:30 PM", "start_time": "2023-03-04T11:30:00.000000-0600", "end_time": "2023-03-04T12:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625757", "target_object_id": 28625757, "target_content_type": "schedule.session" }, { "title": "Introducing moneyinpolitics.wtf, a new campaign-finance dictionary made by and for data journalists", "label": "3/4/2023 3:30 PM - 4:30 PM", "start_time": "2023-03-04T15:30:00.000000-0600", "end_time": "2023-03-04T16:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625784", "target_object_id": 28625784, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476322 | 191394 | Phil Williams | WTVF | 0 | 0 | 220 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Next steps after \u2018no\u2019: What to do when your records request is denied", "label": "3/4/2023 2:15 PM - 3:15 PM", "start_time": "2023-03-04T14:15:00.000000-0600", "end_time": "2023-03-04T15:15:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625773", "target_object_id": 28625773, "target_content_type": "schedule.session" }, { "title": "Tools for statehouse reporting", "label": "3/4/2023 3:30 PM - 4:30 PM", "start_time": "2023-03-04T15:30:00.000000-0600", "end_time": "2023-03-04T16:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625776", "target_object_id": 28625776, "target_content_type": "schedule.session" } ] } ] |
[] |
|||||||||||
15476321 | 191394 | K. Sophie Will | <p> K. Sophie Will is CQ Roll Call's congressional committees reporter and Utah Investigative Journalism Project's Alicia Patterson fellow. Previously, she was the national parks reporter for the USA Today network through Report for America. The award-winning Utah native graduated from Boston University with bylines in the Deseret News, the Boston Globe, the Associated Press, Thomson Reuters, HuffPost, WGBH and more. </p> | FiscalNote CQ Roll Call | 0 | 0 | 170 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Public records and data to request for (almost) any beat", "label": "3/4/2023 4:45 PM - 5:45 PM", "start_time": "2023-03-04T16:45:00.000000-0600", "end_time": "2023-03-04T17:45:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625837", "target_object_id": 28625837, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476320 | 191394 | Thomas Wilburn | Chalkbeat | 0 | 0 | 260 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Dataviz accessibility matters \u2014 here's what you can do to improve it", "label": "3/2/2023 4:45 PM - 5:45 PM", "start_time": "2023-03-02T16:45:00.000000-0600", "end_time": "2023-03-02T17:45:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625760", "target_object_id": 28625760, "target_content_type": "schedule.session" } ] } ] |
[] |
|||||||||||
15476319 | 191394 | John West | <p> John West reports the news with code at The Wall Street Journal, where his work has won multiple awards and where he was a finalist for a Pulitzer Prize. He holds an MFA in writing from the Bennington Writing Seminars and degrees in philosophy and music performance from Oberlin College and Conservatory. His first book, "Lessons and Carols," is forthcoming in May 2023. </p> | The Wall Street Journal | 0 | 0 | 145 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Mining financial disclosures", "label": "3/4/2023 9:00 AM - 10:00 AM", "start_time": "2023-03-04T09:00:00.000000-0600", "end_time": "2023-03-04T10:00:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625777", "target_object_id": 28625777, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476318 | 191394 | Ben Welsh | <p>Ben Welsh is the news applications editor at Reuters. He is also a fellow at the DePaul University Center for Journalism Integrity & Excellence.</p> | Reuters | 0 | 0 | 56 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Teaching the teachers", "label": "3/2/2023 9:00 AM - 10:00 AM", "start_time": "2023-03-02T09:00:00.000000-0600", "end_time": "2023-03-02T10:00:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625787", "target_object_id": 28625787, "target_content_type": "schedule.session" }, { "title": "First Python Notebook - pre-registered attendees only", "label": "3/3/2023 9:00 AM - 5:45 PM", "start_time": "2023-03-03T09:00:00.000000-0600", "end_time": "2023-03-03T17:45:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625681", "target_object_id": 28625681, "target_content_type": "schedule.session" }, { "title": "First Visual Story - pre-registered attendees only", "label": "3/4/2023 9:00 AM - 12:30 PM", "start_time": "2023-03-04T09:00:00.000000-0600", "end_time": "2023-03-04T12:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625809", "target_object_id": 28625809, "target_content_type": "schedule.session" }, { "title": "Introducing moneyinpolitics.wtf, a new campaign-finance dictionary made by and for data journalists", "label": "3/4/2023 3:30 PM - 4:30 PM", "start_time": "2023-03-04T15:30:00.000000-0600", "end_time": "2023-03-04T16:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625784", "target_object_id": 28625784, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476317 | 191394 | Simone Weichselbaum | <p> Simone Weichselbaum is a national investigative reporter for NBC News, focusing on local and federal law enforcement issues. She previously was a police reporter for The Marshall Project, the New York Daily News and the Philadelphia Daily News. She holds a graduate degree in criminology from the University of Pennsylvania. </p> | NBC News | 0 | 0 | 251 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Investigative reporting for everyone WITH DATA: A quick-start guide", "label": "3/2/2023 11:30 AM - 12:30 PM", "start_time": "2023-03-02T11:30:00.000000-0600", "end_time": "2023-03-02T12:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625753", "target_object_id": 28625753, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476315 | 191394 | Todd Wallack | <p> Darla Cameron is the managing editor for visual journalism for The Texas Tribune. She works with multidisciplinary teams to elevate the visual storytelling and reach audiences across Texas. </p> | WBUR | 0 | 0 | 264 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Excel: Basic stats", "label": "3/2/2023 10:15 AM - 11:15 AM", "start_time": "2023-03-02T10:15:00.000000-0600", "end_time": "2023-03-02T11:15:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625720", "target_object_id": 28625720, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476314 | 191394 | Mark Walker | The New York Times | 0 | 0 | 186 | Speakers 1045976 | [] |
[] |
|||||||||||
15476313 | 191394 | Lucia Walinchus | <p> Lucia Walinchus, Esq. is the Executive Director at Eye on Ohio. She was a 2016 Fulbright Berlin Capital Program Scholar, has been featured as a guest speaker on CNN and is a contracted freelancer for the New York Times and the Washington Post. Her work has previously been recognized as the Best Investigative Reporting in Ohio, the Best Data Journalism in Ohio, and the Best Public Service Journalism. </p> | The Ohio Center for Journalism, Eye On Ohio | 0 | 0 | 180 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "When data assumes a male population", "label": "3/2/2023 3:30 PM - 4:30 PM", "start_time": "2023-03-02T15:30:00.000000-0600", "end_time": "2023-03-02T16:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625769", "target_object_id": 28625769, "target_content_type": "schedule.session" }, { "title": "Supercharge your local investigation with machine learning", "label": "3/4/2023 10:15 AM - 11:15 AM", "start_time": "2023-03-04T10:15:00.000000-0600", "end_time": "2023-03-04T11:15:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625770", "target_object_id": 28625770, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476312 | 191394 | Matt Waite | <p>Matt Waite is a journalism professor at the University of Nebraska-Lincoln who teaches courses in data analysis and visualization. In 2011, he founded the Drone Journalism Lab, where he and his students have used drones to report news in six countries. From 2007-2011, he was a programmer/journalist for the St. Petersburg Times where he developed the Pulitzer Prize-winning website PolitiFact. Before that, he was an award-winning investigative reporter for the Times.</p> | University of Nebraska-Lincoln | 0 | 0 | 191 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Bringing data journalism to the sports section", "label": "3/2/2023 11:30 AM - 12:30 PM", "start_time": "2023-03-02T11:30:00.000000-0600", "end_time": "2023-03-02T12:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625734", "target_object_id": 28625734, "target_content_type": "schedule.session" }, { "title": "Tools for teaching R", "label": "3/2/2023 3:30 PM - 4:30 PM", "start_time": "2023-03-02T15:30:00.000000-0600", "end_time": "2023-03-02T16:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625781", "target_object_id": 28625781, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476311 | 191394 | Evan Wagstaff | <p> Evan Wagstaff is the director of newsroom engineering for Hearst Newspapers' DevHub, a team of developer journalists who create storytelling tools for local newspapers across the country. </p> | San Francisco Chronicle | 0 | 0 | 102 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Creating and serving vector map tiles using open source tools", "label": "3/3/2023 3:30 PM - 4:30 PM", "start_time": "2023-03-03T15:30:00.000000-0600", "end_time": "2023-03-03T16:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625796", "target_object_id": 28625796, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476310 | 191394 | Kelsey Volk | Kansas State Collegian | 0 | 0 | 166 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "AI art creation: From the classroom to the newsroom", "label": "3/4/2023 3:30 PM - 4:30 PM", "start_time": "2023-03-04T15:30:00.000000-0600", "end_time": "2023-03-04T16:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625744", "target_object_id": 28625744, "target_content_type": "schedule.session" } ] } ] |
[] |
|||||||||||
15476309 | 191394 | Lam Thuy Vo | Independent journalist | 0 | 0 | 171 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Networking: Journalists of color", "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=28625828", "target_object_id": 28625828, "target_content_type": "schedule.session" }, { "title": "Lightning Talks", "label": "3/3/2023 5:00 PM - 6:15 PM", "start_time": "2023-03-03T17:00:00.000000-0600", "end_time": "2023-03-03T18:15:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28665755", "target_object_id": 28665755, "target_content_type": "schedule.session" }, { "title": "Data scraping and mining: What are your legal rights?", "label": "3/3/2023 3:30 PM - 4:30 PM", "start_time": "2023-03-03T15:30:00.000000-0600", "end_time": "2023-03-03T16:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625815", "target_object_id": 28625815, "target_content_type": "schedule.session" }, { "title": "Going beyond 'skills-based': contextualizing data journalism for students", "label": "3/4/2023 9:00 AM - 10:00 AM", "start_time": "2023-03-04T09:00:00.000000-0600", "end_time": "2023-03-04T10:00:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625826", "target_object_id": 28625826, "target_content_type": "schedule.session" } ] } ] |
[] |
|||||||||||
15476307 | 191394 | AJ Vicens | CyberScoop | 0 | 0 | 29 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Command line for reporters on a Mac", "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=28625696", "target_object_id": 28625696, "target_content_type": "schedule.session" } ] } ] |
[] |
|||||||||||
15476306 | 191394 | Aria Velasquez | <p>Aria Velasquez is a freelancer currently based in Atlanta, soon to be based in Chicago. She works full-time as a newsletter strategist at Reckon. Outside of her full-time job, Aria's professional interests include audio and local news. Setting aside work entirely, she enjoys rotating through any number of Real Housewives franchises, cooking, knitting and listening to audiobooks or podcasts. You can find her on Instagram @aria.snaps.</p> | Independent journalist | 0 | 0 | 50 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "How to get a seat at the data journalism table and bring more chairs with you", "label": "3/4/2023 9:00 AM - 10:00 AM", "start_time": "2023-03-04T09:00:00.000000-0600", "end_time": "2023-03-04T10:00:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625790", "target_object_id": 28625790, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476305 | 191394 | Maddy Varner | <p>Maddy Varner is an investigative data journalist at The Markup, where she extracts datasets from public documents and databases and analyzes them to tell stories about how technology impacts areas like labor, education and politics. Prior to The Markup, she was a researcher at ProPublica, where she was on a team that won a Loeb Award for Beat Reporting in 2017 for “Monetizing Hate,” a series of stories that examined Facebook’s ad practices.</p> | The Markup | 0 | 0 | 182 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "How to use investigative techniques to hold algorithms and artificial intelligence accountable", "label": "3/4/2023 9:00 AM - 10:00 AM", "start_time": "2023-03-04T09:00:00.000000-0600", "end_time": "2023-03-04T10:00:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625745", "target_object_id": 28625745, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476304 | 191394 | Shlomo Urbach | <p> Urbach is a senior software engineer with a diverse technological background who has been at Google for 15 years. In the past few years, he has worked on tools for investigative journalists. Urbach is the technical lead for the Pinpoint Extract Structured Data tool, and he is a huge fan of investigative journalism. </p> | 0 | 0 | 249 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Sneak peek of Google's new PDF-busting reporting tool", "label": "3/4/2023 10:15 AM - 11:15 AM", "start_time": "2023-03-04T10:15:00.000000-0600", "end_time": "2023-03-04T11:15:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625831", "target_object_id": 28625831, "target_content_type": "schedule.session" } ] } ] |
[] |
|||||||||||
15476303 | 191394 | Kevin Uhrmacher | <p> Kevin Uhrmacher is an assignment editor on The Washington Post's Graphics team. He oversees visual stories relating to politics, including elections, public policy, abortion access and other national coverage. He joined The Post as a news design and graphics intern in 2014 and spent six years as a graphics reporter. He graduated from UNC-Chapel Hill. </p> | The Washington Post | 0 | 0 | 167 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "30 places to find data to cover issues in your community", "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=28625752", "target_object_id": 28625752, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476302 | 191394 | Serdar Tumgoren | <p>Serdar teaches data journalism at Stanford University. He is passionate about open-source tools and civic data-gathering efforts that help reporters tell local stories.</p> | Stanford University | 0 | 0 | 246 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Showcase: Big Local Data tools", "label": "3/4/2023 10:15 AM - 11:15 AM", "start_time": "2023-03-04T10:15:00.000000-0600", "end_time": "2023-03-04T11:15:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625803", "target_object_id": 28625803, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476301 | 191394 | Andrew Ba Tran | The Washington Post | 0 | 0 | 41 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Exploring data in R with the Tidyverse - pre-registered attendees only (second half)", "label": "3/5/2023 9:00 AM - 12:30 PM", "start_time": "2023-03-05T09:00:00.000000-0600", "end_time": "2023-03-05T12:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28668959", "target_object_id": 28668959, "target_content_type": "schedule.session" }, { "title": "R: Making fancieR graphics", "label": "3/2/2023 10:15 AM - 11:15 AM", "start_time": "2023-03-02T10:15:00.000000-0600", "end_time": "2023-03-02T11:15:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625713", "target_object_id": 28625713, "target_content_type": "schedule.session" }, { "title": "How to investigate pay inequities at your workplace", "label": "3/2/2023 4:45 PM - 5:45 PM", "start_time": "2023-03-02T16:45:00.000000-0600", "end_time": "2023-03-02T17:45:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625761", "target_object_id": 28625761, "target_content_type": "schedule.session" }, { "title": "Exploring data in R with the Tidyverse - pre-registered attendees only (first half)", "label": "3/4/2023 9:00 AM - 12:30 PM", "start_time": "2023-03-04T09:00:00.000000-0600", "end_time": "2023-03-04T12:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625682", "target_object_id": 28625682, "target_content_type": "schedule.session" } ] } ] |
[] |
|||||||||||
15476300 | 191394 | Katie Townsend | <p> Katie Townsend is Deputy Executive Director and Legal Director at the Reporters Committee for Freedom of the Press (<a href="http://www.rcfp.org">www.rcfp.org</a>), a nonprofit organization based in Washington, D.C. She oversees the litigation, amicus, and other legal work of RCFP attorneys, and represents the Reporters Committee, news organizations, and individual journalists, including documentary filmmakers, in court access, freedom of information, and other First Amendment and press freedom matters. </p> | Reporters Committee for Freedom of the Press | 0 | 0 | 163 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Media Lawyer Q&A", "label": "3/3/2023 12:45 PM - 1:45 PM", "start_time": "2023-03-03T12:45:00.000000-0600", "end_time": "2023-03-03T13:45:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28665753", "target_object_id": 28665753, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476299 | 191394 | Mc Nelly Torres | <p> Mc Nelly Torres is an award-winning investigative journalist and editor at the Center for Public Integrity where she leads a team investigating inequality. Previously, Torres worked as an investigative producer for NBC6 in Miami and co-founder of <a href="http://FCIR.org">FCIR.org</a>. Throughout her career, Torres has worked for numerous newspapers across the country including the Sun-Sentinel and the San Antonio Express-News. Torres was the first Latina to be elected to the IRE board of directors. </p> | Center for Public Integrity | 0 | 0 | 193 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Master Class: Managing investigators\u2026 or how to lead journalists born to challenge authority", "label": "3/3/2023 9:00 AM - 12:30 PM", "start_time": "2023-03-03T09:00:00.000000-0600", "end_time": "2023-03-03T12:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625688", "target_object_id": 28625688, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476298 | 191394 | Mago Torres | <p>Torres is an investigative journalist and data editor specializing in research and project leadership. She has been part of OpenNews as Research Project Director and, until recently, was the data editor at the Latin American Center for Investigative Reporting. Torres was part of the ICIJ’s investigations Pandora Papers, FinCEN Files, Luanda Leaks, and the Pulitzer prize-winning Panama Papers. She is a proud JSK Fellow Alumni, and she has a Ph.D. in Humanistic Studies.</p> | OpenNews | 0 | 0 | 185 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Use our data!", "label": "3/2/2023 11:30 AM - 12:30 PM", "start_time": "2023-03-02T11:30:00.000000-0600", "end_time": "2023-03-02T12:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625785", "target_object_id": 28625785, "target_content_type": "schedule.session" }, { "title": "Successful project management for collaboration", "label": "3/2/2023 3:30 PM - 4:30 PM", "start_time": "2023-03-02T15:30:00.000000-0600", "end_time": "2023-03-02T16:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625738", "target_object_id": 28625738, "target_content_type": "schedule.session" }, { "title": "Going beyond 'skills-based': contextualizing data journalism for students", "label": "3/4/2023 9:00 AM - 10:00 AM", "start_time": "2023-03-04T09:00:00.000000-0600", "end_time": "2023-03-04T10:00:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625826", "target_object_id": 28625826, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476297 | 191394 | Matt Topic | <p>Matt Topic is a media and transparency attorney. He has litigated hundreds of state and federal FOIA cases on behalf of journalists and others.</p> | Loevy & Loevy | 0 | 0 | 190 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Media Lawyer Q&A", "label": "3/3/2023 12:45 PM - 1:45 PM", "start_time": "2023-03-03T12:45:00.000000-0600", "end_time": "2023-03-03T13:45:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28665753", "target_object_id": 28665753, "target_content_type": "schedule.session" }, { "title": "Litigating FOIA denials", "label": "3/2/2023 2:15 PM - 3:15 PM", "start_time": "2023-03-02T14:15:00.000000-0600", "end_time": "2023-03-02T15:15:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625833", "target_object_id": 28625833, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476296 | 191394 | Mike Tigas | <p>Mike Tigas is the Lead Product Developer (DevOps + Security) at ProPublica. He previously worked on news applications. Outside of ProPublica he is a core contributor to the Tor Project, working on censorship-circumventing mobile apps. He was an adjunct instructor at New York University's Studio20 digital journalism program and was a 2013 Knight-Mozilla OpenNews Fellow. On Mastadon: @mtigas@mastodon.social</p> | ProPublica | 0 | 0 | 202 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Reporting Tools: Security research for reporters", "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=28625821", "target_object_id": 28625821, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476295 | 191394 | Tisha Thompson | <p>Tisha Thompson is an investigative reporter for ESPN, appearing on all domestic and international platforms, including (but not limited to) espn.com, SportsCenter, OTL, E60, SCFeatures, ESPN Deportes, ESPNW and The Daily podcast. She's a second-generation member of IRE and has been coming to NICAR conferences for more than 20 years.</p> | ESPN | 0 | 0 | 263 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Google Sheets 2: Formulas & sorting", "label": "3/2/2023 10:15 AM - 11:15 AM", "start_time": "2023-03-02T10:15:00.000000-0600", "end_time": "2023-03-02T11:15:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625700", "target_object_id": 28625700, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476294 | 191394 | Sarah Kate Thomas | <p>Sarah Kate is a manager of Information Security at The New York Times, leading the security education team. Sarah Kate holds a Master's in Cybersecurity from New York University and dual undergraduate degrees in Computer Science and Philosophy from Wake Forest University. Born and raised in Texas, she now lives in New York City with her partner and their cat, Winky.</p> | The New York Times | 0 | 0 | 239 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Keeping secrets: Secure source communications", "label": "3/3/2023 9:00 AM - 10:00 AM", "start_time": "2023-03-03T09:00:00.000000-0600", "end_time": "2023-03-03T10:00:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625822", "target_object_id": 28625822, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476293 | 191394 | James Thomas | <p> James Thomas is a software engineer on the Interactive News team at The New York Times. He often works on media-rich projects that involve reader-generated content, and works closely with editors early in the conception of stories that use the digital tools we build on INT. His reporting often examines our cultural habits around music, movement and public space. </p> | The New York Times | 0 | 0 | 123 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "First Visual Story - pre-registered attendees only", "label": "3/4/2023 9:00 AM - 12:30 PM", "start_time": "2023-03-04T09:00:00.000000-0600", "end_time": "2023-03-04T12:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625809", "target_object_id": 28625809, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476292 | 191394 | Aadit Tambe | <p> Aadit Tambe works on the news design team at The Washington Post. He builds interactive stories to explain the news visually. Previously, he was a fellow at the Howard Center for Investigative Journalism at the University of Maryland, and has interned at NBC News on the data and graphics team. </p> | The Washington Post | 0 | 0 | 19 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "First GitHub Scraper - pre-registered attendees only", "label": "3/3/2023 2:15 PM - 5:45 PM", "start_time": "2023-03-03T14:15:00.000000-0600", "end_time": "2023-03-03T17:45:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625716", "target_object_id": 28625716, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476291 | 191394 | Andrea Suozzo | <p>Andrea Suozzo is a news apps developer at ProPublica, where she works on Nonprofit Explorer, builds databases and does reporting. In her free time, she runs, reads, sews, knits and plays the fiddle.</p> | ProPublica | 0 | 0 | 40 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "First Python Notebook - pre-registered attendees only", "label": "3/3/2023 9:00 AM - 5:45 PM", "start_time": "2023-03-03T09:00:00.000000-0600", "end_time": "2023-03-03T17:45:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625681", "target_object_id": 28625681, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476290 | 191394 | Samantha Sunne | <p> Samantha Sunne is a freelance journalist based in New Orleans, Louisiana. She is currently a ProPublica Local Reporting Fellow at WVUE, and she recently published her first book, “Data + Journalism: A Story-Driven Approach to Learning Data Reporting." </p> | Independent journalist | 0 | 0 | 232 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Teaching the teachers", "label": "3/2/2023 9:00 AM - 10:00 AM", "start_time": "2023-03-02T09:00:00.000000-0600", "end_time": "2023-03-02T10:00:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625787", "target_object_id": 28625787, "target_content_type": "schedule.session" }, { "title": "DEI in data reporting", "label": "3/3/2023 2:15 PM - 3:15 PM", "start_time": "2023-03-03T14:15:00.000000-0600", "end_time": "2023-03-03T15:15:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625834", "target_object_id": 28625834, "target_content_type": "schedule.session" }, { "title": "Scraping without programming", "label": "3/4/2023 10:15 AM - 11:15 AM", "start_time": "2023-03-04T10:15:00.000000-0600", "end_time": "2023-03-04T11:15:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625730", "target_object_id": 28625730, "target_content_type": "schedule.session" }, { "title": "Scraping without programming (repeat)", "label": "3/4/2023 3:30 PM - 4:30 PM", "start_time": "2023-03-04T15:30:00.000000-0600", "end_time": "2023-03-04T16:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625735", "target_object_id": 28625735, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476289 | 191394 | Jan Strozyk | <p>Jan is OCCRP's senior data editor and co-head of the Research & Data team. He coordinates data analysis and research and works on data-driven investigations.</p> | Organized Crime and Corruption Reporting Project | 0 | 0 | 126 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Uncovering underground money networks", "label": "3/3/2023 9:00 AM - 10:00 AM", "start_time": "2023-03-03T09:00:00.000000-0600", "end_time": "2023-03-03T10:00:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625813", "target_object_id": 28625813, "target_content_type": "schedule.session" }, { "title": "OCCRP Aleph: Learn the data tool that enables large cross-border investigations", "label": "3/4/2023 9:00 AM - 10:00 AM", "start_time": "2023-03-04T09:00:00.000000-0600", "end_time": "2023-03-04T10:00:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625807", "target_object_id": 28625807, "target_content_type": "schedule.session" }, { "title": "Find public records and leaks: OCCRP Aleph", "label": "3/4/2023 10:15 AM - 11:15 AM", "start_time": "2023-03-04T10:15:00.000000-0600", "end_time": "2023-03-04T11:15:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625814", "target_object_id": 28625814, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476288 | 191394 | Stephannie Stokes | <p> Stephannie Stokes is a journalist covering housing and inequality at the Atlanta NPR affiliate, WABE 90.1 FM. In her investigations, she’s revealed how predatory investors strip wealth from Black homeowners in Atlanta’s fast-appreciating neighborhoods, and she’s spent a year following tenants in a federally-subsidized housing complex with some of the worst conditions in the city. This past year, she joined the inaugural class of Data-Driven Reporting Project awardees. </p> | WABE | 0 | 0 | 255 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Come learn about the Data-Driven Reporting Project", "label": "3/2/2023 10:15 AM - 11:15 AM", "start_time": "2023-03-02T10:15:00.000000-0600", "end_time": "2023-03-02T11:15:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625768", "target_object_id": 28625768, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476287 | 191394 | Stephen Stock | <p> Stephen Stock serves as national investigative correspondent for CBS News and Stations. Prior to joining CBS News, Stephen was a founding member of NBC Bay Area’s 15-member investigative unit. He also helped build investigative teams in Miami and Orlando. He teaches not only at IRE but at universities around the country. He’s won just about every broadcast journalism award including a Peabody, du-Pont, national SPJ, three Murrow, six Assoicated Press awards and 18 regional Emmys. </p> | CBS News and Stations | 0 | 0 | 256 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Under pressure: Real life in real time with breaking news", "label": "3/2/2023 11:30 AM - 12:30 PM", "start_time": "2023-03-02T11:30:00.000000-0600", "end_time": "2023-03-02T12:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625836", "target_object_id": 28625836, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476286 | 191394 | Jim Steele | Independent journalist | 0 | 0 | 141 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Celebrating the 50th anniversary of \"Precision Journalism\"", "label": "3/3/2023 3:30 PM - 4:30 PM", "start_time": "2023-03-03T15:30:00.000000-0600", "end_time": "2023-03-03T16:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625800", "target_object_id": 28625800, "target_content_type": "schedule.session" } ] } ] |
[] |
|||||||||||
15476285 | 191394 | Megan Squire | <p> Dr. Megan Squire is deputy director for data analytics and OSINT at the Southern Poverty Law Center. As a computer scientist, she applies her background in data science and cybersecurity to track and expose networks of hate and extremism online. </p> | Southern Poverty Law Center | 0 | 0 | 194 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Data on the business and economics beat", "label": "3/3/2023 2:15 PM - 3:15 PM", "start_time": "2023-03-03T14:15:00.000000-0600", "end_time": "2023-03-03T15:15:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625737", "target_object_id": 28625737, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476284 | 191394 | Jonathan Soma | <p> Jonathan Soma is Knight Chair of Data Journalism at Columbia University, where he directs both the Data Journalism MS and the summer intensive Lede Program. His courses there cover everything from basic Python and analysis to ai2html and machine learning. When Soma isn't boring his students to tears he's probably rescuing cats. </p> | Columbia University | 0 | 0 | 146 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Supercharge your coding workflow with Chat-GPT and GitHub Copilot", "label": "3/2/2023 4:45 PM - 5:45 PM", "start_time": "2023-03-02T16:45:00.000000-0600", "end_time": "2023-03-02T17:45:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625795", "target_object_id": 28625795, "target_content_type": "schedule.session" }, { "title": "Best practices when teaching investigative and data journalism classes", "label": "3/4/2023 11:30 AM - 12:30 PM", "start_time": "2023-03-04T11:30:00.000000-0600", "end_time": "2023-03-04T12:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625757", "target_object_id": 28625757, "target_content_type": "schedule.session" }, { "title": "Practical machine learning for everyone - pre-registered attendees only", "label": "3/4/2023 2:15 PM - 5:45 PM", "start_time": "2023-03-04T14:15:00.000000-0600", "end_time": "2023-03-04T17:45:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625691", "target_object_id": 28625691, "target_content_type": "schedule.session" }, { "title": "Building your own AI editors", "label": "3/5/2023 10:15 AM - 11:15 AM", "start_time": "2023-03-05T10:15:00.000000-0600", "end_time": "2023-03-05T11:15:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625783", "target_object_id": 28625783, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476283 | 191394 | Barnaby Skinner | <p> I manage the visuals department with data journalists, visuals journalists, software developers and OSINT reporters of the leading Swiss daily NZZ. Before that I built a team of data journalists and data scientists for Tamedia, another large Swiss publisher. I regularly teach data literacy skills and speak about digital transformation and the disruption of the news industry. </p> | Neue Zürcher Zeitung | 0 | 0 | 54 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Building an interactive map in the newsroom: How to bring skills and talent together", "label": "3/4/2023 4:45 PM - 5:45 PM", "start_time": "2023-03-04T16:45:00.000000-0600", "end_time": "2023-03-04T17:45:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625806", "target_object_id": 28625806, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476282 | 191394 | Gunita Singh | <p> Gunita is an attorney at RCFP where she litigates against state and federal agencies using freedom of information laws and helps reporters with records requests. She has co-authored two publications analyzing the role of news media in providing information about COVID-19. Gunita was previously an attorney at Property of the People, a DC-based FOIA operation. She received her J.D. from Georgetown and serves on the board of LION Publishers. </p> | Reporters Committee for Freedom of the Press | 0 | 0 | 113 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Next steps after \u2018no\u2019: What to do when your records request is denied", "label": "3/4/2023 2:15 PM - 3:15 PM", "start_time": "2023-03-04T14:15:00.000000-0600", "end_time": "2023-03-04T15:15:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625773", "target_object_id": 28625773, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476281 | 191394 | Jeremy Singer-Vine | <p> Jeremy Singer-Vine runs the Data Liberation Project and writes Data Is Plural, a weekly newsletter. </p> | The Data Liberation Project | 0 | 0 | 139 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Use our data!", "label": "3/2/2023 11:30 AM - 12:30 PM", "start_time": "2023-03-02T11:30:00.000000-0600", "end_time": "2023-03-02T12:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625785", "target_object_id": 28625785, "target_content_type": "schedule.session" }, { "title": "Python: Working with PDFs using pdfplumber", "label": "3/3/2023 10:15 AM - 11:15 AM", "start_time": "2023-03-03T10:15:00.000000-0600", "end_time": "2023-03-03T11:15:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625726", "target_object_id": 28625726, "target_content_type": "schedule.session" }, { "title": "Command line data analysis with VisiData", "label": "3/3/2023 2:15 PM - 3:15 PM", "start_time": "2023-03-03T14:15:00.000000-0600", "end_time": "2023-03-03T15:15:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625725", "target_object_id": 28625725, "target_content_type": "schedule.session" }, { "title": "Data blitz", "label": "3/4/2023 2:15 PM - 3:15 PM", "start_time": "2023-03-04T14:15:00.000000-0600", "end_time": "2023-03-04T15:15:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625724", "target_object_id": 28625724, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476280 | 191394 | Sara Silver | <p>Sara Silver is Abelson professor of business journalism at Quinnipiac University and trains newsrooms to follow the money. She covered the implosion of telecom equipment giants for The Wall Street Journal. Her award-winning series for the Financial Times kept Mexico’s would-be Evita from diverting charity to her campaign to succeed her husband as president. Silver covered Mexico and New York for The Associated Press and was a Knight-Bagehot fellow at Columbia.</p> | Quinnipiac University | 0 | 0 | 241 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Mining financial disclosures", "label": "3/4/2023 9:00 AM - 10:00 AM", "start_time": "2023-03-04T09:00:00.000000-0600", "end_time": "2023-03-04T10:00:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625777", "target_object_id": 28625777, "target_content_type": "schedule.session" }, { "title": "The international money trail", "label": "3/4/2023 11:30 AM - 12:30 PM", "start_time": "2023-03-04T11:30:00.000000-0600", "end_time": "2023-03-04T12:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625817", "target_object_id": 28625817, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476279 | 191394 | Naël Shiab | <p> Naël Shiab is the senior data producer for CBC/Radio-Canada. He uses his programming skills to answer questions of public interest with data. He loves to create digital interactive experiences, especially immersive 3D dataviz. Naël is also the creator and maintainer of the open-source library simple-data-analysis (<a href="http://github.com/nshiab/simple-data-analysis">github.com/nshiab/simple-data-analysis</a>). For more, including his portfolio, visit <a href="http://naelshiab.com">naelshiab.com</a>. </p> | CBC | 0 | 0 | 203 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Introduction to web development - pre-registered attendees only", "label": "3/2/2023 9:00 AM - 5:45 PM", "start_time": "2023-03-02T09:00:00.000000-0600", "end_time": "2023-03-02T17:45:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625685", "target_object_id": 28625685, "target_content_type": "schedule.session" }, { "title": "Data analysis in JavaScript", "label": "3/3/2023 10:15 AM - 11:15 AM", "start_time": "2023-03-03T10:15:00.000000-0600", "end_time": "2023-03-03T11:15:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625808", "target_object_id": 28625808, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476278 | 191394 | Ryan Serpico | <p>Ryan Serpico is a graphics reporter for the San Antonio Express-News. He specializes in creating quick-turn data stories and helping other journalists with their data-driven stories. He builds tools for the newsroom that take advantage of generative AI — like GPT-3 — in a safe and responsible manner. He graduated from the University of Florida in 2018. He is thankful to all those who helped him get this far. Follow him on Mastodon: @ryan@ryanserpi.co</p> | San Antonio Express-News | 0 | 0 | 229 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Quick turn data stories: Using the quick turn to your advantage", "label": "3/3/2023 10:15 AM - 11:15 AM", "start_time": "2023-03-03T10:15:00.000000-0600", "end_time": "2023-03-03T11:15:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625775", "target_object_id": 28625775, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476277 | 191394 | Libby Seline | <p> Libby Seline is a data visualization reporter for the San Antonio Express-News and Houston Chronicle. Before coming to San Antonio, she attended the University of Nebraska-Lincoln and worked for The New York Times, the Salt Lake Tribune and the Lincoln Journal Star. </p> | San Antonio Express-News | 0 | 0 | 176 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "How and when to open-source your code and analysis", "label": "3/4/2023 11:30 AM - 12:30 PM", "start_time": "2023-03-04T11:30:00.000000-0600", "end_time": "2023-03-04T12:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625774", "target_object_id": 28625774, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476276 | 191394 | Daniel Schwalbe | Domain Tools | 0 | 0 | 76 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Finding the story: Using DNS search for investigative journalism", "label": "3/2/2023 9:00 AM - 10:00 AM", "start_time": "2023-03-02T09:00:00.000000-0600", "end_time": "2023-03-02T10:00:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625714", "target_object_id": 28625714, "target_content_type": "schedule.session" } ] } ] |
[] |
|||||||||||
15476275 | 191394 | Zoe Schumacher | <p> I am a sophomore in Marketing and Graphic Design at Kansas State University. As the Page Design Chief for the Collegian, I communicate our stories to our students through interesting, compelling design and artwork. </p> | Kansas State University | 0 | 0 | 278 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "AI art creation: From the classroom to the newsroom", "label": "3/4/2023 3:30 PM - 4:30 PM", "start_time": "2023-03-04T15:30:00.000000-0600", "end_time": "2023-03-04T16:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625744", "target_object_id": 28625744, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476274 | 191394 | Hilke Schellmann | New York University | 0 | 0 | 115 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "How to use investigative techniques to hold algorithms and artificial intelligence accountable", "label": "3/4/2023 9:00 AM - 10:00 AM", "start_time": "2023-03-04T09:00:00.000000-0600", "end_time": "2023-03-04T10:00:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625745", "target_object_id": 28625745, "target_content_type": "schedule.session" }, { "title": "Best practices when teaching investigative and data journalism classes", "label": "3/4/2023 11:30 AM - 12:30 PM", "start_time": "2023-03-04T11:30:00.000000-0600", "end_time": "2023-03-04T12:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625757", "target_object_id": 28625757, "target_content_type": "schedule.session" } ] } ] |
[] |
|||||||||||
15476273 | 191394 | Carter Schafer | Kansas State University | 0 | 0 | 66 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "AI art creation: From the classroom to the newsroom", "label": "3/4/2023 3:30 PM - 4:30 PM", "start_time": "2023-03-04T15:30:00.000000-0600", "end_time": "2023-03-04T16:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625744", "target_object_id": 28625744, "target_content_type": "schedule.session" } ] } ] |
[] |
|||||||||||
15476272 | 191394 | Ben Schachtman | <p> Ben Schachtman is a journalist and editor with a focus on local government accountability. He began reporting for Port City Daily in the Wilmington area in 2016 and took over as managing editor there in 2018. He’s a graduate of Rutgers College and later received his master's degree from New York University and his PhD from State University New York-Stony Brook, both in English Literature. He loves spending time with his wife and playing rock 'n' roll very loudly. </p> | WHQR | 0 | 0 | 55 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Telling data stories in audio", "label": "3/4/2023 11:30 AM - 12:30 PM", "start_time": "2023-03-04T11:30:00.000000-0600", "end_time": "2023-03-04T12:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625742", "target_object_id": 28625742, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476271 | 191394 | Niall Sargent | <p> Niall Sargent is an award-winning multimedia investigative reporter with Noteworthy, a community-led investigative journalism platform in Ireland, where he is focused on issues related to climate change, biodiversity, and ecosystem services. He holds an MA in Investigative Journalism from City University London and a Diploma in Online Journalism from Goldsmiths University in London. </p> | Noteworthy | 0 | 0 | 209 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "It\u2019s freezing! Investigating the climate crisis", "label": "3/2/2023 11:30 AM - 12:30 PM", "start_time": "2023-03-02T11:30:00.000000-0600", "end_time": "2023-03-02T12:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625739", "target_object_id": 28625739, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476270 | 191394 | Robert L. Santos | <p>Rob Santos is the 26th director of the U.S. Census Bureau. His 40 year career includes serving in executive and technical positions in statistics and survey operations. He is also a champion of diversity, equity and inclusion. He was president of the American Statistical Association in 2021 and is an ASA Fellow. He was also the 2014 president of the American Association for Public Opinion Research and has received numerous awards over his career.</p> | U.S. Census Bureau | 0 | 0 | 225 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "A conversation with U.S. Census Bureau director, Robert L. Santos", "label": "3/3/2023 2:15 PM - 3:15 PM", "start_time": "2023-03-03T14:15:00.000000-0600", "end_time": "2023-03-03T15:15:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625832", "target_object_id": 28625832, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476269 | 191394 | Aarushi Sahejpal | <p> Aarushi Sahejpal is data editor at the Investigative Reporting Workshop and an adjunct professor of quantitative methods and data journalism at American University's School of Communication. </p> | American University/Investigative Reporting Workshop | 0 | 0 | 22 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Use our data!", "label": "3/2/2023 11:30 AM - 12:30 PM", "start_time": "2023-03-02T11:30:00.000000-0600", "end_time": "2023-03-02T12:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625785", "target_object_id": 28625785, "target_content_type": "schedule.session" }, { "title": "Best practices when teaching investigative and data journalism classes", "label": "3/4/2023 11:30 AM - 12:30 PM", "start_time": "2023-03-04T11:30:00.000000-0600", "end_time": "2023-03-04T12:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625757", "target_object_id": 28625757, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476268 | 191394 | Naveena Sadasivam | <p> Naveena Sadasivam is a staff writer covering the environment, energy, and climate change at Grist. She previously covered environmental issues at the Texas Observer, InsideClimate News, and ProPublica. She is a Livingston award finalist and has received awards from the Society of Professional Journalists, Society of Environmental Journalists, and the Radio Television Digital News Association for her reporting. </p> | Grist | 0 | 0 | 207 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Supercharge your local investigation with machine learning", "label": "3/4/2023 10:15 AM - 11:15 AM", "start_time": "2023-03-04T10:15:00.000000-0600", "end_time": "2023-03-04T11:15:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625770", "target_object_id": 28625770, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476267 | 191394 | Inori Roy | <p> Inori Roy is a Toronto-based feature writer and associate editor at The Local magazine. She specializes in data-driven investigations exposing inequities, particularly across race, class and geographic lines, and driven by policy choices. Her work has previously appeared in the Toronto Star, environmental outlets Unearthed and The Narwhal, and the CBC. </p> | The Local (Toronto) | 0 | 0 | 120 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Come learn about the Data-Driven Reporting Project", "label": "3/2/2023 10:15 AM - 11:15 AM", "start_time": "2023-03-02T10:15:00.000000-0600", "end_time": "2023-03-02T11:15:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625768", "target_object_id": 28625768, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476266 | 191394 | Libby Rogers | <p> Libby is a data scientist with BBC News. Recent projects include uncovering the extent of the NHS dentistry shortage in the UK, heat hazards and the latest NHS winter tracker. Libby also supports the BBC data journalism team technically with training and developing reusable tools and processes. </p> | BBC News | 0 | 0 | 175 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "QGIS 1: Mapmaking for beginners", "label": "3/2/2023 2:15 PM - 3:15 PM", "start_time": "2023-03-02T14:15:00.000000-0600", "end_time": "2023-03-02T15:15:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625804", "target_object_id": 28625804, "target_content_type": "schedule.session" }, { "title": "QGIS 2: Analyzing geographic data", "label": "3/2/2023 3:30 PM - 4:30 PM", "start_time": "2023-03-02T15:30:00.000000-0600", "end_time": "2023-03-02T16:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625805", "target_object_id": 28625805, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476265 | 191394 | Cam Rodriguez | <p> Cam Rodriguez is a data + graphics reporter at Chalkbeat. In the past, she's been a Dow Jones intern at USA TODAY, a 2020 elections fellow at the Detroit Free Press and she chased down historical oddities with WTTW/Chicago PBS, in addition to freelancing with Voice of San Diego and South Side Weekly. A recent grad-school grad, Cam was also managing editor at 14 East, DePaul University's award-winning online student magazine based in Chicago. </p> | Chalkbeat | 0 | 0 | 64 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Let's make mapping better! - pre-registered attendees only", "label": "3/2/2023 9:00 AM - 12:30 PM", "start_time": "2023-03-02T09:00:00.000000-0600", "end_time": "2023-03-02T12:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625692", "target_object_id": 28625692, "target_content_type": "schedule.session" }, { "title": "How to get a seat at the data journalism table and bring more chairs with you", "label": "3/4/2023 9:00 AM - 10:00 AM", "start_time": "2023-03-04T09:00:00.000000-0600", "end_time": "2023-03-04T10:00:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625790", "target_object_id": 28625790, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476264 | 191394 | Janet Roberts | <p>Janet Roberts heads the data journalism team at Reuters and has been wringing stories out of data since she was a student in Phil Meyer’s journalism class at UNC. Before Reuters, she was a data journalist at the New York Times and the St. Paul Pioneer Press. She co-edited a data-driven Reuters project that won the Pulitzer Prize in Explanatory Journalism in 2020 and has been a finalist herself for the same prize.</p> | Reuters | 0 | 0 | 125 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Celebrating the 50th anniversary of \"Precision Journalism\"", "label": "3/3/2023 3:30 PM - 4:30 PM", "start_time": "2023-03-03T15:30:00.000000-0600", "end_time": "2023-03-03T16:30:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625800", "target_object_id": 28625800, "target_content_type": "schedule.session" } ] } ] |
[] |
||||||||||
15476263 | 191394 | Alex Richards | <p> Alex Richards is an assistant professor at Syracuse University. Prior to his current role, he was the deputy investigations editor at NerdWallet and has been a reporter and editor at news organizations including the Chicago Tribune, The Chronicle of Higher Education and the Las Vegas Sun. He's also a former IRE training director. </p> | Syracuse University | 0 | 0 | 33 | Speakers 1045976 | [ { "categoryTitle": "Sessions", "links": [ { "title": "Finding the story: Higher education data", "label": "3/4/2023 4:45 PM - 5:45 PM", "start_time": "2023-03-04T16:45:00.000000-0600", "end_time": "2023-03-04T17:45:00.000000-0600", "all_day": false, "image": "", "gb_url": "gb://guide/191394/event/?id=28625847", "target_object_id": 28625847, "target_content_type": "schedule.session" } ] } ] |
[] |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "guidebook_poi" ( [id] INTEGER PRIMARY KEY, [guide_id] INTEGER, [import_id] TEXT, [name] TEXT, [description] TEXT, [image] TEXT, [label] TEXT, [allowRating] INTEGER, [addToDo] INTEGER, [deleted] TEXT, [last_updated] TEXT, [rank] INTEGER, [locations] TEXT, [categories] INTEGER, [links] TEXT, [subimage] TEXT, [link_image] TEXT, [thumbnail] TEXT, [cog_details] TEXT, [contact_email] TEXT, [meeting_url] TEXT, FOREIGN KEY([categories]) REFERENCES [guidebook_poicategory]([id]) );