music_press
Data source: https://www.hallelujahthehills.com
2 rows where publish = 1, quote = 1 and title = "The Ash Gray Proclamation"
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 |
|---|---|---|---|---|---|---|---|---|
| 99 | 1 | 2016-05-08 17:22:01 | The Ash Gray Proclamation | 2016-04-13 | https://theashgrayproclamation.com/2016/04/13/hallelujah-the-hills-a-band-is-something-to/ | 1 | A Band Is Something To Figure Out 12 | One constant for Hallelujah The Hills is their ability to push their sound into new exciting directions with each successive release. |
| 105 | 1 | 2011-01-21 22:35:49 | The Ash Gray Proclamation | 2011-01-21 | http://evilspeakers.blogspot.com/2011/01/hallelujah-hills-capstan-shafts-january.html | 1 | …our expectations were high to hear the yet to be recorded material as well as selections from the bands impressive back catalog and HTH did not disappoint. |
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");