Ultimate UFC Dataset

Merging All Kaggle Public UFC Datasets

@kaggle.mdabbert_ultimate_ufc_dataset

Table List

2 tables(723.83 KB)

Ufc Master

@kaggle.mdabbert_ultimate_ufc_dataset.ufc_master

641.91 KB
6528 rows
118 columns
Only the first 100 columns are shown

redfighter RedFighter	bluefighter BlueFighter	redodds RedOdds	blueodds BlueOdds	redexpectedvalue RedExpectedValue	blueexpectedvalue BlueExpectedValue	date Date	location Location	country Country	winner Winner	titlebout TitleBout	weightclass WeightClass	gender Gender	numberofrounds NumberOfRounds	bluecurrentlosestreak BlueCurrentLoseStreak	bluecurrentwinstreak BlueCurrentWinStreak	bluedraws BlueDraws	blueavgsigstrlanded BlueAvgSigStrLanded	blueavgsigstrpct BlueAvgSigStrPct	blueavgsubatt BlueAvgSubAtt	blueavgtdlanded BlueAvgTDLanded	blueavgtdpct BlueAvgTDPct	bluelongestwinstreak BlueLongestWinStreak	bluelosses BlueLosses	bluetotalroundsfought BlueTotalRoundsFought	bluetotaltitlebouts BlueTotalTitleBouts	bluewinsbydecisionsplit BlueWinsByDecisionSplit	bluewinsbydecisionunanimous BlueWinsByDecisionUnanimous	bluewinsbyko BlueWinsByKO	bluewinsbysubmission BlueWinsBySubmission	bluewins BlueWins	bluestance BlueStance	blueheightcms BlueHeightCms	bluereachcms BlueReachCms	blueweightlbs BlueWeightLbs	redcurrentlosestreak RedCurrentLoseStreak	redcurrentwinstreak RedCurrentWinStreak	redavgsigstrlanded RedAvgSigStrLanded	redavgsigstrpct RedAvgSigStrPct	redavgsubatt RedAvgSubAtt	redavgtdlanded RedAvgTDLanded	redavgtdpct RedAvgTDPct	redlongestwinstreak RedLongestWinStreak	redlosses RedLosses	redtotalroundsfought RedTotalRoundsFought	redtotaltitlebouts RedTotalTitleBouts	redwinsbydecisionmajority RedWinsByDecisionMajority	redwinsbydecisionsplit RedWinsByDecisionSplit	redwinsbydecisionunanimous RedWinsByDecisionUnanimous	redwinsbyko RedWinsByKO	redwinsbysubmission RedWinsBySubmission	redwins RedWins	redstance RedStance	redheightcms RedHeightCms	redreachcms RedReachCms	redweightlbs RedWeightLbs	redage RedAge	blueage BlueAge	losestreakdif LoseStreakDif	winstreakdif WinStreakDif	longestwinstreakdif LongestWinStreakDif	windif WinDif	lossdif LossDif	totalrounddif TotalRoundDif	totaltitleboutdif TotalTitleBoutDif	kodif KODif	subdif SubDif	heightdif HeightDif	reachdif ReachDif	agedif AgeDif	sigstrdif SigStrDif	avgsubattdif AvgSubAttDif	avgtddif AvgTDDif	bmatchwcrank BMatchWCRank	rmatchwcrank RMatchWCRank	rheavyweightrank RHeavyweightRank	rlightheavyweightrank RLightHeavyweightRank	rwelterweightrank RWelterweightRank	rfeatherweightrank RFeatherweightRank	rpfprank RPFPRank	bheavyweightrank BHeavyweightRank	blightheavyweightrank BLightHeavyweightRank
Alexandre Pantoja	Kai Asakura	-250	215	40	215	Sat Dec 07 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Las Vegas, Nevada, USA	USA	Red	true	Flyweight	MALE	5																		Orthodox	172.72	175.26	125		6	4.41	0.49	0.8	2.61	0.47	6	3	42	3		2	4	2	4	12	Orthodox	165.1	170.18	125	34	31		-6	-6	-12	-3	-42	-3	-2	-4	7.62	5.08	-3	-4.41	-0.8	-2.61							11
Shavkat Rakhmonov	Ian Machado Garry	-210	295	47.619	295	Sat Dec 07 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Las Vegas, Nevada, USA	USA	Red		Welterweight	MALE	3		8		5.5	0.55	0.3	0.77	0.55	8		20		1	4	3		8	Orthodox	190.5	187.96	170		6	4.12	0.61	1.8	1.49	0.29	6		11					1	5	6	Orthodox	185.42	195.58	170	30	27		2	2	2		9		2	-5	5.08	-7.62	-3	1.38	-1.5	-0.72	7	3			3
Ciryl Gane	Alexander Volkov	-380	300	26.3158	300	Sat Dec 07 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Las Vegas, Nevada, USA	USA	Red		Heavyweight	MALE	3		4		5.13	0.57	0.2	0.45	0.63	4	4	44		1	4	6	1	12	Orthodox	200.66	203.2	250		1	5.49	0.6	0.5	0.58	0.21	7	2	33	3			3	4	2	9	Orthodox	193.04	205.74	245	34	36		3	-3	3	2	11	-3	2	-1	7.62	-2.54	2	-0.36	-0.3	-0.13	3	2	2					3
Bryce Mitchell	Kron Gracie	-950	625	10.5263	625	Sat Dec 07 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Las Vegas, Nevada, USA	USA	Red		Featherweight	MALE	3	2			3.74	0.44	0.5	0.47	0.25	1	2	7					1	1	Southpaw	175.26	177.8	145	1		2.3	0.58	1.6	3.45	0.41	6	2	22		1		5		1	7	Southpaw	177.8	177.8	145	30	36	1		-5	-6		-15				-2.54		6	1.44	-1.1	-2.98		13				13
Nate Landwehr	Dooho Choi	-130	110	76.9231	110	Sat Dec 07 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Las Vegas, Nevada, USA	USA	Blue		Featherweight	MALE	3		1	1	4.41	0.53	0.8	0.75	0.37	3	3	15				4		4	Orthodox	177.8	177.8	145		1	6.25	0.46	1	1	0.41	3	3	17		1		1	1	2	5	Orthodox	175.26	182.88	145	36	33				-1		-2		3	-2	2.54	-5.08	-3	-1.84	-0.2	-0.25
Dominick Reyes	Anthony Smith	-380	300	26.3158	300	Sat Dec 07 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Las Vegas, Nevada, USA	USA	Red		Light Heavyweight	MALE	3	1			3.24	0.49	0.6	0.46	0.26	3	12	63	1	1	1	7	6	15	Orthodox	193.04	193.04	205		1	4.87	0.5	0.3	0.35	0.28	6	4	21	2		1	1	4	1	7	Southpaw	193.04	195.58	205	34	36	1	-1	-3	8	8	42	-1	3	5		-2.54	2	-1.63	0.3	0.11	13	12		12					13
Vicente Luque	Themba Gorimbo	-650	-162	15.3846	61.7284	Sat Dec 07 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Las Vegas, Nevada, USA	USA	Red		Welterweight	MALE	3		4		3.11	0.61	0.6	4.89	0.65	4	1	12			3	1		4	Orthodox	185.42	195.58	170	1		5.07	0.52	0.6	1	0.53	6	6	47			1	1	8	5	15	Orthodox	180.34	190.5	170	33	33	-1	4	-2	-11	-5	-35		-7	-5	5.08	5.08		-1.96		3.89		14			14
Movsar Evloev	Aljamain Sterling	-238	195	42.0168	195	Sat Dec 07 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Las Vegas, Nevada, USA	USA	Red		Featherweight	MALE	3		1		4.61	0.52	0.7	2.31	0.27	9	4	57	5	2	7	2	4	16	Orthodox	170.18	180.34	145		8	4.43	0.48	0.2	4.75	0.46	8		24			1	7			8	Orthodox	170.18	182.88	145	30	35		-7	1	8	4	33	5	2	4		-2.54	5	0.18	0.5	-2.44	9	5				5
Randy Brown	Bryan Battle	150	-180	150	55.5556	Sat Dec 07 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Las Vegas, Nevada, USA	USA	Blue		Welterweight	MALE	3		3		5.44	0.53	0.5	0.96	0.23	3	1	16			1	3	2	6	Orthodox	185.42	195.58	170		3	4.38	0.47	0.6	0.72	0.39	4	5	43			1	6	3	3	13	Orthodox	190.5	198.12	170	34	30			-1	-7	-4	-27			-1	-5.08	-2.54	-4	1.06	-0.1	0.24
Chris Weidman	Eryk Anders	-112	-108	89.2857	92.5926	Sat Dec 07 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Las Vegas, Nevada, USA	USA	Blue		Catch Weight	MALE	3		1		3.41	0.47	0.1	1.79	0.26	2	8	44		1	3	4		8	Southpaw	185.42	190.5	185		1	3.18	0.45	0.8	3.44	0.42	9	7	46	5			5	4	3	12	Orthodox	187.96	198.12	185	40	37			-7	-4	1	-2	-5		-3	-2.54	-7.62	-3	0.23	-0.7	-1.65


CREATE TABLE ufc_master (
  "redfighter" VARCHAR,
  "bluefighter" VARCHAR,
  "redodds" DOUBLE,
  "blueodds" DOUBLE,
  "redexpectedvalue" DOUBLE,
  "blueexpectedvalue" DOUBLE,
  "date" TIMESTAMP,
  "location" VARCHAR,
  "country" VARCHAR,
  "winner" VARCHAR,
  "titlebout" BOOLEAN,
  "weightclass" VARCHAR,
  "gender" VARCHAR,
  "numberofrounds" BIGINT,
  "bluecurrentlosestreak" BIGINT,
  "bluecurrentwinstreak" BIGINT,
  "bluedraws" BIGINT,
  "blueavgsigstrlanded" DOUBLE,
  "blueavgsigstrpct" DOUBLE,
  "blueavgsubatt" DOUBLE,
  "blueavgtdlanded" DOUBLE,
  "blueavgtdpct" DOUBLE,
  "bluelongestwinstreak" BIGINT,
  "bluelosses" BIGINT,
  "bluetotalroundsfought" BIGINT,
  "bluetotaltitlebouts" BIGINT,
  "bluewinsbydecisionmajority" BIGINT,
  "bluewinsbydecisionsplit" BIGINT,
  "bluewinsbydecisionunanimous" BIGINT,
  "bluewinsbyko" BIGINT,
  "bluewinsbysubmission" BIGINT,
  "bluewinsbytkodoctorstoppage" BIGINT,
  "bluewins" BIGINT,
  "bluestance" VARCHAR,
  "blueheightcms" DOUBLE,
  "bluereachcms" DOUBLE,
  "blueweightlbs" BIGINT,
  "redcurrentlosestreak" BIGINT,
  "redcurrentwinstreak" BIGINT,
  "reddraws" BIGINT,
  "redavgsigstrlanded" DOUBLE,
  "redavgsigstrpct" DOUBLE,
  "redavgsubatt" DOUBLE,
  "redavgtdlanded" DOUBLE,
  "redavgtdpct" DOUBLE,
  "redlongestwinstreak" BIGINT,
  "redlosses" BIGINT,
  "redtotalroundsfought" BIGINT,
  "redtotaltitlebouts" BIGINT,
  "redwinsbydecisionmajority" BIGINT,
  "redwinsbydecisionsplit" BIGINT,
  "redwinsbydecisionunanimous" BIGINT,
  "redwinsbyko" BIGINT,
  "redwinsbysubmission" BIGINT,
  "redwinsbytkodoctorstoppage" BIGINT,
  "redwins" BIGINT,
  "redstance" VARCHAR,
  "redheightcms" DOUBLE,
  "redreachcms" DOUBLE,
  "redweightlbs" BIGINT,
  "redage" BIGINT,
  "blueage" BIGINT,
  "losestreakdif" BIGINT,
  "winstreakdif" BIGINT,
  "longestwinstreakdif" BIGINT,
  "windif" BIGINT,
  "lossdif" BIGINT,
  "totalrounddif" BIGINT,
  "totaltitleboutdif" BIGINT,
  "kodif" BIGINT,
  "subdif" BIGINT,
  "heightdif" DOUBLE,
  "reachdif" DOUBLE,
  "agedif" BIGINT,
  "sigstrdif" DOUBLE,
  "avgsubattdif" DOUBLE,
  "avgtddif" DOUBLE,
  "emptyarena" DOUBLE,
  "bmatchwcrank" DOUBLE,
  "rmatchwcrank" DOUBLE,
  "rwflyweightrank" DOUBLE,
  "rwfeatherweightrank" DOUBLE,
  "rwstrawweightrank" DOUBLE,
  "rwbantamweightrank" DOUBLE,
  "rheavyweightrank" DOUBLE,
  "rlightheavyweightrank" DOUBLE,
  "rmiddleweightrank" DOUBLE,
  "rwelterweightrank" DOUBLE,
  "rlightweightrank" DOUBLE,
  "rfeatherweightrank" DOUBLE,
  "rbantamweightrank" DOUBLE,
  "rflyweightrank" DOUBLE,
  "rpfprank" DOUBLE,
  "bwflyweightrank" DOUBLE,
  "bwfeatherweightrank" DOUBLE,
  "bwstrawweightrank" DOUBLE,
  "bwbantamweightrank" DOUBLE,
  "bheavyweightrank" DOUBLE,
  "blightheavyweightrank" DOUBLE,
  "bmiddleweightrank" DOUBLE
);