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

Raw Total Fight Data

@kaggle.rajeevw_ufcdata.raw_total_fight_data

491.64 KB
6012 rows
41 columns

r_fighter R Fighter	b_fighter B Fighter	r_kd R KD	b_kd B KD	r_sig_str R SIG STR.	b_sig_str B SIG STR.	r_sig_str_pct R SIG STR Pct	b_sig_str_pct B SIG STR Pct	r_total_str R TOTAL STR.	b_total_str B TOTAL STR.	r_td R TD	b_td B TD	r_td_pct R TD Pct	b_td_pct B TD Pct	r_sub_att R SUB ATT	b_sub_att B SUB ATT	r_rev R REV	b_rev B REV	r_ctrl R CTRL	b_ctrl B CTRL	r_head R HEAD	b_head B HEAD	r_body R BODY	b_body B BODY	r_leg R LEG	b_leg B LEG	r_distance R DISTANCE	b_distance B DISTANCE	r_clinch R CLINCH	b_clinch B CLINCH	r_ground R GROUND	b_ground B GROUND	win_by Win By	last_round Last Round	last_round_time Last Round Time	format Format	referee Referee	date Date	location Location	fight_type Fight Type	winner Winner
Adrian Yanez	Gustavo Lopez	2		41 of 103	23 of 51	39%	45%	41 of 103	23 of 51	0 of 0	0 of 1	---	0%					0:03	0:00	32 of 83	14 of 40	8 of 19	5 of 7	1 of 1	4 of 4	41 of 102	23 of 51	0 of 0	0 of 0	0 of 1	0 of 0	KO/TKO	3	0:27	3 Rnd (5-5-5)	Chris Tognoni	March 20, 2021	Las Vegas, Nevada, USA	Bantamweight Bout	Adrian Yanez
Trevin Giles	Roman Dolidze			27 of 57	32 of 67	47%	47%	43 of 73	75 of 110	1 of 2	1 of 3	50%	33%	1	2		1	1:15	4:15	22 of 51	10 of 37	4 of 4	7 of 14	1 of 2	15 of 16	15 of 42	28 of 59	4 of 5	3 of 6	8 of 10	1 of 2	Decision - Unanimous	3	5:00	3 Rnd (5-5-5)	Herb Dean	March 20, 2021	Las Vegas, Nevada, USA	Middleweight Bout	Trevin Giles
Tai Tuivasa	Harry Hunsucker	1		14 of 18	2 of 6	77%	33%	14 of 18	2 of 6	0 of 0	0 of 0	---	---					0:10	0:00	10 of 14	1 of 5	0 of 0	0 of 0	4 of 4	1 of 1	9 of 10	2 of 6	0 of 0	0 of 0	5 of 8	0 of 0	KO/TKO	1	0:49	3 Rnd (5-5-5)	Herb Dean	March 20, 2021	Las Vegas, Nevada, USA	Heavyweight Bout	Tai Tuivasa
Cheyanne Buys	Montserrat Conejo			31 of 65	15 of 41	47%	36%	49 of 87	136 of 168	0 of 0	4 of 5	---	80%		2	3	1	1:04	9:53	26 of 60	10 of 35	5 of 5	0 of 1	0 of 0	5 of 5	26 of 56	15 of 41	2 of 2	0 of 0	3 of 7	0 of 0	Decision - Unanimous	3	5:00	3 Rnd (5-5-5)	Mark Smith	March 20, 2021	Las Vegas, Nevada, USA	Women's Strawweight Bout	Montserrat Conejo
Marion Reneau	Macy Chiasson			30 of 63	51 of 138	47%	36%	59 of 93	92 of 184	2 of 4	1 of 1	50%	100%				1	2:15	3:48	14 of 40	29 of 110	7 of 13	15 of 20	9 of 10	7 of 8	25 of 54	36 of 119	5 of 9	13 of 15	0 of 0	2 of 4	Decision - Unanimous	3	5:00	3 Rnd (5-5-5)	Mark Smith	March 20, 2021	Las Vegas, Nevada, USA	Women's Bantamweight Bout	Macy Chiasson
Leonardo Santos	Grant Dawson			30 of 67	46 of 84	44%	54%	74 of 115	75 of 132	1 of 2	1 of 13	50%	7%					1:21	8:18	14 of 45	16 of 48	6 of 10	23 of 27	10 of 12	7 of 9	28 of 65	33 of 68	2 of 2	9 of 11	0 of 0	4 of 5	KO/TKO	3	4:59	3 Rnd (5-5-5)	Chris Tognoni	March 20, 2021	Las Vegas, Nevada, USA	Lightweight Bout	Grant Dawson
Song Kenan	Max Griffin		1	14 of 24	17 of 28	58%	60%	14 of 24	17 of 28	0 of 0	0 of 1	---	0%					0:00	0:28	5 of 10	11 of 17	5 of 8	2 of 7	4 of 6	4 of 4	14 of 24	16 of 27	0 of 0	0 of 0	0 of 0	1 of 1	KO/TKO	1	2:20	3 Rnd (5-5-5)	Keith Peterson	March 20, 2021	Las Vegas, Nevada, USA	Welterweight Bout	Max Griffin
Derek Brunson	Kevin Holland			43 of 93	36 of 74	46%	48%	226 of 323	190 of 236	6 of 12	1 of 1	50%	100%	1				16:55	1:47	28 of 74	28 of 64	7 of 10	2 of 4	8 of 9	6 of 6	14 of 43	29 of 64	10 of 10	5 of 7	19 of 40	2 of 3	Decision - Unanimous	5	5:00	5 Rnd (5-5-5-5-5)	Herb Dean	March 20, 2021	Las Vegas, Nevada, USA	Middleweight Bout	Derek Brunson
Montel Jackson	Jesse Strader	2		15 of 26	14 of 25	57%	56%	15 of 26	14 of 25	0 of 0	0 of 0	---	---					0:16	0:01	11 of 22	3 of 7	2 of 2	3 of 7	2 of 2	8 of 11	5 of 12	12 of 22	3 of 4	0 of 1	7 of 10	2 of 2	KO/TKO	1	1:58	3 Rnd (5-5-5)	Keith Peterson	March 20, 2021	Las Vegas, Nevada, USA	Bantamweight Bout	Montel Jackson
Bruno Silva	JP Buys	3		37 of 61	17 of 56	60%	30%	62 of 89	37 of 76	1 of 2	0 of 1	50%	0%		1			3:51	1:02	29 of 51	8 of 42	4 of 6	4 of 7	4 of 4	5 of 7	26 of 43	15 of 53	1 of 2	2 of 3	10 of 16	0 of 0	KO/TKO	2	2:56	3 Rnd (5-5-5)	Mark Smith	March 20, 2021	Las Vegas, Nevada, USA	Flyweight Bout	Bruno Silva


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