UFC-Fight Historical Data From 1993 To 2021

Compiled UFC fight, fighter stats and information

@kaggle.rajeevw_ufcdata

Table List

4 tables(4.48 MB)

Data

Preprocessed Data

Raw Fighter Details

Raw Total Fight Data

Data

@kaggle.rajeevw_ufcdata.data

1.96 MB
6012 rows
144 columns
Only the first 100 columns are shown

r_fighter R Fighter	b_fighter B Fighter	referee Referee	date Date	location Location	winner Winner	weight_class Weight Class	b_avg_kd B Avg KD	b_avg_opp_kd B Avg Opp KD	b_avg_sig_str_pct B Avg SIG STR Pct	b_avg_opp_sig_str_pct B Avg Opp SIG STR Pct	b_avg_td_pct B Avg TD Pct	b_avg_opp_td_pct B Avg Opp TD Pct	b_avg_sub_att B Avg SUB ATT	b_avg_opp_sub_att B Avg Opp SUB ATT	b_avg_rev B Avg REV	b_avg_opp_rev B Avg Opp REV	b_avg_sig_str_att B Avg SIG STR Att	b_avg_sig_str_landed B Avg SIG STR Landed	b_avg_opp_sig_str_att B Avg Opp SIG STR Att	b_avg_opp_sig_str_landed B Avg Opp SIG STR Landed	b_avg_total_str_att B Avg TOTAL STR Att	b_avg_total_str_landed B Avg TOTAL STR Landed	b_avg_opp_total_str_att B Avg Opp TOTAL STR Att	b_avg_opp_total_str_landed B Avg Opp TOTAL STR Landed	b_avg_td_att B Avg TD Att	b_avg_td_landed B Avg TD Landed	b_avg_opp_td_att B Avg Opp TD Att	b_avg_opp_td_landed B Avg Opp TD Landed	b_avg_head_att B Avg HEAD Att	b_avg_head_landed B Avg HEAD Landed	b_avg_opp_head_att B Avg Opp HEAD Att	b_avg_opp_head_landed B Avg Opp HEAD Landed	b_avg_body_att B Avg BODY Att	b_avg_body_landed B Avg BODY Landed	b_avg_opp_body_att B Avg Opp BODY Att	b_avg_opp_body_landed B Avg Opp BODY Landed	b_avg_leg_att B Avg LEG Att	b_avg_leg_landed B Avg LEG Landed	b_avg_opp_leg_att B Avg Opp LEG Att	b_avg_opp_leg_landed B Avg Opp LEG Landed	b_avg_distance_att B Avg DISTANCE Att	b_avg_distance_landed B Avg DISTANCE Landed	b_avg_opp_distance_att B Avg Opp DISTANCE Att	b_avg_opp_distance_landed B Avg Opp DISTANCE Landed	b_avg_clinch_att B Avg CLINCH Att	b_avg_clinch_landed B Avg CLINCH Landed	b_avg_opp_clinch_att B Avg Opp CLINCH Att	b_avg_opp_clinch_landed B Avg Opp CLINCH Landed	b_avg_ground_att B Avg GROUND Att	b_avg_ground_landed B Avg GROUND Landed	b_avg_opp_ground_att B Avg Opp GROUND Att	b_avg_opp_ground_landed B Avg Opp GROUND Landed	b_avg_ctrl_time_seconds B Avg CTRL Time(seconds)	b_avg_opp_ctrl_time_seconds B Avg Opp CTRL Time(seconds)	b_total_time_fought_seconds B Total Time Fought(seconds)	b_total_rounds_fought B Total Rounds Fought	b_total_title_bouts B Total Title Bouts	b_current_win_streak B Current Win Streak	b_current_lose_streak B Current Lose Streak	b_longest_win_streak B Longest Win Streak	b_wins B Wins	b_losses B Losses	b_win_by_decision_majority B Win By Decision Majority	b_win_by_decision_split B Win By Decision Split	b_win_by_decision_unanimous B Win By Decision Unanimous	b_win_by_ko_tko B Win By KO/TKO	b_win_by_submission B Win By Submission	b_stance B Stance	b_height_cms B Height Cms	b_reach_cms B Reach Cms	b_weight_lbs B Weight Lbs	r_avg_kd R Avg KD	r_avg_opp_kd R Avg Opp KD	r_avg_sig_str_pct R Avg SIG STR Pct	r_avg_opp_sig_str_pct R Avg Opp SIG STR Pct	r_avg_td_pct R Avg TD Pct	r_avg_opp_td_pct R Avg Opp TD Pct	r_avg_sub_att R Avg SUB ATT	r_avg_opp_sub_att R Avg Opp SUB ATT	r_avg_rev R Avg REV	r_avg_opp_rev R Avg Opp REV	r_avg_sig_str_att R Avg SIG STR Att	r_avg_sig_str_landed R Avg SIG STR Landed	r_avg_opp_sig_str_att R Avg Opp SIG STR Att	r_avg_opp_sig_str_landed R Avg Opp SIG STR Landed	r_avg_total_str_att R Avg TOTAL STR Att	r_avg_total_str_landed R Avg TOTAL STR Landed	r_avg_opp_total_str_att R Avg Opp TOTAL STR Att	r_avg_opp_total_str_landed R Avg Opp TOTAL STR Landed	r_avg_td_att R Avg TD Att	r_avg_td_landed R Avg TD Landed	r_avg_opp_td_att R Avg Opp TD Att	r_avg_opp_td_landed R Avg Opp TD Landed	r_avg_head_att R Avg HEAD Att	r_avg_head_landed R Avg HEAD Landed	r_avg_opp_head_att R Avg Opp HEAD Att
Adrian Yanez	Gustavo Lopez	Chris Tognoni	Sat Mar 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Las Vegas, Nevada, USA	Red	Bantamweight			0.42	0.495	0.33	0.36	0.5	1			50	20	84	45	76.5	41	114	64	1.5	1	9	6.5	39.5	11	63	27.5	7.5	7	12	9	3	2	9	8.5	35	12.5	43.5	17.5	10.5	4.5	4	3	4.5	3	36.5	24.5	34	277.5	531.5	4			1	1	1	1					1	Orthodox	165.1	170.18	135	1		0.5	0.46							34	17	13	6	35	18	16	9			3		32	15	11
Trevin Giles	Roman Dolidze	Herb Dean	Sat Mar 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Las Vegas, Nevada, USA	Red	Middleweight	0.5		0.66	0.305	0.3	0.5	1.5				65.5	35	50	16.5	113.5	68.5	68.5	29	2.5	1.5	0.5	0.5	46	20	36	7.5	12	8	8	3	7.5	7	6	6	58	30	48	15.5	0.5	0.5	0.5	0.5	7	4.5	1.5	0.5	219.5	24.5	577.5	4		2		2	2			1		1		Orthodox	187.96	193.04	205	1.03125	0.0625	0.576875	0.38125	0.40625	0.11625	0.25	1.1875	0.375	0.25	77.5625	43.15625	69.15625	27.59375	93.125	57.21875	98.34375	52.46875	1.28125	0.78125	4.6875	0.4375	71.09375	38.0625	50.40625
Tai Tuivasa	Harry Hunsucker	Herb Dean	Sat Mar 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Las Vegas, Nevada, USA	Red	Heavyweight																																																														Orthodox	187.96	190.5	241	0.546875	0.1875	0.53890625	0.59859375		0.3125		0.25			59.234375	30.375	43.8125	24.796875	70.5	41.390625	50.234375	30.90625	0.03125		2.84375	1.75	42.5	16.78125	34.296875
Cheyanne Buys	Montserrat Conejo	Mark Smith	Sat Mar 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Las Vegas, Nevada, USA	Blue	WomenStrawweight																																																														Southpaw	152.4	154.94	115
Marion Reneau	Macy Chiasson	Mark Smith	Sat Mar 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Las Vegas, Nevada, USA	Blue	WomenBantamweight	0.125		0.535625	0.5787500000000001	0.185	0.16625	0.125	0.1875	0.25		109.1875	57.9375	50.625	28.4375	170.4375	105.625	74.375	44.25	5.375	1.5	2	0.625	77.375	31.375	41.5625	22.625	31.1875	26.1875	7.6875	4.9375	0.625	0.375	1.375	0.875	33.5625	11	32.0625	13.9375	39.0625	28.8125	13.3125	10.75	36.5625	18.125	5.25	3.75	390.25	156.3125	764	11	1	3		3	4	1			1	2	1	Orthodox	180.34	182.88	135		0.0009765625	0.403076171875	0.5549609375	0.51171875	0.62875	0.2314453125	0.03125	0.03125	0.5	109.3310546875	44.3623046875	148.8466796875	84.5546875	137.154296875	70.1982421875	172.4990234375	106.6806640625	2.26171875	1.26171875	3.1376953125	1.771484375	86.375	26.0302734375	94.2255859375
Leonardo Santos	Grant Dawson	Chris Tognoni	Sat Mar 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Las Vegas, Nevada, USA	Blue	Lightweight			0.515	0.4737499999999999	0.435	0.25	1.25	0.625		0.25	86	40.75	55.5	25.125	150.625	93.5	79	46.75	6.375	2.625	0.25	0.25	60.625	23.125	42.375	14.625	10	4.5	10.625	8.25	15.375	13.125	2.5	2.25	68.875	29.625	50.125	20.25	3.125	2	3	2.75	14	9.125	2.375	2.125	431.75	17.375	717.875	10		4		4	4				2		2	Switch	177.8	182.88	145	0.3125	0.015625	0.56515625	0.34359375	0.33703125	0.04890625	0.0390625			0.5	78.9296875	42.1875	78.6171875	32.046875	110.9140625	68.0625	99.2890625	48.8984375	1.40625	0.6328125	5.6875	0.515625	65.1953125	32.28125	54.765625
Song Kenan	Max Griffin	Keith Peterson	Sat Mar 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Las Vegas, Nevada, USA	Blue	Welterweight	0.046875	0.125	0.4592773437499999	0.4046875	0.3221875	0.0688671875	0.189453125		0.283203125		130.818359375	60.11328125	129.337890625	50.548828125	151.5546875	78.32421875	137.427734375	58.5078125	2.73046875	1.453125	1.552734375	0.28515625	102.328125	38.814453125	111.267578125	37.830078125	20.951171875	14.419921875	12.15625	7.1796875	7.5390625	6.87890625	5.9140625	5.5390625	125.130859375	55.888671875	122.193359375	45.869140625	5.03125	3.763671875	6.263671875	3.966796875	0.65625	0.4609375	0.880859375	0.712890625	148.5078125	80.09765625	809.53125	28			1	1	4	6	1		1	2		Orthodox	180.34	193.04	170	0.625		0.493125	0.43		0.6875		0.25	0.25	0.25	73.8125	33.5	61.0625	26.5	77.5625	36.5625	67.4375	32.125			2.375	1.375	56.5625	23.375	51.5625
Derek Brunson	Kevin Holland	Herb Dean	Sat Mar 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Las Vegas, Nevada, USA	Red	Middleweight	0.15625		0.7915820312499999	0.8505859375	0.26919921875	0.3933984375	0.029296875	0.080078125	0.0234375	0.041015625	39.2109375	26.078125	24.494140625	11.953125	61.64453125	47.791015625	31.279296875	17.46484375	0.935546875	0.529296875	2.759765625	1.451171875	31.01953125	19.921875	15.763671875	5.615234375	4.162109375	2.685546875	4.70703125	2.8203125	4.029296875	3.470703125	4.0234375	3.517578125	25.35546875	14.09375	17.171875	7.177734375	3.630859375	2.984375	1.857421875	1.353515625	10.224609375	9	5.46484375	3.421875	69.5	82.31640625	267.517578125	23			1	5	8	2		2	1	3	2	Orthodox	190.5	205.74	185	0.0245513916015625	0.220703125	0.5156361389160156	0.44597412109375	0.3558242797851562		0.000091552734375				133.4735107421875	72.17990112304688	95.71842956542967	41.511474609375	150.52398681640625	88.71699523925781	102.1464385986328	47.68928527832031	8.111679077148438	3.008209228515625	2.1568603515625		98.62075805664062	46.65184020996094	66.27102661132812
Montel Jackson	Jesse Strader	Keith Peterson	Sat Mar 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Las Vegas, Nevada, USA	Red	Bantamweight																																																														Orthodox	170.18	177.8	135	0.75		0.615	0.474375	0.66875	0.3868749999999999	0.0625	1.25	0.625		68	43	28.1875	12.9375	117.625	88.4375	41.6875	25.25	5.875	4.25	12.9375	4.8125	55.4375	31.8125	17.5
Bruno Silva	JP Buys	Mark Smith	Sat Mar 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Las Vegas, Nevada, USA	Red	Flyweight																																																														Orthodox	165.1	170.18	125		0.25	0.42	0.4175	0.3625	0.225		0.25		0.5	93.75	39.75	116.25	49.25	117	57.25	148	76	9.5	3.25	6	2.5	66	18.5	93.75


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