music_press
Data source: https://www.hallelujahthehills.com
4 rows where publish = 1 and title = "Prefix"
This data as json, CSV (advanced)
Suggested facets: release_id, publish_on (date), date (date)
| id ▼ | publish | publish_on | title | date | source_url | quote | release_id | body |
|---|---|---|---|---|---|---|---|---|
| 14 | 1 | 2009-09-25 17:00:00 | Prefix | 2009-09-22 | http://www.prefixmag.com/reviews/hallelujah-the-hills/colonial-drones/30852/ | 1 | Colonial Drones 3 | …as catchy as each song can be, what grew on me is how they all mesh into a cohesive whole. |
| 32 | 1 | 2009-11-24 18:39:46 | Prefix | 2009-11-24 | http://www.prefixmag.com/photos/times-new-viking-hallelujah-the-hills-and-the-axem | 1 | Boston's own Hallelujah the Hills wrapped up a five week tour and were tighter than Glenn Beck's throbbing forehead vein. |
|
| 44 | 1 | 2012-05-20 23:05:24 | Prefix | 2012-04-27 | http://www.prefixmag.com/media/hallelujah-the-hills/hungry-ghost-extraordinaire-prefix-premiere/64721/ | 1 | No One Knows What Happens Next 7 | It's a great introduction to No One Knows What Will Happen Next, and despite the warning in that title, and even if we don't know yet what that album will be, "Hungry Ghost Extraordinaire" is surely a good omen. |
| 45 | 1 | 2012-05-21 21:57:03 | Prefix | 2012-05-21 | http://www.prefixmag.com/reviews/hallelujah-the-hills/no-one-knows-what-happens-next/65248/ | 1 | No One Knows What Happens Next 7 | The clarity of this record is a daring move for a band that has existed so firmly in the gauze, but it pays off at nearly every turn...they've also gone ahead and made their best record. |
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");