published_songs (view)
1 row where "publish_on" is on date 2009-09-09
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 |
---|---|---|---|---|---|---|---|---|---|---|
35 | classic-tapes | 1 | 2009-09-09 00:00:00 | Classic Tapes | Written by Ryan Walsh, © 2009 Reverse The Tape Decks (ASCAP) |
oh we crashed in the ash I strayed during the ticker tape parade my dear, I could drift into backyards forever is incomprehensible the stop light changes but nothing else does I feel it / I feel it / I feel it / I feel it |
10 | 3 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW published_songs as select * from music_song where publish;