NHL NBA,MLB,NBA Salaries + Statistics (1876-2024)

CREATE TABLE all_goalies (
  "assists" BIGINT,
  "gamesplayed" BIGINT,
  "gamesstarted" BIGINT,
  "fullname" VARCHAR,
  "goals" BIGINT,
  "goalsagainst" BIGINT,
  "goalsagainstaverage" DOUBLE,
  "lastname" VARCHAR,
  "losses" BIGINT,
  "otlosses" DOUBLE,
  "penaltyminutes" BIGINT,
  "playerid" BIGINT,
  "points" BIGINT,
  "savepct" DOUBLE,
  "saves" DOUBLE,
  "seasonid" BIGINT,
  "shootscatches" VARCHAR,
  "shotsagainst" DOUBLE,
  "shutouts" BIGINT,
  "teamabbrevs" VARCHAR,
  "ties" DOUBLE,
  "timeonice" BIGINT,
  "wins" BIGINT
);

CREATE TABLE all_goalies_1917_2025 (
  "assists" BIGINT,
  "gamesplayed" BIGINT,
  "gamesstarted" BIGINT,
  "goaliefullname" VARCHAR,
  "goals" BIGINT,
  "goalsagainst" BIGINT,
  "goalsagainstaverage" DOUBLE,
  "lastname" VARCHAR,
  "losses" BIGINT,
  "otlosses" DOUBLE,
  "penaltyminutes" BIGINT,
  "playerid" BIGINT,
  "points" BIGINT,
  "savepct" DOUBLE,
  "saves" DOUBLE,
  "seasonid" BIGINT,
  "shootscatches" VARCHAR,
  "shotsagainst" DOUBLE,
  "shutouts" BIGINT,
  "teamabbrevs" VARCHAR,
  "ties" DOUBLE,
  "timeonice" BIGINT,
  "wins" BIGINT
);

CREATE TABLE all_players (
  "name" VARCHAR,
  "slug" VARCHAR,
  "note" VARCHAR,
  "yearsremaining" VARCHAR,
  "terms" VARCHAR,
  "termsdetails" VARCHAR,
  "termswaiversexempt" VARCHAR,
  "termsslidecandidate" VARCHAR,
  "termsspcexempt" VARCHAR,
  "pos" VARCHAR,
  "status" VARCHAR,
  "acquired" VARCHAR,
  "acquisitiondetails" VARCHAR,
  "born" VARCHAR,
  "birthplace" VARCHAR,
  "nationality" VARCHAR,
  "shoots" VARCHAR,
  "height" VARCHAR,
  "weight" VARCHAR,
  "elc_signing_age" VARCHAR,
  "waivers_age" VARCHAR,
  "draft_year" VARCHAR,
  "drafted_overall" DOUBLE,
  "draft_round" DOUBLE,
  "drafted_by" VARCHAR,
  "contracts" VARCHAR,
  "stats" VARCHAR,
  "nhlurl" VARCHAR,
  "nhlid" BIGINT,
  "headshot" VARCHAR,
  "sweaternumber" DOUBLE,
  "shootscatches" VARCHAR,
  "careergamesplayed" DOUBLE,
  "careerseasonsplayed" DOUBLE,
  "currentteam" VARCHAR,
  "currentteamtricode" VARCHAR,
  "currentteamslug" VARCHAR,
  "positions" VARCHAR,
  "nhldays" VARCHAR,
  "transactions" VARCHAR,
  "team" VARCHAR,
  "arbitrationeligible" VARCHAR,
  "acquisitiontradeid" VARCHAR,
  "injury" VARCHAR,
  "acqisitiondetails" VARCHAR,
  "position" VARCHAR
);

CREATE TABLE all_skaters (
  "assists" BIGINT,
  "evgoals" DOUBLE,
  "evpoints" DOUBLE,
  "faceoffwinpct" DOUBLE,
  "gamewinninggoals" BIGINT,
  "gamesplayed" BIGINT,
  "goals" BIGINT,
  "lastname" VARCHAR,
  "otgoals" BIGINT,
  "penaltyminutes" BIGINT,
  "playerid" BIGINT,
  "plusminus" DOUBLE,
  "points" BIGINT,
  "pointspergame" DOUBLE,
  "positioncode" VARCHAR,
  "ppgoals" DOUBLE,
  "pppoints" DOUBLE,
  "seasonid" BIGINT,
  "shgoals" DOUBLE,
  "shpoints" DOUBLE,
  "shootingpct" DOUBLE,
  "shootscatches" VARCHAR,
  "shots" DOUBLE,
  "fullname" VARCHAR,
  "teamabbrevs" VARCHAR,
  "timeonicepergame" DOUBLE
);

CREATE TABLE all_skaters_1917_1967 (
  "assists" BIGINT,
  "evgoals" DOUBLE,
  "evpoints" DOUBLE,
  "faceoffwinpct" VARCHAR,
  "gamewinninggoals" BIGINT,
  "gamesplayed" BIGINT,
  "goals" BIGINT,
  "lastname" VARCHAR,
  "otgoals" BIGINT,
  "penaltyminutes" BIGINT,
  "playerid" BIGINT,
  "plusminus" DOUBLE,
  "points" BIGINT,
  "pointspergame" DOUBLE,
  "positioncode" VARCHAR,
  "ppgoals" DOUBLE,
  "pppoints" DOUBLE,
  "seasonid" BIGINT,
  "shgoals" DOUBLE,
  "shpoints" DOUBLE,
  "shootingpct" DOUBLE,
  "shootscatches" VARCHAR,
  "shots" DOUBLE,
  "skaterfullname" VARCHAR,
  "teamabbrevs" VARCHAR,
  "timeonicepergame" VARCHAR
);

CREATE TABLE all_skaters_1968_1980 (
  "assists" BIGINT,
  "evgoals" BIGINT,
  "evpoints" BIGINT,
  "faceoffwinpct" VARCHAR,
  "gamewinninggoals" BIGINT,
  "gamesplayed" BIGINT,
  "goals" BIGINT,
  "lastname" VARCHAR,
  "otgoals" BIGINT,
  "penaltyminutes" BIGINT,
  "playerid" BIGINT,
  "plusminus" BIGINT,
  "points" BIGINT,
  "pointspergame" DOUBLE,
  "positioncode" VARCHAR,
  "ppgoals" BIGINT,
  "pppoints" BIGINT,
  "seasonid" BIGINT,
  "shgoals" BIGINT,
  "shpoints" BIGINT,
  "shootingpct" DOUBLE,
  "shootscatches" VARCHAR,
  "shots" BIGINT,
  "skaterfullname" VARCHAR,
  "teamabbrevs" VARCHAR,
  "timeonicepergame" VARCHAR
);

CREATE TABLE all_skaters_1981_1990 (
  "assists" BIGINT,
  "evgoals" BIGINT,
  "evpoints" BIGINT,
  "faceoffwinpct" VARCHAR,
  "gamewinninggoals" BIGINT,
  "gamesplayed" BIGINT,
  "goals" BIGINT,
  "lastname" VARCHAR,
  "otgoals" BIGINT,
  "penaltyminutes" BIGINT,
  "playerid" BIGINT,
  "plusminus" BIGINT,
  "points" BIGINT,
  "pointspergame" DOUBLE,
  "positioncode" VARCHAR,
  "ppgoals" BIGINT,
  "pppoints" BIGINT,
  "seasonid" BIGINT,
  "shgoals" BIGINT,
  "shpoints" BIGINT,
  "shootingpct" DOUBLE,
  "shootscatches" VARCHAR,
  "shots" BIGINT,
  "skaterfullname" VARCHAR,
  "teamabbrevs" VARCHAR,
  "timeonicepergame" VARCHAR
);

CREATE TABLE all_skaters_1991_2000 (
  "assists" BIGINT,
  "evgoals" BIGINT,
  "evpoints" BIGINT,
  "faceoffwinpct" DOUBLE,
  "gamewinninggoals" BIGINT,
  "gamesplayed" BIGINT,
  "goals" BIGINT,
  "lastname" VARCHAR,
  "otgoals" BIGINT,
  "penaltyminutes" BIGINT,
  "playerid" BIGINT,
  "plusminus" BIGINT,
  "points" BIGINT,
  "pointspergame" DOUBLE,
  "positioncode" VARCHAR,
  "ppgoals" BIGINT,
  "pppoints" BIGINT,
  "seasonid" BIGINT,
  "shgoals" BIGINT,
  "shpoints" BIGINT,
  "shootingpct" DOUBLE,
  "shootscatches" VARCHAR,
  "shots" BIGINT,
  "skaterfullname" VARCHAR,
  "teamabbrevs" VARCHAR,
  "timeonicepergame" DOUBLE
);

CREATE TABLE all_skaters_2001_2010 (
  "assists" BIGINT,
  "evgoals" BIGINT,
  "evpoints" BIGINT,
  "faceoffwinpct" DOUBLE,
  "gamewinninggoals" BIGINT,
  "gamesplayed" BIGINT,
  "goals" BIGINT,
  "lastname" VARCHAR,
  "otgoals" BIGINT,
  "penaltyminutes" BIGINT,
  "playerid" BIGINT,
  "plusminus" BIGINT,
  "points" BIGINT,
  "pointspergame" DOUBLE,
  "positioncode" VARCHAR,
  "ppgoals" BIGINT,
  "pppoints" BIGINT,
  "seasonid" BIGINT,
  "shgoals" BIGINT,
  "shpoints" BIGINT,
  "shootingpct" DOUBLE,
  "shootscatches" VARCHAR,
  "shots" BIGINT,
  "skaterfullname" VARCHAR,
  "teamabbrevs" VARCHAR,
  "timeonicepergame" DOUBLE
);

CREATE TABLE all_skaters_2011_2020 (
  "assists" BIGINT,
  "evgoals" BIGINT,
  "evpoints" BIGINT,
  "faceoffwinpct" DOUBLE,
  "gamewinninggoals" BIGINT,
  "gamesplayed" BIGINT,
  "goals" BIGINT,
  "lastname" VARCHAR,
  "otgoals" BIGINT,
  "penaltyminutes" BIGINT,
  "playerid" BIGINT,
  "plusminus" BIGINT,
  "points" BIGINT,
  "pointspergame" DOUBLE,
  "positioncode" VARCHAR,
  "ppgoals" BIGINT,
  "pppoints" BIGINT,
  "seasonid" BIGINT,
  "shgoals" BIGINT,
  "shpoints" BIGINT,
  "shootingpct" DOUBLE,
  "shootscatches" VARCHAR,
  "shots" BIGINT,
  "skaterfullname" VARCHAR,
  "teamabbrevs" VARCHAR,
  "timeonicepergame" DOUBLE
);

CREATE TABLE all_skaters_2021_2025 (
  "assists" BIGINT,
  "evgoals" BIGINT,
  "evpoints" BIGINT,
  "faceoffwinpct" DOUBLE,
  "gamewinninggoals" BIGINT,
  "gamesplayed" BIGINT,
  "goals" BIGINT,
  "lastname" VARCHAR,
  "otgoals" BIGINT,
  "penaltyminutes" BIGINT,
  "playerid" BIGINT,
  "plusminus" BIGINT,
  "points" BIGINT,
  "pointspergame" DOUBLE,
  "positioncode" VARCHAR,
  "ppgoals" BIGINT,
  "pppoints" BIGINT,
  "seasonid" BIGINT,
  "shgoals" BIGINT,
  "shpoints" BIGINT,
  "shootingpct" DOUBLE,
  "shootscatches" VARCHAR,
  "shots" BIGINT,
  "skaterfullname" VARCHAR,
  "teamabbrevs" VARCHAR,
  "timeonicepergame" DOUBLE
);

CREATE TABLE all_teams_1917_2025 (
  "faceoffwinpct" DOUBLE,
  "gamesplayed" BIGINT,
  "goalsagainst" BIGINT,
  "goalsagainstpergame" DOUBLE,
  "goalsfor" BIGINT,
  "goalsforpergame" DOUBLE,
  "losses" BIGINT,
  "otlosses" DOUBLE,
  "penaltykillnetpct" DOUBLE,
  "penaltykillpct" DOUBLE,
  "pointpct" DOUBLE,
  "points" BIGINT,
  "powerplaynetpct" DOUBLE,
  "powerplaypct" DOUBLE,
  "regulationandotwins" BIGINT,
  "seasonid" BIGINT,
  "shotsagainstpergame" DOUBLE,
  "shotsforpergame" DOUBLE,
  "teamfullname" VARCHAR,
  "teamid" BIGINT,
  "ties" DOUBLE,
  "wins" BIGINT,
  "winsinregulation" BIGINT,
  "winsinshootout" BIGINT
);

CREATE TABLE averagefighttimelong (
  "rnk" BIGINT,
  "event" VARCHAR,
  "time" VARCHAR
);

CREATE TABLE averagefighttimeshort (
  "rnk" BIGINT,
  "event" VARCHAR,
  "time" VARCHAR
);

CREATE TABLE average_nba (
  "player_id" BIGINT,
  "player_name" VARCHAR,
  "nickname" VARCHAR,
  "team_id" BIGINT,
  "team_abbreviation" VARCHAR,
  "age" DOUBLE,
  "gp" BIGINT,
  "w" BIGINT,
  "l" BIGINT,
  "w_pct" DOUBLE,
  "min" DOUBLE,
  "fgm" DOUBLE,
  "fga" DOUBLE,
  "fg_pct" DOUBLE,
  "fg3m" DOUBLE,
  "fg3a" DOUBLE,
  "fg3_pct" DOUBLE,
  "ftm" DOUBLE,
  "fta" DOUBLE,
  "ft_pct" DOUBLE,
  "oreb" DOUBLE,
  "dreb" DOUBLE,
  "reb" DOUBLE,
  "ast" DOUBLE,
  "tov" DOUBLE,
  "stl" DOUBLE,
  "blk" DOUBLE,
  "blka" DOUBLE,
  "pf" DOUBLE,
  "pfd" DOUBLE,
  "pts" DOUBLE,
  "plus_minus" DOUBLE,
  "nba_fantasy_pts" DOUBLE,
  "dd2" BIGINT,
  "td3" BIGINT,
  "wnba_fantasy_pts" DOUBLE,
  "gp_rank" BIGINT,
  "w_rank" BIGINT,
  "l_rank" BIGINT,
  "w_pct_rank" BIGINT,
  "min_rank" BIGINT,
  "fgm_rank" BIGINT,
  "fga_rank" BIGINT,
  "fg_pct_rank" BIGINT,
  "fg3m_rank" BIGINT,
  "fg3a_rank" BIGINT,
  "fg3_pct_rank" BIGINT,
  "ftm_rank" BIGINT,
  "fta_rank" BIGINT,
  "ft_pct_rank" BIGINT,
  "oreb_rank" BIGINT,
  "dreb_rank" BIGINT,
  "reb_rank" BIGINT,
  "ast_rank" BIGINT,
  "tov_rank" BIGINT,
  "stl_rank" BIGINT,
  "blk_rank" BIGINT,
  "blka_rank" BIGINT,
  "pf_rank" BIGINT,
  "pfd_rank" BIGINT,
  "pts_rank" BIGINT,
  "plus_minus_rank" BIGINT,
  "nba_fantasy_pts_rank" BIGINT,
  "dd2_rank" BIGINT,
  "td3_rank" BIGINT,
  "wnba_fantasy_pts_rank" BIGINT,
  "year" VARCHAR
);

CREATE TABLE bottompositiontime (
  "rnk" BIGINT,
  "fighter" VARCHAR,
  "time" VARCHAR
);

CREATE TABLE bottompositiontimepercentage (
  "rnk" BIGINT,
  "fighter" VARCHAR,
  "percent" VARCHAR
);

CREATE TABLE center (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "player" VARCHAR,
  "team" VARCHAR,
  "year_signed" BIGINT,
  "years" BIGINT,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "value" BIGINT,
  "apy" BIGINT,
  "guaranteed" BIGINT,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "apy_as_of_cap_at_signing" VARCHAR  -- APY As % Of Cap At Signing,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "inflated_value" BIGINT,
  "inflated_apy" BIGINT,
  "inflated_guaranteed" BIGINT
);

CREATE TABLE combined (
  "player" VARCHAR,
  "team" VARCHAR,
  "year_signed" BIGINT,
  "years" DOUBLE,
  "value" BIGINT,
  "apy" BIGINT,
  "guaranteed" BIGINT,
  "apy_as_of_cap_at_signing" VARCHAR  -- APY As % Of Cap At Signing,
  "inflated_value" BIGINT,
  "inflated_apy" BIGINT,
  "inflated_guaranteed" BIGINT,
  "position" VARCHAR
);

CREATE TABLE controltime (
  "rnk" BIGINT,
  "fighter" VARCHAR,
  "time" VARCHAR
);

CREATE TABLE controltimepercentage (
  "rnk" BIGINT,
  "fighter" VARCHAR,
  "percent" VARCHAR
);

CREATE TABLE cornerback (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "player" VARCHAR,
  "team" VARCHAR,
  "year_signed" BIGINT,
  "years" DOUBLE,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "value" BIGINT,
  "apy" BIGINT,
  "guaranteed" BIGINT,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "apy_as_of_cap_at_signing" VARCHAR  -- APY As % Of Cap At Signing,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "inflated_value" BIGINT,
  "inflated_apy" BIGINT,
  "inflated_guaranteed" BIGINT
);

CREATE TABLE decisionwins (
  "rnk" BIGINT,
  "fighter" VARCHAR,
  "total" BIGINT
);

CREATE TABLE edge_rusher (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "player" VARCHAR,
  "team" VARCHAR,
  "year_signed" BIGINT,
  "years" DOUBLE,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "value" BIGINT,
  "apy" BIGINT,
  "guaranteed" BIGINT,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "apy_as_of_cap_at_signing" VARCHAR  -- APY As % Of Cap At Signing,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "inflated_value" BIGINT,
  "inflated_apy" BIGINT,
  "inflated_guaranteed" BIGINT
);

CREATE TABLE eligible_salaries_2019 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "player" VARCHAR,
  "age" DOUBLE,
  "service_time" DOUBLE,
  "contract" BIGINT,
  "aav" VARCHAR,
  "n_2025" BIGINT  -- 2025,
  "n_2026" VARCHAR  -- 2026,
  "n_2027" VARCHAR  -- 2027,
  "n_2028" VARCHAR  -- 2028,
  "n_2029" VARCHAR  -- 2029,
  "n_2030" VARCHAR  -- 2030,
  "n_2031" VARCHAR  -- 2031
);