Dataset: F1 GrandPrix Dataset

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.41 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
);

Constructors

@kaggle.harshitstark_f1_grandprix_datavault.constructors

12.23 KB
212 rows
5 columns


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

Constructor Results

@kaggle.harshitstark_f1_grandprix_datavault.constructor_results

102.41 KB
12515 rows
5 columns


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

Constructor Standings

@kaggle.harshitstark_f1_grandprix_datavault.constructor_standings

133.11 KB
13281 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

53.8 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

338.42 KB
34616 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.31 MB
575989 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

186.17 KB
11030 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

217.08 KB
10274 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

43.64 KB
1125 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

575.29 KB
26539 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.27 KB
75 rows
2 columns


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

Sprint Results

@kaggle.harshitstark_f1_grandprix_datavault.sprint_results

21.03 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.17 KB
139 rows
2 columns


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