music_press
1 row where release_id = 13
This data as json, CSV (advanced)
Suggested facets: publish_on (date), date (date)
| id ▼ | publish | publish_on | title | date | source_url | quote | release_id | body |
|---|---|---|---|---|---|---|---|---|
| 103 | 1 | 2016-06-30 10:38:39 | Boston Herald | 2016-06-27 | http://www.bostonherald.com/entertainment/music/guestlisted/2016/06/guestlisted_premiere_hallelujah_the_hills_new_video | 1 | Movement Scorekeepers 13 | The band got right back to cooking up the weird, wonderful indie rock we’ve come to love from them for ten years. |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "music_press" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "publish" bool NOT NULL, "publish_on" datetime NULL, "title" varchar(200) NOT NULL, "date" date NOT NULL, "source_url" varchar(200) NOT NULL, "quote" bool NOT NULL, "release_id" integer NULL REFERENCES "music_release" ("id"), "body" text NOT NULL);
CREATE INDEX "music_press_release_id_5a017a78" ON "music_press" ("release_id");