UFC-Fight Historical Data From 1993 To 2021
Compiled UFC fight, fighter stats and information
@kaggle.rajeevw_ufcdata
Compiled UFC fight, fighter stats and information
@kaggle.rajeevw_ufcdata
CREATE TABLE data (
"r_fighter" VARCHAR,
"b_fighter" VARCHAR,
"referee" VARCHAR,
"date" TIMESTAMP,
"location" VARCHAR,
"winner" VARCHAR,
"title_bout" BOOLEAN,
"weight_class" VARCHAR,
"b_avg_kd" DOUBLE,
"b_avg_opp_kd" DOUBLE,
"b_avg_sig_str_pct" DOUBLE,
"b_avg_opp_sig_str_pct" DOUBLE,
"b_avg_td_pct" DOUBLE,
"b_avg_opp_td_pct" DOUBLE,
"b_avg_sub_att" DOUBLE,
"b_avg_opp_sub_att" DOUBLE,
"b_avg_rev" DOUBLE,
"b_avg_opp_rev" DOUBLE,
"b_avg_sig_str_att" DOUBLE,
"b_avg_sig_str_landed" DOUBLE,
"b_avg_opp_sig_str_att" DOUBLE,
"b_avg_opp_sig_str_landed" DOUBLE,
"b_avg_total_str_att" DOUBLE,
"b_avg_total_str_landed" DOUBLE,
"b_avg_opp_total_str_att" DOUBLE,
"b_avg_opp_total_str_landed" DOUBLE,
"b_avg_td_att" DOUBLE,
"b_avg_td_landed" DOUBLE,
"b_avg_opp_td_att" DOUBLE,
"b_avg_opp_td_landed" DOUBLE,
"b_avg_head_att" DOUBLE,
"b_avg_head_landed" DOUBLE,
"b_avg_opp_head_att" DOUBLE,
"b_avg_opp_head_landed" DOUBLE,
"b_avg_body_att" DOUBLE,
"b_avg_body_landed" DOUBLE,
"b_avg_opp_body_att" DOUBLE,
"b_avg_opp_body_landed" DOUBLE,
"b_avg_leg_att" DOUBLE,
"b_avg_leg_landed" DOUBLE,
"b_avg_opp_leg_att" DOUBLE,
"b_avg_opp_leg_landed" DOUBLE,
"b_avg_distance_att" DOUBLE,
"b_avg_distance_landed" DOUBLE,
"b_avg_opp_distance_att" DOUBLE,
"b_avg_opp_distance_landed" DOUBLE,
"b_avg_clinch_att" DOUBLE,
"b_avg_clinch_landed" DOUBLE,
"b_avg_opp_clinch_att" DOUBLE,
"b_avg_opp_clinch_landed" DOUBLE,
"b_avg_ground_att" DOUBLE,
"b_avg_ground_landed" DOUBLE,
"b_avg_opp_ground_att" DOUBLE,
"b_avg_opp_ground_landed" DOUBLE,
"b_avg_ctrl_time_seconds" DOUBLE,
"b_avg_opp_ctrl_time_seconds" DOUBLE,
"b_total_time_fought_seconds" DOUBLE,
"b_total_rounds_fought" BIGINT,
"b_total_title_bouts" BIGINT,
"b_current_win_streak" BIGINT,
"b_current_lose_streak" BIGINT,
"b_longest_win_streak" BIGINT,
"b_wins" BIGINT,
"b_losses" BIGINT,
"b_draw" BIGINT,
"b_win_by_decision_majority" BIGINT,
"b_win_by_decision_split" BIGINT,
"b_win_by_decision_unanimous" BIGINT,
"b_win_by_ko_tko" BIGINT,
"b_win_by_submission" BIGINT,
"b_win_by_tko_doctor_stoppage" BIGINT,
"b_stance" VARCHAR,
"b_height_cms" DOUBLE,
"b_reach_cms" DOUBLE,
"b_weight_lbs" DOUBLE,
"r_avg_kd" DOUBLE,
"r_avg_opp_kd" DOUBLE,
"r_avg_sig_str_pct" DOUBLE,
"r_avg_opp_sig_str_pct" DOUBLE,
"r_avg_td_pct" DOUBLE,
"r_avg_opp_td_pct" DOUBLE,
"r_avg_sub_att" DOUBLE,
"r_avg_opp_sub_att" DOUBLE,
"r_avg_rev" DOUBLE,
"r_avg_opp_rev" DOUBLE,
"r_avg_sig_str_att" DOUBLE,
"r_avg_sig_str_landed" DOUBLE,
"r_avg_opp_sig_str_att" DOUBLE,
"r_avg_opp_sig_str_landed" DOUBLE,
"r_avg_total_str_att" DOUBLE,
"r_avg_total_str_landed" DOUBLE,
"r_avg_opp_total_str_att" DOUBLE,
"r_avg_opp_total_str_landed" DOUBLE,
"r_avg_td_att" DOUBLE,
"r_avg_td_landed" DOUBLE,
"r_avg_opp_td_att" DOUBLE,
"r_avg_opp_td_landed" DOUBLE,
"r_avg_head_att" DOUBLE,
"r_avg_head_landed" DOUBLE,
"r_avg_opp_head_att" DOUBLE
);
CREATE TABLE preprocessed_data (
"winner" VARCHAR,
"title_bout" BOOLEAN,
"b_avg_kd" DOUBLE,
"b_avg_opp_kd" DOUBLE,
"b_avg_sig_str_pct" DOUBLE,
"b_avg_opp_sig_str_pct" DOUBLE,
"b_avg_td_pct" DOUBLE,
"b_avg_opp_td_pct" DOUBLE,
"b_avg_sub_att" DOUBLE,
"b_avg_opp_sub_att" DOUBLE,
"b_avg_rev" DOUBLE,
"b_avg_opp_rev" DOUBLE,
"b_avg_sig_str_att" DOUBLE,
"b_avg_sig_str_landed" DOUBLE,
"b_avg_opp_sig_str_att" DOUBLE,
"b_avg_opp_sig_str_landed" DOUBLE,
"b_avg_total_str_att" DOUBLE,
"b_avg_total_str_landed" DOUBLE,
"b_avg_opp_total_str_att" DOUBLE,
"b_avg_opp_total_str_landed" DOUBLE,
"b_avg_td_att" DOUBLE,
"b_avg_td_landed" DOUBLE,
"b_avg_opp_td_att" DOUBLE,
"b_avg_opp_td_landed" DOUBLE,
"b_avg_head_att" DOUBLE,
"b_avg_head_landed" DOUBLE,
"b_avg_opp_head_att" DOUBLE,
"b_avg_opp_head_landed" DOUBLE,
"b_avg_body_att" DOUBLE,
"b_avg_body_landed" DOUBLE,
"b_avg_opp_body_att" DOUBLE,
"b_avg_opp_body_landed" DOUBLE,
"b_avg_leg_att" DOUBLE,
"b_avg_leg_landed" DOUBLE,
"b_avg_opp_leg_att" DOUBLE,
"b_avg_opp_leg_landed" DOUBLE,
"b_avg_distance_att" DOUBLE,
"b_avg_distance_landed" DOUBLE,
"b_avg_opp_distance_att" DOUBLE,
"b_avg_opp_distance_landed" DOUBLE,
"b_avg_clinch_att" DOUBLE,
"b_avg_clinch_landed" DOUBLE,
"b_avg_opp_clinch_att" DOUBLE,
"b_avg_opp_clinch_landed" DOUBLE,
"b_avg_ground_att" DOUBLE,
"b_avg_ground_landed" DOUBLE,
"b_avg_opp_ground_att" DOUBLE,
"b_avg_opp_ground_landed" DOUBLE,
"b_avg_ctrl_time_seconds" DOUBLE,
"b_avg_opp_ctrl_time_seconds" DOUBLE,
"b_total_time_fought_seconds" DOUBLE,
"b_total_rounds_fought" BIGINT,
"b_total_title_bouts" BIGINT,
"b_current_win_streak" BIGINT,
"b_current_lose_streak" BIGINT,
"b_longest_win_streak" BIGINT,
"b_wins" BIGINT,
"b_losses" BIGINT,
"b_draw" BIGINT,
"b_win_by_decision_majority" BIGINT,
"b_win_by_decision_split" BIGINT,
"b_win_by_decision_unanimous" BIGINT,
"b_win_by_ko_tko" BIGINT,
"b_win_by_submission" BIGINT,
"b_win_by_tko_doctor_stoppage" BIGINT,
"b_height_cms" DOUBLE,
"b_reach_cms" DOUBLE,
"b_weight_lbs" DOUBLE,
"r_avg_kd" DOUBLE,
"r_avg_opp_kd" DOUBLE,
"r_avg_sig_str_pct" DOUBLE,
"r_avg_opp_sig_str_pct" DOUBLE,
"r_avg_td_pct" DOUBLE,
"r_avg_opp_td_pct" DOUBLE,
"r_avg_sub_att" DOUBLE,
"r_avg_opp_sub_att" DOUBLE,
"r_avg_rev" DOUBLE,
"r_avg_opp_rev" DOUBLE,
"r_avg_sig_str_att" DOUBLE,
"r_avg_sig_str_landed" DOUBLE,
"r_avg_opp_sig_str_att" DOUBLE,
"r_avg_opp_sig_str_landed" DOUBLE,
"r_avg_total_str_att" DOUBLE,
"r_avg_total_str_landed" DOUBLE,
"r_avg_opp_total_str_att" DOUBLE,
"r_avg_opp_total_str_landed" DOUBLE,
"r_avg_td_att" DOUBLE,
"r_avg_td_landed" DOUBLE,
"r_avg_opp_td_att" DOUBLE,
"r_avg_opp_td_landed" DOUBLE,
"r_avg_head_att" DOUBLE,
"r_avg_head_landed" DOUBLE,
"r_avg_opp_head_att" DOUBLE,
"r_avg_opp_head_landed" DOUBLE,
"r_avg_body_att" DOUBLE,
"r_avg_body_landed" DOUBLE,
"r_avg_opp_body_att" DOUBLE,
"r_avg_opp_body_landed" DOUBLE,
"r_avg_leg_att" DOUBLE,
"r_avg_leg_landed" DOUBLE
);
CREATE TABLE raw_fighter_details (
"fighter_name" VARCHAR,
"height" VARCHAR,
"weight" VARCHAR,
"reach" VARCHAR,
"stance" VARCHAR,
"dob" TIMESTAMP,
"slpm" DOUBLE,
"str_acc" VARCHAR,
"sapm" DOUBLE,
"str_def" VARCHAR,
"td_avg" DOUBLE,
"td_acc" VARCHAR,
"td_def" VARCHAR,
"sub_avg" DOUBLE
);
CREATE TABLE raw_total_fight_data (
"r_fighter" VARCHAR,
"b_fighter" VARCHAR,
"r_kd" BIGINT,
"b_kd" BIGINT,
"r_sig_str" VARCHAR,
"b_sig_str" VARCHAR,
"r_sig_str_pct" VARCHAR,
"b_sig_str_pct" VARCHAR,
"r_total_str" VARCHAR,
"b_total_str" VARCHAR,
"r_td" VARCHAR,
"b_td" VARCHAR,
"r_td_pct" VARCHAR,
"b_td_pct" VARCHAR,
"r_sub_att" BIGINT,
"b_sub_att" BIGINT,
"r_rev" BIGINT,
"b_rev" BIGINT,
"r_ctrl" VARCHAR,
"b_ctrl" VARCHAR,
"r_head" VARCHAR,
"b_head" VARCHAR,
"r_body" VARCHAR,
"b_body" VARCHAR,
"r_leg" VARCHAR,
"b_leg" VARCHAR,
"r_distance" VARCHAR,
"b_distance" VARCHAR,
"r_clinch" VARCHAR,
"b_clinch" VARCHAR,
"r_ground" VARCHAR,
"b_ground" VARCHAR,
"win_by" VARCHAR,
"last_round" BIGINT,
"last_round_time" VARCHAR,
"format" VARCHAR,
"referee" VARCHAR,
"date" VARCHAR,
"location" VARCHAR,
"fight_type" VARCHAR,
"winner" VARCHAR
);
Anyone who has the link will be able to view this.