shows_gig
4 rows where venue_id = 43
This data as json, CSV (advanced)
Suggested facets: publish, 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. |
|
| 309 | 0 | 2020-01-20 13:56:43 | 2020-04-04 | Cafe Nine 43 | with Eyelids |
$10, 21+ |
| 327 | 1 | 2023-01-31 00:51:55.804000 | 2023-03-19 | Cafe Nine 43 | with Eyelids |
|
| 329 | 1 | 2023-09-04 20:59:31 | 2023-10-08 | Cafe Nine 43 | with The Sheila Divine |
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");