sessions

Data source: OpenNews/srccon-2020 · About: simonw/srccon-2020-datasette

1 row where event_dtend = "2020-07-15T13:00:00", event_dtstart = "2020-07-15T12:15:00" and timeblock = "wed-12pm" sorted by event_dtstart

Search:

descending

id	day	time	event_name	event_description	facilitators	break	everyone	facilitators_twitter	length	notepad	room	talk	timeblock	transcription	event_dtstart ▼	event_dtend	event_tzid	event_uid
wed-talks-alicia-tauhid	Wednesday	12:15-1pm ET	SRCCON Talks: Alicia Bell & Tauhid Chappell	Alicia Bell and Tauhid Chappell on campaigning and organizing as journalists and inside our own organizations.					45 minutes			y	wed-12pm	y	2020-07-15T12:15:00	2020-07-15T13:00:00	America/New_York	srccon-2020/wed-talks-alicia-tauhid

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE [sessions] (
   [id] TEXT PRIMARY KEY,
   [day] TEXT,
   [time] TEXT,
   [event_name] TEXT,
   [event_description] TEXT,
   [facilitators] TEXT,
   [break] TEXT,
   [everyone] TEXT,
   [facilitators_twitter] TEXT,
   [length] TEXT,
   [notepad] TEXT,
   [room] TEXT,
   [talk] TEXT,
   [timeblock] TEXT,
   [transcription] TEXT,
   [event_dtstart] TEXT,
   [event_dtend] TEXT,
   [event_tzid] TEXT,
   [event_uid] TEXT
);