Datasettes

Covid-19 cases and deaths

https://covid-19.datasettes.com/ uses data from Johns Hopkins CSSE, the New York Times and the LA Times to show Covid-19 cases and deaths around the USA and the world. It updates several times a day as new data becomes available.

SBA Paycheck Protection Program Loan Data

https://sba-loans-covid-19.datasettes.com/ shows recipients of Covid-19 Paycheck Protection Program loans, using data released by the Small Business Administration.

Public Data Release of Stack Overflow’s 2019 Developer Survey

Hosted here: https://2019-stackoverflow-datasette.glitch.me/

Read more about it on the Glitch blog and the Stack Overflow blog.

Global Power Plants Database

https://global-power-plants.datasettes.com

Data from http://www.wri.org/publication/global-power-plant-database

Deployed automatically when the underlying data changes by https://github.com/simonw/global-power-plants-datasette

UK Register of Members Interests

https://register-of-members-interests.datasettes.com/ - background here: https://simonwillison.net/2018/Apr/25/register-members-interests/ source code here: https://github.com/simonw/register-of-members-interests

San Francisco Open Data

https://san-francisco.datasettes.com/ - datasets derived from https://data.sfgov.org/browse

https://simonwillison.net/2017/Nov/25/new-in-datasette/ has various tutorials relating to this data.

VICE News Police Shootings

https://vice-police-shootings.now.sh/vice-bc7c892/ViceNews_FullOISData

Notes on how this was created: https://gist.github.com/simonw/6785c842e6b0849aee3a9b1ef59d492e

Himalayan Database

This is not yet hosted publicly, but Raffaele Messuti‏ provides step-by-step instructions in From Visual FoxPro GUI to JSON API with Datasette for converting http://himalayandatabase.com/ to SQLite for exploration with Datasette.