arena

36 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Opened

id ▼ Arena Latitude Longitude Capacity Opened Closed Team
1 Abbotsford Centre 49.03055555555555 122.28722222222223 7000 2009   Abbotsford Heat 1
2 Allstate Arena 42.00527777777778 87.88777777777779 16692 1980   Chicago Wolves 8
3 Bell MTS Place 49.89277777777778 97.14361111111111 15321 2004   Manitoba Moose 19
4 Blue Cross Arena 43.15369444444444 77.61077777777777 11215 1955   Rochester Americans 24
5 Adirondack Bank Center 43.105000000000004 75.23361111111112 3860 1960   Utica Comets 36
6 Mechanics Bank Arena 35.371944444444445 119.01361111111112 8751 1998   Bakersfield Condors 4
7 CAA Arena 44.18861111111111 77.38277777777778 4400 1978   Belleville Senators 5
8 Webster Bank Arena 41.17333333333333 73.18694444444445 8412 2001   Bridgeport Islanders 41
9 Bojangles' Coliseum 35.20516388888889 80.79510277777777 8600 1955   Charlotte Checkers 7
10 Rocket Mortgage FieldHouse 41.49638888888889 81.68805555555556 18926 1994   Cleveland Monsters 10
11 Acrisure Arena 33.77916666666667 116.33888888888889 10087 2022   Coachella Valley Firebirds 39
12 Budweiser Events Center 40.443888888888885 104.98944444444444 5829 2003   Colorado Eagles 43
13 Van Andel Arena 42.96222222222222 85.67194444444445 10834 1996   Grand Rapids Griffins 11
14 XL Center 41.76833333333333 72.67694444444444 14750 1975   Hartford Wolf Pack 13
15 Dollar Loan Center 36.01888888888889 115.08166666666666 6019 2022   Henderson Silver Knights 44
16 Orleans Arena 36.10583333333334 115.20222222222222 7773 2003 2022 Henderson Silver Knights 44
17 Giant Center 40.28638888888889 76.66916666666667 10500 2002   Hershey Bears 14
18 Wells Fargo Arena 41.592666666666666 93.62113888888888 15181 2005   Iowa Wild 16
19 Place Bell 45.55583333333333 73.72166666666666 10000 2017   Laval Rocket 45
20 PPL Center 40.6025 75.47277777777778 8420 2014   Lehigh Valley Phantoms 18
21 UW–Milwaukee Panther Arena 43.04222222222222 87.91694444444445 9652 1950   Milwaukee Admirals 20
22 Toyota Arena 34.073055555555555 117.56638888888888 9736 2008   Ontario Reign 21
23 Amica Mutual Pavilion 41.82361111111111 71.41833333333334 11075 1972   Providence Bruins 22
24 BMO Harris Bank Center 42.27026388888889 89.09608333333333 5895 1981   Rockford IceHogs 25
25 Pechanga Arena 32.75527777777778 117.21222222222222 12920 1966   San Diego Gulls 27
26 SAP Center at San Jose 37.33277777777778 121.90111111111112 17562 1993 2022 San Jose Barracuda 28
27 MassMutual Center 42.102222222222224 72.58694444444444 6793 1972   Springfield Thunderbirds 30
28 Onondaga County War Memorial 43.04472222222222 76.14833333333334 6159 1951   Syracuse Crunch 32
29 H-E-B Center at Cedar Park 30.54138888888889 97.82027777777778 8000 2009   Texas Stars 33
30 Coca-Cola Coliseum 43.63583333333333 79.415 7851 1921   Toronto Marlies 34
31 Tucson Convention Center 32.218333333333334 110.97416666666666 8962 1971   Tucson Roadrunners 35
32 Mohegan Sun Arena at Casey Plaza 41.24055555555556 75.84861111111111 8300 1999   Wilkes-Barre/Scranton Penguins 37
33 Stockton Arena 37.95611111111111 121.2961111111111 9737 2005 2022 Stockton Heat 46
34 Tech CU Arena 37.31930555555556 121.86405555555555 4200 2022   San Jose Barracuda 28
35 Scotiabank Saddledome 51.0375 114.05194444444444 19289 2022   Calgary Wranglers 42
36 Abbotsford Centre 49.03055555555555 122.28722222222223 7000 2009   Abbotsford Canucks 40

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");