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

Mexico Driver Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.mexico_driver_performance

5.63 KB
20 rows
6 columns


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

Monaco Constructor Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.monaco_constructor_performance

5.6 KB
10 rows
6 columns


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

Monaco Driver Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.monaco_driver_performance

5.62 KB
20 rows
6 columns


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

Netherands Constructor Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.netherands_constructor_performance

5.58 KB
10 rows
6 columns


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

Netherlands Driver Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.netherlands_driver_performance

5.61 KB
20 rows
6 columns


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

Portugal Constructor Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.portugal_constructor_performance

5.59 KB
10 rows
6 columns


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

Portugal Driver Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.portugal_driver_performance

5.61 KB
20 rows
6 columns


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

Qatar Constructor Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.qatar_constructor_performance

5.59 KB
10 rows
6 columns


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

Qatar Driver Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.qatar_driver_performance

5.61 KB
20 rows
6 columns


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

Russia Constructor Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.russia_constructor_performance

5.6 KB
10 rows
6 columns


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

Russia Driver Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.russia_driver_performance

5.61 KB
20 rows
6 columns


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

Saudiarabia Constructor Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.saudiarabia_constructor_performance

5.5 KB
10 rows
6 columns


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

Saudiarabia Driver Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.saudiarabia_driver_performance

5.6 KB
20 rows
6 columns


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

Spain Constructor Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.spain_constructor_performance

5.6 KB
10 rows
6 columns


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

Spain Driver Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.spain_driver_performance

5.61 KB
20 rows
6 columns


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

Stryria Driver Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.stryria_driver_performance

5.62 KB
20 rows
6 columns


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

Styria Constructor Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.styria_constructor_performance

5.59 KB
10 rows
6 columns


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

Turkey Constructor Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.turkey_constructor_performance

5.7 KB
10 rows
6 columns


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

Turkey Driver Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.turkey_driver_performance

5.7 KB
20 rows
6 columns


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

Usa Constructor Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.usa_constructor_performance

5.51 KB
10 rows
6 columns


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

Usa Driver Performance

@kaggle.prathamsharma123_formula_1_fantasy_2021.usa_driver_performance

5.62 KB
20 rows
6 columns


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