This data as JSON, CSV (advanced)
Suggested facets: clean_description, start_date_clean, start_time, end_time, pre_reg_flag, paid_flag
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27 | 27 | 4381 | CAR Conference registration (Friday) | CAR Conference registration will be located in Salon EF on the lobby level of the Newport Beach Marriott. | Salon EF 12 | 2019-03-08 | 2019-03-08 08:00:00 | 2019-03-08 17:00:00 | 1 | 1 | 0 | General 5 | ||||
| 28 | 28 | 4383 | CAR Conference registration (Saturday) | CAR Conference registration will be located in Salon EF on the lobby level of the Newport Beach Marriott. | Salon EF 12 | 2019-03-09 | 2019-03-09 08:30:00 | 2019-03-09 18:00:00 | 1 | 1 | 0 | General 5 | ||||
| 29 | 29 | 4379 | CAR Conference registration (Thursday) | CAR Conference registration will be located in Salon EF on the lobby level of the Newport Beach Marriott. | Salon EF 12 | 2019-03-07 | 2019-03-07 07:30:00 | 2019-03-07 18:00:00 | 1 | 1 | 0 | General 5 | ||||
| 30 | 30 | 4377 | CAR Conference registration (Wednesday) | CAR Conference registration will be located in Salon EF on the lobby level of the Newport Beach Marriott. | Salon EF 12 | 2019-03-06 | 2019-03-06 15:00:00 | 2019-03-06 18:00:00 | 1 | 1 | 0 | General 5 | ||||
| 31 | 31 | 4382 | CAR Conference sales (Friday) | Stop by the CAR Conference sales table and browse our merchandise, including the IRE bookstore's most popular titles and shirts with the winning design from the T-shirt contest. | Salon EF 12 | 2019-03-08 | 2019-03-08 08:00:00 | 2019-03-08 17:00:00 | 0 | 0 | 0 | General 5 | ||||
| 32 | 32 | 4384 | CAR Conference sales (Saturday) | Stop by the CAR Conference sales table and browse our merchandise, including the IRE bookstore's most popular titles and shirts with the winning design from the T-shirt contest. | Salon EF 12 | 2019-03-09 | 2019-03-09 08:30:00 | 2019-03-09 18:00:00 | 0 | 0 | 0 | General 5 | ||||
| 33 | 33 | 4385 | CAR Conference sales (Sunday) | Stop by the CAR Conference sales table and browse our merchandise, including the IRE bookstore's most popular titles and shirts with the winning design from the T-shirt contest. | Salon EF 12 | 2019-03-10 | 2019-03-10 09:00:00 | 2019-03-10 10:30:00 | 0 | 0 | 0 | General 5 | ||||
| 34 | 34 | 4380 | CAR Conference sales (Thursday) | Stop by the CAR Conference sales table and browse our merchandise, including the IRE bookstore's most popular titles and shirts with the winning design from the T-shirt contest. | Salon EF 12 | 2019-03-07 | 2019-03-07 07:30:00 | 2019-03-07 18:00:00 | 0 | 0 | 0 | General 5 | ||||
| 35 | 35 | 4378 | CAR Conference sales (Wednesday) | Stop by the CAR Conference sales table and browse our merchandise, including the IRE bookstore's most popular titles and shirts with the winning design from the T-shirt contest. | Salon EF 12 | 2019-03-06 | 2019-03-06 15:00:00 | 2019-03-06 18:00: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))