About this Dataset

International Migration Database

This dataset includes annual series on flows of foreign population and of asylum seekers by nationality, stocks of foreign population by nationality, as well as acquisitions of nationality by former nationality. Most of these data have been provided by national correspondents of the OECD Expert Group on Migration. They are based on national concepts and definitions and therefore are not fully comparable across countries.

Tables

Observations

@oecd.oecd_els_imd_dsd_mig_df_mig_v1_0.observations

2.03 MB
1,017,037 rows
14 columns

CREATE TABLE observations (
  "dataflow" VARCHAR,
  "ref_area" VARCHAR,
  "citizenship" VARCHAR,
  "freq" VARCHAR,
  "measure" VARCHAR,
  "sex" VARCHAR,
  "birth_place" VARCHAR,
  "education_lev" VARCHAR,
  "unit_measure" VARCHAR,
  "time_period" DOUBLE,
  "obs_value" DOUBLE,
  "obs_status" VARCHAR,
  "unit_mult" DOUBLE,
  "decimals" BIGINT
);