music_press
4 rows where release_id = 14
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 |
|---|---|---|---|---|---|---|---|---|
| 106 | 1 | 2018-12-15 22:32:00.221000 | Ryan's Smashing Life | 2018-12-16 | http://www.rslblog.com/2018/11/suddenly-hallelujah-hills-drop.html | 1 | Against Electricity 14 | Mesmerizing |
| 107 | 1 | 2018-12-15 22:34:24.328000 | Doom & Gloom From The Tomb | 2018-12-19 | https://twitter.com/tywilc/status/1064554745837187072 | 1 | Against Electricity 14 | A killer new Hallelujah the Hills instrumental album. |
| 108 | 1 | 2018-12-15 22:35:17 | If It's Too Loud... | 2018-12-14 | http://www.ifitstooloud.com/2018/11/hallelujah-hills-against-electricity.html | 1 | Against Electricity 14 | There are two things Boston's Hallelujah the Hills do incredibly well: Catchy roots based rock songs and experimental instrumental noise rock. Their sixth album, Against Electricty, was just released yesterday and it fits squarely in the latter category. |
| 109 | 1 | 2018-12-15 22:36:51.191000 | Aquarium Drunkard | 2018-12-03 | https://aquariumdrunkard.com/2018/12/03/bandcamping-winter-2018/ | 1 | Against Electricity 14 | All kinds of interesting textures and atmospheres happening. HTH doesn’t bother really going for a particular Astral Weeks-y vibe and wisely avoids late-60s psych cliches – maybe the most overt “reference” is the (excellent) “Rayrunner” rave-up. I’ll let you guess what that one sounds like! |
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");