Why did you migrate from OECD.Stat (the OECD's data dissemination platform until July 2024) to OECD Data Explorer?
We transitioned from OECD.Stat to the OECD Data Explorer in an effort to improve usability. Many users found the previous platform challenging to navigate and had difficulties mastering excessive features, making it harder to find, understand and use the data for which they were looking. The new platform, built with SDMX standards, offers a more intuitive design focusing on search, while maintaining key functionalities. For more details, you can read about the background and main objectives here.
How do I find the dataset that I used to access in OECD.Stat in OECD Data Explorer?
A complete list of the migrated dataset can be found this Excel file. The file has two tabs: one for currently updated datasets ("CurrentMappingDatasets") and another for archived datasets ("CurrentMappingArchive").
After the migration, my API queries no longer work, what do I do?
On July 1st, 2024, the OECD.Stat servers (the former OECD data dissemination platform) were taken offline, meaning queries to http://stats.oecd.org no longer work. Please refer to this document to update your API queries. A mapping of all OECD.Stat datasets to their corresponding OECD Data Explorer versions is available here.
I find it difficult to apply filters to my data. I must click items one by one, is there an easier way to make my data selection?
Please use the advanced selection modes to improve your filtering experience. To access the advanced selection mode, please click the four arrows icon in the filter menu on the left-hand side of the screen.
A pop-up window will appear, enabling you to choose from various selection options.
How do I extract data via API using R or Python?
R Example: Download CSV Data from API
This example shows how to download and read a CSV file as a DataFrame in R, including labels and Series IDs, directly from the API.
url= "https://sdmx.oecd.org/public/rest/data/OECD.SDD.STES,DSD_STES@DF_CLI/.M.LI...AA...H?startPeriod=2023-02&dimensionAtObservation=AllDimensions&format=csvfilewithlabels"
df<-read.csv(url)
Python Example: Download CSV Data from API
This example shows how to download and read a CSV file as a DataFrame in Python, including labels and Series IDs, directly from the API.
import pandas as pd
url = 'https://sdmx.oecd.org/public/rest/data/OECD.SDD.STES,DSD_STES@DF_CLI/.M.LI...AA...H?startPeriod=2023-02&dimensionAtObservation=AllDimensions&format=csvfilewithlabels' df = pd.read_csv(url)
Learn more about downloading data through the API
How do I save my queries?
- Run your query and customize the data as needed
- Bookmark the generated URL in your web browser
How can the OECD Data Explorer datasets be cited in a publication?
Currently, the OECD Data Explorer does not have a built-in citation functionality.
However, to make it easier for you to reference data in your work, you can generate a short URL that links directly to your query. Here's how:
- Create a MyOECD account: Sign up here.
- Log in to the OECD Data Explorer: Click on the avatar icon and log in using your MyOECD credentials.
- Generate a short URL: After completing your data selection, click the Share icon at the top of the data table, then select Generate short URL. Make sure to copy and save the URL, as it cannot be retrieved later from your MyOECD account.
I find OECD Data Explorer rather slow. When will the site become more responsive?
At the moment, the system is regularly experiencing diminished performance due to a high number of user requests. We have made this our top priority and our technical team is actively working on improvements. Progress has already been made, but these improvements may take some time to fully implement. We expect to see significant performance gains over the coming months.