shows_gig

Data source: https://www.hallelujahthehills.com

3 rows where venue_id = 43

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: publish_on (date), date (date)

id ▼ publish publish_on date venue_id description details
56 1 2007-09-17 00:00:00 2007-10-17 Cafe Nine 43

with Southeast Engine.

  
327 1 2023-01-31 00:51:55.804000 2023-03-19 Cafe Nine 43

with Eyelids

Tickets
329 1 2023-09-04 20:59:31 2023-10-08 Cafe Nine 43

with The Sheila Divine

Tickets

Advanced export

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

CSV options: 

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