Datasettes

Simon Willison edited this page May 25, 2018 · 18 revisions

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

Wireless Telegraphy Register

https://wtr-api.herokuapp.com/

A browsable interface to the UK's register of business radio licenses, built by @russss. Demonstrates the new units mechanism added in Datasette 0.18, e.g. https://wtr-api.herokuapp.com/wtr-663ea99/license_frequency?frequency__gt=50GHz&height__lt=50ft

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.

Lahman’s Baseball Database

https://baseballdb.lawlesst.net/ - published by Ted Lawless: http://lawlesst.github.io/notebook/baseball-datasette.html

NHS Hospitals

https://nhs-england-hospitals.now.sh/ from https://data.gov.uk/dataset/hospitals_ built by @tomdyson

FiveThirtyEight

https://fivethirtyeight.datasettes.com/ - data derived from https://github.com/fivethirtyeight/data

ParlGov

https://parlgov.datasettes.com/ - worldwide political data from http://www.parlgov.org/

Google Trends

https://google-trends.datasettes.com/ - data published by https://trends.google.com/trends/ from https://github.com/GoogleTrends/data

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

https://australian-dogs.now.sh/ - a number of different dog registration databases, pulled from https://data.sa.gov.au/data/dataset?q=dog+registration

Here's an example query showing the most common names of Chihuahuas registered in Australia

New York Cultural Institutions

https://nyc-cultural-institutions.now.sh/ - libraries and museums from https://github.com/mgiraldo/nyc-cultural-institutions-map

US Census Gazetteer

All of the TSV data from https://www.census.gov/geo/maps-data/data/gazetteer2017.html in Datasette: https://us-census-gazetteer-2017.now.sh/

Clone this wiki locally
You can’t perform that action at this time.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.
Press h to open a hovercard with more details.