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.51 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

7.91 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

278.94 KB
5328 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
);