datasettes

1 row where source_hash = "1b3aa3aa"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ title url about_url description source_hash license_hash
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)
        );