March Madness Historical DataSet (2002 To 2025)
March Madness Analytics: Insights and Projections using Historical KenPom Data
@kaggle.jonathanpilafas_2024_march_madness_statistical_analysis
March Madness Analytics: Insights and Projections using Historical KenPom Data
@kaggle.jonathanpilafas_2024_march_madness_statistical_analysis
CREATE TABLE dev_march_madness (
"season" BIGINT,
"short_conference_name" VARCHAR,
"adjusted_temo" DOUBLE,
"adjusted_tempo_rank" BIGINT,
"raw_tempo" DOUBLE,
"raw_tempo_rank" BIGINT,
"adjusted_offensive_efficiency" DOUBLE,
"adjusted_offensive_efficiency_rank" BIGINT,
"raw_offensive_efficiency" DOUBLE,
"raw_offensive_efficiency_rank" BIGINT,
"adjusted_defensive_efficiency" DOUBLE,
"adjusted_defensive_efficiency_rank" BIGINT,
"raw_defensive_efficiency" DOUBLE,
"raw_defensive_efficiency_rank" BIGINT,
"avg_possession_length_offense" DOUBLE,
"avg_possession_length_offense_rank" DOUBLE,
"avg_possession_length_defense" DOUBLE,
"avg_possession_length_defense_rank" DOUBLE,
"efgpct" DOUBLE,
"rankefgpct" BIGINT,
"topct" DOUBLE,
"ranktopct" BIGINT,
"orpct" DOUBLE,
"rankorpct" BIGINT,
"ftrate" DOUBLE,
"rankftrate" BIGINT,
"offft" DOUBLE,
"rankoffft" BIGINT,
"off2ptfg" DOUBLE,
"rankoff2ptfg" BIGINT,
"off3ptfg" DOUBLE,
"rankoff3ptfg" BIGINT,
"defft" DOUBLE,
"rankdefft" BIGINT,
"def2ptfg" DOUBLE,
"rankdef2ptfg" BIGINT,
"def3ptfg" DOUBLE,
"rankdef3ptfg" BIGINT,
"tempo" DOUBLE,
"ranktempo" BIGINT,
"adjtempo" DOUBLE,
"rankadjtempo" BIGINT,
"oe" DOUBLE,
"rankoe" BIGINT,
"adjoe" DOUBLE,
"rankadjoe" BIGINT,
"de" DOUBLE,
"rankde" BIGINT,
"adjde" DOUBLE,
"rankadjde" BIGINT,
"adjem" DOUBLE,
"rankadjem" BIGINT,
"fg2pct" DOUBLE,
"rankfg2pct" BIGINT,
"fg3pct" DOUBLE,
"rankfg3pct" BIGINT,
"ftpct" DOUBLE,
"rankftpct" BIGINT,
"blockpct" DOUBLE,
"rankblockpct" BIGINT,
"oppfg2pct" DOUBLE,
"rankoppfg2pct" BIGINT,
"oppfg3pct" DOUBLE,
"rankoppfg3pct" BIGINT,
"oppftpct" DOUBLE,
"rankoppftpct" BIGINT,
"oppblockpct" DOUBLE,
"rankoppblockpct" BIGINT,
"fg3rate" DOUBLE,
"rankfg3rate" BIGINT,
"oppfg3rate" DOUBLE,
"rankoppfg3rate" BIGINT,
"arate" DOUBLE,
"rankarate" BIGINT,
"opparate" DOUBLE,
"rankopparate" BIGINT,
"stlrate" DOUBLE,
"rankstlrate" BIGINT,
"oppstlrate" DOUBLE,
"rankoppstlrate" BIGINT,
"dfp" DOUBLE,
"nstrate" DOUBLE,
"ranknstrate" DOUBLE,
"oppnstrate" DOUBLE,
"rankoppnstrate" DOUBLE,
"avgheight" DOUBLE,
"rankavgheight" DOUBLE,
"centerheight" DOUBLE,
"rankcenterheight" DOUBLE,
"pfheight" DOUBLE,
"rankpfheight" DOUBLE,
"sfheight" DOUBLE,
"ranksfheight" DOUBLE,
"sgheight" DOUBLE,
"ranksgheight" DOUBLE,
"pgheight" DOUBLE,
"rankpgheight" DOUBLE,
"effectiveheight" DOUBLE,
"rankeffectiveheight" DOUBLE,
"experience" DOUBLE
);
CREATE TABLE int_kenpom_defense (
"season" BIGINT,
"teamname" VARCHAR,
"efgpct" DOUBLE,
"rankefgpct" BIGINT,
"topct" DOUBLE,
"ranktopct" BIGINT,
"orpct" DOUBLE,
"rankorpct" BIGINT,
"ftrate" DOUBLE,
"rankftrate" BIGINT
);
CREATE TABLE int_kenpom_efficiency (
"season" BIGINT,
"team" VARCHAR,
"conference" VARCHAR,
"adjusted_temo" DOUBLE,
"adjusted_tempo_rank" BIGINT,
"raw_tempo" DOUBLE,
"raw_tempo_rank" BIGINT,
"adjusted_offensive_efficiency" DOUBLE,
"adjusted_offensive_efficiency_rank" BIGINT,
"raw_offensive_efficiency" DOUBLE,
"raw_offensive_efficiency_rank" BIGINT,
"adjusted_defensive_efficiency" DOUBLE,
"adjusted_defensive_efficiency_rank" BIGINT,
"raw_defensive_efficiency" DOUBLE,
"raw_defensive_efficiency_rank" BIGINT,
"avg_possession_length_offense" DOUBLE,
"avg_possession_length_offense_rank" DOUBLE,
"avg_possession_length_defense" DOUBLE,
"avg_possession_length_defense_rank" DOUBLE
);
CREATE TABLE int_kenpom_height (
"season" BIGINT,
"teamname" VARCHAR,
"avgheight" DOUBLE,
"rankavgheight" BIGINT,
"centerheight" DOUBLE,
"rankcenterheight" BIGINT,
"pfheight" DOUBLE,
"rankpfheight" BIGINT,
"sfheight" DOUBLE,
"ranksfheight" BIGINT,
"sgheight" DOUBLE,
"ranksgheight" BIGINT,
"pgheight" DOUBLE,
"rankpgheight" BIGINT,
"effectiveheight" DOUBLE,
"rankeffectiveheight" BIGINT,
"experience" DOUBLE,
"rankexperience" BIGINT,
"bench" DOUBLE,
"benchrank" BIGINT,
"centerpts" DOUBLE,
"rankcenterpts" BIGINT,
"pfpts" DOUBLE,
"rankpfpts" BIGINT,
"sfpts" DOUBLE,
"ranksfpts" BIGINT,
"sgpts" DOUBLE,
"ranksgpts" BIGINT,
"pgpts" DOUBLE,
"rankpgpts" BIGINT,
"centeror" DOUBLE,
"rankcenteror" BIGINT,
"pfor" DOUBLE,
"rankpfor" BIGINT,
"sfor" DOUBLE,
"ranksfor" BIGINT,
"sgor" DOUBLE,
"ranksgor" BIGINT,
"pgor" DOUBLE,
"rankpgor" BIGINT,
"centerdr" DOUBLE,
"rankcenterdr" BIGINT,
"pfdr" DOUBLE,
"rankpfdr" BIGINT,
"sfdr" DOUBLE,
"ranksfdr" BIGINT,
"sgdr" DOUBLE,
"ranksgdr" BIGINT,
"pgdr" DOUBLE,
"rankpgdr" BIGINT
);
CREATE TABLE int_kenpom_miscellaneous_team_stats (
"season" BIGINT,
"teamname" VARCHAR,
"fg2pct" DOUBLE,
"rankfg2pct" BIGINT,
"fg3pct" DOUBLE,
"rankfg3pct" BIGINT,
"ftpct" DOUBLE,
"rankftpct" BIGINT,
"blockpct" DOUBLE,
"rankblockpct" BIGINT,
"oppfg2pct" DOUBLE,
"rankoppfg2pct" BIGINT,
"oppfg3pct" DOUBLE,
"rankoppfg3pct" BIGINT,
"oppftpct" DOUBLE,
"rankoppftpct" BIGINT,
"oppblockpct" DOUBLE,
"rankoppblockpct" BIGINT,
"fg3rate" DOUBLE,
"rankfg3rate" BIGINT,
"oppfg3rate" DOUBLE,
"rankoppfg3rate" BIGINT,
"arate" DOUBLE,
"rankarate" BIGINT,
"opparate" DOUBLE,
"rankopparate" BIGINT,
"stlrate" DOUBLE,
"rankstlrate" BIGINT,
"oppstlrate" DOUBLE,
"rankoppstlrate" BIGINT,
"dfp" DOUBLE,
"nstrate" DOUBLE,
"ranknstrate" DOUBLE,
"oppnstrate" DOUBLE,
"rankoppnstrate" DOUBLE
);
CREATE TABLE int_kenpom_offense (
"season" BIGINT,
"teamname" VARCHAR,
"efgpct" DOUBLE,
"rankefgpct" BIGINT,
"topct" DOUBLE,
"ranktopct" BIGINT,
"orpct" DOUBLE,
"rankorpct" BIGINT,
"ftrate" DOUBLE,
"rankftrate" BIGINT
);
CREATE TABLE int_kenpom_point_distribution (
"season" BIGINT,
"teamname" VARCHAR,
"offft" DOUBLE,
"rankoffft" BIGINT,
"off2ptfg" DOUBLE,
"rankoff2ptfg" BIGINT,
"off3ptfg" DOUBLE,
"rankoff3ptfg" BIGINT,
"defft" DOUBLE,
"rankdefft" BIGINT,
"def2ptfg" DOUBLE,
"rankdef2ptfg" BIGINT,
"def3ptfg" DOUBLE,
"rankdef3ptfg" BIGINT
);
CREATE TABLE int_kenpom_summary (
"season" BIGINT,
"teamname" VARCHAR,
"tempo" DOUBLE,
"ranktempo" BIGINT,
"adjtempo" DOUBLE,
"rankadjtempo" BIGINT,
"oe" DOUBLE,
"rankoe" BIGINT,
"adjoe" DOUBLE,
"rankadjoe" BIGINT,
"de" DOUBLE,
"rankde" BIGINT,
"adjde" DOUBLE,
"rankadjde" BIGINT,
"adjem" DOUBLE,
"rankadjem" BIGINT
);
CREATE TABLE ref_2024_post_season_tournament_teams (
"team_name" VARCHAR,
"seed" BIGINT,
"region" VARCHAR,
"correct_team_name" VARCHAR,
"post_season_tournament" VARCHAR,
"post_season_tournament_sorting_index" BIGINT
);
CREATE TABLE ref_current_ncaam_coaches (
"current_coach" VARCHAR,
"team" VARCHAR,
"since" BIGINT,
"join_team" VARCHAR
);
Anyone who has the link will be able to view this.