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

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