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_1958 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1959 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1960 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1961 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1962 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1963 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1964 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1965 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1966 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1967 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1968 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1969 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1970 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1971 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1972 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1973 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1974 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1975 (
"position" BIGINT,
"constructor" VARCHAR,
"points" DOUBLE
);CREATE TABLE formula1_constructor_1976 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1977 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1978 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1979 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1980 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1981 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1982 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);Anyone who has the link will be able to view this.