Name: Formula 1 Dataset (1950 - 2023) [Cleaned]
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Formula 1 Dataset (1950 - 2023) [Cleaned]

Description:
Dive into the thrilling world of Formula 1 with this comprehensive dataset covering races, drivers, constructors, qualifying, circuits, lap times, pit stops, and championships from 1950 to the 2023 season. Uncover fascinating insights into the evolution of the sport and the remarkable achievements of legendary drivers and teams.

Acknowledgements:
The data is taken from https://www.kaggle.com/datasets/rohanrao/formula-1-world-championship-1950-2020 which is compiled from http://ergast.com/mrd/

Inspiration:
“If you no longer go for a gap that exists, you're no longer a racing driver.” - Ayrton Senna

As you explore this rich dataset documenting Formula 1's storied history, you're delving into a world where data isn't just numbers; it's the essence of speed, precision, and human achievement. From the meticulous engineering of cars to the strategic brilliance of teams and the sheer talent of drivers, every data point represents a quest for perfection on the track.
By analyzing this data, you're not just crunching numbers; you're unraveling the secrets behind the fastest racers in the world. So, dive in, analyze with curiosity, and uncover the stories that make this sport truly legendary.

Tables

Cleaned Circuits

@kaggle.suletanmay_formula_1_dataset_1950_2023_cleaned.cleaned_circuits

7.67 kB
77 rows
5 columns

CREATE TABLE cleaned_circuits (
  "circuitid" BIGINT,
  "circuit_name" VARCHAR,
  "circuit_location" VARCHAR,
  "circuit_country" VARCHAR,
  "circuit_nationality" VARCHAR
);

Cleaned Constructor Results

@kaggle.suletanmay_formula_1_dataset_1950_2023_cleaned.cleaned_constructor_results

102.44 kB
12,290 rows
4 columns

CREATE TABLE cleaned_constructor_results (
  "constructorresultsid" BIGINT,
  "raceid" BIGINT,
  "constructorid" BIGINT,
  "points" DOUBLE
);

Cleaned Constructors

@kaggle.suletanmay_formula_1_dataset_1950_2023_cleaned.cleaned_constructors

7.53 kB
211 rows
4 columns

CREATE TABLE cleaned_constructors (
  "constructorid" BIGINT,
  "constructor_name" VARCHAR,
  "constructor_nationality" VARCHAR,
  "constructor_home" VARCHAR
);

Cleaned Constructor Standings

@kaggle.suletanmay_formula_1_dataset_1950_2023_cleaned.cleaned_constructor_standings

125.06 kB
13,051 rows
6 columns

CREATE TABLE cleaned_constructor_standings (
  "constructorstandingsid" BIGINT,
  "raceid" BIGINT,
  "constructorid" BIGINT,
  "points" DOUBLE,
  "position" BIGINT,
  "wins" BIGINT
);

Cleaned Drivers

@kaggle.suletanmay_formula_1_dataset_1950_2023_cleaned.cleaned_drivers

32.72 kB
857 rows
7 columns

CREATE TABLE cleaned_drivers (
  "driverid" BIGINT,
  "driver_code" VARCHAR,
  "driver_forename" VARCHAR,
  "driver_surname" VARCHAR,
  "driver_dob" TIMESTAMP,
  "driver_nationality" VARCHAR,
  "driver_home" VARCHAR
);

Cleaned Driver Standings

@kaggle.suletanmay_formula_1_dataset_1950_2023_cleaned.cleaned_driver_standings

309.64 kB
34,124 rows
6 columns

CREATE TABLE cleaned_driver_standings (
  "driverstandingsid" BIGINT,
  "raceid" BIGINT,
  "driverid" BIGINT,
  "points" DOUBLE,
  "position" BIGINT,
  "wins" BIGINT
);

Cleaned Lap Times

@kaggle.suletanmay_formula_1_dataset_1950_2023_cleaned.cleaned_lap_times

3.5 MB
551,742 rows
5 columns

CREATE TABLE cleaned_lap_times (
  "raceid" BIGINT,
  "driverid" BIGINT,
  "lap" BIGINT,
  "position" BIGINT,
  "lap_time" VARCHAR
);

Cleaned Pit Stops

@kaggle.suletanmay_formula_1_dataset_1950_2023_cleaned.cleaned_pit_stops

71.8 kB
10,089 rows
5 columns

CREATE TABLE cleaned_pit_stops (
  "raceid" BIGINT,
  "driverid" BIGINT,
  "stop" BIGINT,
  "lap" BIGINT,
  "milliseconds" BIGINT
);

Cleaned Qualifying

@kaggle.suletanmay_formula_1_dataset_1950_2023_cleaned.cleaned_qualifying

234.53 kB
9,815 rows
9 columns

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

Cleaned Races

@kaggle.suletanmay_formula_1_dataset_1950_2023_cleaned.cleaned_races

11.56 kB
1,101 rows
4 columns

CREATE TABLE cleaned_races (
  "raceid" BIGINT,
  "year" BIGINT,
  "round" BIGINT,
  "circuitid" BIGINT
);

Cleaned Results

@kaggle.suletanmay_formula_1_dataset_1950_2023_cleaned.cleaned_results

414.1 kB
26,080 rows
13 columns

CREATE TABLE cleaned_results (
  "resultid" BIGINT,
  "raceid" BIGINT,
  "driverid" BIGINT,
  "constructorid" BIGINT,
  "grid_position" BIGINT,
  "position" BIGINT,
  "points" DOUBLE,
  "laps" BIGINT,
  "fastestlap" BIGINT,
  "fastestlaprank" BIGINT,
  "fastestlaptime" VARCHAR,
  "fastestlapspeed" DOUBLE,
  "statusid" BIGINT
);

Cleaned Seasons

@kaggle.suletanmay_formula_1_dataset_1950_2023_cleaned.cleaned_seasons

3.34 kB
74 rows
2 columns

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

Cleaned Sprint Results

@kaggle.suletanmay_formula_1_dataset_1950_2023_cleaned.cleaned_sprint_results

12.76 kB
180 rows
12 columns

CREATE TABLE cleaned_sprint_results (
  "resultid" BIGINT,
  "raceid" BIGINT,
  "driverid" BIGINT,
  "constructorid" BIGINT,
  "grid_position" BIGINT,
  "position" BIGINT,
  "points" BIGINT,
  "laps" BIGINT,
  "fastestlap" BIGINT,
  "fastestlaptime" VARCHAR,
  "statusid" BIGINT,
  "fastestlaprank" BIGINT
);

Cleaned Status

@kaggle.suletanmay_formula_1_dataset_1950_2023_cleaned.cleaned_status

4.27 kB
139 rows
2 columns

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