Dataset: Formula 1 Dataset (1950 - 2023) [Cleaned]

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.49 KB
77 rows
5 columns


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

Cleaned Constructors

@kaggle.suletanmay_formula_1_dataset_1950_2023_cleaned.cleaned_constructors

7.36 KB
211 rows
4 columns


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

Cleaned Constructor Results

@kaggle.suletanmay_formula_1_dataset_1950_2023_cleaned.cleaned_constructor_results

100.04 KB
12290 rows
4 columns


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

Cleaned Constructor Standings

@kaggle.suletanmay_formula_1_dataset_1950_2023_cleaned.cleaned_constructor_standings

122.12 KB
13051 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

31.95 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

302.38 KB
34124 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.34 MB
551742 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

70.12 KB
10089 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

229.03 KB
9815 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.29 KB
1101 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

404.4 KB
26080 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.26 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.46 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.17 KB
139 rows
2 columns


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