International Migrant Stock
@owid.migrant_stock
@owid.migrant_stock
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.