music_video
3 rows where release_id = 3
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 5 | blank-passports | 1 | 2009-09-09 23:04:20 | Blank Passports | http://www.youtube.com/watch?v=59cbFQnBLsg | <iframe src="https://www.youtube.com/embed/59cbFQnBLsg?wmode=opaque" seamless allowfullscreen></iframe> | Colonial Drones 3 | https://img.youtube.com/vi/59cbFQnBLsg/hqdefault.jpg | |||
| 8 | put-the-gurus-in-charge | 1 | 2010-08-30 16:47:12 | Put The Gurus In Charge | http://www.youtube.com/watch?v=P_WLB3VsrIM | <iframe src="https://www.youtube.com/embed/P_WLB3VsrIM?wmode=opaque" seamless allowfullscreen></iframe> | Colonial Drones 3 | https://img.youtube.com/vi/P_WLB3VsrIM/hqdefault.jpg | |||
| 10 | station | 1 | 2010-11-16 22:18:43.746000 | Station | http://www.youtube.com/watch?v=jGPDc-R0wcE | <iframe src="https://www.youtube.com/embed/jGPDc-R0wcE?wmode=opaque" seamless allowfullscreen></iframe> | Colonial Drones 3 | https://img.youtube.com/vi/jGPDc-R0wcE/hqdefault.jpg |
Advanced export
JSON shape: default, array, newline-delimited, object
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");