sessions

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

1 row where day = "Wednesday" and timeblock = "wed-930pm" sorted by talk

View and edit SQL

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

transcription

  • y 1

timeblock

  • wed-930pm · 1

day

  • Wednesday · 1
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-tasneem-candice Wednesday 9:30-10:15pm ET SRCCON Talks: Tasneem Raja in conversation with Candice Fortman Tasneem Raja in conversation with Candice Fortman, on the joys and challenges of being a woman of color leading her own newsroom, while working within an ecosystem of racist policies and institutions.         45 minutes     y wed-930pm y 2020-07-15T21:30:00 2020-07-15T22:15:00 America/New_York srccon-2020/wed-talks-tasneem-candice

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 46.177ms · Data source: OpenNews/srccon-2020 · About: simonw/srccon-2020-datasette