Formula1 Fantasy 2021
Driver and Constructor value for the 2021 F1 fantasy league
@kaggle.prathamsharma123_formula_1_fantasy_2021
Driver and Constructor value for the 2021 F1 fantasy league
@kaggle.prathamsharma123_formula_1_fantasy_2021
The 2021 FIA Formula One World Championship is a planned motor racing championship for Formula One cars which will be the 72nd running of the Formula One World Championship. It is recognized by the Fédération Internationale de l'Automobile (FIA), the governing body of international motorsport, as the highest class of competition for open-wheel racing cars. The championship is due to be contested over twenty-three Grands Prix, which will be held around the world. Drivers and teams are scheduled to compete for the titles of World Drivers' Champion and World Constructors' Champion respectively.
F1 Fantasy allows F1 fans to choose a team consisting of 5 F1 drivers and an F1 constructor, with a maximum spending limit of $100M. Each driver and constructor has a certain value, which changes based on previous performance. Based on performance of drivers and constructors selected in a team, the fan earns points. Fans can create or join leagues to compete with other fans. At the end of the season, the fan with the most number of points earned wins his/her respective league.
For more information on Formula 1: Formula 1 Official Website
For more information of Formula 1 Fantasy: F1 Fantasy Official Website
The dataset includes CSV files for driver values and constructor values. Each file contains the F1 Fantasy value for each driver and constructor, respectively, before the start of each grand prix. Along with these files, constructors' and drivers' performance at each grand prix is also recorded.
CREATE TABLE abudhabi_constructor_performance (
"constructor_name" VARCHAR,
"fantasy_points" BIGINT,
"driver_1_qualifying_position" BIGINT,
"driver_2_qualifying_position" BIGINT,
"driver_1_race_finish" VARCHAR,
"driver_2_race_finish" VARCHAR
);CREATE TABLE abudhabi_driver_performance (
"driver_name" VARCHAR,
"fantasy_points" BIGINT,
"qualifying_position" BIGINT,
"race_finish" VARCHAR,
"fastest_lap" BIGINT,
"finished_ahead_of_teammate" BIGINT
);CREATE TABLE austria_constructor_performance (
"constructor_name" VARCHAR,
"fantasy_points" BIGINT,
"driver_1_qualifying_position" BIGINT,
"driver_2_qualifying_position" BIGINT,
"driver_1_race_finish" BIGINT,
"driver_2_race_finish" VARCHAR
);CREATE TABLE austria_driver_performance (
"driver_name" VARCHAR,
"fantasy_points" BIGINT,
"qualifying_position" BIGINT,
"race_finish" VARCHAR,
"fastest_lap" BIGINT,
"finished_ahead_of_teammate" BIGINT
);CREATE TABLE azerbaijan_constructor_performance (
"constructor_name" VARCHAR,
"fantasy_points" BIGINT,
"driver_1_qualifying_position" BIGINT,
"driver_2_qualifying_position" VARCHAR,
"driver_1_race_finish" BIGINT,
"driver_2_race_finish" VARCHAR
);CREATE TABLE azerbaijan_driver_performance (
"driver_name" VARCHAR,
"fantasy_points" BIGINT,
"qualifying_position" VARCHAR,
"race_finish" VARCHAR,
"fastest_lap" BIGINT,
"finished_ahead_of_teammate" BIGINT
);CREATE TABLE bahrain_constructor_performance (
"constructor_name" VARCHAR,
"fantasy_points" BIGINT,
"driver_1_qualifying_position" BIGINT,
"driver_2_qualifying_position" BIGINT,
"driver_1_race_finish" BIGINT,
"driver_2_race_finish" VARCHAR
);CREATE TABLE bahrain_driver_performance (
"driver_name" VARCHAR,
"fantasy_points" BIGINT,
"qualifying_position" BIGINT,
"race_finish" VARCHAR,
"fastest_lap" BIGINT,
"finished_ahead_of_teammate" BIGINT
);CREATE TABLE belgium_constructor_performance (
"constructor_name" VARCHAR,
"fantasy_points" BIGINT,
"driver_1_qualifying_position" BIGINT,
"driver_2_qualifying_position" BIGINT,
"driver_1_race_finish" BIGINT,
"driver_2_race_finish" BIGINT
);CREATE TABLE belgium_driver_performance (
"driver_name" VARCHAR,
"fantasy_points" BIGINT,
"qualifying_position" BIGINT,
"race_finish" BIGINT,
"fastest_lap" BIGINT,
"finished_ahead_of_teammate" BIGINT
);CREATE TABLE brazil_constructor_performance (
"constructor_name" VARCHAR,
"fantasy_points" BIGINT,
"driver_1_qualifying_position" BIGINT,
"driver_2_qualifying_position" VARCHAR,
"driver_1_sprint_qualifying_position" BIGINT,
"driver_2_sprint_qualifying_position" BIGINT,
"driver_1_race_finish" BIGINT,
"driver_2_race_finish" VARCHAR
);CREATE TABLE brazil_driver_performance (
"driver_name" VARCHAR,
"fantasy_points" BIGINT,
"qualifying_position" VARCHAR,
"sprint_qualifying_position" BIGINT,
"race_finish" VARCHAR,
"fastest_lap" BIGINT,
"finished_ahead_of_teammate" BIGINT
);CREATE TABLE britain_constructor_performance (
"constructor_name" VARCHAR,
"fantasy_points" BIGINT,
"driver_1_qualifying_position" BIGINT,
"driver_2_qualifying_position" BIGINT,
"driver_1_sprint_qualifying_position" BIGINT,
"driver_2_sprint_qualifying_position" VARCHAR,
"driver_1_race_finish" BIGINT,
"driver_2_race_finish" VARCHAR
);CREATE TABLE britain_driver_performance (
"driver_name" VARCHAR,
"fantasy_points" BIGINT,
"qualifying_position" BIGINT,
"sprint_qualifying_position" BIGINT,
"race_finish" VARCHAR,
"fastest_lap" BIGINT,
"finished_ahead_of_teammate" BIGINT
);CREATE TABLE constructor_value (
"constructor_name" VARCHAR,
"bahrain_gp" DOUBLE,
"imola_gp" DOUBLE,
"portugal_gp" DOUBLE,
"spain_gp" DOUBLE,
"monaco_gp" DOUBLE,
"azerbaijan_gp" DOUBLE,
"french_gp" DOUBLE,
"styrian_gp" DOUBLE,
"austrian_gp" DOUBLE,
"british_gp" DOUBLE,
"hungarian_gp" DOUBLE,
"belgian_gp" DOUBLE,
"dutch_gp" DOUBLE,
"italian_gp" DOUBLE,
"russian_gp" DOUBLE,
"turkish_gp" DOUBLE,
"usa_gp" DOUBLE,
"mexican_gp" DOUBLE,
"brazilian_gp" DOUBLE,
"qatar_gp" DOUBLE,
"saudi_arabian_gp" DOUBLE,
"abu_dhabi_gp" DOUBLE
);CREATE TABLE driver_value (
"driver_name" VARCHAR,
"bahrain_gp" DOUBLE,
"imola_gp" DOUBLE,
"portugal_gp" DOUBLE,
"spain_gp" DOUBLE,
"monaco_gp" DOUBLE,
"azerbaijan_gp" DOUBLE,
"french_gp" DOUBLE,
"styrian_gp" DOUBLE,
"austrian_gp" DOUBLE,
"british_gp" DOUBLE,
"hungarian_gp" DOUBLE,
"belgian_gp" DOUBLE,
"dutch_gp" DOUBLE,
"italian_gp" DOUBLE,
"russian_gp" DOUBLE,
"turkish_gp" DOUBLE,
"usa_gp" DOUBLE,
"mexican_gp" DOUBLE,
"brazilian_gp" DOUBLE,
"qatar_gp" DOUBLE,
"saudi_arabian_gp" DOUBLE,
"abu_dhabi_gp" DOUBLE
);CREATE TABLE france_constructor_performance (
"constructor_name" VARCHAR,
"fantasy_points" BIGINT,
"driver_1_qualifying_position" BIGINT,
"driver_2_qualifying_position" VARCHAR,
"driver_1_race_finish" BIGINT,
"driver_2_race_finish" BIGINT
);CREATE TABLE france_driver_performance (
"driver_name" VARCHAR,
"fantasy_points" BIGINT,
"qualifying_position" VARCHAR,
"race_finish" BIGINT,
"fastest_lap" BIGINT,
"finished_ahead_of_teammate" BIGINT
);CREATE TABLE hungary_constructor_performance (
"constructor_name" VARCHAR,
"fantasy_points" BIGINT,
"driver_1_qualifying_position" BIGINT,
"driver_2_qualifying_position" VARCHAR,
"driver_1_race_finish" VARCHAR,
"driver_2_race_finish" VARCHAR
);CREATE TABLE hungary_driver_performance (
"driver_name" VARCHAR,
"fantasy_points" BIGINT,
"qualifying_position" VARCHAR,
"race_finish" VARCHAR,
"fastest_lap" BIGINT,
"finished_ahead_of_teammate" BIGINT
);CREATE TABLE imola_constructor_performance (
"constructor_name" VARCHAR,
"fantasy_points" BIGINT,
"driver_1_qualifying_position" BIGINT,
"driver_2_qualifying_position" BIGINT,
"driver_1_race_finish" VARCHAR,
"driver_2_race_finish" VARCHAR
);CREATE TABLE imola_driver_performance (
"driver_name" VARCHAR,
"fantasy_points" BIGINT,
"qualifying_position" BIGINT,
"race_finish" VARCHAR,
"fastest_lap" BIGINT,
"finished_ahead_of_teammate" BIGINT
);CREATE TABLE italy_constructor_performance (
"constructor_name" VARCHAR,
"fantasy_points" BIGINT,
"driver_1_qualifying_position" BIGINT,
"driver_2_qualifying_position" BIGINT,
"driver_1_sprint_qualifying_position" BIGINT,
"driver_2_sprint_qualifying_position" VARCHAR,
"driver_1_race_finish" VARCHAR,
"driver_2_race_finish" VARCHAR
);CREATE TABLE italy_driver_performance (
"driver_name" VARCHAR,
"fantasy_points" BIGINT,
"qualifying_position" BIGINT,
"sprint_qualifying_position" VARCHAR,
"race_finish" VARCHAR,
"fastest_lap" BIGINT,
"finished_ahead_of_teammate" BIGINT
);CREATE TABLE mexico_constructor_performance (
"constructor_name" VARCHAR,
"fantasy_points" BIGINT,
"driver_1_qualifying_position" BIGINT,
"driver_2_qualifying_position" BIGINT,
"driver_1_race_finish" BIGINT,
"driver_2_race_finish" VARCHAR
);CREATE TABLE mexico_driver_performance (
"driver_name" VARCHAR,
"fantasy_points" BIGINT,
"qualifying_position" BIGINT,
"race_finish" VARCHAR,
"fastest_lap" BIGINT,
"finished_ahead_of_teammate" BIGINT
);CREATE TABLE monaco_constructor_performance (
"constructor_name" VARCHAR,
"fantasy_points" BIGINT,
"driver_1_qualifying_position" BIGINT,
"driver_2_qualifying_position" BIGINT,
"driver_1_race_finish" BIGINT,
"driver_2_race_finish" VARCHAR
);CREATE TABLE monaco_driver_performance (
"driver_name" VARCHAR,
"fantasy_points" BIGINT,
"qualifying_position" BIGINT,
"race_finish" VARCHAR,
"fastest_lap" BIGINT,
"finished_ahead_of_teammate" BIGINT
);CREATE TABLE netherands_constructor_performance (
"constructor_name" VARCHAR,
"fantasy_points" BIGINT,
"driver_1_qualifying_position" BIGINT,
"driver_2_qualifying_position" BIGINT,
"driver_1_race_finish" BIGINT,
"driver_2_race_finish" VARCHAR
);CREATE TABLE netherlands_driver_performance (
"driver_name" VARCHAR,
"fantasy_points" BIGINT,
"qualifying_position" BIGINT,
"race_finish" VARCHAR,
"fastest_lap" BIGINT,
"finished_ahead_of_teammate" BIGINT
);CREATE TABLE portugal_constructor_performance (
"constructor_name" VARCHAR,
"fantasy_points" BIGINT,
"driver_1_qualifying_position" BIGINT,
"driver_2_qualifying_position" BIGINT,
"driver_1_race_finish" BIGINT,
"driver_2_race_finish" VARCHAR
);CREATE TABLE portugal_driver_performance (
"driver_name" VARCHAR,
"fantasy_points" BIGINT,
"qualifying_position" BIGINT,
"race_finish" VARCHAR,
"fastest_lap" BIGINT,
"finished_ahead_of_teammate" BIGINT
);CREATE TABLE qatar_constructor_performance (
"constructor_name" VARCHAR,
"fantasy_points" BIGINT,
"driver_1_qualifying_position" BIGINT,
"driver_2_qualifying_position" BIGINT,
"driver_1_race_finish" BIGINT,
"driver_2_race_finish" VARCHAR
);CREATE TABLE qatar_driver_performance (
"driver_name" VARCHAR,
"fantasy_points" BIGINT,
"qualifying_position" BIGINT,
"race_finish" VARCHAR,
"fastest_lap" BIGINT,
"finished_ahead_of_teammate" BIGINT
);CREATE TABLE russia_constructor_performance (
"constructor_name" VARCHAR,
"fantasy_points" BIGINT,
"driver_1_qualifying_position" BIGINT,
"driver_2_qualifying_position" BIGINT,
"driver_1_race_finish" BIGINT,
"driver_2_race_finish" VARCHAR
);CREATE TABLE russia_driver_performance (
"driver_name" VARCHAR,
"fantasy_points" BIGINT,
"qualifying_position" BIGINT,
"race_finish" VARCHAR,
"fastest_lap" BIGINT,
"finished_ahead_of_teammate" BIGINT
);CREATE TABLE saudiarabia_constructor_performance (
"constructor_name" VARCHAR,
"fantasy_points" BIGINT,
"driver_1_qualifying_position" BIGINT,
"driver_2_qualifying_position" BIGINT,
"driver_1_race_finish" VARCHAR,
"driver_2_race_finish" VARCHAR
);CREATE TABLE saudiarabia_driver_performance (
"driver_name" VARCHAR,
"fantasy_points" BIGINT,
"qualifying_position" BIGINT,
"race_finish" VARCHAR,
"fastest_lap" BIGINT,
"finished_ahead_of_teammate" BIGINT
);CREATE TABLE spain_constructor_performance (
"constructor_name" VARCHAR,
"fantasy_points" BIGINT,
"driver_1_qualifying_position" BIGINT,
"driver_2_qualifying_position" BIGINT,
"driver_1_race_finish" BIGINT,
"driver_2_race_finish" VARCHAR
);CREATE TABLE spain_driver_performance (
"driver_name" VARCHAR,
"fantasy_points" BIGINT,
"qualifying_position" BIGINT,
"race_finish" VARCHAR,
"fastest_lap" BIGINT,
"finished_ahead_of_teammate" BIGINT
);CREATE TABLE stryria_driver_performance (
"driver_name" VARCHAR,
"fantasy_points" BIGINT,
"qualifying_position" BIGINT,
"race_finish" VARCHAR,
"fastest_lap" BIGINT,
"finished_ahead_of_teammate" BIGINT
);CREATE TABLE styria_constructor_performance (
"constructor_name" VARCHAR,
"fantasy_points" BIGINT,
"driver_1_qualifying_position" BIGINT,
"driver_2_qualifying_position" BIGINT,
"driver_1_race_finish" BIGINT,
"driver_2_race_finish" VARCHAR
);CREATE TABLE turkey_constructor_performance (
"constructor_name" VARCHAR,
"fantasy_points" BIGINT,
"driver_1_qualifying_position" BIGINT,
"driver_2_qualifying_position" BIGINT,
"driver_1_race_finish" BIGINT,
"driver_2_race_finish" BIGINT
);CREATE TABLE turkey_driver_performance (
"driver_name" VARCHAR,
"fantasy_points" BIGINT,
"qualifying_position" BIGINT,
"race_finish" BIGINT,
"fastest_lap" BIGINT,
"finished_ahead_of_teammate" BIGINT
);CREATE TABLE usa_constructor_performance (
"constructor_name" VARCHAR,
"fantasy_points" BIGINT,
"driver_1_qualifying_position" BIGINT,
"driver_2_qualifying_position" BIGINT,
"driver_1_race_finish" VARCHAR,
"driver_2_race_finish" VARCHAR
);CREATE TABLE usa_driver_performance (
"driver_name" VARCHAR,
"fantasy_points" BIGINT,
"qualifying_position" BIGINT,
"race_finish" VARCHAR,
"fastest_lap" BIGINT,
"finished_ahead_of_teammate" BIGINT
);Anyone who has the link will be able to view this.