Formula 1 Championship Dataset
Championship data from 1950 to 2021
@kaggle.mohammedmaazshaikh_formula_1_championship_dataset
Championship data from 1950 to 2021
@kaggle.mohammedmaazshaikh_formula_1_championship_dataset
Formula 1 Championship Dataset
This dataset contains the championship standings for both drivers and constructors championships from 1950 to 2021. I created this dataset because Formula 1 is my favorite sport and it would be interesting to see the trends that can be found in the data. Some points differences between the World Champions of earlier championships and more recent ones can be seen due to the change in points scoring system in 1950, 1960, 1962, 1991 and 2010.
CREATE TABLE formula1_constructor_2008 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_2009 (
"position" BIGINT,
"constructor" VARCHAR,
"points" DOUBLE
);CREATE TABLE formula1_constructor_2010 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_2011 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_2012 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_2013 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_2014 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_2015 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_2016 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_2017 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_2018 (
"position" VARCHAR,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_2019 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_2020 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_2021 (
"position" BIGINT,
"constructor" VARCHAR,
"points" DOUBLE
);Anyone who has the link will be able to view this.