Dataset: Formula 1 Official Data (1950-2022)

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

71.14 KB
19814 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.32 KB
1618 rows
7 columns


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

Fastestlaps Detailed

@kaggle.debashish311601_formula_1_official_data_19502022.fastestlaps_detailed

263.65 KB
15512 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
);

Fastest Laps

@kaggle.debashish311601_formula_1_official_data_19502022.fastest_laps

19.6 KB
1078 rows
6 columns


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

Pitstops

@kaggle.debashish311601_formula_1_official_data_19502022.pitstops

425.96 KB
20293 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

465.97 KB
37089 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

252.73 KB
17236 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

218.63 KB
23978 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

30.95 KB
1082 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.31 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.74 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

214.75 KB
22529 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

27.92 KB
10334 rows
5 columns


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