Formula 1 Official Data (1950-2022)

car Car	detail Detail	driver Driver	drivercode DriverCode	grand_prix Grand Prix	lap Lap	no No	pos Pos	time Time	time_of_day Time Of Day	year Year
Alfa Romeo	Fastest-Laps	Nino Farina	FAR	Great Britain	2	2	1	1:50.600	nan	1950
Alfa Romeo	Fastest-Laps	Juan Manuel Fangio	FAN	Monaco		34	1	1:51.000	nan	1950
Kurtis Kraft Offenhauser	Fastest-Laps	Johnnie Parsons	PAR	Indianapolis 500		1	1	nan	nan	1950
Alfa Romeo	Fastest-Laps	Nino Farina	FAR	Switzerland	8	16	1	2:41.600	nan	1950
Alfa Romeo	Fastest-Laps	Nino Farina	FAR	Belgium	18	8	1	4:34.100	nan	1950
Alfa Romeo	Fastest-Laps	Juan Manuel Fangio	FAN	France	52	6	1	2:35.600	nan	1950
Alfa Romeo	Fastest-Laps	Juan Manuel Fangio	FAN	Italy	7	18	1	2:00.000	nan	1950
Alfa Romeo	Fastest-Laps	Juan Manuel Fangio	FAN	Switzerland	33	24	1	2:51.100	nan	1951
Kurtis Kraft Offenhauser	Fastest-Laps	Lee Wallard	WAL	Indianapolis 500	23	99	1	1:07.260	nan	1951
Alfa Romeo	Fastest-Laps	Juan Manuel Fangio	FAN	Belgium	10	2	1	4:22.100	nan	1951


CREATE TABLE fastestlaps_detailed (
  "avg_speed" DOUBLE,
  "car" VARCHAR,
  "detail" VARCHAR,
  "driver" VARCHAR,
  "drivercode" VARCHAR,
  "grand_prix" VARCHAR,
  "lap" DOUBLE,
  "no" BIGINT,
  "pos" BIGINT,
  "time" VARCHAR,
  "time_of_day" VARCHAR,
  "year" BIGINT
);