Baselight

Historical NBA

This data-set contains the data behind the Complete History Of The NBA.

@kaggle.mysarahmadbhat_historical_nba

Loading...
Loading...

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.51 MB
  • 126314 rows
  • 23 columns
Loading...

CREATE TABLE nbaallelo (
  "gameorder" BIGINT,
  "game_id" VARCHAR,
  "lg_id" VARCHAR,
  "n__iscopy" BIGINT,
  "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
);