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

6 rows where talk = "y" sorted by event_dtstart

View and edit SQL

Suggested facets: time, 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-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
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
thu-talks-john Thursday 11:15am-12pm ET SRCCON Talks: John Hernandez John Hernandez on burning it all down, and the problematic, inherited cultures imbued within journalism.         45 minutes     y thu-11am y 2020-07-16T11:15:00 2020-07-16T12:00:00 America/New_York srccon-2020/thu-talks-john
thu-talks-doris-samantha Thursday 5:30-6:15pm ET SRCCON Talks: Doris Truong & Samantha Ragland Doris Truong and Samantha Ragland on how no matter where you are on your organization’s ladder, you have agency and you have power.         45 minutes     y thu-530pm y 2020-07-16T17:30:00 2020-07-16T18:15:00 America/New_York srccon-2020/thu-talks-doris-samantha
fri-talks-moiz-ellis Friday 11:15am-12pm ET SRCCON Talks: Moiz Syed & Ellis Simani Moiz Syed and Ellis Simani on objectivity, privilege, and how both bleed into how journalism interacts with protests.         45 minutes     y fri-11am y 2020-07-17T11:15:00 2020-07-17T12:00:00 America/New_York srccon-2020/fri-talks-moiz-ellis
fri-talks-royal Friday 3-3:45pm ET SRCCON Talks: Destinée-Charisse Royal Destinée-Charisse Royal on how to have difficult but effective conversations with people about racism, sexism, you name it.         45 minutes     y fri-3pm y 2020-07-17T15:00:00 2020-07-17T15:45:00 America/New_York srccon-2020/fri-talks-royal

Advanced export

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

CSV options:

CREATE TABLE [sessions] (
   [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 36.878ms · Data source: OpenNews/srccon-2020 · About: simonw/srccon-2020-datasette