Skip to content

Datasettes

Simon Willison edited this page Apr 12, 2018 · 23 revisions

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/

Wireless Telegraphy Register

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

A browsable interface to the UK's register of business radio licenses, built by @russss

Clone this wiki locally