Hamburg Data Updates

Data from the 2015 ITU World Triathlon Hamburg event has now been added to the Statistics API database.

The race was notable for the fastest ever run split in a Sprint distance format race by Mario Mola with 13:55. To obtain this result the query can be approached in one of two ways. Firstly you could query the minimum run time and group by event.name and then find the minimum result from the list:

curl --header "apikey: YOUR_APP_KEY" "https://proxy.api.triathlon.org/v1/statistics/results?analysis=minimum&target_property=splits.run&filters=format,eq,Sprint&group_by=event.name

1629 — Mario's run split was the fastest ever over a Sprint distance format in WTS history

Which returns the following list of the minimum run times from all sprint distance events (in seconds). From the result we can determine that the 835 second split in Hamburg 2015 was the fastest ever run split and can then query the results for additional information.

{
   "code":200,
   "status":"success",
   "data":[
      {
         "event.name":"2011 Lausanne ITU Elite Sprint Triathlon World Championships",
         "result":864
      },
      {
         "event.name":"2012 Dextro Energy World Triathlon Hamburg",
         "result":845
      },
      {
         "event.name":"2012 ITU World Triathlon Stockholm",
         "result":839
      },
      {
         "event.name":"2013 ITU World Triathlon Hamburg",
         "result":854
      },
      {
         "event.name":"2014 ITU World Triathlon Hamburg",
         "result":849
      },
      {
         "event.name":"2014 ITU World Triathlon London",
         "result":858
      },
      {
         "event.name":"2014 ITU World Triathlon Stockholm",
         "result":859
      },
      {
         "event.name":"2015 ITU World Triathlon Abu Dhabi",
         "result":843
      },
      {
         "event.name":"2015 ITU World Triathlon Hamburg",
         "result":835
      },
      {
         "event.name":"2015 ITU World Triathlon London",
         "result":852
      }
   ]
}

Alternatively, combining two queries we can arrive at the same result. Firstly, find the minimum run split:

curl --header "apikey: YOUR_APP_KEY" "https://proxy.api.triathlon.org/v1/statistics/results?analysis=minimum&target_property=splits.run&filters=format,eq,Sprint"

Which simply returns the minimum i.e. fastest run time.

{  
   "code":200,
   "status":"success",
   "data":835
}

Then make a query to find additional information by using the run time as a filter and multiple group by requests to extract the information required (note if this time had occurred more than once then the result would simply be an array of all the times this had happened).

curl --header "apikey: YOUR_APP_KEY" "https://proxy.api.triathlon.org/v1/statistics/results?analysis=minimum&target_property=position&filters=splits.run,eq,835&group_by=event.name|athlete.name|finish_time|date|splits.run"

As expected this returns Mario's result from Hamburg 2015.

{  
   "code":200,
   "status":"success",
   "data":[  
      {  
         "splits.run":835,
         "finish_time":3140,
         "athlete.name":"Mario Mola",
         "result":3,
         "date":"2015-07-18T17:46:00+0000",
         "event.name":"2015 ITU World Triathlon Hamburg"
      }
   ]
}

Changelog

added: 2015 ITU World Triathlon Hamburg Data
added: