home / hth

published_songs (view)

1 row where "publish_on" is on date 2009-07-01 and track = 1

✎ 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
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
listened closely to their gibberish
for some sign of an omen or portent
all night — all week

soon he had collected all of their wisdom
into a book he titled so
A Guide To The World’s Most Fantastic Monsters
and I read it searching for some new feeling but
the monster that you run from doesn’t exist

1 3  

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE VIEW published_songs as
select * from music_song where publish;
Powered by Datasette · Queries took 9.922ms