About this Dataset

Population By Age And Sex - Cities And FUAs

This dataset provides population counts by 5-year age groups and sex for OECD Functional Urban Areas (FUAs) and cities.

Data sources and methodology

Population by age and sex data is collected at the level of small administrative units (e.g. municipalities) and aggregated at the FUA and city level. The correspondence table between SAUs and FUAs/cities is available at this link.

When population by age and sex data is not available at such granular level, FUA and city level indicators are estimated by adjusting the regional (OECD TL3 regions) values to the FUA and city boundaries, based on the population distribution in each region. Regional values (population by age and sex) in TL3 regions are used as data inputs and combined with gridded total population data (European Commission, GHSL Data Package 2023). FUA and city boundaries are intersected with TL3 borders and coefficients are computed for each region, based on the share of the regional population that lives within the FUA/city. These coefficients are then applied to the variables of interest (e.g. population by age groups) and allocated to the FUA/city. In case several regions intersect the FUA/city, the adjusted values of intersecting regions are summed. This approach assumes that the variables of interest have the same spatial distribution as the total population. Therefore, the modelled indicators should be interpreted with caution.

Defining FUAs and cities

The OECD, in cooperation with the EU, has developed a harmonised definition of functional urban areas (FUAs) to capture the economic and functional reach of cities based on daily commuting patterns (OECD, 2012). FUAs consist of:

A city – defined by urban centres in the degree of urbanisation, adapted to the closest local administrative units to define a city.
A commuting zone – including all local areas where at least 15% of employed residents work in the city.

The delineation process includes:

Assigning municipalities surrounded by a single FUA to that FUA.
Excluding non-contiguous municipalities.

The definition identifies 1 285 FUAs and 1 402 cities in all OECD member countries except Costa Rica and three accession countries.

Cite this dataset

OECD Regions, cities and local areas database (Population by age and sex - Cities and FUAs), http://oe.cd/geostats

Further information

For questions and/or comments, please email CitiesStat@oecd.org

Tables

Observations

@oecd.oecd_cfe_eds_dsd_fua_demo_df_age_sex_v1_1.observations

15.02 MB
3,115,561 rows
14 columns

CREATE TABLE observations (
  "dataflow" VARCHAR,
  "ref_area" VARCHAR,
  "freq" VARCHAR,
  "measure" VARCHAR,
  "unit_measure" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "origin" VARCHAR,
  "territorial_level" VARCHAR,
  "time_period" BIGINT,
  "obs_value" BIGINT,
  "obs_status" VARCHAR,
  "unit_mult" BIGINT,
  "decimals" BIGINT
);