datasette_tags

3 rows where tag = "uk"

descending

Link	datasette_id	tag
2,uk	UK Registers of Members Interest 2	uk
10,uk	Wireless Telegraphy Register 10	uk
12,uk	Ministry of Defence MERLIN Vehicle Database 12	uk

Advanced export

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

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