team

53 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: year_founded, division_id, franchise_id

id ▼ name year_founded division_id franchise_id
1 Abbotsford Heat 2009 West 5  
2 Adirondack Flames 2014 North 2  
3 Adirondack Phantoms 2009 North 2  
4 Bakersfield Condors 2015 Pacific 4  
5 Belleville Senators 2017 North 2  
6 Bridgeport Sound Tigers 2001 Atlantic 1  
7 Charlotte Checkers 2010 Atlantic 1  
8 Chicago Wolves 2001 Central 3  
9 Cleveland Barons 2001 North 2  
10 Cleveland Monsters 2007 North 2  
11 Grand Rapids Griffins 2001 Central 3  
12 Hamilton Bulldogs 2002 North 2  
13 Hartford Wolf Pack 1997 Atlantic 1  
14 Hershey Bears 1938 Atlantic 1  
15 Houston Aeros 2001 Central 3  
16 Iowa Wild 2013 Central 3  
17 Lake Erie Monsters 2007 North 2  
18 Lehigh Valley Phantoms 2014 Atlantic 1  
19 Manitoba Moose 2001 Central 3  
20 Milwaukee Admirals 2001 Central 3  
21 Ontario Reign 2015 Pacific 4  
22 Providence Bruins 1992 Atlantic 1  
23 Quad City Flames 2007 North 2  
24 Rochester Americans 1956 North 2  
25 Rockford IceHogs 2007 Central 3  
26 San Antonio Rampage 2002 Central 3  
27 San Diego Gulls 2015 Pacific 4  
28 San Jose Barracuda 2015 Pacific 4  
29 Springfield Falcons 2010 Atlantic 1  
30 Springfield Thunderbirds 2016 Atlantic 1  
31 St. John's IceCaps 2011 North 2  
32 Syracuse Crunch 1994 North 2  
33 Texas Stars 2009 Central 3  
34 Toronto Marlies 2005 North 2  
35 Tucson Roadrunners 2016 Pacific 4  
36 Utica Comets 2013 North 2  
37 Wilkes-Barre/Scranton Penguins 1999 Atlantic 1  
38 Worcester Sharks 2006 Atlantic 1  
39 Coachella Valley Firebirds 2022 Pacific 4 1 1
40 Abbotsford Canucks 2021 Pacific 4  
41 Bridgeport Islanders 2001 Atlantic 1  
42 Calgary Wranglers 2022 Pacific 4 2 2
43 Colorado Eagles 2003 Pacific 4  
44 Henderson Silver Knights 2020 Pacific 4  
45 Laval Rocket 2017 North 2  
46 Stockton Heat 2015 Pacific 4 2 2
47 Maine Mariners 1977   2 2
48 Utica Devils 1987   2 2
49 Saint John's Flames 1993   2 2
50 Omaha Ak-Sar-Ben Knights 2005   2 2
51 Quad City Flames 2007   2 2
52 Adirondak Flames 2014 North 6 2 2
53 Abbotsford Heat 2009 West 5 2 2

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "team" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "name" varchar(32) NULL, "year_founded" integer NULL, "division_id" bigint NULL REFERENCES "division" ("id") DEFERRABLE INITIALLY DEFERRED, "franchise_id" bigint NULL REFERENCES "franchise" ("id") DEFERRABLE INITIALLY DEFERRED);
CREATE INDEX "team_division_id_d045beb7" ON "team" ("division_id");
CREATE INDEX "team_franchise_id_c7da83a8" ON "team" ("franchise_id");