home / hth

music_song

1 row where publish_on = "2013-05-07 22:47:28", "publish_on" is on date 2013-05-07 and release_id = 9

✎ 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
63 portrait-artist-young-trashcan 1 2013-05-07 22:47:28 Portrait Of The Artist As A Young Trashcan    

In the haunted mansion
Where Jefferson Airplane
Use to write their hit songs
I fell in love

The future holds me hostage
The past is slightly less violent
I have issues with the present
Still, I come at it with love

It’s neverending
This rule bending
Beat Up, Blissed Out
Bruises On The Brain
They’re sending in a team
To try and write a new refrain

In a clapboard palace
Famished for something
But aiming to mingle
I build a makeshift throne

It’s like I told you
I’m coming for you
With spat out verses
Another bloody nose
The car might not make it
But I can still get us home

Portrait of the artist
As a young trash can
With a naïve game plan
Comes to me now

21 Portrait Of The Artist As A Young Trashcan 9  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "music_song" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "slug" varchar(50) NOT NULL UNIQUE, "publish" bool NOT NULL, "publish_on" datetime NULL, "title" varchar(200) NOT NULL, "description" text NOT NULL, "credits" text NOT NULL, "lyrics" text NOT NULL, "track" integer unsigned NULL, "release_id" integer NULL REFERENCES "music_release" ("id"), "player_code" text NOT NULL);
CREATE INDEX "music_song_release_id_d94af625" ON "music_song" ("release_id");
Powered by Datasette · Queries took 10.136ms