music_press

1 row where "date" is on date 2016-06-14, publish = 1 and title = "Bandcamp Daily"

✎ View and edit SQL

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
102 1 2016-06-20 09:53:49 Bandcamp Daily 2016-06-14   0 A Band Is Something To Figure Out 12

Fan Interviews: Hallelujah the Hills
Jon Doyle (of Wake The Deaf) interviews Ryan Walsh.

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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");