World Marathon Series Analytics Set (WW)
SPTMAR906· 41K records · 30 tables · v1.0.0 · Updated 2026-08-11
Sports & Athlete Performance Sports & Athlete Performance Dataset API
Overview
This linked marathon analytics product follows modelled leading athletes across major-city races in Tokyo, Boston, London, Sydney, Berlin, Chicago and New York over a longitudinal series. It connects event entries and results to course segments, split times, aid-station passages, weather, rankings, coaching, training load, wellness, physical assessments, injuries, treatment, equipment, travel, earnings, official record context, identity-matched athlete media and leakage-controlled predictions. The design supports pacing, course difficulty, climate exposure, travel, athlete development, race operations and performance forecasting without representing a real athlete or organizer transaction.
Athletes and Performance
Four athletes from the field, with the career numbers the dataset records for them. Every value below is read from the packaged tables.
Mateo HorvatMARMarathon
MoroccoAge 36Height 188 cmProfessional since 2008
23Races
22Finishes
1Best finish
8.59Rating
By season2020 4 races, 0 wins2021 3 races, 1 wins2022 4 races, 0 wins2023 5 races, 1 wins2024 4 races, 1 wins2025 3 races, 0 wins
RatingAvg 8.54
1 / 4
Row Counts by Table
Counted from the files that ship, not estimated.
| Table | Rows |
|---|---|
| marathon_sessions | 12 |
| marathon_countries | 30 |
| marathon_disciplines | 2 |
| marathon_athletes | 50 |
| marathon_athlete_media | 100 |
| marathon_coaches | 34 |
| marathon_athlete_sessions | 341 |
| marathon_coach_assignments | 341 |
| marathon_venues | 7 |
| marathon_competitions | 7 |
| marathon_events | 42 |
| marathon_event_entries | 1,195 |
| marathon_results | 1,195 |
| marathon_split_metrics | 10,458 |
| marathon_performance_metrics | 1,195 |
| marathon_rankings | 4,092 |
| marathon_training_sessions | 4,092 |
| marathon_training_loads | 4,092 |
| marathon_wellness | 4,092 |
| marathon_physical_assessments | 682 |
| marathon_injuries | 50 |
| marathon_treatments | 150 |
| marathon_equipment | 341 |
| marathon_travel | 1,195 |
| marathon_athlete_financials | 341 |
| marathon_record_benchmarks | 1 |
| marathon_prediction_features | 1,195 |
| marathon_performance_predictions | 1,195 |
| marathon_course_segments | 252 |
| marathon_aid_station_passages | 4,648 |
Table Relationships
One parent record and seven child tables, each joined back on the same key.
70%
Loading diagram
Schema
Every table ships with typed columns, referential integrity, and documentation.
marathon_sessions· Rows: 12
| Column | Type | Description |
|---|---|---|
| session_id | varchar(16) | Stable identifier for session; use it for declared joins. |
| session_label | integer | Session label for the marathon_sessions record. |
| calendar_year | integer | Calendar year for the marathon_sessions record. |
| starts_on | date | starts on as an ISO 8601 calendar date. |
| ends_on | date | ends on as an ISO 8601 calendar date. |
| source_status | varchar(32) | source status in the declared lifecycle, result or source-status vocabulary. |
marathon_countries· Rows: 30
| Column | Type | Description |
|---|---|---|
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| country_code | varchar(8) | Stable code for country. |
| country_name | varchar(24) | Human-readable country name; names are fictional where the disclosure states so. |
| region_name | varchar(16) | Human-readable region name; names are fictional where the disclosure states so. |
marathon_disciplines· Rows: 2
| Column | Type | Description |
|---|---|---|
| discipline_id | varchar(8) | Stable identifier for discipline; use it for declared joins. |
| discipline_code | varchar(8) | Stable code for discipline. |
| discipline_name | varchar(24) | Human-readable discipline name; names are fictional where the disclosure states so. |
| measurement_unit | varchar(16) | Measurement unit for the marathon_disciplines record. |
| governing_context | varchar(64) | Governing context for the marathon_disciplines record. |
marathon_athletes· Rows: 50
| Column | Type | Description |
|---|---|---|
| athlete_id | varchar(16) | Stable identifier for athlete; use it for declared joins. |
| athlete_name | varchar(24) | Human-readable athlete name; names are fictional where the disclosure states so. |
| gender | varchar(16) | Gender for the marathon_athletes record. |
| birth_date | date | birth date as an ISO 8601 calendar date. |
| nationality_country_id | varchar(8) | Stable identifier for nationality country; use it for declared joins. |
| nationality_code | varchar(8) | Stable code for nationality. |
| height_cm | integer | height in centimetres. |
+7 more columns in marathon_athletes. The full schema ships with the download.
marathon_athlete_media· Rows: 100
| Column | Type | Description |
|---|---|---|
| athlete_media_id | varchar(16) | Stable identifier for athlete media; use it for declared joins. |
| athlete_id | varchar(16) | Stable identifier for athlete; use it for declared joins. |
| session_id | varchar(8) | Stable identifier for session; use it for declared joins. |
| media_scope | varchar(16) | Media scope for the marathon_athlete_media record. |
| media_type | varchar(16) | Media type for the marathon_athlete_media record. |
| image_file | varchar(56) | Image file for the marathon_athlete_media record. |
| image_format | varchar(16) | Image format for the marathon_athlete_media record. |
+5 more columns in marathon_athlete_media. The full schema ships with the download.
marathon_coaches· Rows: 34
| Column | Type | Description |
|---|---|---|
| coach_id | varchar(8) | Stable identifier for coach; use it for declared joins. |
| coach_name | varchar(24) | Human-readable coach name; names are fictional where the disclosure states so. |
| nationality_code | varchar(8) | Stable code for nationality. |
| specialty | varchar(32) | Specialty for the marathon_coaches record. |
| certification_level | varchar(24) | Certification level for the marathon_coaches record. |
| fictional_person_flag | boolean | Boolean indicator for fictional person. |
marathon_athlete_sessions· Rows: 341
| Column | Type | Description |
|---|---|---|
| athlete_session_id | varchar(16) | Stable identifier for athlete session; use it for declared joins. |
| athlete_id | varchar(16) | Stable identifier for athlete; use it for declared joins. |
| session_id | varchar(16) | Stable identifier for session; use it for declared joins. |
| coach_id | varchar(8) | Stable identifier for coach; use it for declared joins. |
| age_years | integer | Age years for the marathon_athlete_sessions record. |
| competition_status | varchar(24) | competition status in the declared lifecycle, result or source-status vocabulary. |
| squad_tier | varchar(16) | Squad tier for the marathon_athlete_sessions record. |
+6 more columns in marathon_athlete_sessions. The full schema ships with the download.
marathon_coach_assignments· Rows: 341
| Column | Type | Description |
|---|---|---|
| coach_assignment_id | varchar(16) | Stable identifier for coach assignment; use it for declared joins. |
| coach_id | varchar(8) | Stable identifier for coach; use it for declared joins. |
| athlete_id | varchar(16) | Stable identifier for athlete; use it for declared joins. |
| session_id | varchar(16) | Stable identifier for session; use it for declared joins. |
| assignment_role | varchar(24) | Assignment role for the marathon_coach_assignments record. |
| starts_on | date | starts on as an ISO 8601 calendar date. |
| ends_on | date | ends on as an ISO 8601 calendar date. |
+2 more columns in marathon_coach_assignments. The full schema ships with the download.
marathon_venues· Rows: 7
| Column | Type | Description |
|---|---|---|
| venue_id | varchar(8) | Stable identifier for venue; use it for declared joins. |
| venue_name | varchar(40) | Human-readable venue name; names are fictional where the disclosure states so. |
| city | varchar(16) | City for the marathon_venues record. |
| country_code | varchar(8) | Stable code for country. |
| venue_type | varchar(16) | Venue type for the marathon_venues record. |
| altitude_m | integer | Altitude m for the marathon_venues record. |
| capacity | integer | Capacity for the marathon_venues record. |
+4 more columns in marathon_venues. The full schema ships with the download.
marathon_competitions· Rows: 7
| Column | Type | Description |
|---|---|---|
| competition_id | varchar(8) | Stable identifier for competition; use it for declared joins. |
| competition_name | varchar(40) | Human-readable competition name; names are fictional where the disclosure states so. |
| competition_tier | varchar(24) | Competition tier for the marathon_competitions record. |
| venue_id | varchar(8) | Stable identifier for venue; use it for declared joins. |
| country_code | varchar(8) | Stable code for country. |
| surface_or_course | varchar(16) | Surface or course for the marathon_competitions record. |
| recurring_month | integer | Recurring month for the marathon_competitions record. |
+2 more columns in marathon_competitions. The full schema ships with the download.
marathon_events· Rows: 42
| Column | Type | Description |
|---|---|---|
| event_id | varchar(16) | Stable identifier for event; use it for declared joins. |
| competition_id | varchar(8) | Stable identifier for competition; use it for declared joins. |
| session_id | varchar(16) | Stable identifier for session; use it for declared joins. |
| discipline_id | varchar(8) | Stable identifier for discipline; use it for declared joins. |
| event_date | date | event date as an ISO 8601 calendar date. |
| event_round | varchar(16) | Event round for the marathon_events record. |
| gender_class | varchar(16) | Gender class for the marathon_events record. |
+4 more columns in marathon_events. The full schema ships with the download.
marathon_event_entries· Rows: 1,195
| Column | Type | Description |
|---|---|---|
| entry_id | varchar(16) | Stable identifier for entry; use it for declared joins. |
| event_id | varchar(16) | Stable identifier for event; use it for declared joins. |
| athlete_id | varchar(16) | Stable identifier for athlete; use it for declared joins. |
| session_id | varchar(16) | Stable identifier for session; use it for declared joins. |
| entry_rank | integer | Entry rank for the marathon_event_entries record. |
| seed_mark_seconds | numeric(9,3) | seed mark in seconds. |
| lane_or_draw_position | integer | Lane or draw position for the marathon_event_entries record. |
+2 more columns in marathon_event_entries. The full schema ships with the download.
marathon_results· Rows: 1,195
| Column | Type | Description |
|---|---|---|
| result_id | varchar(16) | Stable identifier for result; use it for declared joins. |
| entry_id | varchar(16) | Stable identifier for entry; use it for declared joins. |
| event_id | varchar(16) | Stable identifier for event; use it for declared joins. |
| athlete_id | varchar(16) | Stable identifier for athlete; use it for declared joins. |
| session_id | varchar(16) | Stable identifier for session; use it for declared joins. |
| discipline_id | varchar(8) | Stable identifier for discipline; use it for declared joins. |
| finish_position | integer | Finish position for the marathon_results record. |
+8 more columns in marathon_results. The full schema ships with the download.
marathon_split_metrics· Rows: 10,458
| Column | Type | Description |
|---|---|---|
| split_metric_id | varchar(16) | Stable identifier for split metric; use it for declared joins. |
| result_id | varchar(16) | Stable identifier for result; use it for declared joins. |
| event_id | varchar(16) | Stable identifier for event; use it for declared joins. |
| athlete_id | varchar(16) | Stable identifier for athlete; use it for declared joins. |
| session_id | varchar(16) | Stable identifier for session; use it for declared joins. |
| split_sequence | integer | Split sequence for the marathon_split_metrics record. |
| split_label | varchar(16) | Split label for the marathon_split_metrics record. |
+5 more columns in marathon_split_metrics. The full schema ships with the download.
marathon_performance_metrics· Rows: 1,195
| Column | Type | Description |
|---|---|---|
| performance_metric_id | varchar(16) | Stable identifier for performance metric; use it for declared joins. |
| result_id | varchar(16) | Stable identifier for result; use it for declared joins. |
| athlete_id | varchar(16) | Stable identifier for athlete; use it for declared joins. |
| event_id | varchar(16) | Stable identifier for event; use it for declared joins. |
| session_id | varchar(16) | Stable identifier for session; use it for declared joins. |
| technical_efficiency_score | numeric(6,2) | technical efficiency score as the declared analytical score or index. |
| tactical_execution_score | numeric(6,2) | tactical execution score as the declared analytical score or index. |
+7 more columns in marathon_performance_metrics. The full schema ships with the download.
marathon_rankings· Rows: 4,092
| Column | Type | Description |
|---|---|---|
| ranking_id | varchar(16) | Stable identifier for ranking; use it for declared joins. |
| athlete_id | varchar(16) | Stable identifier for athlete; use it for declared joins. |
| session_id | varchar(16) | Stable identifier for session; use it for declared joins. |
| ranking_date | date | ranking date as an ISO 8601 calendar date. |
| ranking_position | integer | Ranking position for the marathon_rankings record. |
| ranking_points | integer | Ranking points for the marathon_rankings record. |
| rolling_win_or_top_half_pct | numeric(6,2) | rolling win or top half expressed as a percentage. |
+2 more columns in marathon_rankings. The full schema ships with the download.
marathon_training_sessions· Rows: 4,092
| Column | Type | Description |
|---|---|---|
| training_session_id | varchar(16) | Stable identifier for training session; use it for declared joins. |
| athlete_id | varchar(16) | Stable identifier for athlete; use it for declared joins. |
| session_id | varchar(16) | Stable identifier for session; use it for declared joins. |
| training_date | date | training date as an ISO 8601 calendar date. |
| session_type | varchar(32) | Session type for the marathon_training_sessions record. |
| planned_duration_minutes | integer | planned duration in minutes. |
| completed_duration_minutes | integer | completed duration in minutes. |
+4 more columns in marathon_training_sessions. The full schema ships with the download.
marathon_training_loads· Rows: 4,092
| Column | Type | Description |
|---|---|---|
| training_load_id | varchar(16) | Stable identifier for training load; use it for declared joins. |
| training_session_id | varchar(16) | Stable identifier for training session; use it for declared joins. |
| athlete_id | varchar(16) | Stable identifier for athlete; use it for declared joins. |
| session_id | varchar(16) | Stable identifier for session; use it for declared joins. |
| duration_minutes | integer | duration in minutes. |
| session_rpe_1_10 | integer | Session rpe 1 10 for the marathon_training_loads record. |
| workload_units | integer | Workload units for the marathon_training_loads record. |
+6 more columns in marathon_training_loads. The full schema ships with the download.
marathon_wellness· Rows: 4,092
| Column | Type | Description |
|---|---|---|
| wellness_id | varchar(16) | Stable identifier for wellness; use it for declared joins. |
| athlete_id | varchar(16) | Stable identifier for athlete; use it for declared joins. |
| session_id | varchar(16) | Stable identifier for session; use it for declared joins. |
| assessment_date | date | assessment date as an ISO 8601 calendar date. |
| sleep_hours | numeric(4,1) | sleep in hours. |
| sleep_quality_1_10 | integer | Sleep quality 1 10 for the marathon_wellness record. |
| fatigue_1_10 | integer | Fatigue 1 10 for the marathon_wellness record. |
+8 more columns in marathon_wellness. The full schema ships with the download.
marathon_physical_assessments· Rows: 682
| Column | Type | Description |
|---|---|---|
| physical_assessment_id | varchar(16) | Stable identifier for physical assessment; use it for declared joins. |
| athlete_id | varchar(16) | Stable identifier for athlete; use it for declared joins. |
| session_id | varchar(16) | Stable identifier for session; use it for declared joins. |
| assessment_date | date | assessment date as an ISO 8601 calendar date. |
| body_fat_pct | numeric(5,1) | body fat expressed as a percentage. |
| vo2max_ml_kg_min | numeric(5,1) | Vo2max ml kg min for the marathon_physical_assessments record. |
| counter_movement_jump_cm | numeric(5,1) | counter movement jump in centimetres. |
+5 more columns in marathon_physical_assessments. The full schema ships with the download.
marathon_injuries· Rows: 50
| Column | Type | Description |
|---|---|---|
| injury_id | varchar(16) | Stable identifier for injury; use it for declared joins. |
| athlete_id | varchar(16) | Stable identifier for athlete; use it for declared joins. |
| session_id | varchar(16) | Stable identifier for session; use it for declared joins. |
| injury_date | date | injury date as an ISO 8601 calendar date. |
| body_region | varchar(16) | Body region for the marathon_injuries record. |
| injury_type | varchar(24) | Injury type for the marathon_injuries record. |
| severity_band | varchar(16) | Severity band for the marathon_injuries record. |
+5 more columns in marathon_injuries. The full schema ships with the download.
marathon_treatments· Rows: 150
| Column | Type | Description |
|---|---|---|
| treatment_id | varchar(16) | Stable identifier for treatment; use it for declared joins. |
| injury_id | varchar(16) | Stable identifier for injury; use it for declared joins. |
| athlete_id | varchar(16) | Stable identifier for athlete; use it for declared joins. |
| session_id | varchar(16) | Stable identifier for session; use it for declared joins. |
| treatment_date | date | treatment date as an ISO 8601 calendar date. |
| treatment_type | varchar(32) | Treatment type for the marathon_treatments record. |
| provider_role | varchar(24) | Provider role for the marathon_treatments record. |
+3 more columns in marathon_treatments. The full schema ships with the download.
marathon_equipment· Rows: 341
| Column | Type | Description |
|---|---|---|
| equipment_id | varchar(16) | Stable identifier for equipment; use it for declared joins. |
| athlete_id | varchar(16) | Stable identifier for athlete; use it for declared joins. |
| session_id | varchar(16) | Stable identifier for session; use it for declared joins. |
| equipment_category | varchar(32) | Equipment category for the marathon_equipment record. |
| brand_reference | varchar(16) | Brand reference for the marathon_equipment record. |
| model_family | varchar(16) | Model family for the marathon_equipment record. |
| fit_or_setup_code | varchar(16) | Stable code for fit or setup. |
+5 more columns in marathon_equipment. The full schema ships with the download.
marathon_travel· Rows: 1,195
| Column | Type | Description |
|---|---|---|
| travel_id | varchar(16) | Stable identifier for travel; use it for declared joins. |
| athlete_id | varchar(16) | Stable identifier for athlete; use it for declared joins. |
| event_id | varchar(16) | Stable identifier for event; use it for declared joins. |
| session_id | varchar(16) | Stable identifier for session; use it for declared joins. |
| origin_country_code | varchar(8) | Stable code for origin country. |
| destination_country_code | varchar(8) | Stable code for destination country. |
| distance_km | integer | distance in kilometres. |
+5 more columns in marathon_travel. The full schema ships with the download.
marathon_athlete_financials· Rows: 341
| Column | Type | Description |
|---|---|---|
| athlete_financial_id | varchar(16) | Stable identifier for athlete financial; use it for declared joins. |
| athlete_id | varchar(16) | Stable identifier for athlete; use it for declared joins. |
| session_id | varchar(16) | Stable identifier for session; use it for declared joins. |
| prize_money_eur | numeric(11,2) | prize money in euros. |
| appearance_fees_eur | numeric(10,2) | appearance fees in euros. |
| sponsorship_income_eur | numeric(11,2) | sponsorship income in euros. |
| coaching_cost_eur | numeric(9,2) | coaching cost in euros. |
+7 more columns in marathon_athlete_financials. The full schema ships with the download.
marathon_record_benchmarks· Rows: 1
| Column | Type | Description |
|---|---|---|
| record_benchmark_id | varchar(8) | Stable identifier for record benchmark; use it for declared joins. |
| discipline_id | varchar(8) | Stable identifier for discipline; use it for declared joins. |
| gender_class | varchar(16) | Gender class for the marathon_record_benchmarks record. |
| record_scope | varchar(32) | Record scope for the marathon_record_benchmarks record. |
| performance_seconds | integer | performance in seconds. |
| record_date | date | record date as an ISO 8601 calendar date. |
| record_location | varchar(16) | Record location for the marathon_record_benchmarks record. |
+6 more columns in marathon_record_benchmarks. The full schema ships with the download.
marathon_prediction_features· Rows: 1,195
| Column | Type | Description |
|---|---|---|
| prediction_feature_id | varchar(16) | Stable identifier for prediction feature; use it for declared joins. |
| athlete_id | varchar(16) | Stable identifier for athlete; use it for declared joins. |
| event_id | varchar(16) | Stable identifier for event; use it for declared joins. |
| session_id | varchar(16) | Stable identifier for session; use it for declared joins. |
| feature_source_cutoff | date | Latest source date available to this feature row; it is strictly earlier than the target event or period when history exists. |
| ranking_before_event | integer | Ranking before event for the marathon_prediction_features record. |
| rolling_form_score | numeric(6,2) | rolling form score as the declared analytical score or index. |
+8 more columns in marathon_prediction_features. The full schema ships with the download.
marathon_performance_predictions· Rows: 1,195
| Column | Type | Description |
|---|---|---|
| performance_prediction_id | varchar(16) | Stable identifier for performance prediction; use it for declared joins. |
| prediction_feature_id | varchar(16) | Stable identifier for prediction feature; use it for declared joins. |
| athlete_id | varchar(16) | Stable identifier for athlete; use it for declared joins. |
| event_id | varchar(16) | Stable identifier for event; use it for declared joins. |
| session_id | varchar(16) | Stable identifier for session; use it for declared joins. |
| prediction_created_on | date | prediction created on as an ISO 8601 calendar date. |
| model_version | varchar(32) | Model version for the marathon_performance_predictions record. |
+9 more columns in marathon_performance_predictions. The full schema ships with the download.
marathon_course_segments· Rows: 252
| Column | Type | Description |
|---|---|---|
| course_segment_id | varchar(16) | Stable identifier for course segment; use it for declared joins. |
| event_id | varchar(16) | Stable identifier for event; use it for declared joins. |
| session_id | varchar(16) | Stable identifier for session; use it for declared joins. |
| segment_number | varchar(8) | Segment number for the marathon_course_segments record. |
| segment_start_km | numeric(7,3) | segment start in kilometres. |
| segment_end_km | numeric(7,3) | segment end in kilometres. |
| elevation_gain_m | integer | Elevation gain m for the marathon_course_segments record. |
+5 more columns in marathon_course_segments. The full schema ships with the download.
marathon_aid_station_passages· Rows: 4,648
| Column | Type | Description |
|---|---|---|
| aid_station_passage_id | varchar(16) | Stable identifier for aid station passage; use it for declared joins. |
| result_id | varchar(16) | Stable identifier for result; use it for declared joins. |
| event_id | varchar(16) | Stable identifier for event; use it for declared joins. |
| athlete_id | varchar(16) | Stable identifier for athlete; use it for declared joins. |
| session_id | varchar(16) | Stable identifier for session; use it for declared joins. |
| station_km | integer | station in kilometres. |
| passage_seconds | numeric(9,3) | passage in seconds. |
+6 more columns in marathon_aid_station_passages. The full schema ships with the download.
Sample Data
A snapshot of real rows from the dataset (values are fully synthetic).
| result_id | entry_id | event_id | athlete_id | session_id | discipline_id | finish_position | result_status | official_time_seconds | ranking_points | personal_best_flag | season_best_flag |
|---|---|---|---|---|---|---|---|---|---|---|---|
| RES0000009 | ENT0000009 | EVT01002 | MPLY0092 | SES2015 | DSP002 | 1 | finished | 5077.462 | 1205 | false | true |
| RES0000010 | ENT0000010 | EVT01002 | MPLY0064 | SES2015 | DSP002 | 2 | finished | 5348.57 | 1180 | false | true |
| RES0000011 | ENT0000011 | EVT01002 | MPLY0022 | SES2015 | DSP002 | 3 | finished | 5559.595 | 1162 | false | true |
Version History
| v1.0.0 | 2026-08-11 | First release with complete relational coverage, deterministic generation, documentation, SQL, JSON, CSV and API schema. |
Related Datasets
Basketball Club Analytics Set (EU)
Sports & Athlete PerformanceA complete synthetic European basketball-club warehouse covering eleven seasons of games, play-by-play, shots, tactics, rotations, athlete condition, prediction, roster movement and finance.
$299one time
View details Football Club Analytics Set (EU)
Sports & Athlete PerformanceA complete synthetic Italian football-club data warehouse covering eleven seasons of matches, tactics, players, training, medical load, predictions, salaries and club finance.
$349one time
View details Sprint Running Athlete Analytics Set (WW)
Sports & Athlete PerformanceA complete worldwide sprint athlete warehouse for short sprint, half-lap and full-lap races, with starts, splits, weather, training, health and prediction.
$169one time
View details