Formula 1 Race Events

Tables of safety car deployments and red flags in Formula 1 Grand Prix races

@kaggle.jtrotman_formula_1_race_events

Table List

4 tables(30.63 KB)

Fatal Accidents Drivers

Fatal Accidents Marshalls

Red Flags

Safety Cars

Red Flags

@kaggle.jtrotman_formula_1_race_events.red_flags

12.1 KB
98 rows
5 columns

race Race	lap Lap	resumed Resumed	incident Incident	excluded Excluded
1950 Indianapolis 500	138	N	Rain.	nan
1971 Canadian Grand Prix	64	N	Mist.	nan
1973 British Grand Prix	2	Y	Crash involving Jody Scheckter, Jean-Pierre Beltoise, George Follmer, Mike Hailwood, Carlos Pace, Jochen Mass, Jackie Oliver, Roger Williamson and Andrea de Adamich.	Jody Scheckter, Jean-Pierre Beltoise, George Follmer, Mike Hailwood, Carlos Pace, Jochen Mass, Jackie Oliver, Roger Williamson and Andrea de Adamich (crash) Graham McRae (throttle) and David Purley (spun off).
1974 Brazilian Grand Prix	32	N	Rain.	nan
1975 Spanish Grand Prix	29	N	Crash of Rolf Stommelen which killed five spectators. Half points were awarded.	nan
1975 British Grand Prix	56	N	Rain and crashes involving Wilson Fittipaldi, Jochen Mass, John Watson, Carlos Pace, Jody Scheckter, James Hunt and Mark Donohue.	nan
1975 Austrian Grand Prix	29	N	Rain. Half points were awarded.	nan
1976 British Grand Prix	1	Y	Crash at the start involving Clay Regazzoni, James Hunt, Jacques Laffite and Niki Lauda.	None, although Clay Regazzoni and Jacques Laffite illegally used their spare cars at the restart, and were subsequently disqualified.
1976 German Grand Prix	2	Y	Crash involving Niki Lauda, Brett Lunger and Harald Ertl.	Niki Lauda (crashed, injured), Brett Lunger and Harald Ertl (crashed), Chris Amon (withdrawn), Hans-Joachim Stuck (clutch) and Jacques Laffite (gearbox)
1978 Austrian Grand Prix	7	R	Rain. The race was decided by combining the time from the first 7 laps with the time from the restarted 47.	Mario Andretti, Jody Scheckter, Nelson Piquet, Héctor Rebaque, Harald Ertl, Riccardo Patrese, Alan Jones and James Hunt.


CREATE TABLE red_flags (
  "race" VARCHAR,
  "lap" BIGINT,
  "resumed" VARCHAR,
  "incident" VARCHAR,
  "excluded" VARCHAR
);