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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 159 | 159 | 4353 | Media lawyers brown bag | **Moderated by Maggie Mulvihill, Boston University During the media lawyers brown bag, between 12:45 and 1:45 p.m. on Friday, March 8, bring your lunch and your questions for a personal discussion with a panel of media lawyers and FOIA-savvy speakers. IRE & NICAR will provide drinks and dessert. | Cardiff 10 | 2019-03-08 | 2019-03-08 12:45:00 | 2019-03-08 13:45:00 | 0 | 0 | 0 | Maggie Mulvihill, Boston University (moderator); Katie Townsend, Reporters Committee for Freedom of the Press; Tina Salvato & Matthew Halgren, Sheppard Mullin; Adam Marshall, Reporters Committee for Freedom of the Press | Brownbag 7 | General interest 1 | Media lawyers brown bag |
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))