sessions

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

1 row where facilitators = "Jon Schleuss, Erin Petenko, Lauren Aguirre" sorted by event_dtstart

View and edit SQL

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

timeblock

facilitators

  • Jon Schleuss, Erin Petenko, Lauren Aguirre · 1

day

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-unionizing Wednesday 8-9:15pm ET Let's talk about unionizing: We did it (or we're doing it right now), ask us anything This will be an off-the-record conversation about what it takes to organize a newsroom union. We’ll share our experiences, the steps we took and what’s happening across the country. We’ll then open it up for any questions you want to talk about: why form a union? How does it work? Is it worth it? What can you actually improve? And what mistakes did you make? Jon Schleuss, Erin Petenko, Lauren Aguirre       75 minutes       wed-8pm   2020-07-15T20:00:00 2020-07-15T21:15:00 America/New_York srccon-2020/wed-unionizing

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