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

62,816

Locations

5

Years

14

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
Peter Vaughan 69 0 69 1989 2024
Peter Bilos 67 0 67 1992 2025
Allan John Moustoukas 33 26 59 2005 2026
David Arnold 33 20 53 2004 2025
Terry Roberts 28 25 53 2001 2023
Shirley Rolston 39 13 52 1999 2026
Anton Kapel 42 7 49 2001 2025
John Hill 30 19 49 2005 2025
Tony Suters 36 13 49 1995 2024
Rob Howitt 34 12 46 1989 2020

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
Ron Skelton Taupo IM 23 2004 2026
Philip O'Toole Taupo IM 22 2003 2026
Shirley Rolston Taupo IM 21 1999 2021
Anton Kapel Western Australia IM 20 2004 2025
Bob Scammell Forster IM 20 1985 2005
Dave ROSS Forster IM 19 1985 2004
Adam Holmes Taupo IM 18 2007 2026
Peter Bilos Western Australia IM 18 2004 2025
Cameron Brown Taupo IM 18 2003 2023
Robert DAVIDSON Forster IM 18 1987 2004

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
2021 Western Australia IM 609 393 216 35.5%
2022 Taupo IM 563 408 155 27.5%
2023 Taupo IM 969 703 266 27.5%
2021 Cairns IM 1,492 1,096 396 26.5%
2020 Cairns IM 289 215 74 25.6%
2022 Cairns IM 1,243 928 315 25.3%
2022 Port Macquarie IM 1,368 1,060 308 22.5%
2025 Cairns IM 1,188 924 264 22.2%
2014 Western Australia IM 1,699 1,330 369 21.7%
2022 Western Australia IM 1,355 1,075 280 20.7%

Participation trend

Result Count Trend

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

Latest year 2026 · 2.4K
Peak year 2014 · 8.5K
Locations represented 5

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 Cairns 14861 results
2 Australia 14667 results
3 New Zealand 14623 results
4 Western Australia 14317 results
5 Melbourne 4348 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 12:20:46
Fastest median 10:03:59
Years with medians 42