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

CREATE TABLE titlefightwins (
  "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 totalawards (
  "rnk" BIGINT,
  "fighter" VARCHAR,
  "total" BIGINT
);

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

CREATE TABLE totalfighttime (
  "rnk" BIGINT,
  "fighter" VARCHAR,
  "time" 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 totalstrikeslanded (
  "rnk" BIGINT,
  "event" VARCHAR,
  "total" BIGINT
);

CREATE TABLE wide_receiver (
  "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 wins (
  "rnk" BIGINT,
  "fighter" VARCHAR,
  "total" BIGINT
);

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