home / registry

datasettes

21 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_hash, license_hash

id ▼ title url about_url description source_hash license_hash
1 Global Power Plant Database https://global-power-plants.datasettes.com/ https://github.com/simonw/global-power-plants-datasette   65ef650f 953f8894
2 UK Registers of Members Interest https://register-of-members-interests.datasettes.com/ https://simonwillison.net/2018/Apr/25/register-members-interests/ MPs declare conflicts of interest, and sources of their income. 7b73837f
3 San Francisco https://san-francisco.datasettes.com/     4e5e9de5
4 Lahman's Baseball Database https://baseballdb.lawlesst.net/ http://lawlesst.github.io/notebook/baseball-datasette.html  
5 Five Thirty Eight https://fivethirtyeight.datasettes.com/     e2bdbdb5 953f8894
6 Time zones API https://timezones.datasette.io/ https://simonwillison.net/2017/Dec/12/location-time-zone-api/ An API for looking up time zones by latitude/longitude 0b479e1f 92c02496
7 The Metropolitan Museum of Art Open Access https://metmuseum.datasettes.com/     dc32b82f d58f2233
8 Datasette Registry https://registry.datasette.io/    
9 COVID-19 cases, using data from Johns Hopkins CSSE, the New York Times and the LA Times https://covid-19.datasettes.com https://github.com/simonw/covid-19-datasette  
10 The Foreign Agents Registration Act https://fara.datasettes.com/ https://simonwillison.net/2020/Jan/21/github-actions-cloud-run/   0ce57351
11 COVID-19 SBA loans above 150k https://sba-loans-covid-19.datasettes.com/ https://simonwillison.net/2020/Jul/9/sba-covid-19-ppp-loans/   fa9e0524
12 Members of the United States Congress https://congress-legislators.datasettes.com/ https://github.com/simonw/congress-legislators-datasette   eb0171cd 139189c6
13 San Francisco Microscopical Society Archive https://archive.sfmicrosociety.org/ https://simonwillison.net/2022/Aug/25/sfms-archive/  
14 California Protected Areas Database (CPAD 2020a) https://calands.datasettes.com/ https://simonwillison.net/2020/Aug/28/weeknotes-cpad/   6b6e4567 06ea41f2
15 github-to-sqlite demo https://github-to-sqlite.dogsheep.net/ https://github.com/dogsheep/github-to-sqlite  
16 LAION-Aesthetics v2 6+ https://laion-aesthetic.datasette.io/ https://simonwillison.net/2022/Sep/5/laion-aesthetics-weeknotes/   c294dc75
17 Datasette https://datasette.io/ https://simonwillison.net/2020/Dec/13/datasette-io/  
18 www.niche-museums.com https://www.niche-museums.com/ https://simonwillison.net/2019/Nov/25/niche-museums/  
19 Today I Learned https://til.simonwillison.net/ https://github.com/simonw/til  
20 Rocky Beaches https://www.rockybeaches.com/us/pillar-point https://github.com/natbat/rockybeaches  
21 ScotRail announcements https://scotrail.datasette.io/ https://simonwillison.net/2022/Aug/21/scotrail/   1b3aa3aa

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE datasettes (
            id integer PRIMARY KEY,
            title text,
            url text,
            about_url text,
            description text,
            source_hash text,
            license_hash text,
            FOREIGN KEY (source_hash) REFERENCES sources(hash),
            FOREIGN KEY (license_hash) REFERENCES licenses(hash)
        );
Powered by Datasette · Queries took 18.765ms