NHL NBA,MLB,NBA Salaries + Statistics (1876-2024)
Data on major North American sports leagues compiled into CSV/JSONL form.
@kaggle.chiefzach12_sports_data
Data on major North American sports leagues compiled into CSV/JSONL form.
@kaggle.chiefzach12_sports_data
All data comes from publicly available datasets compiled into one.
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
);
Anyone who has the link will be able to view this.