Dataset: Formula 1 Race Events

About this Dataset

Formula 1 Race Events

This dataset complements the existing ergast.com F1 dataset with events that happened in Grand Prix, currently:

red flags
safety car deployments
virtual safety car deployments

Data is collected from these pages:

Example usage in F1 Race Traces notebooks: 2024.

Tables

Fatal Accidents Drivers

@kaggle.jtrotman_formula_1_race_events.fatal_accidents_drivers

6.91 KB
51 rows
6 columns


CREATE TABLE fatal_accidents_drivers (
  "driver" VARCHAR,
  "age" DOUBLE,
  "date_of_accident" TIMESTAMP,
  "event" VARCHAR,
  "car" VARCHAR,
  "session" VARCHAR
);

Fatal Accidents Marshalls

@kaggle.jtrotman_formula_1_race_events.fatal_accidents_marshalls

3.71 KB
5 rows
4 columns


CREATE TABLE fatal_accidents_marshalls (
  "name" VARCHAR,
  "age" BIGINT,
  "date_of_accident" TIMESTAMP,
  "event" VARCHAR
);

Red Flags

@kaggle.jtrotman_formula_1_race_events.red_flags

12.1 KB
98 rows
5 columns


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

Safety Cars

@kaggle.jtrotman_formula_1_race_events.safety_cars

7.91 KB
346 rows
5 columns


CREATE TABLE safety_cars (
  "race" VARCHAR,
  "cause" VARCHAR,
  "deployed" BIGINT,
  "retreated" DOUBLE,
  "fulllaps" BIGINT
);