arena
1 row where Team = 25
This data as json, CSV (advanced)
id ▼ | Arena | Latitude | Longitude | Capacity | Opened | Closed | Team |
---|---|---|---|---|---|---|---|
24 | BMO Harris Bank Center | 42.27026388888889 | 89.09608333333333 | 5895 | 1981 | Rockford IceHogs 25 |
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");