UFC Fight Data

Fight-by-fight list of all UFC fights from 2013

@kaggle.calmdownkarm_ufcdataset

Table List

1 table(2.07 MB)

Data

@kaggle.calmdownkarm_ufcdataset.data

2.07 MB
2318 rows
894 columns
Only the first 100 columns are shown

b_age B Age	b_height B Height	b_hometown B HomeTown	b_id B ID	b_location B Location	b_name B Name	b_weight B Weight
38	193	Hounslow England	808	Amsterdam The Netherlands	Alistair Overeem	120
36	172	Chicago, Illinois United States	1054	Chicago, Illinois United States	Ricardo Lamas	65
39	167	Isla Vista , California USA	959	Sacramento, California USA	Urijah Faber	61
33	167	San Diego, CA USA	1056	San Diego, CA USA	Danny Martinez	56
36	185	Southampton England	2005	Southampton England	Tom Watson	84
35	180	Amazonas Brazil	2101	Rio de Janeiro Brazil	Alan Patrick	70
26	175	Detroit, Michigan United States	2157	Las Vegas, Nevada United States	Kevin Lee	70
33	175	Dagestan Russia	2158	Coconut Creek, Florida United States	Rashid Magomedov	70
36	180	Zinzeli, Astrakhan Oblast Russia	2160	Zinzeli, Astrakhan Oblast Russia	Gasan Umalatov	77
33	162	Dagestan Republic Russia	2084	Dagestan Republic Russia	Ali Bagautinov	56


CREATE TABLE data (
  "bprev" BIGINT,
  "bstreak" BIGINT,
  "b_age" DOUBLE,
  "b_height" DOUBLE,
  "b_hometown" VARCHAR,
  "b_id" BIGINT,
  "b_location" VARCHAR,
  "b_name" VARCHAR,
  "b_weight" DOUBLE,
  "b_round1_grappling_reversals_landed" DOUBLE,
  "b_round1_grappling_standups_landed" DOUBLE,
  "b_round1_grappling_submissions_attempts" DOUBLE,
  "b_round1_grappling_takedowns_attempts" DOUBLE,
  "b_round1_grappling_takedowns_landed" DOUBLE,
  "b_round1_strikes_body_significant_strikes_attempts" DOUBLE,
  "b_round1_strikes_body_significant_strikes_landed" DOUBLE,
  "b_round1_strikes_body_total_strikes_attempts" DOUBLE,
  "b_round1_strikes_body_total_strikes_landed" DOUBLE,
  "b_round1_strikes_clinch_body_strikes_attempts" DOUBLE,
  "b_round1_strikes_clinch_body_strikes_landed" DOUBLE,
  "b_round1_strikes_clinch_head_strikes_attempts" DOUBLE,
  "b_round1_strikes_clinch_head_strikes_landed" DOUBLE,
  "b_round1_strikes_clinch_leg_strikes_attempts" DOUBLE,
  "b_round1_strikes_clinch_leg_strikes_landed" DOUBLE,
  "b_round1_strikes_clinch_significant_kicks_attempts" DOUBLE,
  "b_round1_strikes_clinch_significant_kicks_landed" DOUBLE,
  "b_round1_strikes_clinch_significant_punches_attempts" DOUBLE,
  "b_round1_strikes_clinch_significant_punches_landed" DOUBLE,
  "b_round1_strikes_clinch_significant_strikes_attempts" DOUBLE,
  "b_round1_strikes_clinch_significant_strikes_landed" DOUBLE,
  "b_round1_strikes_clinch_total_strikes_attempts" DOUBLE,
  "b_round1_strikes_clinch_total_strikes_landed" DOUBLE,
  "b_round1_strikes_distance_body_kicks_attempts" DOUBLE,
  "b_round1_strikes_distance_body_kicks_landed" DOUBLE,
  "b_round1_strikes_distance_body_punches_attempts" DOUBLE,
  "b_round1_strikes_distance_body_punches_landed" DOUBLE,
  "b_round1_strikes_distance_body_strikes_attempts" DOUBLE,
  "b_round1_strikes_distance_body_strikes_landed" DOUBLE,
  "b_round1_strikes_distance_head_kicks_attempts" DOUBLE,
  "b_round1_strikes_distance_head_kicks_landed" DOUBLE,
  "b_round1_strikes_distance_head_punches_attempts" DOUBLE,
  "b_round1_strikes_distance_head_punches_landed" DOUBLE,
  "b_round1_strikes_distance_head_strikes_attempts" DOUBLE,
  "b_round1_strikes_distance_head_strikes_landed" DOUBLE,
  "b_round1_strikes_distance_leg_kicks_attempts" DOUBLE,
  "b_round1_strikes_distance_leg_kicks_landed" DOUBLE,
  "b_round1_strikes_distance_leg_strikes_attempts" DOUBLE,
  "b_round1_strikes_distance_leg_strikes_landed" DOUBLE,
  "b_round1_strikes_distance_strikes_attempts" DOUBLE,
  "b_round1_strikes_distance_strikes_landed" DOUBLE,
  "b_round1_strikes_ground_body_strikes_attempts" DOUBLE,
  "b_round1_strikes_ground_body_strikes_landed" DOUBLE,
  "b_round1_strikes_ground_head_strikes_attempts" DOUBLE,
  "b_round1_strikes_ground_head_strikes_landed" DOUBLE,
  "b_round1_strikes_ground_leg_strikes_attempts" DOUBLE,
  "b_round1_strikes_ground_leg_strikes_landed" DOUBLE,
  "b_round1_strikes_ground_significant_kicks_attempts" DOUBLE,
  "b_round1_strikes_ground_significant_kicks_landed" DOUBLE,
  "b_round1_strikes_ground_significant_punches_attempts" DOUBLE,
  "b_round1_strikes_ground_significant_punches_landed" DOUBLE,
  "b_round1_strikes_ground_significant_strikes_attempts" DOUBLE,
  "b_round1_strikes_ground_significant_strikes_landed" DOUBLE,
  "b_round1_strikes_ground_total_strikes_attempts" DOUBLE,
  "b_round1_strikes_ground_total_strikes_landed" DOUBLE,
  "b_round1_strikes_head_significant_strikes_attempts" DOUBLE,
  "b_round1_strikes_head_significant_strikes_landed" DOUBLE,
  "b_round1_strikes_head_total_strikes_attempts" DOUBLE,
  "b_round1_strikes_head_total_strikes_landed" DOUBLE,
  "b_round1_strikes_kicks_attempts" DOUBLE,
  "b_round1_strikes_kicks_landed" DOUBLE,
  "b_round1_strikes_knock_down_landed" DOUBLE,
  "b_round1_strikes_leg_total_strikes_attempts" DOUBLE,
  "b_round1_strikes_leg_total_strikes_landed" DOUBLE,
  "b_round1_strikes_legs_significant_strikes_attempts" DOUBLE,
  "b_round1_strikes_legs_significant_strikes_landed" DOUBLE,
  "b_round1_strikes_legs_total_strikes_attempts" DOUBLE,
  "b_round1_strikes_legs_total_strikes_landed" DOUBLE,
  "b_round1_strikes_punches_attempts" DOUBLE,
  "b_round1_strikes_punches_landed" DOUBLE,
  "b_round1_strikes_significant_strikes_attempts" DOUBLE,
  "b_round1_strikes_significant_strikes_landed" DOUBLE,
  "b_round1_strikes_total_strikes_attempts" DOUBLE,
  "b_round1_strikes_total_strikes_landed" DOUBLE,
  "b_round1_tip_back_control_time" DOUBLE,
  "b_round1_tip_clinch_time" DOUBLE,
  "b_round1_tip_control_time" DOUBLE,
  "b_round1_tip_distance_time" DOUBLE,
  "b_round1_tip_ground_control_time" DOUBLE,
  "b_round1_tip_ground_time" DOUBLE,
  "b_round1_tip_guard_control_time" DOUBLE,
  "b_round1_tip_half_guard_control_time" DOUBLE,
  "b_round1_tip_misc_ground_control_time" DOUBLE,
  "b_round1_tip_mount_control_time" DOUBLE,
  "b_round1_tip_neutral_time" DOUBLE,
  "b_round1_tip_side_control_time" DOUBLE,
  "b_round1_tip_standing_time" DOUBLE,
  "b_round2_grappling_reversals_landed" DOUBLE,
  "b_round2_grappling_standups_landed" DOUBLE,
  "b_round2_grappling_submissions_attempts" DOUBLE,
  "b_round2_grappling_takedowns_attempts" DOUBLE
);