shows_gig
Data source: https://www.hallelujahthehills.com
1 row where description = "<p>with Reverend Glasseye and Porsches On The Autobahn</p>", publish = 1 and "publish_on" is on date 2007-01-25
This data as json, CSV (advanced)
Suggested facets: publish_on (date), date (date)
id ▼ | publish | publish_on | date | venue_id | description | details |
---|---|---|---|---|---|---|
91 | 1 | 2007-01-25 00:00:00 | 2007-02-24 | The Middle East Downstairs 2 | with Reverend Glasseye and Porsches On The Autobahn |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "shows_gig" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "publish" bool NOT NULL, "publish_on" datetime NULL, "date" date NOT NULL, "venue_id" integer NOT NULL REFERENCES "shows_venue" ("id"), "description" text NOT NULL, "details" text NOT NULL); CREATE INDEX "shows_gig_venue_id_88683346" ON "shows_gig" ("venue_id");