datasette_tags

3 rows where datasette_id = 3 sorted by datasette_id descending

View and edit SQL

Link datasette_id ▲ tag
San Francisco 3 government
San Francisco 3 san-francisco
San Francisco 3 usa

Advanced export

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

CSV options:

CREATE TABLE datasette_tags (
            datasette_id integer,
            tag text,
            PRIMARY KEY (datasette_id, tag),
            FOREIGN KEY (datasette_id) REFERENCES datasettes(id),
            FOREIGN KEY (tag) REFERENCES tags(tag)
        );
Powered by Datasette · Query took 7.598ms