datasette_tags
4 rows where tag = "templated"
This data as json, CSV (advanced)
| Link | datasette_id | tag |
|---|---|---|
| 17,templated | Datasette 17 | templated |
| 18,templated | www.niche-museums.com 18 | templated |
| 19,templated | Today I Learned 19 | templated |
| 20,templated | Rocky Beaches 20 | templated |
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)
);