Major League Baseball teams, current and former
Every team Major League Baseball counts as a major-league club — the 30 current franchises and defunct clubs of the National League, American League, American Association, Union Association, Players' League, Federal League and the Negro leagues — with years of play, league, former names and World Series won. One row per franchise.
Columns
Stable keys — use them in the API, SQL and code
| Key | Name | Type | Description |
|---|---|---|---|
| team_id | MLB team id | integer | MLB Stats API team identifier. |
| team | Team | string | Current name, or last name for a defunct team. |
| entity | Wikidata | entity | — |
| abbreviation | Abbr. | string | — |
| active | Active | boolean | — |
| league | League | string | Current league (active teams) or last league (defunct teams). |
| division | Division | string | Current division (active teams). |
| city | City | string | Home city (active teams). |
| ballpark | Ballpark | string | Current home ballpark (active teams). |
| first_year | First season | year | First season as a major-league team. |
| last_year | Last season | year | Last season (defunct teams). |
| former_names | Former names | string | Other names MLB's team history records for the franchise, oldest first. |
| world_series_won | World Series won | integer | — |
| world_series_appearances | World Series played | integer | — |
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.