This data as JSON, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | 2 | 4162 | 25th CAR: What a ride it's been! | Buckle up for a fast-paced ride through 25 years of data journalism, told through the people who drove CAR into the mainstream of investigative reporting. You’ll hear about pivotal moments, bizarre twists and befuddled bureaucrats who didn’t know what hit them. Featuring special guests! Expected guest speakers include Crina Boros, Center for Investigative Journalism; Sarah Cohen, ASU Walter Cronkite School of Journalism; Steve Doig, ASU Walter Cronkite School of Journalism; Jaimi Dowdell, Reuters; Mark Horvit, University of Missouri; Brant Houston, University of Illinois; Clarence Jones, independent journalist; Jennifer LaFleur, Investigative Reporting Workshop; and James B. Steele, independent journalist. | Salon C&D 2 | 2019-03-08 | 2019-03-08 15:30:00 | 2019-03-08 16:30:00 | 0 | 0 | 0 | Doug Haddix, IRE/NICAR; Shawn McIntosh, Atlanta Journal-Constitution | Panel 1 | General interest 1 | 25th CAR: What a ride it's been! | |
| 36 | 36 | 4302 | CAR throwback | This year, we’re going way, way back. We’ll take you on a ride on the Information Superhighway 1990s style. We’ll tell you about the tools we used to work with records on a computer! Expect classic NICAR datasets, dated references and more lame jokes. Along with the history lesson, we will provide some of the same data tips that are vital to data journalism. | Salon C&D 2 | 2019-03-08 | 2019-03-08 14:15:00 | 2019-03-08 15:15:00 | 0 | 0 | 0 | Jennifer LaFleur, Investigative Reporting Workshop (moderator); Cheryl Phillips, Stanford University; Aron Pilhofer, Temple University | Demo 2 | General interest 1 | CAR throwback |
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))