Dataset: Formula 1 World Championship History (1950-2024)

About this Dataset

Formula 1 World Championship History (1950-2024)

The Formula 1 World Championship History (1950-2024) dataset offers a comprehensive exploration of Formula 1 racing, spanning over seven decades of competition. This dataset is designed to be a valuable resource for those interested in the evolution of Formula 1, covering every aspect of the sport from its inception in 1950 through the latest 2024 season.

Context

Formula 1, also known as F1, represents the pinnacle of single-seater auto racing. Governed by the Fédération Internationale de l'Automobile (FIA), it has grown into a globally recognized sport, drawing millions of fans around the world. The sport is known for its high-speed races, strategic depth, and the relentless pursuit of excellence both on the track and in the design and engineering of the cars.

This dataset captures the rich history of Formula 1 by providing detailed information on races, drivers, constructors (teams), circuits, and more. Whether you're a motorsport enthusiast, data analyst, or historian, this dataset is an excellent tool for deep diving into the data and uncovering insights about the sport.

Contents of the Dataset

The dataset is organized into multiple CSV files, each offering detailed data on different aspects of Formula 1:

Track_Information.csv: Contains details about the circuits where races have been held, including their location, length, and unique characteristics.
Team_Details.csv: Provides information about the constructors, including their history, achievements, and performance across different seasons.
Constructor_Performance.csv: Details the performance of constructors in individual races, showing how teams have evolved over the years.
Constructor_Rankings.csv: Offers annual standings of constructors, highlighting the competitive dynamics within the sport.
Driver_Details.csv: Includes comprehensive information about the drivers, such as their personal details, career statistics, and achievements.
Driver_Rankings.csv: Displays the yearly standings of drivers, showcasing who topped the charts and how tight the championship battles were.
Race_Schedule.csv: Lists all the races held from 1950 to 2024, along with details such as the date, location, and race name.
Race_Results.csv: Provides detailed results of each race, including finishing positions, points earned, and other key metrics.
Lap_Timings.csv: Contains data on lap times recorded by drivers during races, giving insights into their performance consistency.
Pit_Stop_Records.csv: Offers information on pit stops made during races, including timing and strategy, which often impact the outcome of the race.
Qualifying_Results.csv: Details the results of qualifying sessions, which determine the starting grid for each race.
Sprint_Race_Results.csv: Includes data on sprint races, shorter races introduced to decide starting positions for the main race.
Season_Summaries.csv: Summarizes each season, including the number of races, champions, and key moments.
Race_Status.csv: Contains codes and descriptions related to the status of cars during a race, such as if a car finished, retired, or was disqualified.

Data Source

The dataset is sourced from the Ergast Motor Racing Data API, a trusted and frequently updated source for Formula 1 data. The API has been reliably providing data over the years, ensuring the dataset is accurate and up-to-date. Each file in this dataset has been carefully compiled to offer a thorough overview of Formula 1’s history, making it an essential resource for anyone interested in the sport.

Potential Use Cases

This dataset is versatile and can be used for a wide range of applications, including:

Historical Analysis: Study the changes and trends in Formula 1 over the years, including the evolution of teams, drivers, and circuits.
Performance Trends: Analyze trends in driver and constructor performances, and identify key factors contributing to success in Formula 1.
Race Strategy Insights: Investigate the impact of different strategies, such as pit stops and qualifying positions, on race outcomes and championships.
Data Visualization: Create compelling visualizations to illustrate the history and key events in Formula 1, such as championship rivalries, race victories, and more.
Fan Engagement: Engage with Formula 1 fans by providing them with in-depth data-driven insights about their favorite teams, drivers, and races.

The Formula 1 World Championship History (1950-2024) dataset is a rich and detailed resource that offers extensive insights into one of the world’s most popular motorsports. Whether you are looking to conduct in-depth analysis, create visualizations, or simply explore the history of Formula 1, this dataset is an excellent starting point.

Acknowledgements:

This dataset is also available on Kaggle, thanks to the contributions of Vopani: Formula 1 World Championship History (1950-2020). The purpose of sharing this dataset is to contribute to the understanding and analysis of Formula 1 racing history.

This dataset would not be possible without the efforts of Vopani, who has meticulously gathered and maintained Formula 1 data. Special thanks go to Vopani for their work on compiling the dataset, which provides a comprehensive overview of Formula 1 history.

Tables

Constructor Performance

@kaggle.muhammadehsan02_formula_1_world_championship_history_1950_2024.constructor_performance

102.34 KB
12505 rows
5 columns


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

Constructor Rankings

@kaggle.muhammadehsan02_formula_1_world_championship_history_1950_2024.constructor_rankings

133.01 KB
13271 rows
7 columns


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

Driver Details

@kaggle.muhammadehsan02_formula_1_world_championship_history_1950_2024.driver_details

53.8 KB
859 rows
9 columns


CREATE TABLE driver_details (
  "driverid" BIGINT,
  "driverref" VARCHAR,
  "number" VARCHAR,
  "code" VARCHAR,
  "forename" VARCHAR,
  "surname" VARCHAR,
  "dob" TIMESTAMP,
  "nationality" VARCHAR,
  "url" VARCHAR
);

Driver Rankings

@kaggle.muhammadehsan02_formula_1_world_championship_history_1950_2024.driver_rankings

338.25 KB
34595 rows
7 columns


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

Lap Timings

@kaggle.muhammadehsan02_formula_1_world_championship_history_1950_2024.lap_timings

3.3 MB
575029 rows
6 columns


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

Pit Stop Records

@kaggle.muhammadehsan02_formula_1_world_championship_history_1950_2024.pit_stop_records

185.75 KB
10990 rows
7 columns


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

Qualifying Results

@kaggle.muhammadehsan02_formula_1_world_championship_history_1950_2024.qualifying_results

216.64 KB
10254 rows
9 columns


CREATE TABLE qualifying_results (
  "qualifyid" BIGINT,
  "raceid" BIGINT,
  "driverid" BIGINT,
  "constructorid" BIGINT,
  "number" BIGINT,
  "position" BIGINT,
  "q1" VARCHAR,
  "q2" VARCHAR,
  "q3" VARCHAR
);

Race Results

@kaggle.muhammadehsan02_formula_1_world_championship_history_1950_2024.race_results

574.55 KB
26519 rows
18 columns


CREATE TABLE race_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
);

Race Schedule

@kaggle.muhammadehsan02_formula_1_world_championship_history_1950_2024.race_schedule

43.64 KB
1125 rows
18 columns


CREATE TABLE race_schedule (
  "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
);

Race Status

@kaggle.muhammadehsan02_formula_1_world_championship_history_1950_2024.race_status

4.17 KB
139 rows
2 columns


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

Season Summaries

@kaggle.muhammadehsan02_formula_1_world_championship_history_1950_2024.season_summaries

3.27 KB
75 rows
2 columns


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

Sprint Race Results

@kaggle.muhammadehsan02_formula_1_world_championship_history_1950_2024.sprint_race_results

21.03 KB
300 rows
16 columns


CREATE TABLE sprint_race_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
);

Team Details

@kaggle.muhammadehsan02_formula_1_world_championship_history_1950_2024.team_details

12.23 KB
212 rows
5 columns


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

Track Information

@kaggle.muhammadehsan02_formula_1_world_championship_history_1950_2024.track_information

13.41 KB
77 rows
9 columns


CREATE TABLE track_information (
  "circuitid" BIGINT,
  "circuitref" VARCHAR,
  "name" VARCHAR,
  "location" VARCHAR,
  "country" VARCHAR,
  "lat" DOUBLE,
  "lng" DOUBLE,
  "alt" BIGINT,
  "url" VARCHAR
);