This data as JSON, CSV (advanced)
Suggested facets: clean_description, start_date_clean, pre_reg_flag, paid_flag, speakers_cleaned, session_type, skill_level, session_title
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 53 | 53 | 4095 | Digging into data for stories (cont'd-Saturday) *pre-registered attendees only | This is a continuation of Digging into data for stories: A crash course from Friday, March 8 for pre-registered attendees of this class. | Salon 4 15 | 2019-03-09 | 2019-03-09 14:15:00 | 2019-03-09 17:45:00 | 0 | 0 | 0 | IRE & NICAR staff | Hands-on 3 | Beginner 4 | Digging into data for stories: A crash course in Excel - Group B *pre-registered attendees only | |
| 54 | 54 | 4096 | Digging into data for stories (cont'd-Sunday) *pre-registered attendees only | This is a continuation of Digging into data for stories: A crash course from Saturday, March 9 for pre-registered attendees of this class. | Salon 4 15 | 2019-03-10 | 2019-03-10 09:00:00 | 2019-03-10 12:30:00 | 0 | 0 | 0 | General 5 | ||||
| 55 | 55 | 4089 | Digging into data for stories: A crash course in Excel - *pre-registered attendees only | Skill level: Beginner?? Get started with using data in your stories with IRE's original mini-boot camp. In this 9-hour, hands-on workshop, IRE’s experienced trainers will start with the basics of navigating Excel and using formulas, then walk you through sorting, filtering and aggregating data with PivotTables to find story ideas. You'll come away with a solid base for using data analysis in your newsroom, including how to find and request data, identify and clean dirty data, find story ideas and bulletproof your work. We’ll also provide you with our detailed boot camp materials to help keep you on track long after you leave the conference. Preregistration is required and seating is limited. Laptops will be provided for the training.? Workshop prerequisites: There are no prerequisites for this workshop and beginners are welcome. This workshop is good for those wanting to get started analyzing data for stories. Workshop times are Friday, March 8, 2:15 p.m. - 5:45 p.m.; Saturday, March 9, 2:15 p.m. - 5:45 p.m.; Sunday, March 10, 9:00 a.m. - 12:30 p.m. (Registration for this session reserves your seat for all days of this workshop and attendees are expected to attend all sessions to complete the workshop.) | Salon 4 15 | 2019-03-08 | 2019-03-08 14:15:00 | 2019-03-08 17:45:00 | 1 | 1 | 0 | IRE & NICAR staff | Hands-on 3 | Beginner 4 | Digging into data for stories: A crash course in Excel - Group A *pre-registered attendees only | |
| 124 | 124 | 4134 | Interviewing your data with SQL (cont'd Friday) **pre-registered attendees only | his is a continuation of Interviewing your data with SQL from Thursday, March 7 for pre-registered attendees of this class. | Salon 4 15 | 2019-03-08 | 2019-03-08 09:00:00 | 2019-03-08 12:30:00 | 0 | 0 | 0 | General 5 | ||||
| 125 | 125 | 4113 | Interviewing your data with SQL **pre-registered attendees only | Skill level: Intermediate If you flip over pivot tables, but wish you had more data tools, this session is for you. Structured Query Language, or SQL, can help you use powerful filtering functions, find patterns in millions of records and join multiple data tables. This class will be taught by two experienced data reporters and former IRE trainers, and materials will include the IRE Computer-Assisted Reporting boot camp binder, full of exercises, cheat sheets and tips to help you boost your data analysis and storytelling skills. We will use a free database manager that can be easily installed and used on any computer. Preregistration is required and seating is limited. Laptops will be provided for the training. Workshop prerequisites: The only prerequisites are a reasonable comfort level with using a spreadsheet. No previous SQL skills necessary. This class takes place on Thursday, March 7 from 2:15-5:45 p.m. and continues Friday, March 8, 9 a.m. - 12:30 p.m. (Registration for this session reserves your seat for both days of this workshop and attendees are expected to attend both sessions to complete the workshop.) | Salon 4 15 | 2019-03-07 | 2019-03-07 14:15:00 | 2019-03-07 17:45:00 | 1 | 1 | 0 | Liz Lucas, Kaiser Health News; Megan Luther, InvestigateTV | Hands-on 3 | Intermediate 2 | Interviewing your data with SQL *pre-registered attendees only | |
| 213 | 213 | 4254 | SQL 1: Exploring data | Learning to manipulate data is a bit like learning a new language. Actually, it is a language, called structured query language (SQL). This session is an introduction to using SQL to zero in on your data by viewing slices and chunks of it and putting it into a useful order so you can spot the stuff you need to get started toward a story. We'll use SQLite and DB Browser, a free database manager. This session is good for: People with some experience working with data in columns and rows, in spreadsheets or database managers. | Salon 4 15 | 2019-03-07 | 2019-03-07 09:00:00 | 2019-03-07 10:00:00 | 0 | 0 | 0 | Kendall Taggart, Buzzfeed News | Hands-on 3 | Intermediate 2 | SQL 1: Exploring data | |
| 214 | 214 | 4292 | SQL 1: Exploring data (repeat) | Learning to manipulate data is a bit like learning a new language. Actually, it is a language, called structured query language (SQL). This session is an introduction to using SQL to zero in on your data by viewing slices and chunks of it and putting it into a useful order so you can spot the stuff you need to get started toward a story. We'll use SQLite and DB Browser, a free database manager. This session is good for: People with some experience working with data in columns and rows, in spreadsheets or database managers. | Salon 4 15 | 2019-03-09 | 2019-03-09 09:00:00 | 2019-03-09 10:00:00 | 0 | 0 | 0 | Fedor Zarkin, The Oregonian | Hands-on 3 | SQL 1: Exploring data (repeat) | ||
| 215 | 215 | 4255 | SQL 2: Grouping and summing data | If you know how to write a basic SELECT statement in SQL but are looking to make calculations, then this is the session for you. Learn to count how many times certain records appear in a database, and sum totals across records. These skills can come in handy whether you're covering campaign finance or boating licenses. We'll use SQLite and DB Browser, a free database manager. This session is good for: People who took “SQL 1: Exploring data” or are familiar with “SELECT” and “WHERE” statements in SQL. | Salon 4 15 | 2019-03-07 | 2019-03-07 10:15:00 | 2019-03-07 11:15:00 | 0 | 0 | 0 | Matt Kiefer, The Chicago Reporter | Hands-on 3 | Intermediate 2 | SQL 2: Grouping and summing data | |
| 216 | 216 | 4293 | SQL 2: Grouping and summing data (repeat) | If you know how to write a basic SELECT statement in SQL but are looking to make calculations, then this is the session for you. Learn to count how many times certain records appear in a database, and sum totals across records. These skills can come in handy whether you're covering campaign finance or boating licenses. We'll use SQLite and DB Browser, a free database manager. This session is good for: People who took “SQL 1: Exploring data” or are familiar with “SELECT” and “WHERE” statements in SQL. | Salon 4 15 | 2019-03-09 | 2019-03-09 10:15:00 | 2019-03-09 11:15:00 | 0 | 0 | 0 | Dave Sheingold, The Record | Hands-on 3 | SQL 2: Grouping and summing data (repeat) | ||
| 217 | 217 | 4256 | SQL 3: Joining tables | Learn how to join tables, matching information from one file to another. We'll use SQLite and DB Browser, a free database manager. This session is good for: People who are familiar with counting, summing or “GROUP BY” in SQL and want to add another tool to their SQL skill set. | Salon 4 15 | 2019-03-07 | 2019-03-07 11:30:00 | 2019-03-07 12:30:00 | 0 | 0 | 0 | Chad Day, The Associated Press | Hands-on 3 | Intermediate 2 | SQL 3: Joining tables | |
| 218 | 218 | 4270 | SQL CARwash: Cleaning dirty data | Spend enough time around databases and inevitably you’ll come across one that has an obnoxious number of variations on city names: New York City. New York. NYC. NY. And yes, even NY City. If you’re not sure how to handle that, this session is for you. We’ll cover how to deal with multiple spellings and misspellings, strange date formats and category codes, as well as a few other tricks and tips for using SQL to clean data. This session will be most useful if: You are familiar with basic SQL statements. | Salon 4 15 | 2019-03-09 | 2019-03-09 11:30:00 | 2019-03-09 12:30:00 | 0 | 0 | 0 | Madi Alexander, Bloomberg BNA | Hands-on 3 | Intermediate 2 | SQL CARwash: Cleaning dirty data |
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))