Dataset: Formula 1 Race Data

About this Dataset

Formula 1 Race Data

Context

Formula One (also Formula 1 or F1 and officially the FIA Formula One World Championship) is the highest class of single-seat auto racing that is sanctioned by the Fédération Internationale de l'Automobile (FIA). The FIA Formula One World Championship has been one of the premier forms of racing around the world since its inaugural season in 1950.

Content

This dataset contains data from 1950 all the way through the 2024 season, and consists of tables describing constructors, race drivers, lap times, pit stops and more.

Acknowledgements

The data is downloaded from http://ergast.com/mrd/ and refreshed after each Grand Prix weekend. The data was originally gathered and published to the public domain by Chris Newell.

Tables

Circuits

@kaggle.jtrotman_formula_1_race_data.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
);

Constructors

@kaggle.jtrotman_formula_1_race_data.constructors

12.23 KB
212 rows
5 columns


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

Constructor Results

@kaggle.jtrotman_formula_1_race_data.constructor_results

103.29 KB
12625 rows
5 columns


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

Constructor Standings

@kaggle.jtrotman_formula_1_race_data.constructor_standings

134.23 KB
13391 rows
7 columns


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

Drivers

@kaggle.jtrotman_formula_1_race_data.drivers

53.9 KB
861 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.jtrotman_formula_1_race_data.driver_standings

340.92 KB
34863 rows
7 columns


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

Lap Times

@kaggle.jtrotman_formula_1_race_data.lap_times

3.37 MB
589081 rows
6 columns


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

Pit Stops

@kaggle.jtrotman_formula_1_race_data.pit_stops

192.34 KB
11371 rows
7 columns


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

Qualifying

@kaggle.jtrotman_formula_1_race_data.qualifying

221.77 KB
10494 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.jtrotman_formula_1_race_data.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.jtrotman_formula_1_race_data.results

582.7 KB
26759 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.jtrotman_formula_1_race_data.seasons

3.27 KB
75 rows
2 columns


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

Sprint Results

@kaggle.jtrotman_formula_1_race_data.sprint_results

22.86 KB
360 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.jtrotman_formula_1_race_data.status

4.17 KB
139 rows
2 columns


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