sessions

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

3 rows where everyone = "y" sorted by event_dtstart

View and edit SQL

Suggested facets: event_description, length, event_dtstart (date), event_dtend (date)

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-opening Wednesday 12-12:15pm ET SRCCON 2020 opening       y           wed-12pm y 2020-07-15T12:00:00 2020-07-15T12:15:00 America/New_York srccon-2020/wed-opening
thu-opening Thursday 11-11:15am ET OpenNews special DEI Coalition announcement We're really excited.     y   15 minutes       thu-11am y 2020-07-16T11:00:00 2020-07-16T11:15:00 America/New_York srccon-2020/thu-opening
fri-closing Friday 5:30-6pm ET SRCCON closing       y           fri-530pm y 2020-07-17T17:30:00 2020-07-17T18:00:00 America/New_York srccon-2020/fri-closing

Advanced export

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

CSV options:

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
);
Powered by Datasette · Query took 35.086ms · Data source: OpenNews/srccon-2020 · About: simonw/srccon-2020-datasette