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
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_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_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_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 (
"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_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_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_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_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_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 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 right_guard (
"unnamed_0" BIGINT,
"player" VARCHAR,
"team" VARCHAR,
"year_signed" BIGINT,
"years" DOUBLE,
"unnamed_5" VARCHAR,
"value" BIGINT,
"apy" BIGINT,
"guaranteed" BIGINT,
"unnamed_9" VARCHAR,
"apy_as_of_cap_at_signing" VARCHAR,
"unnamed_11" VARCHAR,
"inflated_value" BIGINT,
"inflated_apy" BIGINT,
"inflated_guaranteed" BIGINT
);
CREATE TABLE left_guard (
"unnamed_0" BIGINT,
"player" VARCHAR,
"team" VARCHAR,
"year_signed" BIGINT,
"years" DOUBLE,
"unnamed_5" VARCHAR,
"value" BIGINT,
"apy" BIGINT,
"guaranteed" BIGINT,
"unnamed_9" VARCHAR,
"apy_as_of_cap_at_signing" VARCHAR,
"unnamed_11" VARCHAR,
"inflated_value" BIGINT,
"inflated_apy" BIGINT,
"inflated_guaranteed" BIGINT
);
CREATE TABLE kicker (
"unnamed_0" BIGINT,
"player" VARCHAR,
"team" VARCHAR,
"year_signed" BIGINT,
"years" BIGINT,
"unnamed_5" VARCHAR,
"value" BIGINT,
"apy" BIGINT,
"guaranteed" BIGINT,
"unnamed_9" VARCHAR,
"apy_as_of_cap_at_signing" VARCHAR,
"unnamed_11" VARCHAR,
"inflated_value" BIGINT,
"inflated_apy" BIGINT,
"inflated_guaranteed" BIGINT
);
CREATE TABLE edge_rusher (
"unnamed_0" BIGINT,
"player" VARCHAR,
"team" VARCHAR,
"year_signed" BIGINT,
"years" DOUBLE,
"unnamed_5" VARCHAR,
"value" BIGINT,
"apy" BIGINT,
"guaranteed" BIGINT,
"unnamed_9" VARCHAR,
"apy_as_of_cap_at_signing" VARCHAR,
"unnamed_11" VARCHAR,
"inflated_value" BIGINT,
"inflated_apy" BIGINT,
"inflated_guaranteed" BIGINT
);
CREATE TABLE fullback (
"unnamed_0" BIGINT,
"player" VARCHAR,
"team" VARCHAR,
"year_signed" BIGINT,
"years" BIGINT,
"unnamed_5" VARCHAR,
"value" BIGINT,
"apy" BIGINT,
"guaranteed" BIGINT,
"unnamed_9" VARCHAR,
"apy_as_of_cap_at_signing" VARCHAR,
"unnamed_11" VARCHAR,
"inflated_value" BIGINT,
"inflated_apy" BIGINT,
"inflated_guaranteed" BIGINT
);
CREATE TABLE interior_defensive_line (
"unnamed_0" BIGINT,
"player" VARCHAR,
"team" VARCHAR,
"year_signed" BIGINT,
"years" DOUBLE,
"unnamed_5" VARCHAR,
"value" BIGINT,
"apy" BIGINT,
"guaranteed" BIGINT,
"unnamed_9" VARCHAR,
"apy_as_of_cap_at_signing" VARCHAR,
"unnamed_11" VARCHAR,
"inflated_value" BIGINT,
"inflated_apy" BIGINT,
"inflated_guaranteed" BIGINT
);
CREATE TABLE center (
"unnamed_0" BIGINT,
"player" VARCHAR,
"team" VARCHAR,
"year_signed" BIGINT,
"years" BIGINT,
"unnamed_5" VARCHAR,
"value" BIGINT,
"apy" BIGINT,
"guaranteed" BIGINT,
"unnamed_9" VARCHAR,
"apy_as_of_cap_at_signing" VARCHAR,
"unnamed_11" VARCHAR,
"inflated_value" BIGINT,
"inflated_apy" BIGINT,
"inflated_guaranteed" BIGINT
);
CREATE TABLE wide_receiver (
"unnamed_0" BIGINT,
"player" VARCHAR,
"team" VARCHAR,
"year_signed" BIGINT,
"years" DOUBLE,
"unnamed_5" VARCHAR,
"value" BIGINT,
"apy" BIGINT,
"guaranteed" BIGINT,
"unnamed_9" VARCHAR,
"apy_as_of_cap_at_signing" VARCHAR,
"unnamed_11" VARCHAR,
"inflated_value" BIGINT,
"inflated_apy" BIGINT,
"inflated_guaranteed" BIGINT
);
CREATE TABLE right_tackle (
"unnamed_0" BIGINT,
"player" VARCHAR,
"team" VARCHAR,
"year_signed" BIGINT,
"years" DOUBLE,
"unnamed_5" VARCHAR,
"value" BIGINT,
"apy" BIGINT,
"guaranteed" BIGINT,
"unnamed_9" VARCHAR,
"apy_as_of_cap_at_signing" VARCHAR,
"unnamed_11" VARCHAR,
"inflated_value" BIGINT,
"inflated_apy" BIGINT,
"inflated_guaranteed" BIGINT
);
CREATE TABLE long_snapper (
"unnamed_0" BIGINT,
"player" VARCHAR,
"team" VARCHAR,
"year_signed" BIGINT,
"years" BIGINT,
"unnamed_5" VARCHAR,
"value" BIGINT,
"apy" BIGINT,
"guaranteed" BIGINT,
"unnamed_9" VARCHAR,
"apy_as_of_cap_at_signing" VARCHAR,
"unnamed_11" VARCHAR,
"inflated_value" BIGINT,
"inflated_apy" BIGINT,
"inflated_guaranteed" BIGINT
);
CREATE TABLE safety (
"unnamed_0" BIGINT,
"player" VARCHAR,
"team" VARCHAR,
"year_signed" BIGINT,
"years" DOUBLE,
"unnamed_5" VARCHAR,
"value" BIGINT,
"apy" BIGINT,
"guaranteed" BIGINT,
"unnamed_9" VARCHAR,
"apy_as_of_cap_at_signing" VARCHAR,
"unnamed_11" VARCHAR,
"inflated_value" BIGINT,
"inflated_apy" BIGINT,
"inflated_guaranteed" BIGINT
);
CREATE TABLE cornerback (
"unnamed_0" BIGINT,
"player" VARCHAR,
"team" VARCHAR,
"year_signed" BIGINT,
"years" DOUBLE,
"unnamed_5" VARCHAR,
"value" BIGINT,
"apy" BIGINT,
"guaranteed" BIGINT,
"unnamed_9" VARCHAR,
"apy_as_of_cap_at_signing" VARCHAR,
"unnamed_11" VARCHAR,
"inflated_value" BIGINT,
"inflated_apy" BIGINT,
"inflated_guaranteed" BIGINT
);
CREATE TABLE punter (
"unnamed_0" BIGINT,
"player" VARCHAR,
"team" VARCHAR,
"year_signed" BIGINT,
"years" BIGINT,
"unnamed_5" VARCHAR,
"value" BIGINT,
"apy" BIGINT,
"guaranteed" BIGINT,
"unnamed_9" VARCHAR,
"apy_as_of_cap_at_signing" VARCHAR,
"unnamed_11" VARCHAR,
"inflated_value" BIGINT,
"inflated_apy" BIGINT,
"inflated_guaranteed" BIGINT
);
CREATE TABLE quarterback (
"unnamed_0" BIGINT,
"player" VARCHAR,
"team" VARCHAR,
"year_signed" BIGINT,
"years" BIGINT,
"unnamed_5" VARCHAR,
"value" BIGINT,
"apy" BIGINT,
"guaranteed" BIGINT,
"unnamed_9" VARCHAR,
"apy_as_of_cap_at_signing" VARCHAR,
"unnamed_11" VARCHAR,
"inflated_value" BIGINT,
"inflated_apy" BIGINT,
"inflated_guaranteed" BIGINT
);
CREATE TABLE tight_end (
"unnamed_0" BIGINT,
"player" VARCHAR,
"team" VARCHAR,
"year_signed" BIGINT,
"years" DOUBLE,
"unnamed_5" VARCHAR,
"value" BIGINT,
"apy" BIGINT,
"guaranteed" BIGINT,
"unnamed_9" VARCHAR,
"apy_as_of_cap_at_signing" VARCHAR,
"unnamed_11" VARCHAR,
"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,
"inflated_value" BIGINT,
"inflated_apy" BIGINT,
"inflated_guaranteed" BIGINT,
"position" VARCHAR
);
CREATE TABLE linebacker (
"unnamed_0" BIGINT,
"player" VARCHAR,
"team" VARCHAR,
"year_signed" BIGINT,
"years" DOUBLE,
"unnamed_5" VARCHAR,
"value" BIGINT,
"apy" BIGINT,
"guaranteed" BIGINT,
"unnamed_9" VARCHAR,
"apy_as_of_cap_at_signing" VARCHAR,
"unnamed_11" VARCHAR,
"inflated_value" BIGINT,
"inflated_apy" BIGINT,
"inflated_guaranteed" BIGINT
);
CREATE TABLE left_tackle (
"unnamed_0" BIGINT,
"player" VARCHAR,
"team" VARCHAR,
"year_signed" BIGINT,
"years" DOUBLE,
"unnamed_5" VARCHAR,
"value" BIGINT,
"apy" BIGINT,
"guaranteed" BIGINT,
"unnamed_9" VARCHAR,
"apy_as_of_cap_at_signing" VARCHAR,
"unnamed_11" VARCHAR,
"inflated_value" BIGINT,
"inflated_apy" BIGINT,
"inflated_guaranteed" BIGINT
);
CREATE TABLE running_back (
"unnamed_0" BIGINT,
"player" VARCHAR,
"team" VARCHAR,
"year_signed" BIGINT,
"years" DOUBLE,
"unnamed_5" VARCHAR,
"value" BIGINT,
"apy" BIGINT,
"guaranteed" BIGINT,
"unnamed_9" VARCHAR,
"apy_as_of_cap_at_signing" VARCHAR,
"unnamed_11" VARCHAR,
"inflated_value" BIGINT,
"inflated_apy" BIGINT,
"inflated_guaranteed" BIGINT
);
CREATE TABLE rushing (
"player" VARCHAR,
"rush_yds" BIGINT,
"att" BIGINT,
"td" BIGINT,
"n_20" BIGINT,
"n_40" BIGINT,
"lng" BIGINT,
"rush_1st" BIGINT,
"rush_1st_44363c" DOUBLE,
"rush_fum" BIGINT
);
CREATE TABLE punts (
"player" VARCHAR,
"avg" DOUBLE,
"net_avg" DOUBLE,
"net_yds" BIGINT,
"punts" BIGINT,
"lng" BIGINT,
"yds" BIGINT,
"in_20" BIGINT,
"oob" BIGINT,
"dn" BIGINT,
"tb" BIGINT,
"fc" BIGINT,
"ret" BIGINT,
"rety" BIGINT,
"td" BIGINT,
"p_blk" BIGINT
);
CREATE TABLE passing (
"player" VARCHAR,
"pass_yds" BIGINT,
"yds_att" DOUBLE,
"att" BIGINT,
"cmp" BIGINT,
"cmp_fbd6fd" DOUBLE,
"td" BIGINT,
"int" BIGINT,
"rate" DOUBLE,
"n_1st" BIGINT,
"n_1st_7f159d" DOUBLE,
"n_20" BIGINT,
"n_40" BIGINT,
"lng" BIGINT,
"sck" BIGINT,
"scky" BIGINT
);
CREATE TABLE tackles (
"player" VARCHAR,
"comb" BIGINT,
"asst" BIGINT,
"solo" BIGINT,
"sck" DOUBLE
);
CREATE TABLE receiving (
"player" VARCHAR,
"rec" BIGINT,
"yds" BIGINT,
"td" BIGINT,
"n_20" BIGINT,
"n_40" BIGINT,
"lng" BIGINT,
"rec_1st" BIGINT,
"n_1st" DOUBLE,
"rec_fum" BIGINT,
"rec_yac_r" BIGINT,
"tgts" BIGINT
);
CREATE TABLE punt_returns (
"player" VARCHAR,
"avg" DOUBLE,
"ret" BIGINT,
"yds" BIGINT,
"pret_t" BIGINT,
"n_20" BIGINT,
"n_40" BIGINT,
"lng" BIGINT,
"fc" BIGINT,
"fum" BIGINT
);
CREATE TABLE kickoffs (
"player" VARCHAR,
"ko" BIGINT,
"yds" BIGINT,
"ret_yds" BIGINT,
"tb" BIGINT,
"tb_a6c929" DOUBLE,
"ret" BIGINT,
"ret_avg" DOUBLE,
"osk" BIGINT,
"osk_rec" BIGINT,
"oob" BIGINT,
"td" BIGINT
);
CREATE TABLE interceptions (
"player" VARCHAR,
"int" BIGINT,
"int_td" BIGINT,
"int_yds" BIGINT,
"lng" BIGINT
);
CREATE TABLE field_goals (
"player" VARCHAR,
"fgm" BIGINT,
"att" BIGINT,
"fg" DOUBLE,
"n_1_19_a_m" VARCHAR,
"n_20_29_a_m" VARCHAR,
"n_30_39_a_m" VARCHAR,
"n_40_49_a_m" VARCHAR,
"n_50_59_a_m" VARCHAR,
"n_60_a_m" VARCHAR,
"lng" BIGINT,
"fg_blk" BIGINT
);
CREATE TABLE kickoff_returns (
"player" VARCHAR,
"avg" DOUBLE,
"ret" BIGINT,
"yds" BIGINT,
"kret_td" BIGINT,
"n_20" BIGINT,
"n_40" BIGINT,
"lng" BIGINT,
"fc" BIGINT,
"fum" BIGINT
);
CREATE TABLE fumbles (
"player" VARCHAR,
"ff" BIGINT,
"fr" BIGINT,
"fr_td" BIGINT
);
CREATE TABLE gauranteed_salaries_2025 (
"unnamed_0" BIGINT,
"player" VARCHAR,
"age" DOUBLE,
"service_time" DOUBLE,
"contract" BIGINT,
"aav" BIGINT,
"n_2025" BIGINT,
"n_2026" VARCHAR,
"n_2027" VARCHAR,
"n_2028" VARCHAR,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" VARCHAR
);
CREATE TABLE gauranteed_salaries_2022 (
"unnamed_0" BIGINT,
"player" VARCHAR,
"age" DOUBLE,
"service_time" DOUBLE,
"contract" BIGINT,
"aav" BIGINT,
"n_2022" BIGINT,
"n_2023" VARCHAR,
"n_2024" VARCHAR,
"n_2025" VARCHAR,
"n_2026" VARCHAR,
"n_2027" VARCHAR,
"n_2028" DOUBLE
);
CREATE TABLE eligible_salaries_2020 (
"unnamed_0" BIGINT,
"player" VARCHAR,
"age" DOUBLE,
"service_time" DOUBLE,
"contract" VARCHAR,
"aav" VARCHAR,
"n_2020" VARCHAR,
"n_2021" VARCHAR,
"n_2022" VARCHAR,
"n_2023" VARCHAR,
"n_2024" VARCHAR,
"n_2025" VARCHAR,
"n_2026" VARCHAR
);
CREATE TABLE ineligible_salaries_2019 (
"unnamed_0" BIGINT,
"player" VARCHAR,
"age" DOUBLE,
"service_time" DOUBLE,
"contract" VARCHAR,
"aav" VARCHAR,
"n_2025" VARCHAR,
"n_2026" VARCHAR,
"n_2027" VARCHAR,
"n_2028" VARCHAR,
"n_2029" VARCHAR,
"n_2030" VARCHAR,
"n_2031" VARCHAR
);
CREATE TABLE eligible_salaries_2024 (
"unnamed_0" BIGINT,
"player" VARCHAR,
"age" DOUBLE,
"service_time" DOUBLE,
"contract" BIGINT,
"aav" VARCHAR,
"n_2024" BIGINT,
"n_2025" VARCHAR,
"n_2026" VARCHAR,
"n_2027" VARCHAR,
"n_2028" VARCHAR,
"n_2029" VARCHAR,
"n_2030" VARCHAR
);
CREATE TABLE ineligible_salaries_2020 (
"unnamed_0" BIGINT,
"player" VARCHAR,
"age" DOUBLE,
"service_time" DOUBLE,
"contract" DOUBLE,
"aav" VARCHAR,
"n_2020" BIGINT,
"n_2021" VARCHAR,
"n_2022" VARCHAR,
"n_2023" VARCHAR,
"n_2024" VARCHAR,
"n_2025" VARCHAR,
"n_2026" VARCHAR
);
CREATE TABLE gauranteed_salaries_2021 (
"unnamed_0" BIGINT,
"player" VARCHAR,
"age" DOUBLE,
"service_time" DOUBLE,
"contract" BIGINT,
"aav" BIGINT,
"n_2021" BIGINT,
"n_2022" VARCHAR,
"n_2023" VARCHAR,
"n_2024" VARCHAR,
"n_2025" VARCHAR,
"n_2026" VARCHAR,
"n_2027" DOUBLE
);
CREATE TABLE gauranteed_salaries_2024 (
"unnamed_0" BIGINT,
"player" VARCHAR,
"age" DOUBLE,
"service_time" DOUBLE,
"contract" VARCHAR,
"aav" BIGINT,
"n_2024" BIGINT,
"n_2025" VARCHAR,
"n_2026" VARCHAR,
"n_2027" VARCHAR,
"n_2028" VARCHAR,
"n_2029" DOUBLE,
"n_2030" DOUBLE
);
CREATE TABLE ineligible_salaries_2022 (
"unnamed_0" BIGINT,
"player" VARCHAR,
"age" DOUBLE,
"service_time" DOUBLE,
"contract" DOUBLE,
"aav" VARCHAR,
"n_2022" DOUBLE,
"n_2023" VARCHAR,
"n_2024" VARCHAR,
"n_2025" VARCHAR,
"n_2026" VARCHAR,
"n_2027" VARCHAR,
"n_2028" VARCHAR
);
CREATE TABLE eligible_salaries_2025 (
"unnamed_0" BIGINT,
"player" VARCHAR,
"age" DOUBLE,
"service_time" DOUBLE,
"contract" BIGINT,
"aav" VARCHAR,
"n_2025" BIGINT,
"n_2026" VARCHAR,
"n_2027" VARCHAR,
"n_2028" VARCHAR,
"n_2029" VARCHAR,
"n_2030" VARCHAR,
"n_2031" VARCHAR
);
CREATE TABLE ineligible_salaries_2024 (
"unnamed_0" BIGINT,
"player" VARCHAR,
"age" DOUBLE,
"service_time" DOUBLE,
"contract" DOUBLE,
"aav" VARCHAR,
"n_2024" DOUBLE,
"n_2025" VARCHAR,
"n_2026" VARCHAR,
"n_2027" VARCHAR,
"n_2028" VARCHAR,
"n_2029" VARCHAR,
"n_2030" VARCHAR
);
CREATE TABLE ineligible_salaries_2025 (
"unnamed_0" BIGINT,
"player" VARCHAR,
"age" DOUBLE,
"service_time" DOUBLE,
"contract" VARCHAR,
"aav" VARCHAR,
"n_2025" VARCHAR,
"n_2026" VARCHAR,
"n_2027" VARCHAR,
"n_2028" VARCHAR,
"n_2029" VARCHAR,
"n_2030" VARCHAR,
"n_2031" VARCHAR
);
CREATE TABLE eligible_salaries_2022 (
"unnamed_0" BIGINT,
"player" VARCHAR,
"age" DOUBLE,
"service_time" DOUBLE,
"contract" BIGINT,
"aav" VARCHAR,
"n_2022" BIGINT,
"n_2023" VARCHAR,
"n_2024" VARCHAR,
"n_2025" VARCHAR,
"n_2026" VARCHAR,
"n_2027" VARCHAR,
"n_2028" VARCHAR
);
CREATE TABLE ineligible_salaries_2021 (
"unnamed_0" BIGINT,
"player" VARCHAR,
"age" DOUBLE,
"service_time" DOUBLE,
"contract" DOUBLE,
"aav" VARCHAR,
"n_2021" DOUBLE,
"n_2022" VARCHAR,
"n_2023" VARCHAR,
"n_2024" VARCHAR,
"n_2025" VARCHAR,
"n_2026" VARCHAR,
"n_2027" VARCHAR
);
CREATE TABLE gauranteed_salaries_2023 (
"unnamed_0" BIGINT,
"player" VARCHAR,
"age" DOUBLE,
"service_time" DOUBLE,
"contract" VARCHAR,
"aav" BIGINT,
"n_2023" BIGINT,
"n_2024" VARCHAR,
"n_2025" VARCHAR,
"n_2026" VARCHAR,
"n_2027" VARCHAR,
"n_2028" DOUBLE,
"n_2029" DOUBLE
);
CREATE TABLE gauranteed_salaries_2019 (
"unnamed_0" BIGINT,
"player" VARCHAR,
"age" DOUBLE,
"service_time" DOUBLE,
"contract" BIGINT,
"aav" BIGINT,
"n_2025" BIGINT,
"n_2026" VARCHAR,
"n_2027" VARCHAR,
"n_2028" VARCHAR,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" VARCHAR
);
CREATE TABLE eligible_salaries_2019 (
"unnamed_0" BIGINT,
"player" VARCHAR,
"age" DOUBLE,
"service_time" DOUBLE,
"contract" BIGINT,
"aav" VARCHAR,
"n_2025" BIGINT,
"n_2026" VARCHAR,
"n_2027" VARCHAR,
"n_2028" VARCHAR,
"n_2029" VARCHAR,
"n_2030" VARCHAR,
"n_2031" VARCHAR
);
CREATE TABLE eligible_salaries_2023 (
"unnamed_0" BIGINT,
"player" VARCHAR,
"age" DOUBLE,
"service_time" DOUBLE,
"contract" BIGINT,
"aav" VARCHAR,
"n_2023" BIGINT,
"n_2024" VARCHAR,
"n_2025" VARCHAR,
"n_2026" VARCHAR,
"n_2027" VARCHAR,
"n_2028" VARCHAR,
"n_2029" VARCHAR
);
CREATE TABLE eligible_salaries_2021 (
"unnamed_0" BIGINT,
"player" VARCHAR,
"age" DOUBLE,
"service_time" DOUBLE,
"contract" BIGINT,
"aav" VARCHAR,
"n_2021" BIGINT,
"n_2022" VARCHAR,
"n_2023" VARCHAR,
"n_2024" VARCHAR,
"n_2025" VARCHAR,
"n_2026" VARCHAR,
"n_2027" VARCHAR
);
CREATE TABLE ineligible_salaries_2023 (
"unnamed_0" BIGINT,
"player" VARCHAR,
"age" DOUBLE,
"service_time" DOUBLE,
"contract" VARCHAR,
"aav" VARCHAR,
"n_2023" VARCHAR,
"n_2024" VARCHAR,
"n_2025" VARCHAR,
"n_2026" VARCHAR,
"n_2027" VARCHAR,
"n_2028" VARCHAR,
"n_2029" VARCHAR
);
CREATE TABLE gauranteed_salaries_2020 (
"unnamed_0" BIGINT,
"player" VARCHAR,
"age" DOUBLE,
"service_time" DOUBLE,
"contract" BIGINT,
"aav" BIGINT,
"n_2020" BIGINT,
"n_2021" VARCHAR,
"n_2022" VARCHAR,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" VARCHAR,
"n_2026" DOUBLE
);
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 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
);
CREATE TABLE n_2006_2007 (
"ranking" DOUBLE,
"team" VARCHAR,
"n_2006_07" BIGINT,
"n_2006_07_cb5291" BIGINT
);
CREATE TABLE n_2007_2008 (
"ranking" DOUBLE,
"team" VARCHAR,
"n_2007_08" BIGINT,
"n_2007_08_db045a" BIGINT
);
CREATE TABLE n_2023_2024 (
"ranking" DOUBLE,
"team" VARCHAR,
"n_2023_24" BIGINT,
"n_2023_24_b41bfc" BIGINT
);
CREATE TABLE n_2015_2016 (
"ranking" DOUBLE,
"team" VARCHAR,
"n_2015_16" BIGINT,
"n_2015_16_f2e521" BIGINT
);
CREATE TABLE n_1991_1992 (
"ranking" DOUBLE,
"team" VARCHAR,
"n_1991_92" BIGINT,
"n_1991_92_790a5e" BIGINT
);
CREATE TABLE n_2005_2006 (
"ranking" DOUBLE,
"team" VARCHAR,
"n_2005_06" BIGINT,
"n_2005_06_88602c" BIGINT
);
CREATE TABLE n_1998_1999 (
"ranking" DOUBLE,
"team" VARCHAR,
"n_1998_99" BIGINT,
"n_1998_99_7f9560" BIGINT
);
CREATE TABLE n_2000_2001 (
"ranking" DOUBLE,
"team" VARCHAR,
"n_2000_01" BIGINT,
"n_2000_01_2b3557" BIGINT
);
CREATE TABLE n_1996_1997 (
"ranking" DOUBLE,
"team" VARCHAR,
"n_1996_97" BIGINT,
"n_1996_97_40a017" BIGINT
);
CREATE TABLE n_2019_2020 (
"ranking" DOUBLE,
"team" VARCHAR,
"n_2019_20" BIGINT,
"n_2019_20_c98c48" BIGINT
);
CREATE TABLE n_2024_2025 (
"ranking" DOUBLE,
"team" VARCHAR,
"n_2024_25" BIGINT,
"n_2025_26" BIGINT,
"n_2026_27" BIGINT,
"n_2027_28" BIGINT,
"n_2028_29" BIGINT,
"n_2029_30" BIGINT
);
CREATE TABLE n_2004_2005 (
"ranking" DOUBLE,
"team" VARCHAR,
"n_2004_05" BIGINT,
"n_2004_05_dda7f7" BIGINT
);
CREATE TABLE n_2017_2018 (
"ranking" DOUBLE,
"team" VARCHAR,
"n_2017_18" BIGINT,
"n_2017_18_32a8c7" BIGINT
);
CREATE TABLE n_2010_2011 (
"ranking" DOUBLE,
"team" VARCHAR,
"n_2010_11" BIGINT,
"n_2010_11_38043b" BIGINT
);
CREATE TABLE n_2003_2004 (
"ranking" DOUBLE,
"team" VARCHAR,
"n_2003_04" BIGINT,
"n_2003_04_0b4629" BIGINT
);
CREATE TABLE n_2013_2014 (
"ranking" DOUBLE,
"team" VARCHAR,
"n_2013_14" BIGINT,
"n_2013_14_60ffd9" BIGINT
);
CREATE TABLE n_2022_2023 (
"ranking" DOUBLE,
"team" VARCHAR,
"n_2022_23" BIGINT,
"n_2022_23_0be4ec" BIGINT
);
CREATE TABLE n_1992_1993 (
"ranking" DOUBLE,
"team" VARCHAR,
"n_1992_93" BIGINT,
"n_1992_93_6562dd" BIGINT
);
CREATE TABLE n_1995_1996 (
"ranking" DOUBLE,
"team" VARCHAR,
"n_1995_96" BIGINT,
"n_1995_96_304c71" BIGINT
);
CREATE TABLE n_1994_1995 (
"ranking" DOUBLE,
"team" VARCHAR,
"n_1994_95" BIGINT,
"n_1994_95_d07a1c" BIGINT
);
CREATE TABLE n_1997_1998 (
"ranking" DOUBLE,
"team" VARCHAR,
"n_1997_98" BIGINT,
"n_1997_98_251faf" BIGINT
);
CREATE TABLE n_2011_2012 (
"ranking" DOUBLE,
"team" VARCHAR,
"n_2011_12" BIGINT,
"n_2011_12_8d36e8" BIGINT
);
CREATE TABLE n_2014_2015 (
"ranking" DOUBLE,
"team" VARCHAR,
"n_2014_15" BIGINT,
"n_2014_15_2decd0" BIGINT
);
CREATE TABLE n_2016_2017 (
"ranking" DOUBLE,
"team" VARCHAR,
"n_2016_17" BIGINT,
"n_2016_17_550dda" BIGINT
);
CREATE TABLE n_1999_2000 (
"ranking" DOUBLE,
"team" VARCHAR,
"n_1999_00" BIGINT,
"n_1999_00_b48994" BIGINT
);
CREATE TABLE n_2021_2022 (
"ranking" DOUBLE,
"team" VARCHAR,
"n_2021_22" BIGINT,
"n_2021_22_438693" BIGINT
);
CREATE TABLE n_2012_2013 (
"ranking" DOUBLE,
"team" VARCHAR,
"n_2012_13" BIGINT,
"n_2012_13_3dfd2c" BIGINT
);
CREATE TABLE n_2008_2009 (
"ranking" DOUBLE,
"team" VARCHAR,
"n_2008_09" BIGINT,
"n_2008_09_85b369" BIGINT
);
CREATE TABLE n_2001_2002 (
"ranking" DOUBLE,
"team" VARCHAR,
"n_2001_02" BIGINT,
"n_2001_02_e6e70a" BIGINT
);
CREATE TABLE n_1990_1991 (
"ranking" DOUBLE,
"team" VARCHAR,
"n_1990_91" BIGINT,
"n_1990_91_066538" BIGINT
);
CREATE TABLE n_1993_1994 (
"ranking" DOUBLE,
"team" VARCHAR,
"n_1993_94" BIGINT,
"n_1993_94_641292" BIGINT
);
CREATE TABLE n_2002_2003 (
"ranking" DOUBLE,
"team" VARCHAR,
"n_2002_03" BIGINT,
"n_2002_03_4c604c" BIGINT
);
CREATE TABLE n_2009_2010 (
"ranking" DOUBLE,
"team" VARCHAR,
"n_2009_10" BIGINT,
"n_2009_10_18090d" BIGINT
);
CREATE TABLE n_2020_2021 (
"ranking" DOUBLE,
"player" VARCHAR,
"n_2020_21" BIGINT,
"n_2020_21_22bd20" BIGINT
);
CREATE TABLE n_2018_2019 (
"ranking" DOUBLE,
"player" VARCHAR,
"n_2018_19" BIGINT,
"n_2018_19_4fc188" BIGINT
);
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 totals_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" BIGINT,
"fga" BIGINT,
"fg_pct" DOUBLE,
"fg3m" BIGINT,
"fg3a" BIGINT,
"fg3_pct" DOUBLE,
"ftm" BIGINT,
"fta" BIGINT,
"ft_pct" DOUBLE,
"oreb" BIGINT,
"dreb" BIGINT,
"reb" BIGINT,
"ast" BIGINT,
"tov" BIGINT,
"stl" BIGINT,
"blk" BIGINT,
"blka" BIGINT,
"pf" BIGINT,
"pfd" BIGINT,
"pts" BIGINT,
"plus_minus" BIGINT,
"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 submissionwins (
"rnk" BIGINT,
"event" VARCHAR,
"total" BIGINT
);
CREATE TABLE kotkowins (
"rnk" BIGINT,
"event" VARCHAR,
"total" BIGINT
);
CREATE TABLE averagefighttimelong (
"rnk" BIGINT,
"event" VARCHAR,
"time" VARCHAR
);
CREATE TABLE submissionsattempted (
"rnk" BIGINT,
"event" VARCHAR,
"total" BIGINT
);
CREATE TABLE averagefighttimeshort (
"rnk" BIGINT,
"event" VARCHAR,
"time" VARCHAR
);
CREATE TABLE shortestevent (
"rnk" BIGINT,
"event" VARCHAR,
"time" VARCHAR
);
CREATE TABLE sigstrikeslanded (
"rnk" BIGINT,
"event" VARCHAR,
"total" BIGINT
);
CREATE TABLE longestevent (
"rnk" BIGINT,
"event" VARCHAR,
"time" VARCHAR
);
CREATE TABLE totalstrikeslanded (
"rnk" BIGINT,
"event" VARCHAR,
"total" BIGINT
);
CREATE TABLE takedownslanded (
"rnk" BIGINT,
"event" VARCHAR,
"total" BIGINT
);
CREATE TABLE knockdowns (
"rnk" BIGINT,
"event" VARCHAR,
"total" BIGINT
);
CREATE TABLE decisionwins (
"rnk" BIGINT,
"fighter" VARCHAR,
"total" BIGINT
);
CREATE TABLE bottompositiontimepercentage (
"rnk" BIGINT,
"fighter" VARCHAR,
"percent" VARCHAR
);
CREATE TABLE slpm (
"rnk" BIGINT,
"fighter" VARCHAR,
"total" DOUBLE
);
CREATE TABLE takedownsdefense (
"rnk" BIGINT,
"fighter" VARCHAR,
"percent" VARCHAR
);
CREATE TABLE sapm (
"rnk" BIGINT,
"fighter" VARCHAR,
"total" DOUBLE
);
CREATE TABLE significantstrikesdifferential (
"rnk" BIGINT,
"fighter" VARCHAR,
"total" DOUBLE
);
CREATE TABLE finishes (
"rnk" BIGINT,
"fighter" VARCHAR,
"total" BIGINT
);
CREATE TABLE takedownsaccuracy (
"rnk" BIGINT,
"fighter" VARCHAR,
"percent" VARCHAR
);
CREATE TABLE submissionsaverage (
"rnk" BIGINT,
"fighter" VARCHAR,
"total" DOUBLE
);
CREATE TABLE knockdownsaverage (
"rnk" BIGINT,
"fighter" VARCHAR,
"total" DOUBLE
);
CREATE TABLE winstreak (
"rnk" BIGINT,
"fighter" VARCHAR,
"total" BIGINT
);
CREATE TABLE toppositiontime (
"rnk" BIGINT,
"fighter" VARCHAR,
"time" VARCHAR
);
CREATE TABLE toppositiontimepercentage (
"rnk" BIGINT,
"fighter" VARCHAR,
"percent" VARCHAR
);
CREATE TABLE titlefightwins (
"rnk" BIGINT,
"fighter" VARCHAR,
"total" BIGINT
);
CREATE TABLE totalfighttime (
"rnk" BIGINT,
"fighter" VARCHAR,
"time" VARCHAR
);
CREATE TABLE wins (
"rnk" BIGINT,
"fighter" VARCHAR,
"total" BIGINT
);
CREATE TABLE totalawards (
"rnk" BIGINT,
"fighter" VARCHAR,
"total" BIGINT
);
CREATE TABLE controltimepercentage (
"rnk" BIGINT,
"fighter" VARCHAR,
"percent" VARCHAR
);
CREATE TABLE bottompositiontime (
"rnk" BIGINT,
"fighter" VARCHAR,
"time" VARCHAR
);
CREATE TABLE sigstrikesaccuracy (
"rnk" BIGINT,
"fighter" VARCHAR,
"percent" VARCHAR
);
CREATE TABLE totalfights (
"rnk" BIGINT,
"fighter" VARCHAR,
"total" BIGINT
);
CREATE TABLE significantstrikesdefense (
"rnk" BIGINT,
"fighter" VARCHAR,
"percent" VARCHAR
);
CREATE TABLE controltime (
"rnk" BIGINT,
"fighter" VARCHAR,
"time" VARCHAR
);
Anyone who has the link will be able to view this.