Join Curt Frye for an in-depth discussion in this video Organization for Economic Cooperation and Development, part of Learning Public Data Sets.
- The Organisation for Economic Co-operation and Development or OECD, is an international organization that promotes policies to improve the economic and social well-being of people around the world. Data gathering in foreign policy creation and evaluation, of course, so the OECD shares their data online for free. The URL for this website is data.oecd.org. The search and browse controls are prominently available at the top of the page but I'll save them for a moment, and I'll show you that down to the right you can see the latest news releases, the statistical news releases here, you can also get database access, querying databases, using statistical tools, and looking inside the Data Lab.
And over on the side you can see a number of featured charts, those are here on the left. But now let's save that, I want to search. Say I want to search by country and from the list of countries that is presented I'll click Portugal, and from the list that appears let's say that I'm interested in the Gross Domestic Product per Capita. You can see that's 27,804, and there's other data available as well.
And if I scroll down I can see agricultural items such as the Land Area, the Amount of Support, and Crop Production. And just as an example, if I click Crop Production I'll see a chart with Portuguese Crop Production as compared to other OECD markets. Now go back to the main page. So I'll click the back button a couple of times, but instead of browsing by country I'll browse by topic.
So I click Topic and I'll scroll down and click Energy. Let's say I'm interested in Renewable energy, and so I'll scroll down and there is a Renewable energy indicator so I'll click that, and as I look at the chart I can get readings on the amount or percentage of total energy generation from Renewable energy. And I can see that in some markets that's as high as 80-85%, that's in Iceland, and the numbers are significantly lower.
For example, Portugal has only 21%, the OECD as a whole only averages about 8.5%. I can also display this data as either a map by clicking that tab and I get different size indicators, or I can also display it as a table. If I want to download the data all I need to do is click the download button and it's downloaded and displayed on my browser's taskbar.
And, of course, it's also available in my Operating System's download folder, and I can open the file normally. The OECD site makes searching pretty straightforward. If you have an idea of what you're looking for, even a broad general category or country, then it's usually pretty easy to find what you're looking for.
- Working with US census data
- Using data from the Securities and Exchange Commission
- Accessing data from other US agencies
- Finding international sources of data
- Gathering data from web-based search engines and data portals
- Visualizing and analyzing public data sets in Excel