team
73 rows
This data as json, CSV (advanced)
Suggested facets: active
| team_id ▼ | team_code | active | name | city | nickname |
|---|---|---|---|---|---|
| 307 | HFD | 1 | Hartford Wolf Pack | Hartford | Wolf Pack |
| 309 | PRO | 1 | Providence Bruins | Providence | Bruins |
| 310 | POR | 1 | Portland Pirates | Portland | Portland |
| 311 | LOW | 1 | Lowell Lock Monsters | Lowell | Lowell |
| 312 | SPR | 1 | Springfield Falcons | Springfield | Springfield |
| 313 | LV | 1 | Lehigh Valley Phantoms | Lehigh Valley | Phantoms |
| 314 | NOR | 1 | Norfolk Admirals | Norfolk | Norfolk |
| 315 | BNG | 1 | Binghamton Senators | Binghamton | Binghamton |
| 316 | WBS | 1 | Wilkes-Barre/Scranton Penguins | Wilkes-Barre/Scranton | Penguins |
| 317 | BRI | 1 | Bridgeport Islanders | Bridgeport | Islanders |
| 318 | ALB | 1 | Albany River Rats | Albany | Albany |
| 319 | HER | 1 | Hershey Bears | Hershey | Bears |
| 321 | MB | 1 | Manitoba Moose | Manitoba | Moose |
| 323 | ROC | 1 | Rochester Americans | Rochester | Americans |
| 324 | SYR | 1 | Syracuse Crunch | Syracuse | Crunch |
| 325 | CLE | 1 | Cleveland Barons | Cleveland | Cleveland |
| 326 | HAM | 1 | Hamilton Bulldogs | Hamilton | Hamilton |
| 327 | MIL | 1 | Milwaukee Admirals | Milwaukee | Admirals |
| 328 | GR | 1 | Grand Rapids Griffins | Grand Rapids | Griffins |
| 329 | HOU | 1 | Houston Aeros | Houston | Houston |
| 330 | CHI | 1 | Chicago Wolves | Chicago | Wolves |
| 331 | SA | 1 | San Antonio Rampage | San Antonio | San Antonio |
| 334 | PEO | 1 | Peoria Rivermen | Peoria | Rivermen |
| 335 | TOR | 1 | Toronto Marlies | Toronto | Marlies |
| 336 | IOW | 1 | Iowa Stars | Iowa | Stars |
| 337 | OMA | 1 | Omaha Ak-Sar-Ben Knights | Omaha | Ak-Sar-Ben Knights |
| 344 | MCH | 1 | Manchester Monarchs | Manchester | Monarchs |
| 367 | CAN | 1 | Canadian AHL All-Stars | Canadian AHL All-Stars | Canadian AHL All-Stars |
| 368 | PUSA | 1 | PlanetUSA AHL All-Stars | PlanetUSA AHL All-Stars | PlanetUSA AHL All-Stars |
| 370 | WOR | 1 | Worcester Sharks | Worcester | Worcester |
| 371 | QC | 1 | Quad City Flames | Quad City | Flames |
| 372 | RFD | 1 | Rockford IceHogs | Rockford | IceHogs |
| 373 | CLE | 1 | Cleveland Monsters | Cleveland | Monsters |
| 375 | IOW | 1 | Iowa Chops | Iowa | Chops |
| 377 | US | 0 | U.S. AHL All-Stars | U.S. AHL All-Stars | US |
| 378 | WOR | 0 | World AHL All-Stars | World AHL-All Stars | World |
| 379 | ABB | 1 | Abbotsford Heat | Abbotsford | Abbotsford |
| 380 | TEX | 1 | Texas Stars | Texas | Stars |
| 383 | OKC | 1 | Oklahoma City Barons | Oklahoma City | Barons |
| 384 | CLT | 1 | Charlotte Checkers | Charlotte | Checkers |
| 385 | EAST | 1 | Eastern Conference AHL All-Stars | Eastern Conference | East |
| 386 | WEST | 1 | Western Conference AHL All-Stars | Western Conference | West |
| 387 | STJ | 1 | St. John's IceCaps | St. John's | IceCaps |
| 389 | IA | 1 | Iowa Wild | Iowa | Wild |
| 390 | UTC | 1 | Utica Comets | Utica | Comets |
| 393 | AHL | 1 | AHL All-Stars | AHL All-Stars | AHL All-Stars |
| 394 | FBK | 1 | Färjestad BK | Färjestad | Färjestad |
| 395 | WOR | 1 | Worcester IceCats | Worcester | IceCats |
| 396 | EDM | 1 | Edmonton Road Runners | Edmonton | Road Runners |
| 397 | STJ | 1 | St. John's Maple Leafs | St. John's | Maple Leafs |
| 398 | CIN | 1 | Cincinnati Mighty Ducks | Cincinnati | Mighty Ducks |
| 399 | UTA | 1 | Utah Grizzlies | Utah | Grizzlies |
| 400 | ADK | 1 | Adirondack Flames | Adirondack | Flames |
| 402 | BAK | 1 | Bakersfield Condors | Bakersfield | Condors |
| 403 | ONT | 1 | Ontario Reign | Ontario | Reign |
| 404 | SD | 1 | San Diego Gulls | San Diego | Gulls |
| 405 | SJ | 1 | San Jose Barracuda | San Jose | Barracuda |
| 406 | STK | 1 | Stockton Heat | Stockton | Heat |
| 407 | ATL | 1 | Atlantic Division All-Stars | Atlantic Division | Atlantic |
| 408 | NOR | 1 | North Division All-Stars | North Division | North |
| 409 | CEN | 1 | Central Division All-Stars | Central Division | Central |
| 410 | PAC | 1 | Pacific Division All-Stars | Pacific Division | Pacific |
| 411 | SPR | 1 | Springfield Thunderbirds | Springfield | Thunderbirds |
| 412 | TUC | 1 | Tucson Roadrunners | Tucson | Roadrunners |
| 413 | BEL | 1 | Belleville Senators | Belleville | Senators |
| 414 | LOW | 1 | Lowell Devils | Lowell | Lowell |
| 415 | LAV | 1 | Laval Rocket | Laval | Rocket |
| 417 | EBB | 1 | Eisbären Berlin | Berlin | Eisbären |
| 419 | COL | 1 | Colorado Eagles | Colorado | Eagles |
| 437 | HSK | 1 | Henderson Silver Knights | Henderson | Silver Knights |
| 440 | ABB | 1 | Abbotsford Canucks | Abbotsford | Canucks |
| 444 | CGY | 1 | Calgary Wranglers | Calgary | Wranglers |
| 445 | CV | 1 | Coachella Valley Firebirds | Coachella Valley | Firebirds |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE team (
team_id INTEGER PRIMARY KEY,
team_code TEXT,
active BOOLEAN,
name TEXT,
city TEXT,
nickname TEXT
);