datasettes

1 row where license_hash = "06ea41f2"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ title url about_url description source_hash license_hash
14 California Protected Areas Database (CPAD 2020a) https://calands.datasettes.com/ https://simonwillison.net/2020/Aug/28/weeknotes-cpad/   6b6e4567 06ea41f2

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)
        );