published_songs (view)
9 rows where track = 3
This data as json, CSV (advanced)
Suggested facets: credits, lyrics, publish_on (date)
id | slug | publish | publish_on | title | description | credits | lyrics | track | release_id | player_code |
---|---|---|---|---|---|---|---|---|---|---|
3 | fight-song | 1 | 2007-06-01 00:00:00 | Hallelujah The Hills | Written by Ryan Walsh, © 2007 Reverse The Tape Decks (ASCAP) |
trouble comes, the mail arrives hundred horses, hundred wines plaintiff's here, jury's gone no more talk of mathmagicians |
3 | 1 | ||
28 | gurus | 1 | 2009-07-01 00:00:00 | Put The Gurus In Charge | Written by Ryan Walsh, © 2009 Reverse The Tape Decks (ASCAP) |
here we are where we thought we began so we’re traversing North Dakota the first thing to know is that you can never go back there call the cops you fell in love with the woman sent here to kill you you were brought here by design and now you’ll live until you die you’ll spend the next year always looking over your shoulder |
3 | 3 | ||
48 | care-to-collapse | 1 | 2012-04-01 21:12:14 | Care To Collapse |
|
You scribbled down these words for me: So keep it all under your hat |
3 | 7 | ||
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 | 9 | |||
66 | destroy-this-poem | 1 | 2014-05-03 08:22:29 | Destroy This Poem | Hey alright, we're cherry picking days till we die hey alright, can you believe we escaped alive? i'm doing ok I guess Hey alright, I figured out how to sleep through the night Cuz there's a lotta people saying |
3 | 10 | |||
78 | boquet-of-omens | 1 | 2015-04-06 21:21:56 | Boquet of Omens | 3 | 11 | ||||
82 | mountain-wanted-more | 1 | 2016-02-25 06:04:05 | The Mountain That Wanted More | i'm halting the mass production too wasted to hear the sirens at first I thought I was ocean |
3 | 12 | |||
93 | follow-these-prompts | 1 | 2016-07-04 16:40:10.311000 | Follow These Prompts | 3 | 13 | ||||
100 | running-hot-with-fate | 1 | 2019-10-03 11:56:18 | Running Hot with Fate |
Trisha went to Washington and lit up like a Christmas Tree
Alice wasn‘t kidding when she said she saw a UFO
Dori’s finally being who she always knew he was inside
Jamie’s back in rehab & this time he says it ain’t no joke
I’m running hot with it
Can u carve a new world
Is this free will
we‘re running hot with fate
(I don’t believe in it / but I’m running hot with it)
hot fate |
3 | 15 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW published_songs as select * from music_song where publish;