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").