Name: Le Mans 24 Hours
Creator: Kaggle
License: https://creativecommons.org/licenses/by-sa/4.0/

About this Dataset

Le Mans 24 Hours

Le Mans 24 Hour Race results from the first one in 1923 till this year 2023.

Dataset also includes how the circuit has changed over the years and details of each race.

Source: https://github.com/gdsotirov/lemans24/tree/main

Tables

Circuits

@kaggle.joebeachcapital_le_mans_24_hours.circuits

4.62 kB
15 rows
4 columns

CREATE TABLE circuits (
  "name" VARCHAR,
  "since" TIMESTAMP,
  "length_km" DOUBLE,
  "changes" VARCHAR
);

Races

@kaggle.joebeachcapital_le_mans_24_hours.races

8.1 kB
101 rows
7 columns

CREATE TABLE races (
  "id" BIGINT,
  "circuit_id" BIGINT,
  "event_date" TIMESTAMP,
  "start_time" VARCHAR,
  "cancelled" BIGINT,
  "cancellation_reason" VARCHAR,
  "distance_km" DOUBLE
);

Results In

@kaggle.joebeachcapital_le_mans_24_hours.results_in

285.63 kB
5,328 rows
15 columns

CREATE TABLE results_in (
  "year" BIGINT,
  "pos" VARCHAR,
  "class" VARCHAR,
  "no" BIGINT,
  "teamctry" VARCHAR,
  "team" VARCHAR,
  "drctry" VARCHAR,
  "drivers" VARCHAR,
  "chassis" VARCHAR,
  "engine" VARCHAR,
  "tyres" VARCHAR,
  "laps" BIGINT,
  "distance" DOUBLE,
  "time" VARCHAR,
  "reason" VARCHAR
);