music_press
2 rows where release_id = 11
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 |
|---|---|---|---|---|---|---|---|---|
| 80 | 1 | 2015-04-16 06:10:07 | Captain's Dead | 2015-03-06 | http://captainsdead.com/hallelujah-hills-devil-level-zero-premiere-tour-dates.html | 1 | Juvenile Oratorios EP 11 | Without a doubt they are one of the greatest bands currently making music. |
| 81 | 1 | 2015-04-16 06:12:58 | PopMatters | 2014-12-04 | http://www.popmatters.com/review/188864-hallelujah-the-hills-juvenile-oratorios-ep/ | 1 | Juvenile Oratorios EP 11 | Leave it to Hallelujah the Hills to craft a four-song EP that feels this grand. |
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");