STAGING Shared staging · PR #192 · commit 60041e469b3a · production is unchanged until explicitly approved

v2 Public DB

Trends

Explore participation, finish-time, and club-participation patterns in the public dataset with grouped Location filters, race type labels, and chart panels tuned for quick comparison.

Median times in HH:MM:SS Aquabike excluded by default
Type IM

Results

2

Locations

1

Years

1

Type context

IM

Location context

All locations

Filter trends

Year, type, and Location filters use the same grouped display labels as the rest of v2. Query values stay stable while visible labels remain readable.

Reset filters
Reset filters

Athlete trend

Unique athletes by year

Distinct athlete IDs by year from summary_athlete_year_type. Total is the precomputed eligible total row, deduped across IM and 70.3.

Unique athletes are distinct athlete IDs. Total is not calculated by adding IM and 70.3.

Athlete trend

First recorded athletes by year

Athletes first recorded in this dataset by year. This is the first time they appear in the current public dataset, not necessarily their first race ever.

Series use IM, 70.3, and deduped Total counts from the yearly athlete summary.

Repeat athletes

Repeat-race distribution

Shows how many athletes have finished 1, 2, 3, 4, 5, 6-9, or 10+ eligible races in the dataset.

Finished eligible races only. Eligible types are IM and 70.3. Athlete groups are mutually exclusive: 70.3 only, IM only, and Both IM and 70.3.

Finish-time percentiles

Finish-time trend — 70.3

Fast group = 10th percentile. Median = 50th percentile. Slow group = 90th percentile. Finish-time summaries use recorded result data; modified events may affect comparisons.

Finish-time percentiles

Finish-time trend — IM

Fast group = 10th percentile. Median = 50th percentile. Slow group = 90th percentile. Finish-time summaries use recorded result data; modified events may affect comparisons.

Repeat athletes

Most Finishes

Leaderboard of athletes with the most finished eligible races. Totals come from the precomputed eligible Total count, with IM and 70.3 shown beside it.

Athlete IM 70.3 Total First year Latest year
Aqua Athlete 3 2 5 2020 2025
Club Runner 1 3 4 2022 2025

Location repeaters

Location Legends

Location Legends are athletes with repeated finishes at the same location and event type.

Athlete Location Type Finishes First year Latest year
Aqua Athlete Western Australia IM 3 2020 2025
Club Runner Melbourne 70.3 3 2022 2024

Event outcomes

Highest non-finisher events

Ranked by non-finisher rate for events with at least 100 results.

Year Location Type Results Finishers Non-finishers Non-finisher rate
2025 Western Australia IM 200 175 25 12.5%

Participation trend

Result Count Trend

Result volume represented by the current filters. This chart reflects summary rows, not unique athletes.

Latest year 2025 · 2
Peak year 2025 · 2
Locations represented 1

Definitions

Trend notes

Short definitions for how the public trend summaries are derived.

  • Participation and result count mean race results for the current filters unless otherwise labelled.
  • Median finish time uses recorded finish data; modified events may affect comparisons.
  • Times are shown as HH:MM:SS.
  • Aqua Bike is excluded from default trend views unless you explicitly select it.

Coverage

Top locations

Locations with the most results in the current trend filters.

1 Western Australia 2 results

Finish-time trend

Median Finish Trend — IM

Median recorded finish times by year for the selected type and current trend filters. Times remain formatted as HH:MM:SS.

Latest median 09:45:00
Fastest median 09:45:00
Years with medians 1