Baselight

Formula 1 World Championship (1950 - 2024)

F1 race data from 1950 to 2024

@kaggle.rohanrao_formula_1_world_championship_1950_2020

Drivers
@kaggle.rohanrao_formula_1_world_championship_1950_2020.drivers

  • 53.8 KB
  • 859 rows
  • 9 columns
driverid

DriverId

driverref

DriverRef

number

Number

code

Code

forename

Forename

surname

Surname

dob

Dob

nationality

Nationality

url

Url

1hamilton44HAMLewisHamiltonMon Jan 07 1985 00:00:00 GMT+0000 (Coordinated Universal Time)Britishhttp://en.wikipedia.org/wiki/Lewis_Hamilton
2heidfeld\NHEINickHeidfeldTue May 10 1977 00:00:00 GMT+0000 (Coordinated Universal Time)Germanhttp://en.wikipedia.org/wiki/Nick_Heidfeld
3rosberg6ROSNicoRosbergThu Jun 27 1985 00:00:00 GMT+0000 (Coordinated Universal Time)Germanhttp://en.wikipedia.org/wiki/Nico_Rosberg
4alonso14ALOFernandoAlonsoWed Jul 29 1981 00:00:00 GMT+0000 (Coordinated Universal Time)Spanishhttp://en.wikipedia.org/wiki/Fernando_Alonso
5kovalainen\NKOVHeikkiKovalainenMon Oct 19 1981 00:00:00 GMT+0000 (Coordinated Universal Time)Finnishhttp://en.wikipedia.org/wiki/Heikki_Kovalainen
6nakajima\NNAKKazukiNakajimaFri Jan 11 1985 00:00:00 GMT+0000 (Coordinated Universal Time)Japanesehttp://en.wikipedia.org/wiki/Kazuki_Nakajima
7bourdais\NBOUSébastienBourdaisWed Feb 28 1979 00:00:00 GMT+0000 (Coordinated Universal Time)Frenchhttp://en.wikipedia.org/wiki/S%C3%A9bastien_Bourdais
8raikkonen7RAIKimiRäikkönenWed Oct 17 1979 00:00:00 GMT+0000 (Coordinated Universal Time)Finnishhttp://en.wikipedia.org/wiki/Kimi_R%C3%A4ikk%C3%B6nen
9kubica88KUBRobertKubicaFri Dec 07 1984 00:00:00 GMT+0000 (Coordinated Universal Time)Polishhttp://en.wikipedia.org/wiki/Robert_Kubica
10glock\NGLOTimoGlockThu Mar 18 1982 00:00:00 GMT+0000 (Coordinated Universal Time)Germanhttp://en.wikipedia.org/wiki/Timo_Glock

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

Share link

Anyone who has the link will be able to view this.