Data source: OpenNews/srccon-2020 · About: simonw/srccon-2020-datasette
This data as json, ics, CSV (advanced)
Suggested facets: 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 | ||||||||
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 |
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 );