shows_gig
4 rows where venue_id = 72
This data as json, CSV (advanced)
Suggested facets: details, publish_on (date), date (date)
| id ▼ | publish | publish_on | date | venue_id | description | details |
|---|---|---|---|---|---|---|
| 100 | 1 | 2006-07-06 00:00:00 | 2006-08-05 | Midway Cafe 72 | with Choo Choo La Rouge and Jimmy Hank Williams |
|
| 214 | 1 | 2012-09-15 16:34:07.092000 | 2012-10-12 | Midway Cafe 72 | with Guillermo Sexo, Squirty Worm, and Drew O'Doherty |
|
| 295 | 1 | 2018-04-18 00:01:23.551000 | 2018-07-20 | Midway Cafe 72 | with Adam Remnant and Planet of Adventure |
$10, 21+
|
| 317 | 1 | 2021-08-28 23:55:10 | 2021-09-04 | Midway Cafe 72 | with Children of the Flaming Wheel, Yobro, and DJ Panda |
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");