UFC Fight Data [1993 To 2023]
Ultimate Fighting Championship - Fight Data - [1993 to April 2023]
@kaggle.akshaysinghim_ufc_fight_data_1993_to_2023
Ultimate Fighting Championship - Fight Data - [1993 to April 2023]
@kaggle.akshaysinghim_ufc_fight_data_1993_to_2023
This Dataset contains fight data of all the fights from the beginning of the UFC in 1993 to April of 2023, till UFC 287 - which was Jorge vs Burns.
Description of the columns included in the dataset-
B_fighter: Blue corner fighter name
R_KD: Red corner knockdowns
B_KD: Blue corner knockdowns
R_SIG_STR.: Red corner significant strikes landed
B_SIG_STR.: Blue corner significant strikes landed
R_SIG_STR_pct: Red corner significant strike accuracy percentage
B_SIG_STR_pct: Blue corner significant strike accuracy percentage
R_TOTAL_STR.: Red corner total strikes landed
B_TOTAL_STR.: Blue corner total strikes landed
R_TD: Red corner takedowns
B_TD: Blue corner takedowns
R_TD_pct: Red corner takedown accuracy percentage
B_TD_pct: Blue corner takedown accuracy percentage
R_SUB_ATT: Red corner submission attempts
B_SUB_ATT: Blue corner submission attempts
R_REV: Red corner reversals
B_REV: Blue corner reversals
R_CTRL: Red corner control time
B_CTRL: Blue corner control time
R_HEAD: Red corner strikes to the head
B_HEAD: Blue corner strikes to the head
R_BODY: Red corner strikes to the body
B_BODY: Blue corner strikes to the body
R_LEG: Red corner strikes to the legs
B_LEG: Blue corner strikes to the legs
R_DISTANCE: Red corner strikes at distance
B_DISTANCE: Blue corner strikes at distance
R_CLINCH: Red corner strikes in the clinch
B_CLINCH: Blue corner strikes in the clinch
R_GROUND: Red corner strikes on the ground
B_GROUND: Blue corner strikes on the ground
win_by: Method of victory
last_round: Last round of the fight
last_round_time: Time of the fight when it ended in the last round
Format: No of rounds.
Referee: Referee name
date: Date of the fight
location: Location of the fight
Fight_type: Type of fight (e.g., "Bantamweight Bout" or "Heavyweight Bout")
Winner: Winner of the fight
CREATE TABLE raw_total_fight_data (
"r_fighter" VARCHAR,
"b_fighter" VARCHAR,
"r_kd" BIGINT,
"b_kd" BIGINT,
"r_sig_str" VARCHAR -- R SIG STR.,
"b_sig_str" VARCHAR -- B SIG STR.,
"r_sig_str_pct" VARCHAR,
"b_sig_str_pct" VARCHAR,
"r_total_str" VARCHAR -- R TOTAL STR.,
"b_total_str" VARCHAR -- B TOTAL STR.,
"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
);
CREATE TABLE ufc_data_till_ufc_292 (
"r_fighter" VARCHAR,
"b_fighter" VARCHAR,
"r_kd" BIGINT,
"b_kd" BIGINT,
"r_sig_str" VARCHAR -- R SIG STR.,
"b_sig_str" VARCHAR -- B SIG STR.,
"r_sig_str_pct" VARCHAR,
"b_sig_str_pct" VARCHAR,
"r_total_str" VARCHAR -- R TOTAL STR.,
"b_total_str" VARCHAR -- B TOTAL STR.,
"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.