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
);

CREATE TABLE eligible_salaries_2020 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "player" VARCHAR,
  "age" DOUBLE,
  "service_time" DOUBLE,
  "contract" VARCHAR,
  "aav" VARCHAR,
  "n_2020" VARCHAR  -- 2020,
  "n_2021" VARCHAR  -- 2021,
  "n_2022" VARCHAR  -- 2022,
  "n_2023" VARCHAR  -- 2023,
  "n_2024" VARCHAR  -- 2024,
  "n_2025" VARCHAR  -- 2025,
  "n_2026" VARCHAR  -- 2026
);

CREATE TABLE eligible_salaries_2021 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "player" VARCHAR,
  "age" DOUBLE,
  "service_time" DOUBLE,
  "contract" BIGINT,
  "aav" VARCHAR,
  "n_2021" BIGINT  -- 2021,
  "n_2022" VARCHAR  -- 2022,
  "n_2023" VARCHAR  -- 2023,
  "n_2024" VARCHAR  -- 2024,
  "n_2025" VARCHAR  -- 2025,
  "n_2026" VARCHAR  -- 2026,
  "n_2027" VARCHAR  -- 2027
);

CREATE TABLE eligible_salaries_2022 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "player" VARCHAR,
  "age" DOUBLE,
  "service_time" DOUBLE,
  "contract" BIGINT,
  "aav" VARCHAR,
  "n_2022" BIGINT  -- 2022,
  "n_2023" VARCHAR  -- 2023,
  "n_2024" VARCHAR  -- 2024,
  "n_2025" VARCHAR  -- 2025,
  "n_2026" VARCHAR  -- 2026,
  "n_2027" VARCHAR  -- 2027,
  "n_2028" VARCHAR  -- 2028
);

CREATE TABLE eligible_salaries_2023 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "player" VARCHAR,
  "age" DOUBLE,
  "service_time" DOUBLE,
  "contract" BIGINT,
  "aav" VARCHAR,
  "n_2023" BIGINT  -- 2023,
  "n_2024" VARCHAR  -- 2024,
  "n_2025" VARCHAR  -- 2025,
  "n_2026" VARCHAR  -- 2026,
  "n_2027" VARCHAR  -- 2027,
  "n_2028" VARCHAR  -- 2028,
  "n_2029" VARCHAR  -- 2029
);

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

CREATE TABLE eligible_salaries_2025 (
  "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
);

CREATE TABLE field_goals (
  "player" VARCHAR,
  "fgm" BIGINT,
  "att" BIGINT,
  "fg" DOUBLE  -- FG %,
  "n_1_19_a_m" VARCHAR  -- 1-19 > A-M,
  "n_20_29_a_m" VARCHAR  -- 20-29 > A-M,
  "n_30_39_a_m" VARCHAR  -- 30-39 > A-M,
  "n_40_49_a_m" VARCHAR  -- 40-49 > A-M,
  "n_50_59_a_m" VARCHAR  -- 50-59 > A-M,
  "n_60_a_m" VARCHAR  -- 60+ > A-M,
  "lng" BIGINT,
  "fg_blk" BIGINT
);

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

CREATE TABLE fullback (
  "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 fumbles (
  "player" VARCHAR,
  "ff" BIGINT,
  "fr" BIGINT,
  "fr_td" BIGINT
);

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

CREATE TABLE gauranteed_salaries_2020 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "player" VARCHAR,
  "age" DOUBLE,
  "service_time" DOUBLE,
  "contract" BIGINT,
  "aav" BIGINT,
  "n_2020" BIGINT  -- 2020,
  "n_2021" VARCHAR  -- 2021,
  "n_2022" VARCHAR  -- 2022,
  "n_2023" DOUBLE  -- 2023,
  "n_2024" DOUBLE  -- 2024,
  "n_2025" VARCHAR  -- 2025,
  "n_2026" DOUBLE  -- 2026
);

CREATE TABLE gauranteed_salaries_2021 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "player" VARCHAR,
  "age" DOUBLE,
  "service_time" DOUBLE,
  "contract" BIGINT,
  "aav" BIGINT,
  "n_2021" BIGINT  -- 2021,
  "n_2022" VARCHAR  -- 2022,
  "n_2023" VARCHAR  -- 2023,
  "n_2024" VARCHAR  -- 2024,
  "n_2025" VARCHAR  -- 2025,
  "n_2026" VARCHAR  -- 2026,
  "n_2027" DOUBLE  -- 2027
);

CREATE TABLE gauranteed_salaries_2022 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "player" VARCHAR,
  "age" DOUBLE,
  "service_time" DOUBLE,
  "contract" BIGINT,
  "aav" BIGINT,
  "n_2022" BIGINT  -- 2022,
  "n_2023" VARCHAR  -- 2023,
  "n_2024" VARCHAR  -- 2024,
  "n_2025" VARCHAR  -- 2025,
  "n_2026" VARCHAR  -- 2026,
  "n_2027" VARCHAR  -- 2027,
  "n_2028" DOUBLE  -- 2028
);

CREATE TABLE gauranteed_salaries_2023 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "player" VARCHAR,
  "age" DOUBLE,
  "service_time" DOUBLE,
  "contract" VARCHAR,
  "aav" BIGINT,
  "n_2023" BIGINT  -- 2023,
  "n_2024" VARCHAR  -- 2024,
  "n_2025" VARCHAR  -- 2025,
  "n_2026" VARCHAR  -- 2026,
  "n_2027" VARCHAR  -- 2027,
  "n_2028" DOUBLE  -- 2028,
  "n_2029" DOUBLE  -- 2029
);

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

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

CREATE TABLE hitting_mlb (
  "year" BIGINT,
  "playerid" BIGINT,
  "playername" VARCHAR,
  "type" VARCHAR,
  "rank" BIGINT,
  "playerfullname" VARCHAR,
  "playerfirstname" VARCHAR,
  "playerlastname" VARCHAR,
  "playerusename" VARCHAR,
  "playerinitlastname" VARCHAR,
  "teamid" BIGINT,
  "teamabbrev" VARCHAR,
  "teamname" VARCHAR,
  "teamshortname" VARCHAR,
  "leaguename" VARCHAR,
  "leagueid" BIGINT,
  "positionabbrev" VARCHAR,
  "position" VARCHAR,
  "primarypositionabbrev" VARCHAR,
  "plateappearances" BIGINT,
  "totalbases" BIGINT,
  "babip" VARCHAR,
  "extrabasehits" BIGINT,
  "walksperplateappearance" VARCHAR,
  "strikeoutsperplateappearance" VARCHAR,
  "homerunsperplateappearance" VARCHAR,
  "walksperstrikeout" VARCHAR,
  "iso" DOUBLE,
  "gamesplayed" BIGINT,
  "runs" BIGINT,
  "doubles" BIGINT,
  "triples" BIGINT,
  "homeruns" BIGINT,
  "strikeouts" DOUBLE,
  "baseonballs" BIGINT,
  "hits" BIGINT,
  "avg" DOUBLE,
  "atbats" BIGINT,
  "slg" DOUBLE,
  "rbi" DOUBLE,
  "atbatsperhomerun" VARCHAR,
  "numberofpitches" DOUBLE,
  "pitchesperplateappearance" VARCHAR,
  "caughtstealing" DOUBLE,
  "stolenbases" DOUBLE,
  "stolenbasepercentage" VARCHAR,
  "hitbypitch" DOUBLE,
  "obp" DOUBLE,
  "ops" DOUBLE,
  "sacbunts" DOUBLE,
  "gidp" DOUBLE,
  "groundintodoubleplay" DOUBLE,
  "sacflies" DOUBLE,
  "intentionalwalks" DOUBLE,
  "leftonbase" DOUBLE,
  "gidpopp" DOUBLE,
  "reachedonerror" DOUBLE,
  "walkoffs" DOUBLE,
  "flyouts" DOUBLE,
  "totalswings" DOUBLE,
  "swingandmisses" DOUBLE,
  "ballsinplay" DOUBLE,
  "popouts" DOUBLE,
  "lineouts" DOUBLE,
  "groundouts" DOUBLE,
  "flyhits" DOUBLE,
  "pophits" DOUBLE,
  "linehits" DOUBLE,
  "groundhits" DOUBLE,
  "airouts" DOUBLE,
  "groundoutstoairouts" VARCHAR,
  "catchersinterference" DOUBLE
);

CREATE TABLE ineligible_salaries_2019 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "player" VARCHAR,
  "age" DOUBLE,
  "service_time" DOUBLE,
  "contract" VARCHAR,
  "aav" VARCHAR,
  "n_2025" VARCHAR  -- 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
);

CREATE TABLE ineligible_salaries_2020 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "player" VARCHAR,
  "age" DOUBLE,
  "service_time" DOUBLE,
  "contract" DOUBLE,
  "aav" VARCHAR,
  "n_2020" BIGINT  -- 2020,
  "n_2021" VARCHAR  -- 2021,
  "n_2022" VARCHAR  -- 2022,
  "n_2023" VARCHAR  -- 2023,
  "n_2024" VARCHAR  -- 2024,
  "n_2025" VARCHAR  -- 2025,
  "n_2026" VARCHAR  -- 2026
);

CREATE TABLE ineligible_salaries_2021 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "player" VARCHAR,
  "age" DOUBLE,
  "service_time" DOUBLE,
  "contract" DOUBLE,
  "aav" VARCHAR,
  "n_2021" DOUBLE  -- 2021,
  "n_2022" VARCHAR  -- 2022,
  "n_2023" VARCHAR  -- 2023,
  "n_2024" VARCHAR  -- 2024,
  "n_2025" VARCHAR  -- 2025,
  "n_2026" VARCHAR  -- 2026,
  "n_2027" VARCHAR  -- 2027
);

CREATE TABLE ineligible_salaries_2022 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "player" VARCHAR,
  "age" DOUBLE,
  "service_time" DOUBLE,
  "contract" DOUBLE,
  "aav" VARCHAR,
  "n_2022" DOUBLE  -- 2022,
  "n_2023" VARCHAR  -- 2023,
  "n_2024" VARCHAR  -- 2024,
  "n_2025" VARCHAR  -- 2025,
  "n_2026" VARCHAR  -- 2026,
  "n_2027" VARCHAR  -- 2027,
  "n_2028" VARCHAR  -- 2028
);

CREATE TABLE ineligible_salaries_2023 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "player" VARCHAR,
  "age" DOUBLE,
  "service_time" DOUBLE,
  "contract" VARCHAR,
  "aav" VARCHAR,
  "n_2023" VARCHAR  -- 2023,
  "n_2024" VARCHAR  -- 2024,
  "n_2025" VARCHAR  -- 2025,
  "n_2026" VARCHAR  -- 2026,
  "n_2027" VARCHAR  -- 2027,
  "n_2028" VARCHAR  -- 2028,
  "n_2029" VARCHAR  -- 2029
);

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

CREATE TABLE ineligible_salaries_2025 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "player" VARCHAR,
  "age" DOUBLE,
  "service_time" DOUBLE,
  "contract" VARCHAR,
  "aav" VARCHAR,
  "n_2025" VARCHAR  -- 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
);