Dataset: Chicago Marathon Results - 1996 To 2023

About this Dataset

Chicago Marathon Results - 1996 To 2023

This dataset includes the individual results from the Chicago Marathon from 1996 to the present. The dataset also includes the dates of each race and the weather on race day.

The finisher data comes from directly from the Chicago Marathon website and the weather data comes from Weather Spark.

A third file in the dataset contains the qualifying times for the Chicago Marathon that were implemented in 2014, 2018, and 2025.

This data was originally collected and prepared as part of an analysis that was published on Medium. You can read find more information about that analysis here.

The feature image on this dataset is Chad Veal, CC BY-SA 4.0, via Wikimedia Commons.

Tables

Chicago Marathon Qualifying Times

@kaggle.runningwithrock_chicago_marathon_results.chicago_marathon_qualifying_times

4.23 KB
24 rows
5 columns


CREATE TABLE chicago_marathon_qualifying_times (
  "gender" VARCHAR,
  "chicago_age" VARCHAR,
  "n_2025_cq" BIGINT,
  "n_2024_cq" BIGINT,
  "n_2014_cq" BIGINT
);

Chicago Marathon Results

@kaggle.runningwithrock_chicago_marathon_results.chicago_marathon_results

16.7 MB
886546 rows
9 columns


CREATE TABLE chicago_marathon_results (
  "race" VARCHAR,
  "year" BIGINT,
  "name" VARCHAR,
  "gender" VARCHAR,
  "age" BIGINT,
  "country" VARCHAR,
  "overall" BIGINT,
  "finish_time" VARCHAR,
  "finish" BIGINT
);

Chicago Marathon Weather

@kaggle.runningwithrock_chicago_marathon_results.chicago_marathon_weather

11.4 KB
45 rows
13 columns


CREATE TABLE chicago_marathon_weather (
  "year" BIGINT,
  "month" VARCHAR,
  "day" BIGINT,
  "date" TIMESTAMP,
  "n_6am_temp" DOUBLE,
  "n_6am_dew" DOUBLE,
  "n_6am_wind" DOUBLE,
  "n_9am_temp" DOUBLE,
  "n_9am_dew" DOUBLE,
  "n_9am_wind" DOUBLE,
  "n_12pm_temp" DOUBLE,
  "n_12pm_dew" DOUBLE,
  "n_12pm_wind" DOUBLE
);