arena
1 row where Team = 36
This data as json, CSV (advanced)
id ▼ | Arena | Latitude | Longitude | Capacity | Opened | Closed | Team |
---|---|---|---|---|---|---|---|
5 | Adirondack Bank Center | 43.105000000000004 | 75.23361111111112 | 3860 | 1960 | Utica Comets 36 |
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");