arena
1 row where Team = 42
This data as json, CSV (advanced)
id ▼ | Arena | Latitude | Longitude | Capacity | Opened | Closed | Team |
---|---|---|---|---|---|---|---|
35 | Scotiabank Saddledome | 51.0375 | 114.05194444444444 | 19289 | 2022 | Calgary Wranglers 42 |
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");