Name: Formula 1 World Championship (1950 - 2024)
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Formula 1 World Championship (1950 - 2024)

Context

Formula 1 (a.k.a. F1 or Formula One) is the highest class of single-seater auto racing sanctioned by the Fédération Internationale de l'Automobile (FIA) and owned by the Formula One Group. The FIA Formula One World Championship has been one of the premier forms of racing around the world since its inaugural season in 1950. The word "formula" in the name refers to the set of rules to which all participants' cars must conform. A Formula One season consists of a series of races, known as Grands Prix, which take place worldwide on purpose-built circuits and on public roads.

Content

The dataset consists of all information on the Formula 1 races, drivers, constructors, qualifying, circuits, lap times, pit stops, championships from 1950 till the latest 2024 season.

Acknowledgements

The data is compiled from http://ergast.com/mrd/

Inspiration

"Races are won at the track. Championships are won at the factory." - Mercedes (2019)

With the amount of data being captured, analyzed and used to design, build and drive the Formula 1 cars is astounding. It is a global sport being followed by millions of people worldwide and it is very fascinating to see drivers pushing their limit in these vehicles to become the fastest racers in the world!

Tables

Circuits

@kaggle.rohanrao_formula_1_world_championship_1950_2020.circuits

13.73 kB
77 rows
9 columns

CREATE TABLE circuits (
  "circuitid" BIGINT,
  "circuitref" VARCHAR,
  "name" VARCHAR,
  "location" VARCHAR,
  "country" VARCHAR,
  "lat" DOUBLE,
  "lng" DOUBLE,
  "alt" BIGINT,
  "url" VARCHAR
);

Constructor Results

@kaggle.rohanrao_formula_1_world_championship_1950_2020.constructor_results

104.79 kB
12,505 rows
5 columns

CREATE TABLE constructor_results (
  "constructorresultsid" BIGINT,
  "raceid" BIGINT,
  "constructorid" BIGINT,
  "points" DOUBLE,
  "status" VARCHAR
);

Constructors

@kaggle.rohanrao_formula_1_world_championship_1950_2020.constructors

12.53 kB
212 rows
5 columns

CREATE TABLE constructors (
  "constructorid" BIGINT,
  "constructorref" VARCHAR,
  "name" VARCHAR,
  "nationality" VARCHAR,
  "url" VARCHAR
);

Constructor Standings

@kaggle.rohanrao_formula_1_world_championship_1950_2020.constructor_standings

136.2 kB
13,271 rows
7 columns

CREATE TABLE constructor_standings (
  "constructorstandingsid" BIGINT,
  "raceid" BIGINT,
  "constructorid" BIGINT,
  "points" DOUBLE,
  "position" BIGINT,
  "positiontext" VARCHAR,
  "wins" BIGINT
);

Drivers

@kaggle.rohanrao_formula_1_world_championship_1950_2020.drivers

55.09 kB
859 rows
9 columns

CREATE TABLE drivers (
  "driverid" BIGINT,
  "driverref" VARCHAR,
  "number" VARCHAR,
  "code" VARCHAR,
  "forename" VARCHAR,
  "surname" VARCHAR,
  "dob" TIMESTAMP,
  "nationality" VARCHAR,
  "url" VARCHAR
);

Driver Standings

@kaggle.rohanrao_formula_1_world_championship_1950_2020.driver_standings

346.37 kB
34,595 rows
7 columns

CREATE TABLE driver_standings (
  "driverstandingsid" BIGINT,
  "raceid" BIGINT,
  "driverid" BIGINT,
  "points" DOUBLE,
  "position" BIGINT,
  "positiontext" VARCHAR,
  "wins" BIGINT
);

Lap Times

@kaggle.rohanrao_formula_1_world_championship_1950_2020.lap_times

3.46 MB
575,029 rows
6 columns

CREATE TABLE lap_times (
  "raceid" BIGINT,
  "driverid" BIGINT,
  "lap" BIGINT,
  "position" BIGINT,
  "time" VARCHAR,
  "milliseconds" BIGINT
);

Pit Stops

@kaggle.rohanrao_formula_1_world_championship_1950_2020.pit_stops

190.21 kB
10,990 rows
7 columns

CREATE TABLE pit_stops (
  "raceid" BIGINT,
  "driverid" BIGINT,
  "stop" BIGINT,
  "lap" BIGINT,
  "time" VARCHAR,
  "duration" VARCHAR,
  "milliseconds" BIGINT
);

Qualifying

@kaggle.rohanrao_formula_1_world_championship_1950_2020.qualifying

221.84 kB
10,254 rows
9 columns

CREATE TABLE qualifying (
  "qualifyid" BIGINT,
  "raceid" BIGINT,
  "driverid" BIGINT,
  "constructorid" BIGINT,
  "number" BIGINT,
  "position" BIGINT,
  "q1" VARCHAR,
  "q2" VARCHAR,
  "q3" VARCHAR
);

Races

@kaggle.rohanrao_formula_1_world_championship_1950_2020.races

44.69 kB
1,125 rows
18 columns

CREATE TABLE races (
  "raceid" BIGINT,
  "year" BIGINT,
  "round" BIGINT,
  "circuitid" BIGINT,
  "name" VARCHAR,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "url" VARCHAR,
  "fp1_date" VARCHAR,
  "fp1_time" VARCHAR,
  "fp2_date" VARCHAR,
  "fp2_time" VARCHAR,
  "fp3_date" VARCHAR,
  "fp3_time" VARCHAR,
  "quali_date" VARCHAR,
  "quali_time" VARCHAR,
  "sprint_date" VARCHAR,
  "sprint_time" VARCHAR
);

Results

@kaggle.rohanrao_formula_1_world_championship_1950_2020.results

588.34 kB
26,519 rows
18 columns

CREATE TABLE results (
  "resultid" BIGINT,
  "raceid" BIGINT,
  "driverid" BIGINT,
  "constructorid" BIGINT,
  "number" VARCHAR,
  "grid" BIGINT,
  "position" VARCHAR,
  "positiontext" VARCHAR,
  "positionorder" BIGINT,
  "points" DOUBLE,
  "laps" BIGINT,
  "time" VARCHAR,
  "milliseconds" VARCHAR,
  "fastestlap" VARCHAR,
  "rank" VARCHAR,
  "fastestlaptime" VARCHAR,
  "fastestlapspeed" VARCHAR,
  "statusid" BIGINT
);

Seasons

@kaggle.rohanrao_formula_1_world_championship_1950_2020.seasons

3.35 kB
75 rows
2 columns

CREATE TABLE seasons (
  "year" BIGINT,
  "url" VARCHAR
);

Sprint Results

@kaggle.rohanrao_formula_1_world_championship_1950_2020.sprint_results

21.54 kB
300 rows
16 columns

CREATE TABLE sprint_results (
  "resultid" BIGINT,
  "raceid" BIGINT,
  "driverid" BIGINT,
  "constructorid" BIGINT,
  "number" BIGINT,
  "grid" BIGINT,
  "position" VARCHAR,
  "positiontext" VARCHAR,
  "positionorder" BIGINT,
  "points" BIGINT,
  "laps" BIGINT,
  "time" VARCHAR,
  "milliseconds" VARCHAR,
  "fastestlap" VARCHAR,
  "fastestlaptime" VARCHAR,
  "statusid" BIGINT
);

Status

@kaggle.rohanrao_formula_1_world_championship_1950_2020.status

4.27 kB
139 rows
2 columns

CREATE TABLE status (
  "statusid" BIGINT,
  "status" VARCHAR
);