published_songs (view)

1 row where "publish_on" is on date 2016-02-25 and track = 7

✎ 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
86 play-it-as-it-loops 1 2016-02-25 06:05:55 Play It As It Loops    

I should have scattered my private life
like a magazine in the trees

got tangled in telemarketing
dialed homesteads, look at these

it's a wow, i'm on fire, it's amazing so bring it to me

I couldn't suspend my disbelief
or invest in foreshadowing

unreliable narrators in my bed
how will they describe how I sleep?

“through the night / he lays bare
in the morning he's not even here”

it is what it is but it's not what we thought
I passed through the mirror to see
I passed through the mirror to see
I converted atoms to bees
I pulled on the forces in threes
But I left out that part of the dream

it's a wow, i'm on fire, it's amazing so bring it to me

 7 12  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW published_songs as
select * from music_song where publish;