home / csvconf

talks

Data source: https://csvconf.com/

2 rows where room = "Daisy Bingham Room" and time = "2:00 PM" sorted by datetime

View and edit SQL

day

datetime

time

room

Link rowid title speaker time day room url datetime ▼ abstract image
19 Hacking Open Data in Africa Soila Kenya 2:00 PM May 8 2019 Daisy Bingham Room https://csvconf.com/speakers/#soila-kenya 2019-05-08T14:00:00 This talk will cover the tips & tricks of community-sourcing for openAFRICA.net - the largest independent repository of open data on the African continent - used in order to digitise deadwood to give citizens actionable information. Data availability in many African countries is dismal. Files upon files of important government information lay gathering dust in abandoned storage rooms. On the other hand, journalists and citizens need this information to keep governments in check and ensure they are receiving the right services. So how do you turn paper-based government archives into machine readable & API accessible digital files? https://csvconf.com/img/speakers-2019/skenya.jpg
45 Datasette Simon Willison 2:00 PM May 9 2019 Daisy Bingham Room https://csvconf.com/speakers/#simon-willison 2019-05-09T14:00:00 Datasette is a tool for instantly publishing structured data on the internet. It makes it easy to construct and execute arbitrary SQL queries (using SQLite) and export the results as CSV. It's accompanying tool csvs-to-sqlite makes it easy to convert CSV files into a SQLite database. More info at https://github.com/simonw/datasette https://csvconf.com/img/speakers-2019/swillison.jpg

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [talks] (
   [title] TEXT,
   [speaker] TEXT,
   [time] TEXT,
   [day] TEXT,
   [room] TEXT,
   [url] TEXT,
   [datetime] TEXT,
   [abstract] TEXT,
   [image] TEXT
)
Powered by Datasette · Query took 6.385ms · Data source: https://csvconf.com/