datasettes

1 row where source_hash = "fa9e0524"

✎ View and edit SQL

This data as json, CSV (advanced)

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

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