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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 245 | 245 | 4349 | Welcome first-timers | Welcome to the conference! Hear from IRE staff about tips and tactics to navigate our conference like a pro. Also, you'll learn about key resources that IRE offers once you're back home. | Salon C 7 | 2019-03-07 | 2019-03-07 08:30:00 | 2019-03-07 08:50:00 | 0 | 0 | 0 | Doug Haddix & Denise Malan, IRE/NICAR | Special 8 | General interest 1 | Welcome first-timers |
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))