shows_gig
3 rows where venue_id = 126
This data as json, CSV (advanced)
Suggested facets: description, publish_on (date), date (date)
| id ▼ | publish | publish_on | date | venue_id | description | details |
|---|---|---|---|---|---|---|
| 185 | 1 | 2011-08-30 09:32:56 | 2011-10-21 | The Rock Shop 126 | The Nicodemus Agency CMJ Showcase! |
|
| 206 | 1 | 2012-05-16 23:06:08 | 2012-06-23 | The Rock Shop 126 | ||
| 221 | 1 | 2013-01-11 14:51:46.144000 | 2013-02-24 | The Rock Shop 126 |
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");