home / hth

music_song

4 rows where release_id = 11

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: publish_on (date)

id ▼ slug publish publish_on title description credits lyrics track release_id player_code
76 compulsory-champagne 1 2015-04-06 21:20:14 Compulsory Champagne       1 Juvenile Oratorios EP 11  
77 devil-level-zero 1 2015-04-06 21:20:50.023000 Devil Level Zero       2 Juvenile Oratorios EP 11  
78 boquet-of-omens 1 2015-04-06 21:21:56 Boquet of Omens       3 Juvenile Oratorios EP 11  
79 kicked-in-the-feels 1 2015-04-06 21:22:30.247000 Kicked in the Feels       4 Juvenile Oratorios EP 11  

Advanced export

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

CSV options:

CREATE TABLE "music_song" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "slug" varchar(50) NOT NULL UNIQUE, "publish" bool NOT NULL, "publish_on" datetime NULL, "title" varchar(200) NOT NULL, "description" text NOT NULL, "credits" text NOT NULL, "lyrics" text NOT NULL, "track" integer unsigned NULL, "release_id" integer NULL REFERENCES "music_release" ("id"), "player_code" text NOT NULL);
CREATE INDEX "music_song_release_id_d94af625" ON "music_song" ("release_id");
Powered by Datasette · Queries took 8.848ms