FIE Fencing Womens Foil Data
Pools Results and Fencer Rankings/Bio Data for Women's Foil Athletes
@kaggle.amichaelsen_fie_fencing_womens_foil_data
Pools Results and Fencer Rankings/Bio Data for Women's Foil Athletes
@kaggle.amichaelsen_fie_fencing_womens_foil_data
The International Fencing Federation (FIE) is recognized by the International Olympic Committee (IOC) as the world governing body of fencing, as such is charged with establishing the rules and implementation for international competition. It also maintains a website where it posts many international tournament results for sport fencing over the years. In addition, it has fencer bio pages for each athlete which stores biographical data.
Within a fencing tournament, there are two phases: pools and direct elimination. During pools, fencers are split into groups of 5-7 and fence a round robin (each person fences every other person in their pool) of short bouts to 5 points. The results from these pools are then tabulated to form a ranking going into the direct elimination round (DEs), where fencers face off in an elimination bracket and fencer longer matches to 15 points.
Strategies for pools and DEs vary and as such results from one cannot be directly applied to the other. However of the two, pools generates a larger amount of data (21 bouts versus 6 for 7 fencers).
You can read more about the raw data collection here and the initial data cleaning here.
The data contains pool results from almost 50,000 bouts from 218 tournaments in Women's Foil from January 2014 to May 2021. Alongside this is biographical data and historical rankings data for the 2,108 fencers appearing in these bouts.
Some possible questions that could be explored with this data are:
CREATE TABLE all_womens_foil_bout_data_may_13_2021_cleaned (
"fencer_id" BIGINT,
"opp_id" BIGINT,
"fencer_age" BIGINT,
"opp_age" BIGINT,
"fencer_score" BIGINT,
"opp_score" BIGINT,
"winner_id" BIGINT,
"fencer_curr_pts" DOUBLE,
"opp_curr_pts" DOUBLE,
"tournament_id" VARCHAR,
"pool_id" BIGINT,
"upset" BOOLEAN,
"date" TIMESTAMP
);
CREATE TABLE all_womens_foil_fencer_bio_data_may_13_2021_cleaned (
"id" BIGINT,
"name" VARCHAR,
"country_code" VARCHAR,
"country" VARCHAR,
"hand" VARCHAR,
"age" BIGINT,
"url" VARCHAR,
"date_accessed" TIMESTAMP
);
CREATE TABLE all_womens_foil_fencer_rankings_data_may_13_2021_cleaned (
"id" BIGINT,
"weapon" VARCHAR,
"category" VARCHAR,
"season" VARCHAR,
"rank" BIGINT,
"points" DOUBLE
);
CREATE TABLE all_womens_foil_tournament_data_may_13_2021_cleaned (
"competition_id" BIGINT,
"season" BIGINT,
"name" VARCHAR,
"category" VARCHAR,
"country" VARCHAR,
"start_date" TIMESTAMP,
"end_date" TIMESTAMP,
"weapon" VARCHAR,
"gender" VARCHAR,
"timezone" VARCHAR,
"url" VARCHAR,
"unique_id" VARCHAR,
"missing_results_flag" VARCHAR
);
Anyone who has the link will be able to view this.