published_songs (view)
1 row where publish_on = "2019-10-03 11:55:42" and "publish_on" is on date 2019-10-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 |
---|---|---|---|---|---|---|---|---|---|---|
107 | the-memory-tree | 1 | 2019-10-03 11:55:42 | The Memory Tree |
This all happens outside the space continuum
I was a sleeper agent before you woke me up
Can you make a memory?
And it’s a transaction, sure
I found a timeshare in the unified field
I’m finally a poet but you know that don’t matter now |
10 | 15 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW published_songs as select * from music_song where publish;