Name: FIA F1 (Formula 1) 1950-2020 Data
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

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

Constructors Championship 1958–2020

@kaggle.aadiltajani_fia_f1_19502019_data.constructors_championship_1958_2020

11.77 kB
655 rows
5 columns

CREATE TABLE constructors_championship_1958_2020 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "year" BIGINT,
  "position" VARCHAR,
  "team" VARCHAR,
  "points" BIGINT
);

Drivers Championship 1950–2020

@kaggle.aadiltajani_fia_f1_19502019_data.drivers_championship_1950_2020

32.66 kB
1,575 rows
8 columns

CREATE TABLE drivers_championship_1950_2020 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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.7 kB
1,035 rows
7 columns

CREATE TABLE fastest_laps_1950_2020 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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

317.5 kB
14,671 rows
11 columns

CREATE TABLE fastest_laps_all_drivers_all_race_1950_2020 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "year" BIGINT,
  "position" BIGINT,
  "driver_no" BIGINT  -- Driver No.,
  "venue" VARCHAR,
  "name" VARCHAR,
  "nametag" VARCHAR,
  "team" VARCHAR,
  "lap_no" DOUBLE  -- Lap No.,
  "time" VARCHAR,
  "avg_speed" DOUBLE
);

N 70 Anniversary Q1 Lapbylap

@kaggle.aadiltajani_fia_f1_19502019_data.n_70_anniversary_q1_lapbylap

7.83 kB
3,337 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.41 kB
3,964 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.92 kB
5,220 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

129.22 kB
28,613 rows
5 columns

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

Qualifying Times 1950–2005

@kaggle.aadiltajani_fia_f1_19502019_data.qualifying_times_1950_2005

175.48 kB
9,949 rows
10 columns

CREATE TABLE qualifying_times_1950_2005 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "year" BIGINT,
  "position" VARCHAR,
  "driver_no" BIGINT  -- Driver No.,
  "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

158.35 kB
6,089 rows
12 columns

CREATE TABLE qualifying_times_2006_2020 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "year" BIGINT,
  "position" VARCHAR,
  "driver_no" BIGINT  -- Driver No.,
  "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

351.74 kB
23,155 rows
11 columns

CREATE TABLE race_results_1950_2020 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "year" BIGINT,
  "position" VARCHAR,
  "driver_no" BIGINT  -- Driver No.,
  "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

35.82 kB
1,038 rows
8 columns

CREATE TABLE race_wins_1950_2020 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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.79 kB
7,825 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.88 kB
7,400 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.73 kB
5,417 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

149.56 kB
41,539 rows
5 columns

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