home / hth

music_video

2 rows where release_id = 9

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: publish_on (date)

id ▼ slug publish publish_on title source_url embed_code description credits release_id preview_url priority
9 introductory-saints 1 2010-09-13 23:22:42 Introductory Saints http://www.youtube.com/watch?v=tAMliN9QcP0 <iframe src="https://www.youtube.com/embed/tAMliN9QcP0?wmode=opaque" seamless allowfullscreen></iframe>     Portrait Of The Artist As A Young Trashcan 9 https://img.youtube.com/vi/tAMliN9QcP0/hqdefault.jpg  
17 confessions-of-an-ex-ghost 1 2013-08-20 20:50:48 Confessions of an Ex-Ghost http://www.youtube.com/watch?v=QXgTDyatfvE <iframe src="https://www.youtube.com/embed/QXgTDyatfvE?wmode=opaque" seamless allowfullscreen></iframe>     Portrait Of The Artist As A Young Trashcan 9 https://img.youtube.com/vi/QXgTDyatfvE/maxresdefault.jpg  

Advanced export

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

CSV options:

CREATE TABLE "music_video" ("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, "source_url" varchar(200) NOT NULL, "embed_code" text NOT NULL, "description" text NOT NULL, "credits" text NOT NULL, "release_id" integer NULL REFERENCES "music_release" ("id"), "preview_url" varchar(200) NOT NULL, "priority" integer unsigned NULL);
CREATE INDEX "music_video_release_id_83f46359" ON "music_video" ("release_id");
Powered by Datasette · Queries took 10.899ms