Dataset: 2023 Marathon Results

About this Dataset

2023 Marathon Results

This dataset contains individual finisher information and race information for all marathons run in the United States in 2023.

I originally collected this information for a series of articles that I published on Medium, exploring alternative ways to age grade marathon performances. Ultimately, I used the data to calculate a set of tables for scoring marathon results based on percentiles (see the calculator here).

The dataset includes the individual results from 641 races. The gender, age, and finish (in seconds) for each of approximately 429,000 runners is included.

The list of races is based on results publicly available at Marathon Guide, with the addition of a couple large races that were missing from Marathon Guide. The individual results were scraped from either Marathon Guide, Athlinks, or an individual race website.

Tables

Races

@kaggle.runningwithrock_2023_marathon_results.races

17.25 KB
641 rows
4 columns


CREATE TABLE races (
  "race" VARCHAR,
  "year" BIGINT,
  "date" TIMESTAMP,
  "finishers" BIGINT
);

Results

@kaggle.runningwithrock_2023_marathon_results.results

6.72 MB
429266 rows
7 columns


CREATE TABLE results (
  "name" VARCHAR,
  "race" VARCHAR,
  "year" BIGINT,
  "gender" VARCHAR,
  "age" BIGINT,
  "finish" BIGINT,
  "age_bracket" VARCHAR
);