music_song
21 rows where release_id = 9
This data as json, CSV (advanced)
Suggested facets: publish_on, credits, lyrics, publish_on (date)
id ▼ | slug | publish | publish_on | title | description | credits | lyrics | track | release_id | player_code |
---|---|---|---|---|---|---|---|---|---|---|
13 | nurses-5-float-past | 1 | 2008-04-08 00:00:00 | Nurses 5 Float Past | Written by Ryan Walsh, © 2008 Reverse The Tape Decks (ASCAP) |
it's the memory you let go and so you slip on past the bazaar “is this an epilogue?” doc asks and while you sit and think about that |
7 | Portrait Of The Artist As A Young Trashcan 9 | ||
14 | dont-take-the-law | 1 | 2008-04-08 00:00:00 | Don't Take The Law Into Your Own Hands But Take Mine In Yours | Written by Ryan Walsh, © 2008 Reverse The Tape Decks (ASCAP) |
a bell for the brave Armenian waitress I'm the one to disintegrate into your dreamscape I remember the day machine wept into lakes I'm the one to camp out under the flagpole |
8 | Portrait Of The Artist As A Young Trashcan 9 | ||
15 | let-it-wave | 1 | 2008-04-08 00:00:00 | Let It Wave | Written by Ryan Walsh, © 2007 Reverse The Tape Decks (ASCAP) |
when you come again we schemed at the built in bar bankrupt birdhouse the crow got the word out the truth and the tooth came out now we're on our own let it wave |
9 | Portrait Of The Artist As A Young Trashcan 9 | ||
16 | cataloging-candys-demise | 1 | 2008-04-08 00:00:00 | Cataloging Candy's Demise | Written by Ryan Walsh, © 2008 Reverse The Tape Decks (ASCAP) |
built by science “the dysphemic alliance” the concierge signals it seems we have a single asleep at the spiel we tried so hard to feel sawed off sneakers |
17 | Portrait Of The Artist As A Young Trashcan 9 | ||
17 | when-night-falls | 1 | 2008-04-08 00:00:00 | When Night Falls | Written by Ryan Walsh, © 2008 Reverse The Tape Decks (ASCAP) |
outside nature beats the tar out of nature when night falls stitched on the inside of his jacket is a note for the doctor: when night falls a hand comes down and turns the airplane around when night falls |
18 | Portrait Of The Artist As A Young Trashcan 9 | ||
18 | monster-eyes | 1 | 2008-04-08 00:00:00 | Monster Eyes | Lyrics by Jonathan Lethem, music by Hallelujah The Hills |
get you out of range before my eyes destroy you |
19 | Portrait Of The Artist As A Young Trashcan 9 | ||
19 | die-before-me | 1 | 2008-04-08 00:00:00 | (You Better Hope You) Die Before Me [Live January 2008] | Written by Ryan Walsh, © 2008 Reverse The Tape Decks (ASCAP) |
the phone line is broken if you take it as a compliment everybody knows you climb a ladder so well dress me up in wires the house is infested so you can bang on every windchime |
10 | Portrait Of The Artist As A Young Trashcan 9 | ||
39 | ticking-sound | 1 | 2010-06-16 08:11:10 | That Ticking Sound You Hear | Written by Ryan Walsh, © 2010 Reverse The Tape Decks (ASCAP) |
I saw your name out of my mind and all of these unbelievable villains and that ticking sound hear |
14 | Portrait Of The Artist As A Young Trashcan 9 | ||
40 | introductory-saints | 1 | 2010-06-16 08:14:07 | Introductory Saints | Written by Ryan Walsh, © 2010 Reverse The Tape Decks (ASCAP) |
gentlemen and if it's true that we've all forgotten something our phones our wide open watch your weapons and if it's true that we've all forgotten something our phones our wide open |
12 | Portrait Of The Artist As A Young Trashcan 9 | ||
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 | |||
43 | some-of-them-we-lost | 1 | 2011-03-22 21:18:58 | Some Of Them We Lost | For the kids, at the time Was it me or was it you And some of them we lost when the city turned its lights out |
6 | Portrait Of The Artist As A Young Trashcan 9 | |||
44 | amateurs | 1 | 2011-11-16 09:05:00 | Amateurs | Big time issues in air tight jars We’re amateurs but we speak like pros No more light sources from the to and the fro A-M-A-T-E-U-R-S Later on we killed some time Make like millions & speak with care No more short cuts through the halls of the king A-M-A-T-E-U-R-S Amateurs! Amateurs! We wish you well, we wish you well “We’re Amateurs” A-M-A-T-E-U-R-S |
11 | Portrait Of The Artist As A Young Trashcan 9 | |||
45 | girls-are-here | 1 | 2011-11-16 09:06:00 | The Girls Are Here | The girls are here There’s nothing Come on team To the trustees of a verified nation Ooooooooh The girls are here Come on team Whatever it is in the way |
15 | Portrait Of The Artist As A Young Trashcan 9 | |||
56 | three-minute-mark | 1 | 2013-02-13 21:54:57 | The Three Minute Mark | Pour me a drink We once had our best interests Just press record I caught some heat in the reviews I’ll need about 3 minutes to explain just how I feel for you now |
5 | Portrait Of The Artist As A Young Trashcan 9 | |||
57 | meet-me-car | 1 | 2013-02-13 21:55:29 | Meet Me In The Car | Here we go Watch this space Go ahead and hook me to the polygraph I remember this! I am the setting sun |
4 | 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");