music_song
7 rows where "publish_on" is on date 2013-05-07 and release_id = 9
This data as json, CSV (advanced)
Suggested facets: lyrics, publish_on (date)
id ▼ | slug | publish | publish_on | title | description | credits | lyrics | track | release_id | player_code |
---|---|---|---|---|---|---|---|---|---|---|
42 | country-before-kings | 1 | 2013-05-07 20:00:00 | Country Before Kings | Knock, knock here I am a civilian outpost Last night I figured out how this will work Country Before Kings! And kings after: For Christ’s sake knock it off Country Before Kings! And kings after: |
2 | Portrait Of The Artist As A Young Trashcan 9 | |||
58 | honey-dont-it-all-seem-so-phony | 1 | 2013-05-07 22:44:20 | Honey, Don't It All Seem So Phony | My twin teleprompters humming in the night I saw you breaking down in a magazine But I assure you Ladies & gentlemen, may I introduce While you’re back home making real life moves But I assure you I been running a marathon But I assure you I’m gonna build a world that won’t fall apart |
1 | Portrait Of The Artist As A Young Trashcan 9 | |||
59 | confessions-ex-ghost | 1 | 2013-05-07 22:45:11 | Confessions Of An Ex-Ghost | Well I used to be a ghost You know I can’t recall my name (trap door looming in the morning sky) I’m coming back not without injuries I used to be a ghost |
3 | Portrait Of The Artist As A Young Trashcan 9 | |||
60 | every-has-potency | 1 | 2013-05-07 22:45:51.171000 | Every # Has A Potency | 13 | Portrait Of The Artist As A Young Trashcan 9 | ||||
61 | wave-backwards-massachusetts-big-digits-remix | 1 | 2013-05-07 22:46:14.033000 | Wave Backwards To Massachusetts (Big Digits Remix) | 16 | Portrait Of The Artist As A Young Trashcan 9 | ||||
62 | elementary-zombie | 1 | 2013-05-07 22:46:58.175000 | Elementary Zombie | 20 | Portrait Of The Artist As A Young Trashcan 9 | ||||
63 | portrait-artist-young-trashcan | 1 | 2013-05-07 22:47:28 | Portrait Of The Artist As A Young Trashcan | In the haunted mansion The future holds me hostage It’s neverending In a clapboard palace It’s like I told you Portrait of the artist |
21 | Portrait Of The Artist As A Young Trashcan 9 |
Advanced export
JSON shape: default, array, newline-delimited, object
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");