OECD, EU28, G20 Population and Demographic Indicators

Free
National Statistics
tick

Annual Data

tick

Updated Annually

tick

> 1960

tick

53 Countries

tick

Worldwide

Summary

Historical demographic indicators for more than 50 countries (OECD + 16)

This is a sample visualization of a small subset of this data product.
Loading...
Charts of OECD, EU28, G20 Population and Demographic Indicators

Key Features

  • Historical data goes back to 1960
  • OECD Members + 16 Countries are Covered
  • Key population indicators

Documentation

Applications

  • Population forecast
  • Country benchmark and segmentation applications
  • Demographic analysis of countries
  • Investment decision support

Overview

This DATA product provides annual population data since 1960 by sex and important breakdowns such as working population, young population, elderly population, and fertility rate. The data is available for 52 countries in total including the OECD member countries as well as for the European Unions, and G20 countries, Colombia, Costa Rica, Singapore and the World total.

Population projections are a common demographic tool. They provide a basis for other statistical projections, helping governments in their decision making.

These demographic trends have a number of implications for government and private spending on pensions, health care, and education and, more generally, for economic growth and welfare.

Coverage

Indicators

  • Men and women population
  • Fertility rates
  • Working population percent
  • Elderly population percent
  • Young population percent

Countries

Here is the country list for this data product: Country List

The table shows the country coverage of the product as of 2019:

World Population Data Product Coverage Coverage %
7,632.82 4,915.46 %64

With the standard country codes, you can merge this data with other national statistics, create
visual dashboards and benchmark countries.

Data Sources

OECD, United Nations, World Bank and various sources for country attributes

Dictionary

Filter
Column
Title
Data Type
Description
yearYearDateReported year of the statistical data
iso_alpha2_codeISO Alpha-2 CodeTextTwo-letter country codes defined in ISO 3166-1, part of the ISO 3166 standard published by the International Organization for Standardization (ISO), to represent countries, dependent territories, and special areas of geographical interest
iso_alpha3_codeISO Alpha-3 CodeTextThree-letter country codes defined in ISO 3166-1, part of the ISO 3166 standard published by the International Organization for Standardization (ISO), to represent countries, dependent territories, and special areas of geographical interest
location_nameLocation NameTextStandard country names used by the United Nations Statistics Division
location_short_nameLocation Short NameTextPrimary name of the location used by Altadata
parent_location_nameParent Location NameTextName of the parent location ("parent" means the upper level from the hierarchical point of view, like a parent location for a subregion can be a region)
geo_region_nameGeographic Region NameTextName of the geographical region (countries and areas are grouped geographically into six regions by UNSD: Africa; Asia; Europe; Latin America and the Caribbean; Northern America, and Oceania
least_less_developed_regions_flagLeast / Less Developed Regions FlagTextFlag indicating if it is a least or less developed country (The designation "less developed" and "least developed" regions are intended for statistical purposes and do not express a judgment about the stage reached by a particular country or area in the development process. - The group of least developed countries includes 47 countries: 32 in Sub-Saharan Africa, 2 in Northern Africa and Western Asia, 4 in Central and Southern Asia, 4 in Eastern and South-Eastern Asia, 1 in Latin America and the Caribbean, 4 in Oceania - Other less developed countries comprise the less developed regions excluding the least developed countries)
lldc_sids_flagLLDC / SIDS FlagTextFlag indicating if it is a LLDC (Landlocked Developing Country) or SIDS (Small Island Developing States) - The United Nations LLDC term describes countries with serious constraints on the overall socio-economic development. Due to lack of territorial access to the sea and therefore remoteness and isolation from world markets causing high transit and transportation costs. - SIDS are a group of small island countries that tend to share similar sustainable development challenges, including small but growing populations, limited resources, remoteness, susceptibility to natural disasters, vulnerability to external shocks, excessive dependence on international trade, and fragile environments.)
wb_income_groupWorld Bank Income GroupTextThe country classification by income level based on per capita from the World Bank
tot_pop_less_than_90kTotal Population Less Than 90kBooleanYes/No flag to indicate countries with total population less than 90k
member_euEU Membership FlagBooleanTrue/False flag if the country is an UN member (The European Union (EU) is a political and economic union of 27 member states (as of 16 June 2016) that are located primarily in Europe.)
member_oecdOECD Membership FlagBooleanTrue/False flag if the country is an OECD member (The Organisation for Economic Co-operation and Development is an intergovernmental economic organisation with 37 member countries (as of 9 June 2018) founded in 1961 to stimulate economic progress and world trade. Generally, OECD members are high-income economies with a very high Human Development Index (HDI) and are regarded as developed countries.)
member_g20G20 Membership FlagBooleanTrue/False flag if the country is a G20 member (The G20 is an international forum for the governments and central bank governors from 19 countries and the European Union.)
fuel_exporting_countryFuel Exporting Country Flag BooleanTrue/False flag if the country is a fuel exporting country according to the World Bank
max_year_by_countryMax Report YearBooleanThe latest year of statistics of a country in the dataset
population_menMen PopulationFloatMen Population (given numbers are in millions)
interpolated_population_menInterpolated Men PopulationFloatInterpolated version of population_men (given numbers are in millions)
population_womenWomen PopulationFloatWomen Population (given numbers are in millions)
interpolated_population_womenInterpolated Women PopulationFloatInterpolated version of population_women (given numbers are in millions)
population_totalTotal PopulationFloatTotal Population (given numbers are in millions)
interpolated_population_totalInterpolated Total PopulationFloatInterpolated version of population_total (given numbers are in millions)
population_men_percentPopulation Men PercentFloatThe share of the men population in total population
interpolated_population_men_percentInterpolated Population Men PercentFloatInterpolated version of population_men_percent
population_women_percentPopulation Women PercentFloatThe share of the women population in total population
interpolated_population_women_percentInterpolated Population Women PercentFloatInterpolated version of population_women_percent
working_population_percentWorking Population PercentFloatThe working age population is defined as those aged 15 to 64. This indicator measures the share of the working age population in total population.
interpolated_working_population_percentInterpolated Working Population PercentFloatInterpolated version of working_population_percent
elderly_population_percentElderly Population PercentFloatThe elderly population is defined as people aged 65 and over. This indicator measures the share of the elderly population in total population.
interpolated_elderly_population_percentInterpolated Elderly Population PercentFloatInterpolated version of elderly_population_percent
fertility_ratesFertility RatesFloatThe total number of children that would be born to each woman
interpolated_fertility_ratesInterpolated Fertility RatesFloatInterpolated version of fertility_rates
young_population_percentYouth Population PercentFloatThe youth population is defined as those people aged less than 15. This indicator measures the share of the youth population in total population.
interpolated_young_population_percentInterpolated Youth Population PercentFloatInterpolated version of young_population_percent

Sample Data

API

ALTADATA provides a powerfull API, compatible with JSON, CSV formats. You can connect, update and analyze our data products with cURL, Python, R, Ruby, Java or Javascript

Authentication

Getting an API key

You need to subscribe to an ALTADATA data product to get an API key. Once you subscribe to the data product you can find your API key on your Account Dashboard.

Auhenticating your requests

`api_key` is your access token. This token must be included on each API call with either a HTTP Header Authorization, or a query parameter api_key.

Example: https://www.altadata.io/data/api/co_08_oecdx_07?api_key=YOUR_API_KEY

ALTADATA API Reference Table

Parameter Type Parameter Explanation Available Values Default
General size The number of records will be returned for each page. 5 - 100 20
General page The page number. It starts at 1 and increments one by one. Each page returns records that row count equals to the size parameter 1- ... 1
General format The data return format of API call json , csv json
General collapse The aggregation format of API call Examples are monthly, yearly, bystate, bycountry, etc. Refer to the data product documentation to see available aggregations for it. null
Select columns Column select is how you specify the content of an SQL SELECT c_only, c_certain, c_columns FROM clause. More detail is in the following sections. *
Order order_by Column order is how you specify the content of an SQL ORDER BY clause. More detail is in the following sections. null
Lookup vary by column name Column lookups are how you specify the content of an SQL WHERE clause. More detail is in the following sections. *

Select

Column select is how you specify the content of an SQL SELECT c_only, c_certain, c_columns FROM clause. It specifies as a keyword argument to the query string of API Call URL. Basic usage is a comma-separated list of column names. If not given, the default value is *(asterisk).

Example 1 :

Query : ?columns=C1,C2,C3 SQL Equivalent : Select C1,C2,C3 from DATA_PRODUCT

Example 2 :

Query : Not Given | ?columns= | ?columns=* SQL Equivalent : Select * from DATA_PRODUCT

Order

Column order is how you specify the content of an SQL ORDER BY clause. It specifies as a keyword argument to the query string of API Call URL. Basic usage is a comma-separated list of column names where each column name has an appropriate suffix (asc,desc) after _(underscore) or no suffix (means ascending).

Example :

Query : ?order_by=C1_asc,C2,C3_desc,C4_asc SQL Equivalent : Select * from DATA_PRODUCT order by C1 asc, C2, C4 desc, C4 asc

Order Type Suffix
Ascending null
Ascending asc
Descending desc

Lookup

Column lookups are how you specify the content of an SQL WHERE clause. They’re specifies as keyword arguments to the query string of API Call URL. Basic usage is appending _(underscore) then lookup type as a suffix to name of the column that you want to filter. The query parameter for a column is built like the format {COLUMN_NAME}_{LOOKUP_TYPE}

As a convenience when no lookup type is provided

Lookup Type Suffix Value Type Example SQL Equivalent
Equal to null String | Numeric | Datetime ?COLUMN=VALUE Select * from DATA_PRODUCT where COLUMN=VALUE
Equal to eq String | Numeric | Datetime ?COLUMN_eq=VALUE Select * from DATA_PRODUCT where COLUMN=VALUE
Not Equal to neq String | Numeric | Datetime ?COLUMN_neq=VALUE Select * from DATA_PRODUCT where COLUMN<>VALUE
Greater Than gt Numeric | Datetime ?COLUMN_gt=VALUE Select * from DATA_PRODUCT where COLUMN>VALUE
Greater Than or Equal to gte Numeric | Datetime ?COLUMN_gte=VALUE Select * from DATA_PRODUCT where COLUMN>=VALUE
Less Than lt Numeric | Datetime ?COLUMN_lt=VALUE Select * from DATA_PRODUCT where COLUMN,VALUE
Less Than or Equal to lte Numeric | Datetime ?COLUMN_lte=VALUE Select * from DATA_PRODUCT where COLUMN<=VALUE
In in String ?COLUMN_in=V1,V2,V3 Select * from DATA_PRODUCT where COLUMN in ('V1','V2','V3')
Not In notin String ?COLUMN_notin=V1,V2,V3 Select * from DATA_PRODUCT where COLUMN not in ('V1','V2','V3')

Data Access Examples

cURL
curl \ -H 'Authorization: api_key' \ 'https://www.altadata.io/data/api/co_08_oecdx_07'
Python (requests)
response = requests.get( 'https://www.altadata.io/data/api/co_08_oecdx_07', headers={'Authorization': 'api_key'} )
Ruby (open-uri)
require 'open-uri' response = URI.open('https://www.altadata.io/data/api/co_08_oecdx_07', "Authorization" => "api_key" )
Java (OkHttp)
Request request = new Request.Builder() .url("https://www.altadata.io/data/api/co_08_oecdx_07") .addHeader("Authorization", "api_key") .build(); Call call = client.newCall(request); Response response = call.execute();
Javascript (axios)
axios.request({ url: 'https://www.altadata.io/data/api/co_08_oecdx_07', method: 'get', headers: { 'Authorization', 'api_key'} }) .then(response => { console.log(response.data) })
R ( jsonlite )
library(jsonlite) data <- fromJSON(`https://www.altadata.io/data/api/co_08_oecdx_07`)

Frequently Asked Questions

HOW DO I SUBSCRIBE TO DATA PRODUCTS ON ALTADATA?
DO YOU PROVIDE CUSTOM DATASETS UPON REQUEST?
WHAT ARE THE DIFFERENT WAYS I CAN ACCESS MY SUBSCRIPTION DATA?
HOW CAN I QUICKLY LOOK AT WHAT IS IN THE DATA THAT I SUBSCRIBED TO?
HOW CAN I JOIN ALTADATA PARTNER NETWORK? DO YOU HAVE A LIST OF REQUIREMENTS?