home / hth

shows_gig

1 row where venue_id = 191

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: publish_on (date), date (date)

id ▼ publish publish_on date venue_id description details
302 1 2019-06-24 00:31:59.940000 2019-07-18 Cambridge Crossing 191

CX Summer Nights
Outdoor show, with Tipling Rock

Free! 5:30-8:30pm
Facebook

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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");
Powered by Datasette · Queries took 801.987ms