Name: Historical NBA
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Historical NBA

This data set contains the data behind the Complete History Of The NBA interactive. Data updated periodically. Game information is from Basketball-Reference.com.

Header Definition

gameorder Play order of game in NBA history

game_id Unique ID for each game

lg_id Which league the game was played in

_iscopy Each row of data is tied to a single team for a single game, so _iscopy flags if this game_id has already occured for the opposing team in the same matchup

year_id Season id, named based on year in which the season ended

date_game Game date

is_playoffs Flag for playoff games

team_id Three letter code for team name, from Basketball Reference

fran_id Franchise id. Multiple team_ids can fall under the same fran_id due to name changes or moves. Interactive is grouped by fran_id.

pts Points scored by team

elo_i Team elo entering the game

elo_n Team elo following the game

win_equiv Equivalent number of wins in a 82-game season for a team of elo_n quality

opp_id Team id of opponent

opp_fran Franchise id of opponent

opp_pts Points scored by opponent

opp_elo_i Opponent elo entering the game

opp_elo_n Opponent elo following the game

game_location Home (H), away (A), or neutral (N)

game_result Win or loss for team in the team_id column

forecast Elo-based chances of winning for the team in the team_id column, based on elo ratings and game location

Tables

Nbaallelo

@kaggle.mysarahmadbhat_historical_nba.nbaallelo

8.92 MB
126,314 rows
23 columns

CREATE TABLE nbaallelo (
  "gameorder" BIGINT,
  "game_id" VARCHAR,
  "lg_id" VARCHAR,
  "n__iscopy" BIGINT  -- Iscopy,
  "year_id" BIGINT,
  "date_game" TIMESTAMP,
  "seasongame" BIGINT,
  "is_playoffs" BIGINT,
  "team_id" VARCHAR,
  "fran_id" VARCHAR,
  "pts" BIGINT,
  "elo_i" DOUBLE,
  "elo_n" DOUBLE,
  "win_equiv" DOUBLE,
  "opp_id" VARCHAR,
  "opp_fran" VARCHAR,
  "opp_pts" BIGINT,
  "opp_elo_i" DOUBLE,
  "opp_elo_n" DOUBLE,
  "game_location" VARCHAR,
  "game_result" VARCHAR,
  "forecast" DOUBLE,
  "notes" VARCHAR
);