March Madness Data

CREATE TABLE n_538_ratings (
  "year" BIGINT,
  "team_no" BIGINT,
  "team" VARCHAR,
  "seed" BIGINT,
  "round" BIGINT,
  "power_rating" DOUBLE,
  "power_rating_rank" BIGINT
);

CREATE TABLE barttorvik_away_neutral (
  "year" BIGINT,
  "team_no" BIGINT,
  "team_id" BIGINT,
  "team" VARCHAR,
  "seed" BIGINT,
  "round" BIGINT,
  "badj_em" DOUBLE,
  "badj_o" DOUBLE,
  "badj_d" DOUBLE,
  "barthag" DOUBLE,
  "games" BIGINT,
  "w" BIGINT,
  "l" BIGINT,
  "win" DOUBLE,
  "efg" DOUBLE,
  "efg_d" DOUBLE,
  "ftr" DOUBLE,
  "ftrd" DOUBLE,
  "tov" DOUBLE,
  "tov_d" DOUBLE,
  "oreb" DOUBLE,
  "dreb" DOUBLE,
  "op_oreb" DOUBLE,
  "op_dreb" DOUBLE,
  "raw_t" DOUBLE,
  "n_2pt" DOUBLE,
  "n_2pt_d" DOUBLE,
  "n_3pt" DOUBLE,
  "n_3pt_d" DOUBLE,
  "blk" DOUBLE,
  "blked" DOUBLE,
  "ast" DOUBLE,
  "op_ast" DOUBLE,
  "n_2ptr" DOUBLE,
  "n_3ptr" DOUBLE,
  "n_2ptrd" DOUBLE,
  "n_3ptrd" DOUBLE,
  "badj_t" DOUBLE,
  "avg_hgt" DOUBLE,
  "eff_hgt" DOUBLE,
  "exp" DOUBLE,
  "talent" DOUBLE,
  "ft" DOUBLE,
  "op_ft" DOUBLE,
  "pppo" DOUBLE,
  "pppd" DOUBLE,
  "elite_sos" DOUBLE,
  "wab" DOUBLE,
  "badj_em_rank" BIGINT,
  "badj_o_rank" BIGINT,
  "badj_d_rank" BIGINT,
  "barthag_rank" BIGINT,
  "efg_rank" BIGINT,
  "efgd_rank" BIGINT,
  "ftr_rank" BIGINT,
  "ftrd_rank" BIGINT,
  "tov_rank" BIGINT,
  "tov_d_rank" BIGINT,
  "oreb_rank" BIGINT,
  "dreb_rank" BIGINT,
  "op_oreb_rank" BIGINT,
  "op_dreb_rank" BIGINT,
  "raw_t_rank" BIGINT,
  "n_2pt_rank" BIGINT,
  "n_2pt_d_rank" BIGINT,
  "n_3pt_rank" BIGINT,
  "n_3pt_d_rank" BIGINT,
  "blk_rank" BIGINT,
  "blked_rank" BIGINT,
  "ast_rank" BIGINT,
  "op_ast_rank" BIGINT,
  "n_2ptr_rank" BIGINT,
  "n_3ptr_rank" BIGINT,
  "n_2ptrd_rank" BIGINT,
  "n_3ptrd_rank" BIGINT,
  "badjt_rank" BIGINT,
  "avg_hgt_rank" BIGINT,
  "eff_hgt_rank" BIGINT,
  "exp_rank" BIGINT,
  "talent_rank" BIGINT,
  "ft_rank" BIGINT,
  "op_ft_rank" BIGINT,
  "pppo_rank" BIGINT,
  "pppd_rank" BIGINT,
  "elite_sos_rank" BIGINT
);

CREATE TABLE barttorvik_away (
  "year" BIGINT,
  "team_no" BIGINT,
  "team_id" BIGINT,
  "team" VARCHAR,
  "seed" BIGINT,
  "round" BIGINT,
  "badj_em" DOUBLE,
  "badj_o" DOUBLE,
  "badj_d" DOUBLE,
  "barthag" DOUBLE,
  "games" BIGINT,
  "w" BIGINT,
  "l" BIGINT,
  "win" DOUBLE,
  "efg" DOUBLE,
  "efg_d" DOUBLE,
  "ftr" DOUBLE,
  "ftrd" DOUBLE,
  "tov" DOUBLE,
  "tov_d" DOUBLE,
  "oreb" DOUBLE,
  "dreb" DOUBLE,
  "op_oreb" DOUBLE,
  "op_dreb" DOUBLE,
  "raw_t" DOUBLE,
  "n_2pt" DOUBLE,
  "n_2pt_d" DOUBLE,
  "n_3pt" DOUBLE,
  "n_3pt_d" DOUBLE,
  "blk" DOUBLE,
  "blked" DOUBLE,
  "ast" DOUBLE,
  "op_ast" DOUBLE,
  "n_2ptr" DOUBLE,
  "n_3ptr" DOUBLE,
  "n_2ptrd" DOUBLE,
  "n_3ptrd" DOUBLE,
  "badj_t" DOUBLE,
  "avg_hgt" DOUBLE,
  "eff_hgt" DOUBLE,
  "exp" DOUBLE,
  "talent" DOUBLE,
  "ft" DOUBLE,
  "op_ft" DOUBLE,
  "pppo" DOUBLE,
  "pppd" DOUBLE,
  "elite_sos" DOUBLE,
  "wab" DOUBLE,
  "badj_em_rank" BIGINT,
  "badj_o_rank" BIGINT,
  "badj_d_rank" BIGINT,
  "barthag_rank" BIGINT,
  "efg_rank" BIGINT,
  "efgd_rank" BIGINT,
  "ftr_rank" BIGINT,
  "ftrd_rank" BIGINT,
  "tov_rank" BIGINT,
  "tov_d_rank" BIGINT,
  "oreb_rank" BIGINT,
  "dreb_rank" BIGINT,
  "op_oreb_rank" BIGINT,
  "op_dreb_rank" BIGINT,
  "raw_t_rank" BIGINT,
  "n_2pt_rank" BIGINT,
  "n_2pt_d_rank" BIGINT,
  "n_3pt_rank" BIGINT,
  "n_3pt_d_rank" BIGINT,
  "blk_rank" BIGINT,
  "blked_rank" BIGINT,
  "ast_rank" BIGINT,
  "op_ast_rank" BIGINT,
  "n_2ptr_rank" BIGINT,
  "n_3ptr_rank" BIGINT,
  "n_2ptrd_rank" BIGINT,
  "n_3ptrd_rank" BIGINT,
  "badjt_rank" BIGINT,
  "avg_hgt_rank" BIGINT,
  "eff_hgt_rank" BIGINT,
  "exp_rank" BIGINT,
  "talent_rank" BIGINT,
  "ft_rank" BIGINT,
  "op_ft_rank" BIGINT,
  "pppo_rank" BIGINT,
  "pppd_rank" BIGINT,
  "elite_sos_rank" BIGINT
);

CREATE TABLE barttorvik_home (
  "year" BIGINT,
  "team_no" BIGINT,
  "team_id" BIGINT,
  "team" VARCHAR,
  "seed" BIGINT,
  "round" BIGINT,
  "badj_em" DOUBLE,
  "badj_o" DOUBLE,
  "badj_d" DOUBLE,
  "barthag" DOUBLE,
  "games" BIGINT,
  "w" BIGINT,
  "l" BIGINT,
  "win" DOUBLE,
  "efg" DOUBLE,
  "efg_d" DOUBLE,
  "ftr" DOUBLE,
  "ftrd" DOUBLE,
  "tov" DOUBLE,
  "tov_d" DOUBLE,
  "oreb" DOUBLE,
  "dreb" DOUBLE,
  "op_oreb" DOUBLE,
  "op_dreb" DOUBLE,
  "raw_t" DOUBLE,
  "n_2pt" DOUBLE,
  "n_2pt_d" DOUBLE,
  "n_3pt" DOUBLE,
  "n_3pt_d" DOUBLE,
  "blk" DOUBLE,
  "blked" DOUBLE,
  "ast" DOUBLE,
  "op_ast" DOUBLE,
  "n_2ptr" DOUBLE,
  "n_3ptr" DOUBLE,
  "n_2ptrd" DOUBLE,
  "n_3ptrd" DOUBLE,
  "badj_t" DOUBLE,
  "avg_hgt" DOUBLE,
  "eff_hgt" DOUBLE,
  "exp" DOUBLE,
  "talent" DOUBLE,
  "ft" DOUBLE,
  "op_ft" DOUBLE,
  "pppo" DOUBLE,
  "pppd" DOUBLE,
  "elite_sos" DOUBLE,
  "wab" DOUBLE,
  "badj_em_rank" BIGINT,
  "badj_o_rank" BIGINT,
  "badj_d_rank" BIGINT,
  "barthag_rank" BIGINT,
  "efg_rank" BIGINT,
  "efgd_rank" BIGINT,
  "ftr_rank" BIGINT,
  "ftrd_rank" BIGINT,
  "tov_rank" BIGINT,
  "tov_d_rank" BIGINT,
  "oreb_rank" BIGINT,
  "dreb_rank" BIGINT,
  "op_oreb_rank" BIGINT,
  "op_dreb_rank" BIGINT,
  "raw_t_rank" BIGINT,
  "n_2pt_rank" BIGINT,
  "n_2pt_d_rank" BIGINT,
  "n_3pt_rank" BIGINT,
  "n_3pt_d_rank" BIGINT,
  "blk_rank" BIGINT,
  "blked_rank" BIGINT,
  "ast_rank" BIGINT,
  "op_ast_rank" BIGINT,
  "n_2ptr_rank" BIGINT,
  "n_3ptr_rank" BIGINT,
  "n_2ptrd_rank" BIGINT,
  "n_3ptrd_rank" BIGINT,
  "badjt_rank" BIGINT,
  "avg_hgt_rank" BIGINT,
  "eff_hgt_rank" BIGINT,
  "exp_rank" BIGINT,
  "talent_rank" BIGINT,
  "ft_rank" BIGINT,
  "op_ft_rank" BIGINT,
  "pppo_rank" BIGINT,
  "pppd_rank" BIGINT,
  "elite_sos_rank" BIGINT
);

CREATE TABLE barttorvik_neutral (
  "year" BIGINT,
  "team_no" BIGINT,
  "team_id" BIGINT,
  "team" VARCHAR,
  "seed" BIGINT,
  "round" BIGINT,
  "badj_em" DOUBLE,
  "badj_o" DOUBLE,
  "badj_d" DOUBLE,
  "barthag" DOUBLE,
  "games" DOUBLE,
  "w" DOUBLE,
  "l" DOUBLE,
  "win" DOUBLE,
  "efg" DOUBLE,
  "efg_d" DOUBLE,
  "ftr" DOUBLE,
  "ftrd" DOUBLE,
  "tov" DOUBLE,
  "tov_d" DOUBLE,
  "oreb" DOUBLE,
  "dreb" DOUBLE,
  "op_oreb" DOUBLE,
  "op_dreb" DOUBLE,
  "raw_t" DOUBLE,
  "n_2pt" DOUBLE,
  "n_2pt_d" DOUBLE,
  "n_3pt" DOUBLE,
  "n_3pt_d" DOUBLE,
  "blk" DOUBLE,
  "blked" DOUBLE,
  "ast" DOUBLE,
  "op_ast" DOUBLE,
  "n_2ptr" DOUBLE,
  "n_3ptr" DOUBLE,
  "n_2ptrd" DOUBLE,
  "n_3ptrd" DOUBLE,
  "badj_t" DOUBLE,
  "avg_hgt" DOUBLE,
  "eff_hgt" DOUBLE,
  "exp" DOUBLE,
  "talent" DOUBLE,
  "ft" DOUBLE,
  "op_ft" DOUBLE,
  "pppo" DOUBLE,
  "pppd" DOUBLE,
  "elite_sos" DOUBLE,
  "wab" DOUBLE,
  "badj_em_rank" DOUBLE,
  "badj_o_rank" DOUBLE,
  "badj_d_rank" DOUBLE,
  "barthag_rank" DOUBLE,
  "efg_rank" DOUBLE,
  "efgd_rank" DOUBLE,
  "ftr_rank" DOUBLE,
  "ftrd_rank" DOUBLE,
  "tov_rank" DOUBLE,
  "tov_d_rank" DOUBLE,
  "oreb_rank" DOUBLE,
  "dreb_rank" DOUBLE,
  "op_oreb_rank" DOUBLE,
  "op_dreb_rank" DOUBLE,
  "raw_t_rank" DOUBLE,
  "n_2pt_rank" DOUBLE,
  "n_2pt_d_rank" DOUBLE,
  "n_3pt_rank" DOUBLE,
  "n_3pt_d_rank" DOUBLE,
  "blk_rank" DOUBLE,
  "blked_rank" DOUBLE,
  "ast_rank" DOUBLE,
  "op_ast_rank" DOUBLE,
  "n_2ptr_rank" DOUBLE,
  "n_3ptr_rank" DOUBLE,
  "n_2ptrd_rank" DOUBLE,
  "n_3ptrd_rank" DOUBLE,
  "badjt_rank" DOUBLE,
  "avg_hgt_rank" DOUBLE,
  "eff_hgt_rank" DOUBLE,
  "exp_rank" DOUBLE,
  "talent_rank" DOUBLE,
  "ft_rank" DOUBLE,
  "op_ft_rank" DOUBLE,
  "pppo_rank" DOUBLE,
  "pppd_rank" DOUBLE,
  "elite_sos_rank" DOUBLE
);

CREATE TABLE coach_results (
  "coach_id" BIGINT,
  "coach" VARCHAR,
  "pake" DOUBLE,
  "pake_rank" BIGINT,
  "pase" DOUBLE,
  "pase_rank" BIGINT,
  "games" BIGINT,
  "w" BIGINT,
  "l" BIGINT,
  "win" DOUBLE,
  "r64" BIGINT,
  "r32" BIGINT,
  "s16" BIGINT,
  "e8" BIGINT,
  "f4" BIGINT,
  "f2" BIGINT,
  "champ" BIGINT,
  "top2" BIGINT,
  "f4_234f67" VARCHAR,
  "champ_337e2f" VARCHAR
);

CREATE TABLE conference_results (
  "conf_id" BIGINT,
  "conf" VARCHAR,
  "pake" DOUBLE,
  "pake_rank" BIGINT,
  "pase" DOUBLE,
  "pase_rank" BIGINT,
  "games" BIGINT,
  "w" BIGINT,
  "l" BIGINT,
  "win" DOUBLE,
  "r64" BIGINT,
  "r32" BIGINT,
  "s16" BIGINT,
  "e8" BIGINT,
  "f4" BIGINT,
  "f2" BIGINT,
  "champ" BIGINT,
  "top2" BIGINT,
  "champ_337e2f" VARCHAR
);

CREATE TABLE conference_stats_away_neutral (
  "year" BIGINT,
  "conf_id" BIGINT,
  "conf" VARCHAR,
  "badj_em" DOUBLE,
  "badj_o" DOUBLE,
  "badj_d" DOUBLE,
  "barthag" DOUBLE,
  "g" BIGINT,
  "w" BIGINT,
  "l" BIGINT,
  "win" DOUBLE,
  "efg" DOUBLE,
  "efgd" DOUBLE,
  "ftr" DOUBLE,
  "ftrd" DOUBLE,
  "tov" DOUBLE,
  "tov_d" DOUBLE,
  "oreb" DOUBLE,
  "dreb" DOUBLE,
  "op_oreb" DOUBLE,
  "op_dreb" DOUBLE,
  "raw_t" DOUBLE,
  "n_2pt" DOUBLE,
  "n_2pt_d" DOUBLE,
  "n_3pt" DOUBLE,
  "n_3pt_d" DOUBLE,
  "blk" DOUBLE,
  "blked" DOUBLE,
  "ast" DOUBLE,
  "op_ast" DOUBLE,
  "n_2ptr" DOUBLE,
  "n_3ptr" DOUBLE,
  "n_2ptrd" DOUBLE,
  "n_3ptrd" DOUBLE,
  "badj_t" DOUBLE,
  "avg_hgt" DOUBLE,
  "eff_hgt" DOUBLE,
  "exp" DOUBLE,
  "talent" DOUBLE,
  "ft" DOUBLE,
  "op_ft" DOUBLE,
  "pppo" DOUBLE,
  "pppd" DOUBLE,
  "elite_sos" DOUBLE,
  "wab" DOUBLE
);

CREATE TABLE conference_stats_away (
  "year" BIGINT,
  "conf_id" BIGINT,
  "conf" VARCHAR,
  "badj_em" DOUBLE,
  "badj_o" DOUBLE,
  "badj_d" DOUBLE,
  "barthag" DOUBLE,
  "g" BIGINT,
  "w" BIGINT,
  "l" BIGINT,
  "win" DOUBLE,
  "efg" DOUBLE,
  "efgd" DOUBLE,
  "ftr" DOUBLE,
  "ftrd" DOUBLE,
  "tov" DOUBLE,
  "tov_d" DOUBLE,
  "oreb" DOUBLE,
  "dreb" DOUBLE,
  "op_oreb" DOUBLE,
  "op_dreb" DOUBLE,
  "raw_t" DOUBLE,
  "n_2pt" DOUBLE,
  "n_2pt_d" DOUBLE,
  "n_3pt" DOUBLE,
  "n_3pt_d" DOUBLE,
  "blk" DOUBLE,
  "blked" DOUBLE,
  "ast" DOUBLE,
  "op_ast" DOUBLE,
  "n_2ptr" DOUBLE,
  "n_3ptr" DOUBLE,
  "n_2ptrd" DOUBLE,
  "n_3ptrd" DOUBLE,
  "badj_t" DOUBLE,
  "avg_hgt" DOUBLE,
  "eff_hgt" DOUBLE,
  "exp" DOUBLE,
  "talent" DOUBLE,
  "ft" DOUBLE,
  "op_ft" DOUBLE,
  "pppo" DOUBLE,
  "pppd" DOUBLE,
  "elite_sos" DOUBLE,
  "wab" DOUBLE
);

CREATE TABLE conference_stats_home (
  "year" BIGINT,
  "conf_id" BIGINT,
  "conf" VARCHAR,
  "badj_em" DOUBLE,
  "badj_o" DOUBLE,
  "badj_d" DOUBLE,
  "barthag" DOUBLE,
  "g" BIGINT,
  "w" BIGINT,
  "l" BIGINT,
  "win" DOUBLE,
  "efg" DOUBLE,
  "efgd" DOUBLE,
  "ftr" DOUBLE,
  "ftrd" DOUBLE,
  "tov" DOUBLE,
  "tov_d" DOUBLE,
  "oreb" DOUBLE,
  "dreb" DOUBLE,
  "op_oreb" DOUBLE,
  "op_dreb" DOUBLE,
  "raw_t" DOUBLE,
  "n_2pt" DOUBLE,
  "n_2pt_d" DOUBLE,
  "n_3pt" DOUBLE,
  "n_3pt_d" DOUBLE,
  "blk" DOUBLE,
  "blked" DOUBLE,
  "ast" DOUBLE,
  "op_ast" DOUBLE,
  "n_2ptr" DOUBLE,
  "n_3ptr" DOUBLE,
  "n_2ptrd" DOUBLE,
  "n_3ptrd" DOUBLE,
  "badj_t" DOUBLE,
  "avg_hgt" DOUBLE,
  "eff_hgt" DOUBLE,
  "exp" DOUBLE,
  "talent" DOUBLE,
  "ft" DOUBLE,
  "op_ft" DOUBLE,
  "pppo" DOUBLE,
  "pppd" DOUBLE,
  "elite_sos" DOUBLE,
  "wab" DOUBLE
);

CREATE TABLE conference_stats_neutral (
  "year" BIGINT,
  "conf_id" BIGINT,
  "conf" VARCHAR,
  "badj_em" DOUBLE,
  "badj_o" DOUBLE,
  "badj_d" DOUBLE,
  "barthag" DOUBLE,
  "g" BIGINT,
  "w" BIGINT,
  "l" BIGINT,
  "win" DOUBLE,
  "efg" DOUBLE,
  "efgd" DOUBLE,
  "ftr" DOUBLE,
  "ftrd" DOUBLE,
  "tov" DOUBLE,
  "tov_d" DOUBLE,
  "oreb" DOUBLE,
  "dreb" DOUBLE,
  "op_oreb" DOUBLE,
  "op_dreb" DOUBLE,
  "raw_t" DOUBLE,
  "n_2pt" DOUBLE,
  "n_2pt_d" DOUBLE,
  "n_3pt" DOUBLE,
  "n_3pt_d" DOUBLE,
  "blk" DOUBLE,
  "blked" DOUBLE,
  "ast" DOUBLE,
  "op_ast" DOUBLE,
  "n_2ptr" DOUBLE,
  "n_3ptr" DOUBLE,
  "n_2ptrd" DOUBLE,
  "n_3ptrd" DOUBLE,
  "badj_t" DOUBLE,
  "avg_hgt" DOUBLE,
  "eff_hgt" DOUBLE,
  "exp" DOUBLE,
  "talent" DOUBLE,
  "ft" DOUBLE,
  "op_ft" DOUBLE,
  "pppo" DOUBLE,
  "pppd" DOUBLE,
  "elite_sos" DOUBLE,
  "wab" DOUBLE
);

CREATE TABLE conference_stats (
  "year" BIGINT,
  "conf_id" BIGINT,
  "conf" VARCHAR,
  "badj_em" DOUBLE,
  "badj_o" DOUBLE,
  "badj_d" DOUBLE,
  "barthag" DOUBLE,
  "g" BIGINT,
  "w" BIGINT,
  "l" BIGINT,
  "win" DOUBLE,
  "efg" DOUBLE,
  "efgd" DOUBLE,
  "ftr" DOUBLE,
  "ftrd" DOUBLE,
  "tov" DOUBLE,
  "tov_d" DOUBLE,
  "oreb" DOUBLE,
  "dreb" DOUBLE,
  "op_oreb" DOUBLE,
  "op_dreb" DOUBLE,
  "raw_t" DOUBLE,
  "n_2pt" DOUBLE,
  "n_2pt_d" DOUBLE,
  "n_3pt" DOUBLE,
  "n_3pt_d" DOUBLE,
  "blk" DOUBLE,
  "blked" DOUBLE,
  "ast" DOUBLE,
  "op_ast" DOUBLE,
  "n_2ptr" DOUBLE,
  "n_3ptr" DOUBLE,
  "n_2ptrd" DOUBLE,
  "n_3ptrd" DOUBLE,
  "badj_t" DOUBLE,
  "avg_hgt" DOUBLE,
  "eff_hgt" DOUBLE,
  "exp" DOUBLE,
  "talent" DOUBLE,
  "ft" DOUBLE,
  "op_ft" DOUBLE,
  "pppo" DOUBLE,
  "pppd" DOUBLE,
  "elite_sos" DOUBLE,
  "wab" DOUBLE
);

CREATE TABLE heat_check_tournament_index (
  "year" BIGINT,
  "team_no" BIGINT,
  "team" VARCHAR,
  "seed" BIGINT,
  "round" BIGINT,
  "power" DOUBLE,
  "path" DOUBLE,
  "draw" DOUBLE,
  "wins" BIGINT,
  "pool_value" DOUBLE,
  "pool_s_rank" BIGINT,
  "ncaa_s_rank" BIGINT,
  "val_z_score" DOUBLE,
  "power_path" DOUBLE
);

CREATE TABLE kenpom_barttorvik (
  "year" BIGINT,
  "conf" VARCHAR,
  "conf_id" BIGINT,
  "quad_no" BIGINT,
  "quad_id" BIGINT,
  "team_no" BIGINT,
  "team_id" BIGINT,
  "team" VARCHAR,
  "seed" BIGINT,
  "round" BIGINT,
  "k_tempo" DOUBLE,
  "k_tempo_rank" BIGINT,
  "kadj_t" DOUBLE,
  "kadj_t_rank" BIGINT,
  "k_off" DOUBLE,
  "ko_rank" BIGINT,
  "kadj_o" DOUBLE,
  "kadj_o_rank" BIGINT,
  "k_def" DOUBLE,
  "kd_rank" BIGINT,
  "kadj_d" DOUBLE,
  "kadj_d_rank" BIGINT,
  "kadj_em" DOUBLE,
  "kadj_em_rank" BIGINT,
  "badj_em" DOUBLE,
  "badj_o" DOUBLE,
  "badj_d" DOUBLE,
  "barthag" DOUBLE,
  "games" BIGINT,
  "w" BIGINT,
  "l" BIGINT,
  "win" DOUBLE,
  "efg" DOUBLE,
  "efg_d" DOUBLE,
  "ftr" DOUBLE,
  "ftrd" DOUBLE,
  "tov" DOUBLE,
  "tov_d" DOUBLE,
  "oreb" DOUBLE,
  "dreb" DOUBLE,
  "op_oreb" DOUBLE,
  "op_dreb" DOUBLE,
  "raw_t" DOUBLE,
  "n_2pt" DOUBLE,
  "n_2pt_d" DOUBLE,
  "n_3pt" DOUBLE,
  "n_3pt_d" DOUBLE,
  "blk" DOUBLE,
  "blked" DOUBLE,
  "ast" DOUBLE,
  "op_ast" DOUBLE,
  "n_2ptr" DOUBLE,
  "n_3ptr" DOUBLE,
  "n_2ptrd" DOUBLE,
  "n_3ptrd" DOUBLE,
  "badj_t" DOUBLE,
  "avg_hgt" DOUBLE,
  "eff_hgt" DOUBLE,
  "exp" DOUBLE,
  "talent" DOUBLE,
  "ft" DOUBLE,
  "op_ft" DOUBLE,
  "pppo" DOUBLE,
  "pppd" DOUBLE,
  "elite_sos" DOUBLE,
  "wab" DOUBLE,
  "badj_em_rank" BIGINT,
  "badj_o_rank" BIGINT,
  "badj_d_rank" BIGINT,
  "barthag_rank" BIGINT,
  "efg_rank" BIGINT,
  "efgd_rank" BIGINT,
  "ftr_rank" BIGINT,
  "ftrd_rank" BIGINT,
  "tov_rank" BIGINT,
  "tov_d_rank" BIGINT,
  "oreb_rank" BIGINT,
  "dreb_rank" BIGINT,
  "op_oreb_rank" BIGINT,
  "op_dreb_rank" BIGINT,
  "raw_t_rank" BIGINT,
  "n_2pt_rank" BIGINT,
  "n_2pt_d_rank" BIGINT,
  "n_3pt_rank" BIGINT,
  "n_3pt_d_rank" BIGINT,
  "blk_rank" BIGINT,
  "blked_rank" BIGINT,
  "ast_rank" BIGINT,
  "op_ast_rank" BIGINT,
  "n_2ptr_rank" BIGINT,
  "n_3ptr_rank" BIGINT,
  "n_2ptrd_rank" BIGINT,
  "n_3ptrd_rank" BIGINT,
  "badjt_rank" BIGINT,
  "avg_hgt_rank" BIGINT,
  "eff_hgt_rank" BIGINT,
  "exp_rank" BIGINT,
  "talent_rank" BIGINT,
  "ft_rank" BIGINT,
  "op_ft_rank" BIGINT
);

CREATE TABLE preseason_votes (
  "year" BIGINT,
  "team_no" DOUBLE,
  "team" VARCHAR,
  "seed" DOUBLE,
  "round" DOUBLE,
  "ap_votes" BIGINT,
  "ap_rank" BIGINT,
  "rank" BIGINT
);

CREATE TABLE public_picks (
  "year" BIGINT,
  "team_no" BIGINT,
  "team" VARCHAR,
  "r64" VARCHAR,
  "r32" VARCHAR,
  "s16" VARCHAR,
  "e8" VARCHAR,
  "f4" VARCHAR,
  "finals" VARCHAR
);

CREATE TABLE resumes (
  "year" BIGINT,
  "team_no" BIGINT,
  "team" VARCHAR,
  "seed" BIGINT,
  "round" BIGINT,
  "net_rpi" BIGINT,
  "resume" BIGINT,
  "wab_rank" BIGINT,
  "elo" BIGINT,
  "b_power" DOUBLE,
  "q1_w" BIGINT,
  "q2_w" BIGINT,
  "q1_plus_q2_w" BIGINT,
  "q3_q4_l" BIGINT,
  "plus_500" BIGINT,
  "r_score" DOUBLE,
  "bid_type" VARCHAR
);

CREATE TABLE seed_results (
  "seed" BIGINT,
  "pake" DOUBLE,
  "pake_rank" BIGINT,
  "pase" DOUBLE,
  "pase_rank" BIGINT,
  "games" BIGINT,
  "w" BIGINT,
  "l" BIGINT,
  "win" DOUBLE,
  "r64" BIGINT,
  "r32" BIGINT,
  "s16" BIGINT,
  "e8" BIGINT,
  "f4" BIGINT,
  "f2" BIGINT,
  "champ" BIGINT,
  "top2" BIGINT,
  "champ_337e2f" VARCHAR
);

CREATE TABLE shooting_splits (
  "year" BIGINT,
  "team_no" BIGINT,
  "team_id" BIGINT,
  "team" VARCHAR,
  "conf" VARCHAR,
  "dunks_fg" DOUBLE,
  "dunks_share" DOUBLE,
  "dunks_fg_d" DOUBLE,
  "dunks_d_share" DOUBLE,
  "close_twos_fg" DOUBLE,
  "close_twos_share" DOUBLE,
  "close_twos_fg_d" DOUBLE,
  "close_twos_d_share" DOUBLE,
  "farther_twos_fg" DOUBLE,
  "farther_twos_share" DOUBLE,
  "farther_twos_fg_d" DOUBLE,
  "farther_twos_d_share" DOUBLE,
  "threes_fg" DOUBLE,
  "threes_share" DOUBLE,
  "threes_fg_d" DOUBLE,
  "threes_d_share" DOUBLE,
  "dunks_fg_rank" BIGINT,
  "dunks_share_rank" BIGINT,
  "dunks_fg_d_rank" BIGINT,
  "dunks_d_share_rank" BIGINT,
  "close_twos_fg_rank" BIGINT,
  "close_twos_share_rank" BIGINT,
  "close_twos_fg_d_rank" BIGINT,
  "close_twos_d_share_rank" BIGINT,
  "farther_twos_fg_rank" BIGINT,
  "farther_twos_share_rank" BIGINT,
  "farther_twos_fg_d_rank" BIGINT,
  "farther_twos_d_share_rank" BIGINT,
  "threes_fg_rank" BIGINT,
  "threes_share_rank" BIGINT,
  "threes_fg_d_rank" BIGINT,
  "threes_d_share_rank" BIGINT
);

CREATE TABLE team_results (
  "team_id" BIGINT,
  "team" VARCHAR,
  "pake" DOUBLE,
  "pake_rank" BIGINT,
  "pase" DOUBLE,
  "pase_rank" BIGINT,
  "games" BIGINT,
  "w" BIGINT,
  "l" BIGINT,
  "win" DOUBLE,
  "r64" BIGINT,
  "r32" BIGINT,
  "s16" BIGINT,
  "e8" BIGINT,
  "f4" BIGINT,
  "f2" BIGINT,
  "champ" BIGINT,
  "top2" BIGINT,
  "f4_234f67" VARCHAR,
  "champ_337e2f" VARCHAR
);

CREATE TABLE tournament_locations (
  "year" BIGINT,
  "by_year_no" BIGINT,
  "by_round_no" BIGINT,
  "team_no" BIGINT,
  "team" VARCHAR,
  "seed" BIGINT,
  "round" BIGINT,
  "college_city" VARCHAR,
  "college_state" VARCHAR,
  "college_location" VARCHAR,
  "college_time_zone" VARCHAR,
  "college_time_zone_value" BIGINT,
  "daylight_savings_time" BOOLEAN,
  "college_latitude" DOUBLE,
  "college_longitude" DOUBLE,
  "game_city" VARCHAR,
  "game_state" VARCHAR,
  "game_location" VARCHAR,
  "game_time_zone" VARCHAR,
  "game_time_zone_value" BIGINT,
  "daylight_savings_time_1" BOOLEAN,
  "game_latitude" DOUBLE,
  "game_longitude" DOUBLE,
  "time_zone_combination" VARCHAR,
  "direction" VARCHAR,
  "longitude_diff" DOUBLE,
  "time_zones_crossed" BIGINT,
  "time_zones_crossed_value" BIGINT,
  "distance_km" DOUBLE,
  "distance_mi" DOUBLE
);

CREATE TABLE tournament_matchups (
  "year" BIGINT,
  "by_year_no" BIGINT,
  "by_round_no" BIGINT,
  "team_no" BIGINT,
  "team" VARCHAR,
  "seed" BIGINT,
  "round" BIGINT,
  "current_round" BIGINT,
  "score" DOUBLE
);

CREATE TABLE tournament_simulation (
  "year" BIGINT,
  "by_year_no" BIGINT,
  "by_round_no" BIGINT,
  "team_no" BIGINT,
  "team" VARCHAR,
  "seed" BIGINT,
  "round" BIGINT,
  "current_round" BIGINT
);

CREATE TABLE upset_count (
  "year" BIGINT,
  "first_round" BIGINT,
  "second_round" BIGINT,
  "sweet_16" BIGINT,
  "elite_8" BIGINT,
  "final_4" BIGINT,
  "total" BIGINT
);

CREATE TABLE upset_seed_info (
  "year" BIGINT,
  "current_round" BIGINT,
  "seed_won" BIGINT,
  "seed_lost" BIGINT,
  "seed_diff" BIGINT
);