shows_gig
4 rows where venue_id = 11
This data as json, CSV (advanced)
Suggested facets: description, details, publish_on (date), date (date)
| id ▼ | publish | publish_on | date | venue_id | description | details |
|---|---|---|---|---|---|---|
| 15 | 1 | 2008-08-07 00:00:00 | 2008-09-06 | Cake Shop 11 | with Ford & Fitzroy. |
|
| 126 | 1 | 2009-09-20 00:00:00 | 2009-11-19 | Cake Shop 11 | ||
| 193 | 1 | 2012-03-09 17:05:15 | 2012-05-11 | Cake Shop 11 | ||
| 277 | 1 | 2016-06-27 23:24:41 | 2016-07-29 | Cake Shop 11 | with P. Everett, Woodsy Pride, Dott |
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");