Name: Formula 1 Official Data (1950-2022)
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Formula 1 Official Data (1950-2022)

Updates:
Updated until the 2022 end of season.

Formula One is the highest class of international racing for open-wheel single-seater formula racing cars sanctioned by the Fédération Internationale de l'Automobile (FIA). The World Drivers' Championship, which became the FIA Formula One World Championship in 1981, 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.[1] A Formula One season consists of a series of races, known as Grands Prix, which take place worldwide on both purpose-built circuits and closed public roads.

Content:
The dataset includes all race, sprint, qualifying, practice, driver, team, lap data among others for all the championships from 1950 until today.

The following files are included in this dataset:

race_details.csv: Includes detailed race results for all Grand Prix tracks from 1950 until present.
race_summaries.csv: Includes summarized race results for all Grand Prix tracks from 1950 until present.
starting_grids.csv: Includes the starting grids for all Grand Prix tracks from 1950 until present.
sprint_grid.csv: Includes the starting grid for the sprint race on a Saturday. The sprint format was introduced in 2021 for three tracks (Silverstone, Monza and Interlagos). The result of the sprint race decides the starting grid for the main race on Sunday.
sprint_results.csv: Includes sprint race results all for all Grand Prix tracks from 2021 until present.
fastest_laps.csv: Includes fastest lap summaries for all Grand Prix tracks from 1950 until present.
fastestlaps_detailed.csv: Includes fastest lap details for all Grand Prix tracks from 1950 until present.
qualifyings.csv: Includes detailed race results for all Grand Prix tracks from 1950 until present.
practices.csv: Includes FP1/FP2/FP3 results for all Grand Prix tracks from 1986 until present.
pitstops.csv: Includes pitstop details for all Grand Prix tracks from 1994 until present.
team_details.csv: Includes team details for teams that drove from 1958 until present.
constructor_standings.csv: Includes team standings for all Grand Prix tracks from 1958 until present. Team awards have been awarded only since 1958.
driver_standings.csv: Includes driver standings for all Grand Prix tracks from 1950 until present.
driver_details.csv: Includes driver details for all races from 1950 until present.

Inspiration:
Data collation from a big F1 fan.

Source:
Web scraped from the Official F1 website.

Tables

Constructor Standings

@kaggle.debashish311601_formula_1_official_data_19502022.constructor_standings

7.83 kB
675 rows
4 columns

CREATE TABLE constructor_standings (
  "pos" VARCHAR,
  "team" VARCHAR,
  "pts" DOUBLE,
  "year" BIGINT
);

Driver Details

@kaggle.debashish311601_formula_1_official_data_19502022.driver_details

72.85 kB
19,814 rows
7 columns

CREATE TABLE driver_details (
  "car" VARCHAR,
  "date" VARCHAR,
  "driver" VARCHAR,
  "grand_prix" VARCHAR,
  "pts" DOUBLE,
  "race_position" VARCHAR,
  "year" BIGINT
);

Driver Standings

@kaggle.debashish311601_formula_1_official_data_19502022.driver_standings

23.88 kB
1,618 rows
7 columns

CREATE TABLE driver_standings (
  "pos" VARCHAR,
  "driver" VARCHAR,
  "nationality" VARCHAR,
  "car" VARCHAR,
  "pts" DOUBLE,
  "drivercode" VARCHAR,
  "year" BIGINT
);

Fastest Laps

@kaggle.debashish311601_formula_1_official_data_19502022.fastest_laps

20.07 kB
1,078 rows
6 columns

CREATE TABLE fastest_laps (
  "grand_prix" VARCHAR,
  "driver" VARCHAR,
  "car" VARCHAR,
  "time" VARCHAR,
  "drivercode" VARCHAR,
  "year" BIGINT
);

Fastestlaps Detailed

@kaggle.debashish311601_formula_1_official_data_19502022.fastestlaps_detailed

269.98 kB
15,512 rows
12 columns

CREATE TABLE fastestlaps_detailed (
  "avg_speed" DOUBLE,
  "car" VARCHAR,
  "detail" VARCHAR,
  "driver" VARCHAR,
  "drivercode" VARCHAR,
  "grand_prix" VARCHAR,
  "lap" DOUBLE,
  "no" BIGINT,
  "pos" BIGINT,
  "time" VARCHAR,
  "time_of_day" VARCHAR,
  "year" BIGINT
);

Pitstops

@kaggle.debashish311601_formula_1_official_data_19502022.pitstops

436.18 kB
20,293 rows
12 columns

CREATE TABLE pitstops (
  "stops" BIGINT,
  "no" BIGINT,
  "driver" VARCHAR,
  "car" VARCHAR,
  "lap" BIGINT,
  "time_of_day" VARCHAR,
  "time" VARCHAR,
  "total" VARCHAR,
  "year" BIGINT,
  "grand_prix" VARCHAR,
  "detail" VARCHAR,
  "drivercode" VARCHAR
);

Practices

@kaggle.debashish311601_formula_1_official_data_19502022.practices

477.15 kB
37,089 rows
11 columns

CREATE TABLE practices (
  "car" VARCHAR,
  "detail" VARCHAR,
  "driver" VARCHAR,
  "drivercode" VARCHAR,
  "gap" VARCHAR,
  "grand_prix" VARCHAR,
  "laps" DOUBLE,
  "no" BIGINT,
  "pos" BIGINT,
  "time" VARCHAR,
  "year" BIGINT
);

Qualifyings

@kaggle.debashish311601_formula_1_official_data_19502022.qualifyings

258.8 kB
17,236 rows
13 columns

CREATE TABLE qualifyings (
  "car" VARCHAR,
  "detail" VARCHAR,
  "driver" VARCHAR,
  "drivercode" VARCHAR,
  "grand_prix" VARCHAR,
  "laps" DOUBLE,
  "no" BIGINT,
  "pos" VARCHAR,
  "q1" VARCHAR,
  "q2" VARCHAR,
  "q3" VARCHAR,
  "time" VARCHAR,
  "year" BIGINT
);

Race Details

@kaggle.debashish311601_formula_1_official_data_19502022.race_details

223.87 kB
23,978 rows
11 columns

CREATE TABLE race_details (
  "pos" VARCHAR,
  "no" BIGINT,
  "driver" VARCHAR,
  "car" VARCHAR,
  "laps" DOUBLE,
  "time_retired" VARCHAR,
  "pts" DOUBLE,
  "year" BIGINT,
  "grand_prix" VARCHAR,
  "detail" VARCHAR,
  "drivercode" VARCHAR
);

Race Summaries

@kaggle.debashish311601_formula_1_official_data_19502022.race_summaries

31.69 kB
1,082 rows
8 columns

CREATE TABLE race_summaries (
  "grand_prix" VARCHAR,
  "date" VARCHAR,
  "winner" VARCHAR,
  "car" VARCHAR,
  "laps" DOUBLE,
  "time" VARCHAR,
  "winnercode" VARCHAR,
  "year" BIGINT
);

Sprint Grid

@kaggle.debashish311601_formula_1_official_data_19502022.sprint_grid

8.51 kB
120 rows
9 columns

CREATE TABLE sprint_grid (
  "pos" BIGINT,
  "no" BIGINT,
  "driver" VARCHAR,
  "car" VARCHAR,
  "time" VARCHAR,
  "year" BIGINT,
  "grand_prix" VARCHAR,
  "detail" VARCHAR,
  "drivercode" VARCHAR
);

Sprint Results

@kaggle.debashish311601_formula_1_official_data_19502022.sprint_results

9.98 kB
120 rows
11 columns

CREATE TABLE sprint_results (
  "pos" VARCHAR,
  "no" BIGINT,
  "driver" VARCHAR,
  "car" VARCHAR,
  "laps" BIGINT,
  "time_retired" VARCHAR,
  "pts" BIGINT,
  "year" BIGINT,
  "grand_prix" VARCHAR,
  "detail" VARCHAR,
  "drivercode" VARCHAR
);

Starting Grids

@kaggle.debashish311601_formula_1_official_data_19502022.starting_grids

219.9 kB
22,529 rows
9 columns

CREATE TABLE starting_grids (
  "car" VARCHAR,
  "detail" VARCHAR,
  "driver" VARCHAR,
  "drivercode" VARCHAR,
  "grand_prix" VARCHAR,
  "no" BIGINT,
  "pos" BIGINT,
  "time" VARCHAR,
  "year" BIGINT
);

Team Details

@kaggle.debashish311601_formula_1_official_data_19502022.team_details

28.59 kB
10,334 rows
5 columns

CREATE TABLE team_details (
  "grand_prix" VARCHAR,
  "date" VARCHAR,
  "pts" DOUBLE,
  "year" BIGINT,
  "team" VARCHAR
);