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

CREATE TABLE punter (
  "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 punt_returns (
  "player" VARCHAR,
  "avg" DOUBLE,
  "ret" BIGINT,
  "yds" BIGINT,
  "pret_t" BIGINT,
  "n_20" BIGINT  -- 20+,
  "n_40" BIGINT  -- 40+,
  "lng" BIGINT,
  "fc" BIGINT,
  "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 quarterback (
  "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 receiving (
  "player" VARCHAR,
  "rec" BIGINT,
  "yds" BIGINT,
  "td" BIGINT,
  "n_20" BIGINT  -- 20+,
  "n_40" BIGINT  -- 40+,
  "lng" BIGINT,
  "rec_1st" BIGINT,
  "n_1st" DOUBLE  -- 1st%,
  "rec_fum" BIGINT,
  "rec_yac_r" BIGINT,
  "tgts" BIGINT
);

CREATE TABLE right_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 right_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 running_back (
  "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 rushing (
  "player" VARCHAR,
  "rush_yds" BIGINT,
  "att" BIGINT,
  "td" BIGINT,
  "n_20" BIGINT  -- 20+,
  "n_40" BIGINT  -- 40+,
  "lng" BIGINT,
  "rush_1st" BIGINT,
  "rush_1st_44363c" DOUBLE  -- Rush 1st%,
  "rush_fum" BIGINT
);

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

CREATE TABLE shortestevent (
  "rnk" BIGINT,
  "event" VARCHAR,
  "time" VARCHAR
);

CREATE TABLE significantstrikesdefense (
  "rnk" BIGINT,
  "fighter" VARCHAR,
  "percent" VARCHAR
);

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

CREATE TABLE sigstrikesaccuracy (
  "rnk" BIGINT,
  "fighter" VARCHAR,
  "percent" VARCHAR
);

CREATE TABLE sigstrikeslanded (
  "rnk" BIGINT,
  "event" VARCHAR,
  "total" BIGINT
);

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

CREATE TABLE submissionsattempted (
  "rnk" BIGINT,
  "event" VARCHAR,
  "total" BIGINT
);

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

CREATE TABLE submissionwins (
  "rnk" BIGINT,
  "event" VARCHAR,
  "total" BIGINT
);

CREATE TABLE tackles (
  "player" VARCHAR,
  "comb" BIGINT,
  "asst" BIGINT,
  "solo" BIGINT,
  "sck" DOUBLE
);

CREATE TABLE takedownsaccuracy (
  "rnk" BIGINT,
  "fighter" VARCHAR,
  "percent" VARCHAR
);

CREATE TABLE takedownsdefense (
  "rnk" BIGINT,
  "fighter" VARCHAR,
  "percent" VARCHAR
);

CREATE TABLE takedownslanded (
  "rnk" BIGINT,
  "event" VARCHAR,
  "total" BIGINT
);

CREATE TABLE tight_end (
  "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
);