music_video
4 rows where release_id = 7
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 11 | get-me-in-a-room | 1 | 2012-05-16 23:55:00.057000 | Get Me In A Room | http://www.youtube.com/watch?v=zLKaes54BPM | <iframe src="https://www.youtube.com/embed/zLKaes54BPM?wmode=opaque" seamless allowfullscreen></iframe> | No One Knows What Happens Next 7 | https://img.youtube.com/vi/zLKaes54BPM/maxresdefault.jpg | |||
| 13 | nightingale-lightning | 1 | 2012-08-13 23:55:34.898000 | Nightingale Lightning | http://vimeo.com/43575893 | <iframe src="https://player.vimeo.com/video/43575893" seamless allowfullscreen></iframe> | No One Knows What Happens Next 7 | https://i.vimeocdn.com/video/302578255_640.jpg | |||
| 14 | night-work-begins-pt-1 | 1 | 2012-08-13 23:55:34.901000 | Night Work Begins - PT 1 | http://vimeo.com/43872976 | <iframe src="https://player.vimeo.com/video/43872976" seamless allowfullscreen></iframe> | No One Knows What Happens Next 7 | https://i.vimeocdn.com/video/304545540_640.jpg | |||
| 15 | call-off-your-horses | 1 | 2013-02-13 22:02:37.495000 | Call Off Your Horses | http://www.youtube.com/watch?v=2VtZF_MNk7o | <iframe src="https://www.youtube.com/embed/2VtZF_MNk7o?wmode=opaque" seamless allowfullscreen></iframe> | No One Knows What Happens Next 7 | https://img.youtube.com/vi/2VtZF_MNk7o/maxresdefault.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");