published_songs (view)
1 row where "publish_on" is on date 2009-07-01 and track = 1
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 |
---|---|---|---|---|---|---|---|---|---|---|
26 | guide-to-monsters | 1 | 2009-07-01 00:00:00 | A Guide To The World's Most Fantastic Monsters | Written by Ryan Walsh, © 2009 Reverse The Tape Decks (ASCAP) | the king rounded up all the insurgents soon he had collected all of their wisdom |
1 | 3 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW published_songs as select * from music_song where publish;