Dataset: FIA F1 (Formula 1) 1950-2020 Data

About this Dataset

FIA F1 (Formula 1) 1950-2020 Data

Context

FIA F1 - Formula 1 is a Cutthroat motorsport competition started since 1950 and continues to date and attracts more and more fans every year towards this heritage sport.

Content

I have included the various datasets like Race wins, all Rcae Results, Qualifying Times, Constructors as well as Drivers Championship and Fastest Laps for years 1950-2020 and will add more and recent data shortly soon as it is available.

Note

This dataset is created from publicly available data and some of the data was recorded after some years so data for previous years might not be available.

Only to be used for non-commercial/study-related purposes strictly.

Tables

N 70 Anniversary Q1 Lapbylap

@kaggle.aadiltajani_fia_f1_19502019_data.n_70_anniversary_q1_lapbylap

7.64 KB
3337 rows
5 columns


CREATE TABLE n_70_anniversary_q1_lapbylap (
  "index" BIGINT,
  "pos" BIGINT,
  "driver" VARCHAR,
  "gap" VARCHAR,
  "time_remaining" VARCHAR
);

N 70 Anniversary Q2 Lapbylap

@kaggle.aadiltajani_fia_f1_19502019_data.n_70_anniversary_q2_lapbylap

7.24 KB
3964 rows
5 columns


CREATE TABLE n_70_anniversary_q2_lapbylap (
  "index" BIGINT,
  "pos" BIGINT,
  "driver" VARCHAR,
  "gap" VARCHAR,
  "time_remaining" VARCHAR
);

N 70 Anniversary Q3 Lapbylap

@kaggle.aadiltajani_fia_f1_19502019_data.n_70_anniversary_q3_lapbylap

7.74 KB
5220 rows
5 columns


CREATE TABLE n_70_anniversary_q3_lapbylap (
  "index" BIGINT,
  "pos" BIGINT,
  "driver" VARCHAR,
  "gap" VARCHAR,
  "time_remaining" VARCHAR
);

N 70 Anniversary Race Lapbylap

@kaggle.aadiltajani_fia_f1_19502019_data.n_70_anniversary_race_lapbylap

126.19 KB
28613 rows
5 columns


CREATE TABLE n_70_anniversary_race_lapbylap (
  "index" BIGINT,
  "pos" DOUBLE,
  "driver" VARCHAR,
  "gap" VARCHAR,
  "lap_no" DOUBLE
);

Constructors Championship 1958–2020

@kaggle.aadiltajani_fia_f1_19502019_data.constructors_championship_1958_2020

11.5 KB
655 rows
5 columns


CREATE TABLE constructors_championship_1958_2020 (
  "unnamed_0" BIGINT,
  "year" BIGINT,
  "position" VARCHAR,
  "team" VARCHAR,
  "points" BIGINT
);

Drivers Championship 1950–2020

@kaggle.aadiltajani_fia_f1_19502019_data.drivers_championship_1950_2020

31.89 KB
1575 rows
8 columns


CREATE TABLE drivers_championship_1950_2020 (
  "unnamed_0" BIGINT,
  "year" BIGINT,
  "position" VARCHAR,
  "name" VARCHAR,
  "driver_tag" VARCHAR,
  "nationality" VARCHAR,
  "team" VARCHAR,
  "points" DOUBLE
);

Fastest Laps 1950–2020

@kaggle.aadiltajani_fia_f1_19502019_data.fastest_laps_1950_2020

25.1 KB
1035 rows
7 columns


CREATE TABLE fastest_laps_1950_2020 (
  "unnamed_0" BIGINT,
  "year" BIGINT,
  "venue" VARCHAR,
  "name" VARCHAR,
  "driver_tag" VARCHAR,
  "team" VARCHAR,
  "lap_time" VARCHAR
);

Fastest Laps All Drivers All Race 1950–2020

@kaggle.aadiltajani_fia_f1_19502019_data.fastest_laps_all_drivers_all_race_1950_2020

310.06 KB
14671 rows
11 columns


CREATE TABLE fastest_laps_all_drivers_all_race_1950_2020 (
  "unnamed_0" BIGINT,
  "year" BIGINT,
  "position" BIGINT,
  "driver_no" BIGINT,
  "venue" VARCHAR,
  "name" VARCHAR,
  "nametag" VARCHAR,
  "team" VARCHAR,
  "lap_no" DOUBLE,
  "time" VARCHAR,
  "avg_speed" DOUBLE
);

Qualifying Times 1950–2005

@kaggle.aadiltajani_fia_f1_19502019_data.qualifying_times_1950_2005

171.36 KB
9949 rows
10 columns


CREATE TABLE qualifying_times_1950_2005 (
  "unnamed_0" BIGINT,
  "year" BIGINT,
  "position" VARCHAR,
  "driver_no" BIGINT,
  "venue" VARCHAR,
  "name" VARCHAR,
  "nametag" VARCHAR,
  "team" VARCHAR,
  "lap_time" VARCHAR,
  "laps" DOUBLE
);

Qualifying Times 2006–2020

@kaggle.aadiltajani_fia_f1_19502019_data.qualifying_times_2006_2020

154.63 KB
6089 rows
12 columns


CREATE TABLE qualifying_times_2006_2020 (
  "unnamed_0" BIGINT,
  "year" BIGINT,
  "position" VARCHAR,
  "driver_no" BIGINT,
  "venue" VARCHAR,
  "name" VARCHAR,
  "nametag" VARCHAR,
  "team" VARCHAR,
  "q1" VARCHAR,
  "q2" VARCHAR,
  "q3" VARCHAR,
  "laps" BIGINT
);

Race Results 1950–2020

@kaggle.aadiltajani_fia_f1_19502019_data.race_results_1950_2020

343.49 KB
23155 rows
11 columns


CREATE TABLE race_results_1950_2020 (
  "unnamed_0" BIGINT,
  "year" BIGINT,
  "position" VARCHAR,
  "driver_no" BIGINT,
  "venue" VARCHAR,
  "name" VARCHAR,
  "nametag" VARCHAR,
  "team" VARCHAR,
  "laps" DOUBLE,
  "time" VARCHAR,
  "points" DOUBLE
);

Race Wins 1950–2020

@kaggle.aadiltajani_fia_f1_19502019_data.race_wins_1950_2020

34.98 KB
1038 rows
8 columns


CREATE TABLE race_wins_1950_2020 (
  "unnamed_0" BIGINT,
  "venue" VARCHAR,
  "date" VARCHAR,
  "name" VARCHAR,
  "nametag" VARCHAR,
  "team" VARCHAR,
  "laps" DOUBLE,
  "time" VARCHAR
);

Spain2020 Q1 Lapbylap

@kaggle.aadiltajani_fia_f1_19502019_data.spain2020_q1_lapbylap

11.52 KB
7825 rows
5 columns


CREATE TABLE spain2020_q1_lapbylap (
  "index" BIGINT,
  "pos" DOUBLE,
  "driver" VARCHAR,
  "gap" VARCHAR,
  "time_remaining" VARCHAR
);

Spain2020 Q2 Lapbylap

@kaggle.aadiltajani_fia_f1_19502019_data.spain2020_q2_lapbylap

10.63 KB
7400 rows
5 columns


CREATE TABLE spain2020_q2_lapbylap (
  "index" BIGINT,
  "pos" DOUBLE,
  "driver" VARCHAR,
  "gap" VARCHAR,
  "time_remaining" VARCHAR
);

Spain2020 Q3 Lapbylap

@kaggle.aadiltajani_fia_f1_19502019_data.spain2020_q3_lapbylap

8.52 KB
5417 rows
5 columns


CREATE TABLE spain2020_q3_lapbylap (
  "index" BIGINT,
  "pos" DOUBLE,
  "driver" VARCHAR,
  "gap" VARCHAR,
  "time_remaining" VARCHAR
);

Spain2020 Race Lapbylap

@kaggle.aadiltajani_fia_f1_19502019_data.spain2020_race_lapbylap

146.06 KB
41539 rows
5 columns


CREATE TABLE spain2020_race_lapbylap (
  "index" BIGINT,
  "pos" DOUBLE,
  "driver" VARCHAR,
  "gap" VARCHAR,
  "lap_no" DOUBLE
);