shows_gig
26 rows where venue_id = 9
This data as json, CSV (advanced)
Suggested facets: description, details, publish_on (date), date (date)
| id ▼ | publish | publish_on | date | venue_id | description | details |
|---|---|---|---|---|---|---|
| 10 | 1 | 2008-11-21 00:00:00 | 2008-12-21 | Great Scott 9 | with Aloud, Nassy, and Ad Frank & Sarah Rabdau. |
|
| 11 | 1 | 2008-10-07 00:00:00 | 2008-11-06 | Great Scott 9 | with Illinois and DJ Carbo. |
|
| 19 | 1 | 2008-05-30 00:00:00 | 2008-06-29 | Great Scott 9 | with Times New Viking and Titus Andronicus. |
|
| 23 | 1 | 2008-03-13 00:00:00 | 2008-04-12 | Great Scott 9 | Rock-N-Romp with You Could Be A Wesley. |
|
| 85 | 1 | 2007-05-17 00:00:00 | 2007-06-16 | Great Scott 9 | with Ho-Ag, Ketman, and Keys To The Streets Of Fear |
|
| 87 | 1 | 2007-03-21 00:00:00 | 2007-04-20 | Great Scott 9 | with readings by Janice Erlbaum and Jami Attenberg |
|
| 90 | 1 | 2007-02-22 00:00:00 | 2007-03-24 | Great Scott 9 | with Cassavettes and Lady Of Spain |
|
| 93 | 1 | 2006-10-31 00:00:00 | 2006-11-30 | Great Scott 9 | with Skeleton Key, Billy Nayer Show, and Stolen Babies |
|
| 97 | 1 | 2006-08-24 00:00:00 | 2006-09-23 | Great Scott 9 | with Choo Choo La Rouge, Extra Golden, and Hats & Glasses |
|
| 107 | 1 | 2006-01-17 00:00:00 | 2006-02-16 | Great Scott 9 | with Black Helicopter, Polaris Mine, and Desert Sea |
|
| 111 | 1 | 2005-10-21 00:00:00 | 2005-11-20 | Great Scott 9 | with Devin Davis and King & Country |
|
| 115 | 1 | 2009-08-27 00:00:00 | 2009-09-26 | Great Scott 9 | Colonial Drones CD release party! |
|
| 125 | 1 | 2009-09-20 00:00:00 | 2009-11-21 | Great Scott 9 | ||
| 158 | 1 | 2010-02-23 00:23:26 | 2010-04-12 | Great Scott 9 | with Titus Andronicus and The Babies. |
|
| 159 | 1 | 2010-05-04 23:39:22 | 2010-07-08 | Great Scott 9 | ||
| 178 | 1 | 2010-08-02 21:32:44 | 2010-10-30 | Great Scott 9 | Halloween Party with Magic Magic and Boy Without God. |
|
| 181 | 1 | 2011-02-14 08:31:38 | 2011-03-26 | Great Scott 9 | Limited edition 7" release show with Parts & Labor and Tallahasse. |
|
| 184 | 1 | 2011-08-30 09:29:14.863000 | 2011-09-28 | Great Scott 9 | with earthquake party! and the Fagettes |
|
| 190 | 1 | 2012-01-19 17:48:44 | 2012-03-28 | Great Scott 9 | with You Won't, Milkman's Union, and Boy Without God. |
|
| 215 | 1 | 2012-09-15 16:48:18.247000 | 2012-11-08 | Great Scott 9 | with Southeast Engine, Marconi, and Magic Magic |
|
| 236 | 1 | 2014-03-24 21:05:53 | 2014-05-30 | Great Scott 9 | with Thick Wild and Tallahassee |
|
| 266 | 1 | 2015-12-04 05:35:04 | 2015-12-31 | Great Scott 9 | with The Barbazons and Milk. |
|
| 267 | 1 | 2016-01-05 07:13:38.450000 | 2016-01-31 | Great Scott 9 | with Magic Magic, Gold Muse, and Twin Foxes |
|
| 269 | 1 | 2016-02-25 10:47:40 | 2016-05-12 | Great Scott 9 | ABISTFO Album Release
|
|
| 282 | 1 | 2016-11-05 11:06:19 | 2016-12-16 | Great Scott 9 | with Beware the Dangers of a Ghost Scorpion and Crooked Coast |
|
| 304 | 1 | 2019-10-06 21:10:24 | 2019-12-19 | Great Scott 9 |
I’m You Album Release
|
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");