datasette_tags

17 rows

descending

Link	datasette_id	tag
1,geospatial	Global Power Plant Database 1	geospatial
2,politics	UK Registers of Members Interest 2	politics
2,uk	UK Registers of Members Interest 2	uk
3,government	San Francisco 3	government
3,san-francisco	San Francisco 3	san-francisco
3,usa	San Francisco 3	usa
4,news	VICE News Police Shootings 4	news
5,baseball	Lahman’s Baseball Database 5	baseball
5,sports	Lahman’s Baseball Database 5	sports
8,art	The Metropolitan Museum of Art Open Access 8	art
8,museums	The Metropolitan Museum of Art Open Access 8	museums
8,nyc	The Metropolitan Museum of Art Open Access 8	nyc
9,nature	IPNI plant names 9	nature
10,uk	Wireless Telegraphy Register 10	uk
11,datasette	Datasette Registry 11	datasette
12,military	Ministry of Defence MERLIN Vehicle Database 12	military
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)
        );