music_press
7 rows where release_id = 3
This data as json, CSV (advanced)
Suggested facets: publish_on, date, 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. |
| 16 | 1 | 2009-09-25 17:00:00 | The Boston Phoenix | 2009-09-22 | http://thephoenix.com/Boston/Music/90199-On-a-roll/ | 1 | Colonial Drones 3 | It’s this open-minded and open-ended approach that has made HTH one of Boston’s most prized pop possessions. We’re not likely to hear a local album that trumps the wonders of Colonial Drones anytime soon. |
| 17 | 1 | 2009-09-25 17:00:00 | The Line Of Best Fit | 2009-09-23 | http://www.thelineofbestfit.com/2009/09/hallelujah-the-hills-colonial-drones/ | 1 | Colonial Drones 3 | Colonial Drones, as the title aptly suggests, is a work full of fantasy-like explorations, laden with anthemic choruses and lyrics freely open for interpretation. |
| 18 | 1 | 2009-09-25 17:00:00 | The Weekly Dig | 2009-09-22 | http://weeklydig.com/%5Bcatpath%5D/200909/hallelujah-hills | 1 | Colonial Drones 3 | It doesn't take long to realize this album is something extra special. |
| 19 | 1 | 2009-09-25 17:00:00 | Pitchfork | 2009-09-24 | http://pitchfork.com/reviews/albums/13461-colonial-drones/ | 1 | Colonial Drones 3 | Hallelujah the Hills [have] jumped to the accelerated class on their second album, Colonial Drones. |
| 23 | 1 | 2009-09-24 16:23:29 | Blurt Online | 2009-09-24 | http://www.blurt-online.com/reviews/view/1494/ | 1 | Colonial Drones 3 | …it's Walsh and his compadres conjuring a rough-hewn classic out of homey materials. Great stuff. |
| 33 | 1 | 2009-10-01 18:47:55 | Erasing Clouds | 2009-10-01 | http://www.erasingclouds.com/wk0709hth.html | 1 | Colonial Drones 3 | Colonial Drones has a big sound, upward movement, punchy hooks, singalong choruses and the tightness of a touring band. |
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");