arena
1 row where Team = 40
This data as json, CSV (advanced)
id ▼ | Arena | Latitude | Longitude | Capacity | Opened | Closed | Team |
---|---|---|---|---|---|---|---|
36 | Abbotsford Centre | 49.03055555555555 | 122.28722222222223 | 7000 | 2009 | Abbotsford Canucks 40 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "arena" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "Arena" varchar(64) NOT NULL, "Latitude" integer NULL, "Longitude" integer NULL, "Capacity" integer NULL, "Opened" integer NULL, "Closed" integer NULL, "Team" bigint NULL REFERENCES "team" ("id") DEFERRABLE INITIALLY DEFERRED); CREATE INDEX "arena_Team_bcb54805" ON "arena" ("Team");