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
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.