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

102.34 KB
12505 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.23 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

133.01 KB
13271 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

53.8 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

338.25 KB
34595 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.3 MB
575029 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

185.75 KB
10990 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

216.64 KB
10254 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

43.64 KB
1125 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

574.55 KB
26519 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.27 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.03 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.17 KB
139 rows
2 columns


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