Formula E Championship

Formula E race data from seasons 1-7

@kaggle.mlandry_formula_e_championship

Table List

1 table(35.68 KB)

Formula E Race Results

@kaggle.mlandry_formula_e_championship.formula_e_race_results

35.68 KB
1480 rows
17 columns

season Season	race_num Race Num	race_name Race Name	race_date Race Date	driver Driver	car Car	team Team	team_group Team Group	rank Rank	rank_num Rank Num	grid Grid	laps Laps	time_retired Time Retired	pts_rank Pts Rank	pts_pole Pts Pole	pts_bonus Pts Bonus	points Points
2	2	2015 Putrajaya	Sat Nov 07 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Lucas di Grassi	11	ABT Schaeffler Audi Sport	Audi	1	1	6	33	50:17.449	25			25
1	4	2015 Buenos Aires	Sat Jan 10 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	António Félix da Costa	55	Amlin Aguri	Techeetah	1	1	8	35	48:52.100	25			25
5	1	2018 Ad Diriyah	Sat Dec 15 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	António Félix da Costa	28	Andretti-BMW	BMW-Andretti	1	1	1	33	46:29.377	25	3		28
6	2	2019 Diriyah race 2	Sat Nov 23 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Alexander Sims	27	Andretti-BMW	BMW-Andretti	1	1	1	30	46:48.327	25	3		28
6	3	2020 Santiago	Sat Jan 18 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Maximilian Günther	28	Andretti-BMW	BMW-Andretti	1	1	2	40	46:11.511	25			25
6	8	2020 Berlin race 3	Sat Aug 08 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Maximilian Günther	28	Andretti-BMW	BMW-Andretti	1	1	2	35	46:15.512	25			25
4	5	2018 Mexico City	Sat Mar 03 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Daniel Abt	66	Audi	Audi	1	1	5	47	50:45.164	25			25
4	9	2018 Berlin	Sat May 19 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Daniel Abt	66	Audi	Audi	1	1	1	45	55:35.546	25	3	1	29
4	10	2018 Zürich	Sun Jun 10 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Lucas di Grassi	1	Audi	Audi	1	1	5	39	51:19.811	25			25
4	11	2018 New York City	Sat Jul 14 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Lucas di Grassi	1	Audi	Audi	1	1	11	43	1:02:30.054	25			25


CREATE TABLE formula_e_race_results (
  "season" BIGINT,
  "race_num" BIGINT,
  "race_name" VARCHAR,
  "race_date" TIMESTAMP,
  "driver" VARCHAR,
  "car" BIGINT,
  "team" VARCHAR,
  "team_group" VARCHAR,
  "rank" VARCHAR,
  "rank_num" BIGINT,
  "grid" VARCHAR,
  "laps" VARCHAR,
  "time_retired" VARCHAR,
  "pts_rank" BIGINT,
  "pts_pole" BIGINT,
  "pts_bonus" BIGINT,
  "points" BIGINT
);