The World Athletics website has various types of data that can be viewed. This website has scripts that run every month, to collect new data that is loaded into our MySQL database. The tables and charts shown here are then based on SQL queries of that data.

Championships

We gather the {championshipId} and other data about the Championships (dates, venue etc) for the following types of Championships (Olympic, World, Area), using the URLs below. We store the gathered data in our Championships table.
Olympics and World Championships, World U20, World U18
Africa, Africa U23, Africa U20, Africa U18
Asia, Asia U23, Asia U20, Asia U18
Europe, Europe U23, Europe U20, Europe U18
North and Central America, North and Central America U23, North and Central America U20, North and Central America U18
Oceania, Oceania U23, Oceania U20, Oceania U18
South America, South America U23, South America U20, South America U18
Commonwealth Games

Championship Events

For each {championshipId} we gather the {eventID} of the different events that took place at that Championship.  We store the gathered data in our Championships-EventID table.

The URL is in the form https://worldathletics.org/competition/calendar-results/results/{$championshipId}.

For example: https://worldathletics.org/competition/calendar-results/results/7137279

Results

For each {championshipId} and each {eventID} that took place at that Championship, we gather the results (heats and finals). We store the gathered data in our Championships-EventID-Results table.

The URL is in the form https://worldathletics.org/competition/calendar-results/results/{$championshipId}?eventId={$eventID}&gender=M

For example: https://worldathletics.org/competition/calendar-results/results/7137279?eventId=10229636&gender=M

Athletes

Each Results record contains a {competitorUrlSlug} that is a unique identifier for the athletes in the results. The {competitorUrlSlug} is made up from /country/surname-givenname-aaID - both the {competitorUrlSlug} and the {aaID} are unique identifiers.

For each {aaID} that was in a final, we gather the basic data (name, country, data of birth). We store the gathered data in our Athlete table.

The URL is in the form https://worldathletics.org/athletes/athlete={$aaID}.

For example: https://worldathletics.org/athletes/athlete=14679502

Additional Tables - Events

We have our own table, using all the {eventID} that have taken place, recording against each information about that sort of event (e.g. "is it measured in distance or time") and for {eventID} that are specific to certain ages we record what that event becomes for seniors (e.g. 10229686 = "Discus Throw (1.75kg)" becomes 10229620 = "Discuss Throw").