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

CREATE TABLE interceptions (
  "player" VARCHAR,
  "int" BIGINT,
  "int_td" BIGINT,
  "int_yds" BIGINT,
  "lng" BIGINT
);

CREATE TABLE interior_defensive_line (
  "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 kicker (
  "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 kickoff_returns (
  "player" VARCHAR,
  "avg" DOUBLE,
  "ret" BIGINT,
  "yds" BIGINT,
  "kret_td" BIGINT,
  "n_20" BIGINT  -- 20+,
  "n_40" BIGINT  -- 40+,
  "lng" BIGINT,
  "fc" BIGINT,
  "fum" BIGINT
);

CREATE TABLE kickoffs (
  "player" VARCHAR,
  "ko" BIGINT,
  "yds" BIGINT,
  "ret_yds" BIGINT,
  "tb" BIGINT,
  "tb_a6c929" DOUBLE  -- TB %,
  "ret" BIGINT,
  "ret_avg" DOUBLE,
  "osk" BIGINT,
  "osk_rec" BIGINT,
  "oob" BIGINT,
  "td" BIGINT
);

CREATE TABLE knockdowns (
  "rnk" BIGINT,
  "event" VARCHAR,
  "total" BIGINT
);

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

CREATE TABLE kotkowins (
  "rnk" BIGINT,
  "event" VARCHAR,
  "total" BIGINT
);

CREATE TABLE left_guard (
  "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 left_tackle (
  "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 linebacker (
  "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 longestevent (
  "rnk" BIGINT,
  "event" VARCHAR,
  "time" VARCHAR
);

CREATE TABLE long_snapper (
  "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 n_1990_1991 (
  "ranking" DOUBLE,
  "team" VARCHAR,
  "n_1990_91" BIGINT  -- 1990/91,
  "n_1990_91_066538" BIGINT  -- 1990/91(*)
);

CREATE TABLE n_1991_1992 (
  "ranking" DOUBLE,
  "team" VARCHAR,
  "n_1991_92" BIGINT  -- 1991/92,
  "n_1991_92_790a5e" BIGINT  -- 1991/92(*)
);

CREATE TABLE n_1992_1993 (
  "ranking" DOUBLE,
  "team" VARCHAR,
  "n_1992_93" BIGINT  -- 1992/93,
  "n_1992_93_6562dd" BIGINT  -- 1992/93(*)
);

CREATE TABLE n_1993_1994 (
  "ranking" DOUBLE,
  "team" VARCHAR,
  "n_1993_94" BIGINT  -- 1993/94,
  "n_1993_94_641292" BIGINT  -- 1993/94(*)
);

CREATE TABLE n_1994_1995 (
  "ranking" DOUBLE,
  "team" VARCHAR,
  "n_1994_95" BIGINT  -- 1994/95,
  "n_1994_95_d07a1c" BIGINT  -- 1994/95(*)
);

CREATE TABLE n_1995_1996 (
  "ranking" DOUBLE,
  "team" VARCHAR,
  "n_1995_96" BIGINT  -- 1995/96,
  "n_1995_96_304c71" BIGINT  -- 1995/96(*)
);

CREATE TABLE n_1996_1997 (
  "ranking" DOUBLE,
  "team" VARCHAR,
  "n_1996_97" BIGINT  -- 1996/97,
  "n_1996_97_40a017" BIGINT  -- 1996/97(*)
);

CREATE TABLE n_1997_1998 (
  "ranking" DOUBLE,
  "team" VARCHAR,
  "n_1997_98" BIGINT  -- 1997/98,
  "n_1997_98_251faf" BIGINT  -- 1997/98(*)
);

CREATE TABLE n_1998_1999 (
  "ranking" DOUBLE,
  "team" VARCHAR,
  "n_1998_99" BIGINT  -- 1998/99,
  "n_1998_99_7f9560" BIGINT  -- 1998/99(*)
);

CREATE TABLE n_1999_2000 (
  "ranking" DOUBLE,
  "team" VARCHAR,
  "n_1999_00" BIGINT  -- 1999/00,
  "n_1999_00_b48994" BIGINT  -- 1999/00(*)
);

CREATE TABLE n_2000_2001 (
  "ranking" DOUBLE,
  "team" VARCHAR,
  "n_2000_01" BIGINT  -- 2000/01,
  "n_2000_01_2b3557" BIGINT  -- 2000/01(*)
);

CREATE TABLE n_2001_2002 (
  "ranking" DOUBLE,
  "team" VARCHAR,
  "n_2001_02" BIGINT  -- 2001/02,
  "n_2001_02_e6e70a" BIGINT  -- 2001/02(*)
);

CREATE TABLE n_2002_2003 (
  "ranking" DOUBLE,
  "team" VARCHAR,
  "n_2002_03" BIGINT  -- 2002/03,
  "n_2002_03_4c604c" BIGINT  -- 2002/03(*)
);

CREATE TABLE n_2003_2004 (
  "ranking" DOUBLE,
  "team" VARCHAR,
  "n_2003_04" BIGINT  -- 2003/04,
  "n_2003_04_0b4629" BIGINT  -- 2003/04(*)
);

CREATE TABLE n_2004_2005 (
  "ranking" DOUBLE,
  "team" VARCHAR,
  "n_2004_05" BIGINT  -- 2004/05,
  "n_2004_05_dda7f7" BIGINT  -- 2004/05(*)
);

CREATE TABLE n_2005_2006 (
  "ranking" DOUBLE,
  "team" VARCHAR,
  "n_2005_06" BIGINT  -- 2005/06,
  "n_2005_06_88602c" BIGINT  -- 2005/06(*)
);

CREATE TABLE n_2006_2007 (
  "ranking" DOUBLE,
  "team" VARCHAR,
  "n_2006_07" BIGINT  -- 2006/07,
  "n_2006_07_cb5291" BIGINT  -- 2006/07(*)
);

CREATE TABLE n_2007_2008 (
  "ranking" DOUBLE,
  "team" VARCHAR,
  "n_2007_08" BIGINT  -- 2007/08,
  "n_2007_08_db045a" BIGINT  -- 2007/08(*)
);

CREATE TABLE n_2008_2009 (
  "ranking" DOUBLE,
  "team" VARCHAR,
  "n_2008_09" BIGINT  -- 2008/09,
  "n_2008_09_85b369" BIGINT  -- 2008/09(*)
);

CREATE TABLE n_2009_2010 (
  "ranking" DOUBLE,
  "team" VARCHAR,
  "n_2009_10" BIGINT  -- 2009/10,
  "n_2009_10_18090d" BIGINT  -- 2009/10(*)
);

CREATE TABLE n_2010_2011 (
  "ranking" DOUBLE,
  "team" VARCHAR,
  "n_2010_11" BIGINT  -- 2010/11,
  "n_2010_11_38043b" BIGINT  -- 2010/11(*)
);

CREATE TABLE n_2011_2012 (
  "ranking" DOUBLE,
  "team" VARCHAR,
  "n_2011_12" BIGINT  -- 2011/12,
  "n_2011_12_8d36e8" BIGINT  -- 2011/12(*)
);

CREATE TABLE n_2012_2013 (
  "ranking" DOUBLE,
  "team" VARCHAR,
  "n_2012_13" BIGINT  -- 2012/13,
  "n_2012_13_3dfd2c" BIGINT  -- 2012/13(*)
);

CREATE TABLE n_2013_2014 (
  "ranking" DOUBLE,
  "team" VARCHAR,
  "n_2013_14" BIGINT  -- 2013/14,
  "n_2013_14_60ffd9" BIGINT  -- 2013/14(*)
);

CREATE TABLE n_2014_2015 (
  "ranking" DOUBLE,
  "team" VARCHAR,
  "n_2014_15" BIGINT  -- 2014/15,
  "n_2014_15_2decd0" BIGINT  -- 2014/15(*)
);

CREATE TABLE n_2015_2016 (
  "ranking" DOUBLE,
  "team" VARCHAR,
  "n_2015_16" BIGINT  -- 2015/16,
  "n_2015_16_f2e521" BIGINT  -- 2015/16(*)
);

CREATE TABLE n_2016_2017 (
  "ranking" DOUBLE,
  "team" VARCHAR,
  "n_2016_17" BIGINT  -- 2016/17,
  "n_2016_17_550dda" BIGINT  -- 2016/17(*)
);

CREATE TABLE n_2017_2018 (
  "ranking" DOUBLE,
  "team" VARCHAR,
  "n_2017_18" BIGINT  -- 2017/18,
  "n_2017_18_32a8c7" BIGINT  -- 2017/18(*)
);

CREATE TABLE n_2018_2019 (
  "ranking" DOUBLE,
  "player" VARCHAR,
  "n_2018_19" BIGINT  -- 2018/19,
  "n_2018_19_4fc188" BIGINT  -- 2018/19(*)
);

CREATE TABLE n_2019_2020 (
  "ranking" DOUBLE,
  "team" VARCHAR,
  "n_2019_20" BIGINT  -- 2019/20,
  "n_2019_20_c98c48" BIGINT  -- 2019/20(*)
);

CREATE TABLE n_2020_2021 (
  "ranking" DOUBLE,
  "player" VARCHAR,
  "n_2020_21" BIGINT  -- 2020/21,
  "n_2020_21_22bd20" BIGINT  -- 2020/21(*)
);

CREATE TABLE n_2021_2022 (
  "ranking" DOUBLE,
  "team" VARCHAR,
  "n_2021_22" BIGINT  -- 2021/22,
  "n_2021_22_438693" BIGINT  -- 2021/22(*)
);

CREATE TABLE n_2022_2023 (
  "ranking" DOUBLE,
  "team" VARCHAR,
  "n_2022_23" BIGINT  -- 2022/23,
  "n_2022_23_0be4ec" BIGINT  -- 2022/23(*)
);

CREATE TABLE n_2023_2024 (
  "ranking" DOUBLE,
  "team" VARCHAR,
  "n_2023_24" BIGINT  -- 2023/24,
  "n_2023_24_b41bfc" BIGINT  -- 2023/24(*)
);

CREATE TABLE n_2024_2025 (
  "ranking" DOUBLE,
  "team" VARCHAR,
  "n_2024_25" BIGINT  -- 2024/25,
  "n_2025_26" BIGINT  -- 2025/26,
  "n_2026_27" BIGINT  -- 2026/27,
  "n_2027_28" BIGINT  -- 2027/28,
  "n_2028_29" BIGINT  -- 2028/29,
  "n_2029_30" BIGINT  -- 2029/30
);

CREATE TABLE passing (
  "player" VARCHAR,
  "pass_yds" BIGINT,
  "yds_att" DOUBLE,
  "att" BIGINT,
  "cmp" BIGINT,
  "cmp_fbd6fd" DOUBLE  -- Cmp %,
  "td" BIGINT,
  "int" BIGINT,
  "rate" DOUBLE,
  "n_1st" BIGINT  -- 1st,
  "n_1st_7f159d" DOUBLE  -- 1st%,
  "n_20" BIGINT  -- 20+,
  "n_40" BIGINT  -- 40+,
  "lng" BIGINT,
  "sck" BIGINT,
  "scky" BIGINT
);

CREATE TABLE pitching_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,
  "winningpercentage" VARCHAR,
  "runsscoredper9" VARCHAR,
  "battersfaced" DOUBLE,
  "strikeoutsper9" VARCHAR,
  "baseonballsper9" VARCHAR,
  "homerunsper9" VARCHAR,
  "hitsper9" VARCHAR,
  "strikesoutstowalks" VARCHAR,
  "gamesfinished" DOUBLE,
  "wildpitches" DOUBLE,
  "walksperplateappearance" VARCHAR,
  "strikeoutsperplateappearance" VARCHAR,
  "homerunsperplateappearance" VARCHAR,
  "walksperstrikeout" VARCHAR,
  "gamesplayed" BIGINT,
  "gamesstarted" BIGINT,
  "runs" BIGINT,
  "homeruns" DOUBLE,
  "strikeouts" BIGINT,
  "baseonballs" BIGINT,
  "hits" BIGINT,
  "era" VARCHAR,
  "inningspitched" DOUBLE,
  "wins" BIGINT,
  "losses" BIGINT,
  "saves" BIGINT,
  "earnedruns" BIGINT,
  "whip" VARCHAR,
  "outs" BIGINT,
  "gamespitched" BIGINT,
  "completegames" BIGINT,
  "shutouts" BIGINT,
  "winpercentage" VARCHAR,
  "strikeoutwalkratio" VARCHAR,
  "strikeoutsper9inn" VARCHAR,
  "walksper9inn" VARCHAR,
  "hitsper9inn" VARCHAR,
  "balks" DOUBLE,
  "stolenbases" DOUBLE,
  "caughtstealing" DOUBLE,
  "pickoffs" DOUBLE,
  "strikepercentage" VARCHAR,
  "pitchesperinning" VARCHAR,
  "pitchesperplateappearance" DOUBLE,
  "stolenbasepercentage" VARCHAR,
  "numberofpitches" DOUBLE,
  "strikes" DOUBLE,
  "totalbases" DOUBLE,
  "babip" VARCHAR,
  "obp" DOUBLE,
  "hitbypitch" DOUBLE,
  "avg" DOUBLE,
  "atbats" DOUBLE,
  "hitbatsmen" DOUBLE,
  "slg" DOUBLE,
  "ops" DOUBLE,
  "iso" DOUBLE,
  "sacbunts" DOUBLE,
  "doubles" DOUBLE,
  "triples" DOUBLE,
  "gidp" DOUBLE,
  "groundintodoubleplay" DOUBLE,
  "intentionalwalks" DOUBLE,
  "sacflies" DOUBLE,
  "saveopportunities" DOUBLE,
  "blownsaves" DOUBLE,
  "inheritedrunners" DOUBLE,
  "inheritedrunnersscored" DOUBLE,
  "bequeathedrunners" DOUBLE,
  "bequeathedrunnersscored" DOUBLE,
  "qualitystarts" DOUBLE,
  "gidpopp" DOUBLE,
  "totalswings" DOUBLE,
  "swingandmisses" DOUBLE,
  "ballsinplay" DOUBLE,
  "runsupport" DOUBLE,
  "flyouts" DOUBLE,
  "popouts" DOUBLE,
  "lineouts" DOUBLE,
  "groundouts" DOUBLE,
  "flyhits" DOUBLE
);