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_1983 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1984 (
"position" BIGINT,
"constructor" VARCHAR,
"points" DOUBLE
);CREATE TABLE formula1_constructor_1985 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1986 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1987 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1988 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1989 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1990 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1991 (
"position" BIGINT,
"constructor" VARCHAR,
"points" DOUBLE
);CREATE TABLE formula1_constructor_1992 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1993 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1994 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1995 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1996 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1997 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1998 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_1999 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_2000 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_2001 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_2002 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_2003 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_2004 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_2005 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_2006 (
"position" BIGINT,
"constructor" VARCHAR,
"points" BIGINT
);CREATE TABLE formula1_constructor_2007 (
"position" VARCHAR,
"constructor" VARCHAR,
"points" BIGINT
);Anyone who has the link will be able to view this.