International Migrant Stock
@owid.migrant_stock
@owid.migrant_stock
The estimates of the number (or “stock”) of international migrants disaggregated by age, sex and country or area of origin are based on national statistics, in most cases obtained from population censuses. Additionally, population registers and nationally representative surveys provided information on the number and composition of international migrants.
The dataset presents estimates of international migrant by age, sex and origin. Estimates are presented for 1990, 1995, 2000, 2005, 2010, 2015 and 2020 and are available for 232 countries and areas of the world. The estimates are based on official statistics on the foreign-born or the foreign population.
CREATE TABLE owid_migrant_stock_1 (
"country" VARCHAR,
"year" INTEGER,
"immigrants_all" UINTEGER,
"immigrants_female" UINTEGER,
"immigrants_male" UINTEGER,
"immigrant_share_of_dest_population_all" FLOAT,
"immigrant_share_of_dest_population_female" FLOAT,
"immigrant_share_of_dest_population_male" FLOAT,
"emigrants_all" UINTEGER,
"emigrants_female" UINTEGER,
"emigrants_male" UINTEGER,
"all_immigrants_aged_0_to_4" UINTEGER,
"all_immigrants_aged_5_to_9" UINTEGER,
"all_immigrants_aged_10_to_14" UINTEGER,
"all_immigrants_aged_15_to_19" UINTEGER,
"all_immigrants_aged_20_to_24" UINTEGER,
"all_immigrants_aged_25_to_29" UINTEGER,
"all_immigrants_aged_30_to_34" UINTEGER,
"all_immigrants_aged_35_to_39" UINTEGER,
"all_immigrants_aged_40_to_44" UINTEGER,
"all_immigrants_aged_45_to_49" UINTEGER,
"all_immigrants_aged_50_to_54" UINTEGER,
"all_immigrants_aged_55_to_59" UINTEGER,
"all_immigrants_aged_60_to_64" UINTEGER,
"all_immigrants_aged_65_to_69" UINTEGER,
"all_immigrants_aged_70_to_74" UINTEGER,
"all_immigrants_aged_75_plus" UINTEGER,
"male_immigrants_aged_0_to_4" UINTEGER,
"male_immigrants_aged_5_to_9" UINTEGER,
"male_immigrants_aged_10_to_14" UINTEGER,
"male_immigrants_aged_15_to_19" UINTEGER,
"male_immigrants_aged_20_to_24" UINTEGER,
"male_immigrants_aged_25_to_29" UINTEGER,
"male_immigrants_aged_30_to_34" UINTEGER,
"male_immigrants_aged_35_to_39" UINTEGER,
"male_immigrants_aged_40_to_44" UINTEGER,
"male_immigrants_aged_45_to_49" UINTEGER,
"male_immigrants_aged_50_to_54" UINTEGER,
"male_immigrants_aged_55_to_59" UINTEGER,
"male_immigrants_aged_60_to_64" UINTEGER,
"male_immigrants_aged_65_to_69" UINTEGER,
"male_immigrants_aged_70_to_74" UINTEGER,
"male_immigrants_aged_75_plus" UINTEGER,
"female_immigrants_aged_0_to_4" UINTEGER,
"female_immigrants_aged_5_to_9" UINTEGER,
"female_immigrants_aged_10_to_14" UINTEGER,
"female_immigrants_aged_15_to_19" UINTEGER,
"female_immigrants_aged_20_to_24" UINTEGER,
"female_immigrants_aged_25_to_29" UINTEGER,
"female_immigrants_aged_30_to_34" UINTEGER,
"female_immigrants_aged_35_to_39" UINTEGER,
"female_immigrants_aged_40_to_44" UINTEGER,
"female_immigrants_aged_45_to_49" UINTEGER,
"female_immigrants_aged_50_to_54" UINTEGER,
"female_immigrants_aged_55_to_59" UINTEGER,
"female_immigrants_aged_60_to_64" UINTEGER,
"female_immigrants_aged_65_to_69" UINTEGER,
"female_immigrants_aged_70_to_74" UINTEGER,
"female_immigrants_aged_75_plus" UINTEGER,
"share_of_all_immigrants_aged_0_to_4" FLOAT,
"share_of_all_immigrants_aged_5_to_9" FLOAT,
"share_of_all_immigrants_aged_10_to_14" FLOAT,
"share_of_all_immigrants_aged_15_to_19" FLOAT,
"share_of_all_immigrants_aged_20_to_24" FLOAT,
"share_of_all_immigrants_aged_25_to_29" FLOAT,
"share_of_all_immigrants_aged_30_to_34" FLOAT,
"share_of_all_immigrants_aged_35_to_39" FLOAT,
"share_of_all_immigrants_aged_40_to_44" FLOAT,
"share_of_all_immigrants_aged_45_to_49" FLOAT,
"share_of_all_immigrants_aged_50_to_54" FLOAT,
"share_of_all_immigrants_aged_55_to_59" FLOAT,
"share_of_all_immigrants_aged_60_to_64" FLOAT,
"share_of_all_immigrants_aged_65_to_69" FLOAT,
"share_of_all_immigrants_aged_70_to_74" FLOAT,
"share_of_all_immigrants_aged_75_plus" FLOAT,
"share_of_male_immigrants_aged_0_to_4" FLOAT,
"share_of_male_immigrants_aged_5_to_9" FLOAT,
"share_of_male_immigrants_aged_10_to_14" FLOAT,
"share_of_male_immigrants_aged_15_to_19" FLOAT,
"share_of_male_immigrants_aged_20_to_24" FLOAT,
"share_of_male_immigrants_aged_25_to_29" FLOAT,
"share_of_male_immigrants_aged_30_to_34" FLOAT,
"share_of_male_immigrants_aged_35_to_39" FLOAT,
"share_of_male_immigrants_aged_40_to_44" FLOAT,
"share_of_male_immigrants_aged_45_to_49" FLOAT,
"share_of_male_immigrants_aged_50_to_54" FLOAT,
"share_of_male_immigrants_aged_55_to_59" FLOAT,
"share_of_male_immigrants_aged_60_to_64" FLOAT,
"share_of_male_immigrants_aged_65_to_69" FLOAT,
"share_of_male_immigrants_aged_70_to_74" FLOAT,
"share_of_male_immigrants_aged_75_plus" FLOAT,
"share_of_female_immigrants_aged_0_to_4" FLOAT,
"share_of_female_immigrants_aged_5_to_9" FLOAT,
"share_of_female_immigrants_aged_10_to_14" FLOAT,
"share_of_female_immigrants_aged_15_to_19" FLOAT,
"share_of_female_immigrants_aged_20_to_24" FLOAT,
"share_of_female_immigrants_aged_25_to_29" FLOAT,
"share_of_female_immigrants_aged_30_to_34" FLOAT,
"share_of_female_immigrants_aged_35_to_39" FLOAT,
"share_of_female_immigrants_aged_40_to_44" FLOAT
);CREATE TABLE owid_migrant_stock_2 (
"country" VARCHAR,
"year" INTEGER,
"immigrants_all" UINTEGER,
"immigrants_female" UINTEGER,
"immigrants_male" UINTEGER,
"immigrant_share_of_dest_population_all" FLOAT,
"immigrant_share_of_dest_population_female" FLOAT,
"immigrant_share_of_dest_population_male" FLOAT,
"emigrants_all" UINTEGER,
"emigrants_female" UINTEGER,
"emigrants_male" UINTEGER,
"emigrants_share_of_total_population" FLOAT
);CREATE TABLE owid_migrant_stock_dest_origin_1 (
"country_destination" VARCHAR,
"country_origin" VARCHAR,
"year" INTEGER,
"migrants_all_sexes" UINTEGER,
"migrants_female" UINTEGER,
"migrants_male" UINTEGER
);CREATE TABLE owid_migrant_stock_dest_origin_2 (
"country_destination" VARCHAR,
"country_origin" VARCHAR,
"year" INTEGER,
"migrants_all_sexes" UINTEGER,
"migrants_female" UINTEGER,
"migrants_male" UINTEGER
);Anyone who has the link will be able to view this.