home / games

arena

1 row where Team = 22

✎ View and edit SQL

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

CSV options:

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");
Powered by Datasette · Queries took 1.2ms