Olympic Medal & Event Results Tables

Collect Olympic medal tables and event-level podium rows in clean datasets for dashboards, research, editorial checks, rankings, and sports-data workflows.

This Actor returns more than a country medal table. It creates the default event-medal dataset, plus datasets for country totals, sport-by-country totals, country event breakdowns, optional team-member rows, and optional full event standings.

What does Olympic Medal & Event Results Tables do?

It reads Olympic Games result pages and turns medal information into structured rows. Choose a Games edition such as Paris 2024, Tokyo 2020, or Beijing 2022, then filter by country, sport, medal type, and event limit.

Core outputs:

Dataset	What it contains	When to use it
eventMedals	One row for each medal awarded in each event	Podium analysis, athlete/event lookup, medal validation
countryMedalTable	Gold, silver, bronze, total, and rank by country	Leaderboards and country dashboards
sportMedalTable	Medal totals by sport and country	Sport-specific country performance comparisons
countryEventBreakdown	Country medals split by sport and event	National team reports and event-level auditing
teamMembers	Athlete rows for medal-winning team events	Team roster enrichment when enabled
eventStandings	Full standings rows from selected event detail pages	Deeper event research when enabled

The default workflow is medal-focused. Optional detail modes open event pages and are slower because they collect granular athlete and standing data.

Why use Olympic Medal & Event Results Tables?

Use it when you need repeatable Olympic data extraction without hand-copying historical tables.

• Build a country medal dashboard for one Olympic Games edition.
• Compare one country across sports and events.
• Pull podium rows for a specific sport such as Athletics, Swimming, Judo, or Cycling Track.
• Create editorial fact-checking sheets for medal counts and medalists.
• Append run results into an existing Apify dataset for larger sports-data pipelines.
• Keep a workflow trace by passing your own runId into every output row.

How do I run Olympic Medal & Event Results Tables?

1. Choose the Olympic Games edition in games.
2. Leave sport and country empty for a full-edition medal export, or set one or both filters for a smaller run.
3. Keep medals set to all three medal types unless you only need gold, silver, or bronze rows.
4. Set maxEvents to control the size of the default event-medal export.
5. Enable includeTeamMembers or includeFullEventStandings only when you need detail-page data.
6. Read the default dataset for event medals and the named datasets from the Actor output object.

For a quick test, use one country and a low maxEvents value.

{
  "games": "Paris 2024",
  "country": "USA",
  "sport": "Athletics",
  "medals": ["gold", "silver", "bronze"],
  "maxEvents": 25,
  "includeTeamMembers": false,
  "includeFullEventStandings": false,
  "maxEventDetails": 10
}

What input does Olympic Medal & Event Results Tables accept?

Field	Type	Default	Description
games	string	Paris 2024	Olympic Games edition. Examples: Paris 2024, Tokyo 2020, Beijing 2022, London 2012.
country	string	empty	Optional country name or NOC code. Examples: USA, Portugal, France, Brazil. Empty returns all countries.
sport	string	empty	Optional sport or discipline from the dropdown. Empty means all sports for the selected Games.
medals	array	all medals	Medal types to include: gold, silver, bronze.
maxEvents	integer	400	Maximum medal events after filters. Range: 1 to 500.
includeTeamMembers	boolean	false	Opens detail pages to collect team-member rows for medal-winning team events.
includeFullEventStandings	boolean	false	Opens detail pages to collect full standings rows, not only podium medals.
maxEventDetails	integer	25	Maximum event detail pages to open when either detail mode is enabled. Range: 1 to 100.
datasetId	string	empty	Optional existing Apify dataset ID that receives copies of default event-medal rows with entityType.
runId	string	empty	Optional workflow identifier copied into output rows for joins, audits, and parent runs.

Country filtering matches NOC codes and country names. Sport filtering matches the parsed sport label, so a dropdown value such as Athletics is safer than free-form text.

What data does Olympic Medal & Event Results Tables return?

The default dataset contains one row per medal in an event.

{
  "games": "Paris 2024",
  "editionYear": 2024,
  "season": "summer",
  "sport": "Athletics",
  "eventName": "100 metres, Men",
  "eventGender": "men",
  "medal": "gold",
  "medalRank": 1,
  "countryCode": "USA",
  "countryName": "United States",
  "medalistName": "Noah Lyles",
  "teamEvent": false,
  "runId": "weekly-olympic-report"
}

Named datasets are returned in the Actor output object:

{
  "eventMedals": "https://api.apify.com/v2/datasets/default/items",
  "countryMedalTable": "https://api.apify.com/v2/datasets/countryMedalTable/items",
  "sportMedalTable": "https://api.apify.com/v2/datasets/sportMedalTable/items",
  "countryEventBreakdown": "https://api.apify.com/v2/datasets/countryEventBreakdown/items",
  "teamMembers": "https://api.apify.com/v2/datasets/teamMembers/items",
  "eventStandings": "https://api.apify.com/v2/datasets/eventStandings/items"
}

teamMembers and eventStandings may be empty when the matching detail mode is disabled or a result page lacks a supported detail table.

How can I integrate Olympic Medal & Event Results Tables?

Run the Actor through the API, then read the dataset URLs returned in the output object.

curl "https://api.apify.com/v2/acts/trovevault~olympic-medal-event-results-tables/runs" \
  -H "Authorization: Bearer $APIFY_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{
    "games": "Paris 2024",
    "country": "USA",
    "sport": "Athletics",
    "maxEvents": 25,
    "runId": "weekly-olympic-report"
  }'

To append event-medal rows into an existing dataset, pass datasetId. The Actor still writes the normal default dataset and named datasets, then also writes default event-medal rows into your target dataset with an entityType value.

{
  "games": "Paris 2024",
  "country": "Portugal",
  "datasetId": "YOUR_DATASET_ID",
  "runId": "portugal-olympic-medals-2024"
}

How much does Olympic Medal & Event Results Tables cost?

The Actor uses Apify pay-per-event pricing. Cost depends on run size and optional detail-page collection:

Choice	Effect on runtime and volume
Full Games export	More events and more default dataset rows
Country or sport filter	Smaller run and fewer rows
includeTeamMembers	More requests for team-event detail pages
includeFullEventStandings	More requests and more rows from selected event pages
Higher maxEventDetails	More detail pages when detail modes are enabled

For predictable test runs, filter by one country or one sport and keep maxEventDetails low.

How do I troubleshoot Olympic Medal & Event Results Tables?

Issue	Likely cause	Solution
No rows in the default dataset	The country, sport, or medal filters removed all events	Run the same Games with empty country and sport, then add one filter at a time
Fewer events than expected	maxEvents stops processing after the requested number of matching events	Increase maxEvents up to 500 or split runs by sport/country
Team members dataset is empty	includeTeamMembers is off, or matched medals are not team events	Enable includeTeamMembers and test with a known team sport such as football or basketball
Full standings are missing	includeFullEventStandings is off, or the event detail page lacks a supported standings table	Enable the option and reduce filters to a known event before scaling
Run is slower than the basic medal table	Detail modes open event pages with a polite delay	Lower maxEventDetails, disable unused detail modes, or run detail collection separately
Country name looks like a NOC code	The code has no local country-name mapping for that NOC	Keep countryCode as the stable join key and enrich country names downstream if needed

Is it legal to use Olympic Medal & Event Results Tables?

This Actor collects publicly accessible sports result pages. You are responsible for using the data in a way that fits your jurisdiction, source terms, and internal rules.

Olympic Medal & Event Results Tables FAQ

Can I collect every Olympic Games at once?
No. Run one Games edition at a time, then merge datasets downstream if you need a multi-Games warehouse.

Can I filter by both sport and country?
Yes. For example, use sport: "Swimming" and country: "AUS" to return Australian swimming medal rows for the selected Games.

Does the Actor return athlete rows for every team event by default?
No. Enable includeTeamMembers to fetch team-member rows. This opens event pages and makes runs slower.

Does the default dataset include country medal-table rows?
No. The default dataset contains event-medal rows. Country, sport, country-event, team-member, and standings data are exposed through named datasets in the Actor output.

What should I use as a stable country key?
Use countryCode when joining datasets. countryName is useful for display, but NOC codes are better for repeatable analysis.