games

Custom SQL query returning 53 rows (hide)

This data as json, CSV

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