Name: Formula 1 Race Data
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

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.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.jtrotman_formula_1_race_data.constructor_results

105.77 kB
12,625 rows
5 columns


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

Constructors

@kaggle.jtrotman_formula_1_race_data.constructors

12.53 kB
212 rows
5 columns


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

Constructor Standings

@kaggle.jtrotman_formula_1_race_data.constructor_standings

137.45 kB
13,391 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

55.2 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

349.1 kB
34,863 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.53 MB
589,081 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

196.96 kB
11,371 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

227.09 kB
10,494 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

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.jtrotman_formula_1_race_data.results

596.69 kB
26,759 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.35 kB
75 rows
2 columns


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

Sprint Results

@kaggle.jtrotman_formula_1_race_data.sprint_results

23.41 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.27 kB
139 rows
2 columns


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