Name: Ultimate UFC Dataset
Creator: Kaggle
License: https://creativecommons.org/licenses/by/4.0/

About this Dataset

Ultimate UFC Dataset

Updates:

2024-11-16:

We now have a upcoming.csv file that will have the upcoming event with odds to train predictions on

2024-11-01:

Past Events are caught up!

2024-09-07:

Updated through 2023

2024-08-28:

I will up updating the files here on github now too: https://github.com/shortlikeafox/ultimate_ufc_dataset
the empty_arena column will be removed soon

Project Title

Tiger Millionaire - UFC Fight Predictor

Full Documentation in the Wiki

Description

The goal of this project is to maintain the most complete UFC database that includes the following data sources:

ufcstats.com - (bout and fighter statistics)
bestfightodds.com - (odds)
kaggle.com/martj42/ufc-rankings - (ufc rankings)

Getting Started

Start with the Wiki

Or go join a contest....

Contest

For every UFC event there will be a betting contest where users can train models to predict profitable bets (or just manually pick!). More details here: UFC Contest

Authors

Matt Dabbert
On GitHub

Acknowledgments

Inspiration, code snippets, etc.

Rajeev Warrier's UFC Dataset

Tables

Ufc Master

@kaggle.mdabbert_ultimate_ufc_dataset.ufc_master

641.91 KB
6528 rows
118 columns


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

Upcoming

@kaggle.mdabbert_ultimate_ufc_dataset.upcoming

81.92 KB
13 rows
118 columns


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