Name: F1 GrandPrix Dataset
Creator: Kaggle
License: https://creativecommons.org/licenses/by/4.0/

About this Dataset

F1 GrandPrix Dataset

The F1 GrandPrix Dataset is a meticulously curated collection of data that provides an in-depth look into the world of Formula 1 racing. This dataset encompasses a wide range of information, including circuits, constructors, drivers, race results, lap times, pit stops, and much more.

With over a dozen files, this dataset offers detailed records that are essential for analyzing the performance and standings of drivers and constructors across various seasons. Whether you are a data scientist, sports analyst, or Formula 1 enthusiast, this dataset is designed to help you uncover patterns, trends, and insights in the high-speed world of Formula 1.

Files Included:

circuits.csv: Details of all racing circuits.
constructor_results.csv: Results of constructors in each race.
constructor_standings.csv: Standings of constructors by season.
constructors.csv: Information on all constructors.
driver_standings.csv: Standings of drivers by season.
drivers.csv: Information on all drivers.
lap_times.csv: Lap times for each race.
pit_stops.csv: Details of pit stops during races.
qualifying.csv: Qualifying session results.
races.csv: Information on all races.
results.csv: Detailed race results.
seasons.csv: Overview of all racing seasons.
sprint_results.csv: Results of sprint races.
status.csv: Status codes for race events.
This comprehensive dataset serves as a valuable resource for conducting various analyses, building predictive models, and gaining a deeper understanding of the dynamics in Formula 1 racing.

Tables

Circuits

@kaggle.harshitstark_f1_grandprix_datavault.circuits

13.73 kB
77 rows
9 columns

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

Constructor Results

@kaggle.harshitstark_f1_grandprix_datavault.constructor_results

104.87 kB
12,515 rows
5 columns

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

Constructors

@kaggle.harshitstark_f1_grandprix_datavault.constructors

12.53 kB
212 rows
5 columns

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

Constructor Standings

@kaggle.harshitstark_f1_grandprix_datavault.constructor_standings

136.31 kB
13,281 rows
7 columns

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

Drivers

@kaggle.harshitstark_f1_grandprix_datavault.drivers

55.09 kB
859 rows
9 columns

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

Driver Standings

@kaggle.harshitstark_f1_grandprix_datavault.driver_standings

346.54 kB
34,616 rows
7 columns

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

Lap Times

@kaggle.harshitstark_f1_grandprix_datavault.lap_times

3.47 MB
575,989 rows
6 columns

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

Pit Stops

@kaggle.harshitstark_f1_grandprix_datavault.pit_stops

190.64 kB
11,030 rows
7 columns

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

Qualifying

@kaggle.harshitstark_f1_grandprix_datavault.qualifying

222.29 kB
10,274 rows
9 columns

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

Races

@kaggle.harshitstark_f1_grandprix_datavault.races

44.69 kB
1,125 rows
18 columns

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

Results

@kaggle.harshitstark_f1_grandprix_datavault.results

589.1 kB
26,539 rows
18 columns

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

Seasons

@kaggle.harshitstark_f1_grandprix_datavault.seasons

3.35 kB
75 rows
2 columns

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

Sprint Results

@kaggle.harshitstark_f1_grandprix_datavault.sprint_results

21.54 kB
300 rows
16 columns

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

Status

@kaggle.harshitstark_f1_grandprix_datavault.status

4.27 kB
139 rows
2 columns

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