published_songs (view)
12 rows where "publish_on" is on date 2014-05-03
This data as json, CSV (advanced)
Suggested facets: player_code, publish_on (date)
id | slug | publish | publish_on | title | description | credits | lyrics | track | release_id | player_code |
---|---|---|---|---|---|---|---|---|---|---|
64 | we-are-what-we-say-we-are | 1 | 2014-05-03 08:21:25 | We Are What We Say We Are | nevermind religion we've got other fields to plow Here comes that old occult feeling call to order secret cults, their intent still unknown Here comes that old occult feeling may I interrupt this dance? We are what we say we are |
1 | 10 | <iframe style="border: 0; width: 100%; height: 42px;" src="https://bandcamp.com/EmbeddedPlayer/album=2575058676/size=small/bgcol=ffffff/linkcol=0687f5/artwork=none/track=1609842071/transparent=true/" seamless><a href="http://hallelujahthehills.bandcamp.com/album/have-you-ever-done-something-evil">Have You Ever Done Something Evil? by Hallelujah The Hills</a></iframe> | ||
65 | try-instead | 1 | 2014-05-03 08:22:04 | Try This Instead | Just read my rights it's hard to start again try this instead what's behind the words Let's punch up the storylines try this instead |
2 | 10 | |||
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 | |||
67 | do-you-have-romantic-courage | 1 | 2014-05-03 08:22:50 | Do You Have Romantic Courage? | Knock me in the head, make it good, lay me out, save my life Do you have romantic courage? I’m responsible for edits that removed this line right here If I had romantic courage Do you have romantic courage? |
4 | 10 | |||
68 | i-stand-corrected | 1 | 2014-05-03 08:23:28 | I Stand Corrected | You’ve been selected to participate & if you’re all alone when the shit goes down Is everybody wasting your time? |
5 | 10 | |||
69 | home-movies | 1 | 2014-05-03 08:24:12 | Home Movies | If you feel like your mother please drop to your knees i've been watching home movies trying to stamp out the doubt we came to paint the myths of lead guitarists Have you ever done something evil? |
6 | 10 | |||
70 | a-domestic-zone | 1 | 2014-05-03 08:24:29 | A Domestic Zone | Meet my wife Watch your back Let’s slow down Watch your back Tap the phone Watch your back |
7 | 10 | |||
71 | pick-up-an-old-phone | 1 | 2014-05-03 08:24:58 | Pick Up An Old Phone | First impressions first My most insistent dream The rest is up to us Pick up an old phone and hear the future coming back for you Everything is on it’s way Last impressions last |
8 | 10 | |||
72 | the-posssible-nows | 1 | 2014-05-03 08:25:16 | The Posssible Nows | I could pass a polygraph Guess which state i'm calling from when you think it's gonna stop it just starts again I could build a monument my lawyer calls, the house explodes you're gorgeous, like a painting, like some outsider art you can stare down the lanes into makeshift frames We could try some ritual |
9 | 10 | |||
73 | mcmliv-continuity-error | 1 | 2014-05-03 08:26:14 | MCMLIV (Continuity Error) | Someone clapped the slate and we all came to sudden life would you believe we've got a problem with continuity? i'm the director of this film 6 8 24 we're losing light |
10 | 10 | |||
74 | phenomenonology | 1 | 2014-05-03 08:26:29 | Phenomenonology | I promise to keep this embarassing take this take land Divine times on the dotted lines I came to on the floor Divine times on the dotted lines |
11 | 10 | |||
75 | you-got-fooled | 1 | 2014-05-03 08:26:48.332000 | You Got Fooled | 12 | 10 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW published_songs as select * from music_song where publish;