NBA teams, current and defunct
The 30 current NBA teams with conference, division, city, arena, arena capacity, location and the years they were founded and joined the league, plus the defunct franchises of the NBA and BAA, with championships and Finals appearances for each. One row per franchise.
Columns
Stable keys — use them in the API, SQL and code
| Key | Name | Type | Description |
|---|---|---|---|
| id | ID | string | Wikidata identifier of the team (or its article title when it has none). |
| team | Team | string | — |
| entity | Wikidata | entity | — |
| status | Status | string | Active (one of the 30 current teams) or Defunct. |
| conference | Conference | string | — |
| division | Division | string | — |
| city | City | string | — |
| arena | Arena | string | Current home arena. |
| arena_capacity | Capacity | integer | Basketball seating capacity of the arena. |
| latitude | Latitude | number | Arena location. |
| longitude | Longitude | number | Arena location. |
| founded | Founded | year | Year the franchise was founded. |
| joined | Joined | year | Year the team joined the NBA (or BAA). |
| left | Left | year | Last year of a defunct team's NBA/BAA play. |
| seasons | Seasons | integer | NBA/BAA seasons played (defunct teams). |
| wins | W | integer | Regular-season wins (defunct teams). |
| losses | L | integer | Regular-season losses (defunct teams). |
| championships | Titles | integer | NBA (and BAA) championships won by the franchise. |
| finals_appearances | Finals | integer | NBA (and BAA) Finals played. |
| last_title | Last title | year | — |
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.