NHL teams, current and former
Every team that has played in the National Hockey League since 1917 — current clubs, earlier names and locations of current franchises, and defunct franchises — with seasons played, all-time regular-season and playoff records, and Stanley Cups won. One row per team name (a relocated or renamed franchise has one row per identity).
Columns
Stable keys — use them in the API, SQL and code
| Key | Name | Type | Description |
|---|---|---|---|
| team_id | NHL team id | integer | The NHL's identifier for this team name. |
| team | Team | string | — |
| entity | Wikidata | entity | — |
| abbreviation | Abbr. | string | — |
| franchise | Franchise | string | Franchise the team belongs to, under its current (or last) name. |
| franchise_id | Franchise id | integer | The NHL's franchise identifier. |
| active | Active | boolean | True for the 32 teams currently playing under this name. |
| first_season | First season | string | — |
| last_season | Last season | string | Last NHL season under this name (empty for active teams). |
| games | GP | integer | Regular-season games played. |
| wins | W | integer | Regular-season wins. |
| losses | L | integer | Regular-season losses in regulation. |
| ties | T | integer | Regular-season ties (until 2004–05). |
| ot_losses | OTL | integer | Regular-season overtime and shootout losses (since 1999–2000). |
| points | Pts | integer | Regular-season standings points. |
| point_pct | Pts% | number | Points earned as a share of points available. |
| goals_for | GF | integer | — |
| goals_against | GA | integer | — |
| playoff_seasons | Playoff seasons | integer | Seasons in which the team reached the playoffs. |
| playoff_games | Playoff GP | integer | — |
| playoff_wins | Playoff W | integer | — |
| playoff_losses | Playoff L | integer | — |
| series_won | Series won | integer | Playoff series won. |
| series_lost | Series lost | integer | Playoff series lost. |
| stanley_cups | Stanley Cups | integer | Stanley Cups won in the NHL era under this name. |
More in Sports
ATP singles match results, 2016–present
Every men's singles match at ATP tour level in the seasons from 2016 to the present — Grand Slams, Masters, other ATP tour events, the season-ending finals, the Olympics, team events and Davis Cup ties — with round, both players' countries and rankings, score and match length. One row per match.
Tennis singles titles and win–loss records by player (ATP and WTA, Open Era)
Every player with at least one tour-level singles match on the ATP or WTA tour since 1968: tour-level titles, Grand Slam titles, finals, match wins and losses and win percentage, computed from the match results. One row per player per tour.
NHL career statistics of every skater
Career regular-season NHL totals for every skater who has played in the league since 1917, as aggregated by the NHL. One row per player.
NBA players (all-time)
People recorded on Wikidata as having played for an NBA or BAA team since 1946, with birth date and place, citizenship, position, height, weight, years and number of franchises, draft details and Hall of Fame status. One row per player.
NFL regular-season standings, every season since 1920
Final regular-season standings of every NFL season (APFA in 1920–21) whose standings pass consistency checks: one row per team per season with wins, losses, ties, winning percentage, points for and against, division, conference and playoff seed.
NBA regular-season standings, every season since 1946–47
Final regular-season standings of every NBA (and BAA, 1946–49) season: one row per team per season with wins, losses, winning percentage, games behind, division, conference, conference rank and the clinch code printed in the standings.