arena
1 row where Team = 22
This data as json, CSV (advanced)
id ▼ | Arena | Latitude | Longitude | Capacity | Opened | Closed | Team |
---|---|---|---|---|---|---|---|
23 | Amica Mutual Pavilion | 41.82361111111111 | 71.41833333333334 | 11075 | 1972 | Providence Bruins 22 |
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");