categories_with_animal_names
1 row where category = "Cat" sorted by animal
This data as json, CSV (advanced)
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "categories_with_animal_names" ( "category" TEXT NOT NULL UNIQUE, "animal" TEXT NOT NULL, FOREIGN KEY("category") REFERENCES "categories"("name") on update cascade on delete restrict, PRIMARY KEY("category") );