shows_gig
5 rows where venue_id = 5
This data as json, CSV (advanced)
Suggested facets: description, publish_on (date), date (date)
| id ▼ | publish | publish_on | date | venue_id | description | details |
|---|---|---|---|---|---|---|
| 6 | 1 | 2009-02-07 00:00:00 | 2009-03-09 | The Mercury Lounge 5 | with Field Music, Arc In Round, and Monuments. |
|
| 64 | 1 | 2007-08-09 00:00:00 | 2007-09-08 | The Mercury Lounge 5 | with Au Revoir Simone and Oh No! Oh My! |
|
| 89 | 1 | 2007-02-24 00:00:00 | 2007-03-26 | The Mercury Lounge 5 | ||
| 171 | 1 | 2010-08-02 21:28:16.221000 | 2010-09-17 | The Mercury Lounge 5 | ||
| 211 | 1 | 2012-07-01 22:34:31.912000 | 2012-07-21 | The Mercury Lounge 5 | with Field Mouse and Firehorse |
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");