Ultimate UFC Dataset

Merging All Kaggle Public UFC Datasets

@kaggle.mdabbert_ultimate_ufc_dataset

Table List

2 tables(723.83 KB)

Upcoming

@kaggle.mdabbert_ultimate_ufc_dataset.upcoming

81.92 KB
13 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	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	bluewinsbydecisionsplit BlueWinsByDecisionSplit	bluewinsbydecisionunanimous BlueWinsByDecisionUnanimous	bluewinsbyko BlueWinsByKO	bluewinsbysubmission BlueWinsBySubmission	bluewins BlueWins	bluestance BlueStance	blueheightcms BlueHeightCms	bluereachcms BlueReachCms	blueweightlbs BlueWeightLbs	redcurrentlosestreak RedCurrentLoseStreak	redcurrentwinstreak RedCurrentWinStreak	reddraws RedDraws	redavgsigstrlanded RedAvgSigStrLanded	redavgsigstrpct RedAvgSigStrPct	redavgsubatt RedAvgSubAtt	redavgtdlanded RedAvgTDLanded	redavgtdpct RedAvgTDPct	redlongestwinstreak RedLongestWinStreak	redlosses RedLosses	redtotalroundsfought RedTotalRoundsFought	redtotaltitlebouts RedTotalTitleBouts	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	rwelterweightrank RWelterweightRank	rflyweightrank RFlyweightRank
Colby Covington	Joaquin Buckley	205	-250	205	40	Sat Dec 14 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Tampa, Florida, USA	USA	Welterweight	MALE	5		5		4.13	0.36		1.96	0.46	5	4	34	1	2	7		10	Southpaw	177.8	193.04	170	1			3.88	0.38	0.2	3.79	0.44	7	4	58	4		7	3	2	12	Orthodox	180.34	182.88	170	36	30	-1	5	-2	-2		-24	-4	4	-2	-2.54	10.16	-6	0.25	-0.2	-1.83	9	6	6
Cub Swanson	Billy Quarantillo	124	-148	124	67.5676	Sat Dec 14 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Tampa, Florida, USA	USA	Featherweight	MALE	3	1			7.36	0.56	1.1	1.24	0.23	4	4	28		2	4	1	7	Orthodox	177.8	177.8	145	1			4.67	0.5	0.4	1.04	0.5	6	13	82		1	10	6	2	19	Orthodox	172.72	177.8	145	41	36			-2	-12	-9	-54		-2	-1	5.08		-5	2.69	0.7	0.2
Manel Kape	Bruno Silva	-395	310	25.3165	310	Sat Dec 14 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Tampa, Florida, USA	USA	Flyweight	MALE	3		4		3.32	0.48	0.2	2.26	0.28	4	2	16			3	1	4	Orthodox	162.56	165.1	125	1			4.44	0.53	0.4	0.54	0.33	4	3	17			2	2		4	Southpaw	165.1	172.72	125	31	34	-1	4			-1	-1		1	1	-2.54	-7.62	3	-1.12	-0.2	1.72	12	9		9
Vitor Petrino	Dustin Jacoby	-340	270	29.4118	270	Sat Dec 14 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Tampa, Florida, USA	USA	Light Heavyweight	MALE	3	2		1	5.5	0.47		0.36	0.25	4	6	35		4	4		8	Orthodox	190.5	193.04	205	1			2.82	0.45	0.8	3.98	0.66	5	1	14			2	2	1	5	Orthodox	187.96	195.58	205	27	36	1		-1	3	5	21		2	-1	2.54	-2.54	9	2.68	-0.8	-3.62
Adrian Yanez	Daniel Marcos	185	-225	185	44.4444	Sat Dec 14 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Tampa, Florida, USA	USA	Bantamweight	MALE	3		4		5.94	0.52		0.25	0.5	4		13	1	2	1		4	Orthodox	170.18	175.26	135		1		6.51	0.41				6	2	15		1		6		7	Orthodox	170.18	177.8	135	31	31		3	-2	-3	-2	-2		-5			-2.54		-0.57		0.25
Navajo Stirling	Tuco Tokkos	-750	525	13.3333	525	Sat Dec 14 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Tampa, Florida, USA	USA	Light Heavyweight	MALE	3	2			3.26	0.43		1.96	1		2	2						Orthodox	193.04	193.04	205		1		7.07	0.68				1		2				1		1	Orthodox	193.04	200.66	205	27	34	2	-1	-1	-1	2			-1			-7.62	7	-3.81		1.96
Michael Johnson	Ottman Azaitar	-230	190	43.4783	190	Sat Dec 14 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Tampa, Florida, USA	USA	Lightweight	MALE	3	2			5.73	0.51				2	2	4			2		2	Switch	172.72	180.34	155		1		4.27	0.39		0.62	0.41	4	15	74	1	1	8	5		14	Southpaw	177.8	185.42	155	38	34	2	-1	-2	-12	-13	-70	-1	-3		-5.08	-5.08	-4	1.46		-0.62
Joel Alvarez	Drakkar Klose	-425	330	23.5294	330	Sat Dec 14 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Tampa, Florida, USA	USA	Lightweight	MALE	3		4		4.37	0.55		1.58	0.26	4	2	29	1	6	2		9	Orthodox	175.26	177.8	155		2		4.39	0.52	1.2			4	2	15				3	3	6	Orthodox	190.5	195.58	155	31	36		2		3		14		-1	-3	-15.24	-17.78	5	-0.02	-1.2	1.58
Sean Woodson	Fernando Padilla	-155	130	64.5161	130	Sat Dec 14 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Tampa, Florida, USA	USA	Featherweight	MALE	3		1		6.48	0.42	0.8			1	1	5			1	1	2	Orthodox	185.42	193.04	145		5	1	5.58	0.46	0.4	0.66	0.62	3	1	24		2	3	2		7	Orthodox	187.96	198.12	145	32	27		-4	-2	-5		-19		-1	1	-2.54	-5.08	-5	0.9	0.4	-0.66
Miles Johns	Felipe Lima	210	-258	210	38.7597	Sat Dec 14 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Tampa, Florida, USA	USA	Featherweight	MALE	3		1		3.29	0.52	1.3	1.33	0.5	1		3				1	1	Orthodox	167.64	172.72	145		3		3.28	0.47		1.02	0.2	3	2	29		1	4	2		7	Orthodox	170.18	167.64	145	30	26		-2	-2	-6	-2	-26		-2	1	-2.54	5.08	-4	0.01	1.3	0.31


CREATE TABLE upcoming (
  "redfighter" VARCHAR,
  "bluefighter" VARCHAR,
  "redodds" BIGINT,
  "blueodds" BIGINT,
  "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" VARCHAR,
  "bmatchwcrank" DOUBLE,
  "rmatchwcrank" DOUBLE,
  "rwflyweightrank" VARCHAR,
  "rwfeatherweightrank" VARCHAR,
  "rwstrawweightrank" VARCHAR,
  "rwbantamweightrank" VARCHAR,
  "rheavyweightrank" VARCHAR,
  "rlightheavyweightrank" VARCHAR,
  "rmiddleweightrank" VARCHAR,
  "rwelterweightrank" DOUBLE,
  "rlightweightrank" VARCHAR,
  "rfeatherweightrank" VARCHAR,
  "rbantamweightrank" VARCHAR,
  "rflyweightrank" DOUBLE,
  "rpfprank" VARCHAR,
  "bwflyweightrank" VARCHAR,
  "bwfeatherweightrank" VARCHAR,
  "bwstrawweightrank" VARCHAR,
  "bwbantamweightrank" VARCHAR,
  "bheavyweightrank" VARCHAR,
  "blightheavyweightrank" VARCHAR,
  "bmiddleweightrank" VARCHAR
);