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 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(*)
);
Anyone who has the link will be able to view this.