About this Dataset

Foreign-born Population - Cities And FUAs

This dataset provides population counts for native and foreign-born population in OECD Functional Urban Areas (FUAs) and cities.

Data sources and methodology

Population by origin 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.

For more details on data sources for each country, please see Astruc-Le Souder et al. (2024).

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 (Foreign-born population - 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_origin_v1_0.observations

102.19 kB
51,786 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" DOUBLE,
  "obs_status" VARCHAR,
  "unit_mult" BIGINT,
  "decimals" BIGINT
);