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 70.3

Results

61,771

Locations

10

Years

8

Type context

70.3

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
2014 Geelong 70.3 1,146 723 423 36.9%
2022 Western Sydney 70.3 1,272 825 447 35.1%
2022 Taupo 70.3 1,201 793 408 34.0%
2022 Melbourne 70.3 1,763 1,205 558 31.6%
2021 Cairns 70.3 1,238 874 364 29.4%
2022 Port Macquarie 70.3 1,148 822 326 28.4%
2021 Melbourne 70.3 1,628 1,172 456 28.0%
2021 Western Australia 70.3 888 644 244 27.5%
2023 Taupo 70.3 795 579 216 27.2%
2022 Sunshine Coast 70.3 2,028 1,487 541 26.7%

Participation trend

Result Count Trend

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

Latest year 2026 · 5.7K
Peak year 2023 · 11.8K
Locations represented 10

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 9280 results
2 Sunshine Coast 9122 results
3 Geelong 8461 results
4 Melbourne 8144 results
5 Western Sydney 6736 results
6 New Zealand 6395 results

Finish-time trend

Median Finish Trend — 70.3

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

Latest median 05:47:18
Fastest median 05:11:44
Years with medians 26