sessions

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

1 row where "event_dtend" is on date 2020-07-17, facilitators = "Steven Rich, Disha Raychaudhuri" and length = "75 minutes" 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 34.183ms · Data source: OpenNews/srccon-2020 · About: simonw/srccon-2020-datasette