This data as JSON, CSV (advanced)
Suggested facets: start_date_clean, session_type, skill_level
| Link | rowid | event_id | name | clean_description | location_room | start_date_clean | start_time | end_time | pre_reg_flag | paid_flag | laptop_flag | speakers_cleaned | session_type | keywords | skill_level | session_title |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20 | 20 | 4341 | Being scrappy: Doing data journalism as a team of one | In many small to medium-sized newsrooms, you could find yourself the only person doing data or interactive journalism. In this NICAR Commons session, we will share tips, tricks and strategies that will help get your data stories published as a team of one. We will also discuss suitable project types that a one-person or scrappy small team is much more efficient at getting done. | Del Mar 9 | 2019-03-09 | 2019-03-09 10:15:00 | 2019-03-09 11:15:00 | 0 | 0 | 0 | Taeler De Haes, KYTX CBS 19; Moiz Syed, The Intercept | Commons 4 | Beginner 4 | Being scrappy: Doing data journalism as a team of one | |
| 40 | 40 | 4367 | Connecting the dots with health data: The Implant Files case | The Implant Files investigation involved a global effort of more than 1,500 FOI requests to gather data on medical devices in different parts of the world. It was a collaboration that involved more than 250 journalists in 36 countries. As a result, ICIJ released the first International Medical Devices Database that facilitates the exploration of more than 75,000 recalls, safety alerts and field safety notices of medical devices and their connections with manufacturers. Join us to explore the possibilities this data collection has to offer and how to connect it with other health datasets to report on stories linked to the medical devices industry. | Del Mar 9 | 2019-03-08 | 2019-03-08 09:00:00 | 2019-03-08 10:00:00 | 0 | 0 | 0 | Emilia Diaz Struck, Margot Williams, Karrie Kehoe, Andy Lehren and Emily Siegel | Commons 4 | Connecting the dots with health data: The Implant Files case | ||
| 46 | 46 | 4396 | Creative ways to teach difficult concepts | Teaching data journalism in newsrooms and at universities has forced us to come up with creative techniques. We wrote The SQL Song to help one group of boot camp attendees understand the order of commands. In an attempt to help students fine-tune their programs, we did a game show called Query Cash. To make string functions make more sense, we’ve created silly, but useful performances. Bring your fun ideas and we can work out creative solutions together. | Del Mar 9 | 2019-03-09 | 2019-03-09 16:45:00 | 2019-03-09 17:45:00 | 0 | 0 | 0 | Jennifer LaFleur, Investigative Reporting Workshop yes); Jaimi Dowdell, Reuters | Commons 4 | General interest 1 | Creative ways to teach difficult concepts | |
| 51 | 51 | 4346 | Data journalism educators resource swap | If you teach a data journalism course or want to, join this NICAR Commons conversation and idea exchange. Bring your best teaching resources and assignments to share with others. And come ready to contribute to the discussion. What aspects of your courses and curriculum have produced the best results? What knowledge and skills do students need to secure an entry-level data reporting job? What data stories can students cover and add to their portfolio? How can we help IRE & NICAR update teaching resources? Educators: Upload your sample assignments, syllabi and discussion ideas for NICAR 2019. | Del Mar 9 | 2019-03-07 | 2019-03-07 11:30:00 | 2019-03-07 12:30:00 | 0 | 0 | 0 | Mark Berkey-Gerard, Rowan University; Dana Chinn, University of Southern California | Commons 4 | General interest 1 | Data journalism educators resource swap | |
| 72 | 72 | 4351 | Favorite code snippets: A responsibly sourced, artisanal list from the Lonely Coder's Club | The Lonely Coder's Club, a Slack community of newsroom programmers without big teams, would like to present our favorite, most-used code snippets. We've translated these snippets to most common coding languages and commented the heck out them so you can plug and play with ease! During this session, a few Lonely Coders will go through our favorites on the list and how they help save us time on project after project. We’ll also share tips on how you can start writing your own reusable code, no matter how lonely a coder you are. | Del Mar 9 | 2019-03-08 | 2019-03-08 10:15:00 | 2019-03-08 11:15:00 | 0 | 0 | 0 | Alexandra Kanik, Louisville Public Media (moderator); David Montgomery, The Atlantic CityLab | Commons 4 | Beginner 4 | Favorite code snippets: A responsibly sourced, artisanal list from the Lonely Coder's Club | |
| 87 | 87 | 4360 | Freelancers' roundtable | A freelancer has to juggle more than the average reporter - long lead time, high expectations, a wide variety of tasks and deadlines (or sometimes worse, no deadlines). Join the conversation and discuss how to know when you have a good enough story to pitch? How deep do you dive before you know you're getting paid? How do you build sources without a household name? A few freelance investigative reporters with experience in these areas will share their own tips and take questions from the audience - past, current and prospective freelancers welcome. | Del Mar 9 | 2019-03-08 | 2019-03-08 14:15:00 | 2019-03-08 15:15:00 | 0 | 0 | 0 | Sandra Fish, Samantha Sunne, Allison McCartney | Commons 4 | Freelancers' roundtable | ||
| 111 | 111 | 4345 | How to help your TV newsroom achieve a data journalism mindset | Data journalism is a staple in many print newsrooms and for most investigative teams. But TV newsrooms have historically shied away from telling stories with data because it's complex, time consuming and hard to explain in a visual and entertaining way. Here's the good news: It doesn't have to be so daunting! Our team at KING-TV teamed up with data experts at Microsoft to find visually-compelling ways to integrate data into the daily mix. We came up with a style that shines on all platforms. In this NICAR Commons session, we'll share key takeaways from our journey, swap practical tips for building a newsroom culture that embraces data storytelling, and we'll work together to remove roadblocks on your path to achieving the data journalism mindset. | Del Mar 9 | 2019-03-07 | 2019-03-07 14:15:00 | 2019-03-07 15:15:00 | 0 | 0 | 0 | Taylor Mirfendereski & Jake Wittenberg, KING5 | Commons 4 | General interest 1 | How to help your TV newsroom achieve a data journalism mindset | |
| 131 | 131 | 4369 | Introducing The Public Accountability search project | The Public Accountability Project is a new site to search hundreds of millions of rows of U.S. transparency data for people, addresses and companies. To date, we've indexed federal and state campaign finance, nonprofit grants and employees, 527s, and some personnel records and voter rolls from states that probably won't sue. We'll be demoing the site, and looking for input on what public data you think should be added next. | Del Mar 9 | 2019-03-09 | 2019-03-09 09:00:00 | 2019-03-09 10:00:00 | 0 | 0 | 0 | Jacob Fenton | Commons 4 | Introducing The Public Accountability search project | ||
| 141 | 141 | 4347 | Keeping your career lit while raising humans | Come to this NICAR Commons session to discuss and share tips on how to keep your career on course after parental leave, childcare struggles and juggling the work-family balance. | Del Mar 9 | 2019-03-09 | 2019-03-09 11:30:00 | 2019-03-09 12:30:00 | 0 | 0 | 0 | Megan Luther, InvestigateTV | Commons 4 | General interest 1 | Keeping your career lit while raising humans | |
| 142 | 142 | 4343 | Learn from my fail: Data always sucks edition | Gather round, friends, and we'll tell some personal stories of otherwise good reporting that failed because we lost sight of a cardinal truth: Data always sucks. | Del Mar 9 | 2019-03-09 | 2019-03-09 15:30:00 | 2019-03-09 16:30:00 | 0 | 0 | 0 | Kristin Hussey, independent journalist; Matt Wynn, USA TODAY | Commons 4 | Beginner 4 | Learn from my fail: Data always sucks edition | |
| 162 | 162 | 4362 | NICAR-L improvement project | Help make the NICAR-L archives more user-friendly by creating ways to identify and surface useful posts and threads. We'll discuss possible new ways to access the archives, a basic app to make things like up-voting and categorization possible and an initial roadmap. During this session, we will gather ideas and create a plan that we'll continue working on after the conference. | Del Mar 9 | 2019-03-07 | 2019-03-07 16:45:00 | 2019-03-07 17:45:00 | 0 | 0 | 0 | Derek Willis, ProPublica | Commons 4 | NICAR-L improvement project | ||
| 205 | 205 | 4386 | Rewriting the code of ethics: New standards for digital journalism | Surveillance, data breaches and misinformation: The hazards inherent in our digital landscape mandate an update to the journalist's code of ethics. Come prepared with any cases of ethical dilemmas you or your newsroom have encountered online. In this NICAR Commons session, journalists and technologists will discuss examples and work toward a new standard for online behavior. | Del Mar 9 | 2019-03-09 | 2019-03-09 14:15:00 | 2019-03-09 15:15:00 | 0 | 0 | 0 | Gisela Perez de Acha Chavez, Mahmoud Hamsho, Christi Warren, Steve Trush, The University of California-Berkeley | General 5 | An Uncertain Future: A Code of Ethics for the Robotic Age | ||
| 223 | 223 | 4357 | Students' roundtable | This is a roundtable for students to have an honest, off-the-record discussion on the challenges of being a student journalist. Some of the topics that might be brought up include: learning to set aside your personal biases, gaining access to data and documents, and backlash from your university for unfavorable coverage. | Del Mar 9 | 2019-03-07 | 2019-03-07 15:30:00 | 2019-03-07 16:30:00 | 0 | 0 | 0 | Kaitlin Washburn, University of Missouri; Orla McCaffrey, Binghamton University | Commons 4 | Students' roundtable | ||
| 233 | 233 | 4344 | The state of data reporting outside major cities | What's life like for a data reporter who doesn't want to live in a major city? In this NICAR Commons session, talk to reporters who have been doing it for a long time and those just starting out. | Del Mar 9 | 2019-03-07 | 2019-03-07 10:15:00 | 2019-03-07 11:15:00 | 0 | 0 | 0 | Erin Mansfield, Tyler Morning Telegraph; Ryan Thornburg, University of North Carolina at Chapel Hill | Commons 4 | General interest 1 | The state of data reporting outside major cities | |
| 237 | 237 | 4342 | To manage or not: Choosing the right career path | Career growth is often equated with becoming a people manager. But what if people management is not your strength? Can it be learned? Let's talk about how to decide what is right for you, discuss career growth options that don't involve managing people and share tips, tricks and resources. | Del Mar 9 | 2019-03-08 | 2019-03-08 15:30:00 | 2019-03-08 16:30:00 | 0 | 0 | 0 | Soo Oh, The Wall Street Journal; Kavya Sukumar, Vox Media | Commons 4 | Beginner 4 | To manage or not: Choosing the right career path | |
| 252 | 252 | 4358 | Women in journalism meetup | This session will be an off-the-record discussion about being a woman in journalism. Some topics we'll bring up will include: negotiating your pay and the pay gap, balancing family and work, challenges and advice on climbing the ladder, dealing with sexist accusations about your reporting and pushing back when you know you have a good story. | Del Mar 9 | 2019-03-08 | 2019-03-08 11:30:00 | 2019-03-08 12:30:00 | 0 | 0 | 0 | Jenifer McKim, NECIR; Nicole Vap, KUSA; Kavya Sukumar, Hearken | Commons 4 | Women in journalism meetup |
JSON shape: default, array, newline-delimited
CREATE TABLE "sessions" (
"event_id" INTEGER,
"name" TEXT,
"clean_description" TEXT,
"location_room" INTEGER,
"start_date_clean" TEXT,
"start_time" TEXT,
"end_time" TEXT,
"pre_reg_flag" INTEGER,
"paid_flag" INTEGER,
"laptop_flag" INTEGER,
"speakers_cleaned" TEXT,
"session_type" INTEGER,
"keywords" REAL,
"skill_level" INTEGER,
"session_title" TEXT
,
FOREIGN KEY ("skill_level") REFERENCES [skill_level](id),
FOREIGN KEY ("location_room") REFERENCES [location_room](id),
FOREIGN KEY ("session_type") REFERENCES [session_type](id))