Datasette Examples
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.
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
The Foreign Agents Registration Act
FARA is a US law that requires foreign lobbyists to register with the US Department of Justice.
fara.datasettes.com publishes data released by the DoJ and uses Datasette to make it searchable.
You can read more about how the project works in Tracking FARA by deploying a data API using GitHub Actions and Cloud Run.
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
FiveThirtyEight
https://fivethirtyeight.datasettes.com/ - data derived from https://github.com/fivethirtyeight/data
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.
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.
Lahman’s Baseball Database
https://baseballdb.lawlesst.net/ - published by Ted Lawless: http://lawlesst.github.io/notebook/baseball-datasette.html
ParlGov
https://parlgov.datasettes.com/ - worldwide political data from http://www.parlgov.org/
Polar Bears
https://polar-bears.now.sh/ - USGS Alaska Science Center data from https://alaska.usgs.gov/products/data.php?dataid=130 - here’s how it was built: https://gist.github.com/simonw/9f8bf23b37a42d7628c4dcc4bba10253
Australian Open Data
https://australian-dunnies.now.sh/ - public toilets in Australia, from https://data.gov.au/dataset/national-public-toilet-map