music_press
Data source: https://www.hallelujahthehills.com
2 rows where publish = 1 and title = "The Line of Best Fit"
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 |
|---|---|---|---|---|---|---|---|---|
| 76 | 1 | 2014-12-18 22:19:12 | The Line of Best Fit | 2014-05-06 | http://www.thelineofbestfit.com/reviews/albums/hallelujah-the-hills-have-you-ever-done-something-evil | 1 | Have You Ever Done Something Evil? 10 | Dizzying, heaving at its brim, full of ideas both lyrical and musical |
| 119 | 1 | 2019-11-25 10:29:11.733000 | The Line of Best Fit | 2019-11-19 | https://www.thelineofbestfit.com/reviews/albums/hallelujah-the-hills-im-you-album-review | 1 | I’m You 15 | 9/10. Ties up everything they've been working towards into one glorious hour-long burst. |
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");