datasettes

12 rows

View and edit SQL

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 VICE News Police Shootings https://vice-police-shootings.now.sh/ https://gist.github.com/simonw/6785c842e6b0849aee3a9b1ef59d492e  
5 Lahman’s Baseball Database https://baseballdb.lawlesst.net/ http://lawlesst.github.io/notebook/baseball-datasette.html  
6 Five Thirty Eight https://fivethirtyeight.datasettes.com/     e2bdbdb5 953f8894
7 OpenStreetMap Time Zone Boundaries https://timezones-api.now.sh/ https://simonwillison.net/2017/Dec/12/location-time-zone-api/   0b479e1f 92c02496
8 The Metropolitan Museum of Art Open Access https://metmuseum.datasettes.com/     dc32b82f d58f2233
9 IPNI plant names https://ipni.sloppy.zone/ https://twitter.com/rdmpage/status/1005121822273277952  
10 Wireless Telegraphy Register https://wtr-api.herokuapp.com/    
11 Datasette Registry https://registry.datasette.io/    
12 Ministry of Defence MERLIN Vehicle Database http://mod-merlin.herokuapp.com/     c30bdfb1

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 · Query took 11.87ms