published_songs (view)
1 row where publish_on = "2014-05-03 08:25:16" and "publish_on" is on date 2014-05-03
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW published_songs as select * from music_song where publish;