Formula 1 Pitstops 1994-2010

Pitstops in Formula One Grand Prix from 1994 to 2010

@kaggle.jtrotman_formula_1_pitstops_1994_2010

Table List

1 table(228.7 KB)

Pitstops

@kaggle.jtrotman_formula_1_pitstops_1994_2010.pitstops

228.7 KB
9921 rows
13 columns

raceid RaceId	driverid DriverId	stops Stops	year Year	race Race	no No	drivername DriverName	code Code	car Car	lap Lap	timeofday TimeOfDay	time Time	total Total
258	100	1	1994	pacific	20	Erik Comas	COM	Larrousse Ford	1	14:01:34	49.111	49.111
258	79	1	1994	pacific	3	Ukyo Katayama	KAT	Tyrrell Yamaha	17	14:20:46	28.482	28.482
258	57	1	1994	pacific	7	Mika Hakkinen	HAK	McLaren Peugeot	18	14:22:35	43.745	43.745
258	71	1	1994	pacific		Damon Hill	HIL	Williams Renault	18	14:23:00	21.992	21.992
258	105	1	1994	pacific	24	Michele Alboreto	ALB	Minardi Ford	19	14:24:39	27.693	27.693
258	91	1	1994	pacific	29	Karl Wendlinger	WEN	Sauber Mercedes	19	14:24:41	24.806	24.806
258	44	1	1994	pacific	26	Olivier Panis	PAN	Ligier Renault	18	14:25:13	53.89	53.890
258	94	1	1994	pacific	23	Pierluigi Martini	MAR	Minardi Ford	22	14:28:34	34.437	34.437
258	30	1	1994	pacific	5	Michael Schumacher	MSC	Benetton Ford	23	14:28:40	23.342	23.342
258	104	1	1994	pacific	9	Christian Fittipaldi	FIT	Footwork Ford	23	14:29:00	56.753	56.753


CREATE TABLE pitstops (
  "raceid" BIGINT,
  "driverid" BIGINT,
  "stops" BIGINT,
  "year" BIGINT,
  "race" VARCHAR,
  "no" BIGINT,
  "drivername" VARCHAR,
  "code" VARCHAR,
  "car" VARCHAR,
  "lap" BIGINT,
  "timeofday" VARCHAR,
  "time" VARCHAR,
  "total" VARCHAR
);