Name: Formula1 Fantasy 2021
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Formula1 Fantasy 2021

Context

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

Content

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.

Tables

Abudhabi Constructor Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.abudhabi_constructor_performance

5.5 KB
10 rows
6 columns


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

Abudhabi Driver Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.abudhabi_driver_performance

5.59 KB
20 rows
6 columns


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

Austria Constructor Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.austria_constructor_performance

5.59 KB
10 rows
6 columns


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

Austria Driver Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.austria_driver_performance

5.62 KB
20 rows
6 columns


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

Azerbaijan Constructor Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.azerbaijan_constructor_performance

5.5 KB
10 rows
6 columns


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

Azerbaijan Driver Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.azerbaijan_driver_performance

5.51 KB
20 rows
6 columns


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

Bahrain Constructor Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.bahrain_constructor_performance

5.58 KB
10 rows
6 columns


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

Bahrain Driver Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.bahrain_driver_performance

5.6 KB
20 rows
6 columns


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

Belgium Constructor Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.belgium_constructor_performance

5.7 KB
10 rows
6 columns


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

Belgium Driver Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.belgium_driver_performance

5.7 KB
20 rows
6 columns


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

Brazil Constructor Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.brazil_constructor_performance

7.35 KB
10 rows
8 columns


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

Brazil Driver Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.brazil_driver_performance

6.39 KB
20 rows
7 columns


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

Britain Constructor Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.britain_constructor_performance

7.35 KB
10 rows
8 columns


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

Britain Driver Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.britain_driver_performance

6.5 KB
20 rows
7 columns


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

Constructor Value

@kaggle.prathamsharma123_formula_1_fantasy_2021.constructor_value

17.4 KB
10 rows
23 columns


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

Driver Value

@kaggle.prathamsharma123_formula_1_fantasy_2021.driver_value

18.76 KB
20 rows
23 columns


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

France Constructor Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.france_constructor_performance

5.6 KB
10 rows
6 columns


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

France Driver Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.france_driver_performance

5.61 KB
20 rows
6 columns


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

Hungary Constructor Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.hungary_constructor_performance

5.39 KB
10 rows
6 columns


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

Hungary Driver Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.hungary_driver_performance

5.5 KB
20 rows
6 columns


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

Imola Constructor Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.imola_constructor_performance

5.51 KB
10 rows
6 columns


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

Imola Driver Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.imola_driver_performance

5.62 KB
20 rows
6 columns


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

Italy Constructor Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.italy_constructor_performance

7.25 KB
10 rows
8 columns


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

Italy Driver Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.italy_driver_performance

6.4 KB
20 rows
7 columns


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

Mexico Constructor Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.mexico_constructor_performance

5.59 KB
10 rows
6 columns


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