F1 Race By Race (1983-2021)

F1 data, race by race, from 1983 onwards

@kaggle.prajwalsood_f1_race_by_race_19832021

Table List

2 tables(254.08 KB)

Test Template

@kaggle.prajwalsood_f1_race_by_race_19832021.test_template

14.99 KB
18 rows
21 columns

season Season	round Round	circuit_id Circuit Id	weather_wet Weather Wet	driver Driver	nationality Nationality	constructor Constructor	grid Grid	podium Podium	driver_points Driver Points	driver_wins Driver Wins	driver_standings_pos Driver Standings Pos	constructor_points Constructor Points	constructor_wins Constructor Wins	constructor_standings_pos Constructor Standings Pos	qualifying_time Qualifying Time	driver_age Driver Age
2021	12	spa	true	hamilton	British	mercedes	1	2	177	4	2	285	4	2		36
2021	12	spa	true	bottas	Finnish	mercedes	2	16	108		4	285	4	2	0.3	31
2021	12	spa	true	max_verstappen	Dutch	red_bull	3	9	185	5	1	289	6	1	0.4	23
2021	12	spa	true	perez	Mexican	red_bull	4	17	104	1	5	289	6	1	1	31
2021	12	spa	true	gasly	French	alphatauri	5	5	39		9	49		5	1.1	25
2021	12	spa	true	norris	British	mclaren	6	15	113		3	163		3	1.1	21
2021	12	spa	true	leclerc	Monegasque	ferrari	7	18	80		7	148		4	1.1	23
2021	12	spa	true	ocon	French	alpine	8	1	14		13	40		7	1.3	24
2021	12	spa	true	alonso	Spanish	alpine	9	4	26		11	40		7	1.3	40
2021	12	spa	true	vettel	German	aston_martin	10	20	30		10	48		6	1.4	34


CREATE TABLE test_template (
  "season" BIGINT,
  "round" BIGINT,
  "circuit_id" VARCHAR,
  "weather_warm" BOOLEAN,
  "weather_cold" BOOLEAN,
  "weather_dry" BOOLEAN,
  "weather_wet" BOOLEAN,
  "weather_cloudy" BOOLEAN,
  "driver" VARCHAR,
  "nationality" VARCHAR,
  "constructor" VARCHAR,
  "grid" BIGINT,
  "podium" BIGINT,
  "driver_points" BIGINT,
  "driver_wins" BIGINT,
  "driver_standings_pos" BIGINT,
  "constructor_points" BIGINT,
  "constructor_wins" BIGINT,
  "constructor_standings_pos" BIGINT,
  "qualifying_time" DOUBLE,
  "driver_age" BIGINT
);