Dataset: UFC Fight Data [1993 To 2023]

About this Dataset

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

Tables

Raw Total Fight Data

@kaggle.akshaysinghim_ufc_fight_data_1993_to_2023.raw_total_fight_data

564.26 KB
7051 rows
41 columns


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
);

Ufc Data Till Ufc 292

@kaggle.akshaysinghim_ufc_fight_data_1993_to_2023.ufc_data_till_ufc_292

579.37 KB
7272 rows
41 columns


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