sessions

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

1 row where day = "Thursday" and facilitators = "Steven Rich" sorted by break

View and edit SQL

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

timeblock

facilitators

  • Steven Rich · 1

day

  • Thursday · 1
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
thu-woodworking Thursday 7-8pm ET How to make tables...out of wood An introduction to the hobby of woodworking, you'll learn some basics and be able to ask anything you want to learn about woodworking in this hands-on(ish) session from the databae woodshop. Steven Rich y             thu-7pm   2020-07-16T19:00:00 2020-07-16T20:00:00 America/New_York srccon-2020/thu-woodworking

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