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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 123 | 123 | 4371 | International meet & greet **invitation-only event | NA | Baycliff 18 | 2019-03-07 | 2019-03-07 07:30:00 | 2019-03-07 08:15:00 | 0 | 0 | 0 | General 5 | ||||
| 160 | 160 | 4373 | Mentoring Breakfast (Sponsored by Donald W. Reynolds Journalism Institute) **invitation-only event | NA | Baycliff 18 | 2019-03-08 | 2019-03-08 07:30:00 | 2019-03-08 08:45:00 | 0 | 0 | 0 | General 5 |
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))