sessions

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

1 row where day = "Friday", event_dtend = "2020-07-17T13:45:00" and facilitators = "Steven Rich, Disha Raychaudhuri" sorted by event_dtstart

View and edit SQL

Suggested facets: 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
fri-policing Friday 12:30-1:45pm ET Policing the police With police always in the news, let’s talk about how to best investigate them and what newsrooms generally get wrong in reporting on police (believing everything they say, for one). Steven Rich, Disha Raychaudhuri       75 minutes       fri-1230pm   2020-07-17T12:30:00 2020-07-17T13:45:00 America/New_York srccon-2020/fri-policing

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