1. Home
  2. Datasets
  3. 11 ac -- Immigration and ...
To download the data set, please sign up or log in

11 ac -- Immigration and emigration by country of departure or arrival, level of education and age group, 2005-2017

11 ac -- Immigration and emigration by country of departure or arrival, level of education and age group, 2005-2017

Tables

Column Descriptions

Fact, Statfin muutl pxt 11ac px, Latest

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 449280 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2005 and maximum value is 2017.
country_of_departure_or_arrival int Countries (ISO 3166). The used classification of continents is the classification of Eurostat, where Cyprus and Turkey belong to Europe. Non-autonomous states are combined with the mother country. . Column country_of_departure_or_arrival has 449280 rows, out of which 4992 are empty, making the null percent 1.11. Minimum value is 4 and maximum value is 894.
level_of_education int The Finnish Standard Classification of Education, which corresponds to the International Standard Classification of Education ISCED 2011, is applied to the whole time series. . Column level_of_education has 449280 rows, out of which 112320 are empty, making the null percent 25.00. Minimum value is 3 and maximum value is 8.
sex int Datasource did not contain a description for Sex. Column sex has 449280 rows, out of which 149760 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
age string Datasource did not contain a description for Age. Column age has 449280 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 18- and maximum string is 75-.
immigration_to_finland_by_finnish_citizens int Datasource did not contain a description for Immigration_to_Finland_by_Finnish_citizens. Column immigration_to_finland_by_finnish_citizens has 449280 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 6978.
emigration_from_finland_by_finnish_citizens int Datasource did not contain a description for Emigration_from_Finland_by_Finnish_citizens. Column emigration_from_finland_by_finnish_citizens has 449280 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 9788.
net_migration_by_finnish_citizens_number int Net migration is the difference between immigration and emigration. . Column net_migration_by_finnish_citizens_number has 449280 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -3930 and maximum value is 429.

Fact, Statfin muutl pxt 11ac px, Full history

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 449280 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2005 and maximum value is 2017.
country_of_departure_or_arrival int Countries (ISO 3166). The used classification of continents is the classification of Eurostat, where Cyprus and Turkey belong to Europe. Non-autonomous states are combined with the mother country. . Column country_of_departure_or_arrival has 449280 rows, out of which 4992 are empty, making the null percent 1.11. Minimum value is 4 and maximum value is 894.
level_of_education int The Finnish Standard Classification of Education, which corresponds to the International Standard Classification of Education ISCED 2011, is applied to the whole time series. . Column level_of_education has 449280 rows, out of which 112320 are empty, making the null percent 25.00. Minimum value is 3 and maximum value is 8.
sex int Datasource did not contain a description for Sex. Column sex has 449280 rows, out of which 149760 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
age string Datasource did not contain a description for Age. Column age has 449280 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 18- and maximum string is 75-.
immigration_to_finland_by_finnish_citizens int Datasource did not contain a description for Immigration_to_Finland_by_Finnish_citizens. Column immigration_to_finland_by_finnish_citizens has 449280 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 6978.
emigration_from_finland_by_finnish_citizens int Datasource did not contain a description for Emigration_from_Finland_by_Finnish_citizens. Column emigration_from_finland_by_finnish_citizens has 449280 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 9788.
net_migration_by_finnish_citizens_number int Net migration is the difference between immigration and emigration. . Column net_migration_by_finnish_citizens_number has 449280 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -3930 and maximum value is 429.
orig_extractdate string The date when the data was originally fetched from the source.

Dim year, Statfin muutl pxt 11ac px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 13 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2005 and maximum value is 2017.
label int The label for the dimension value. Column label has 13 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2005 and maximum value is 2017.

Dim year, Statfin muutl pxt 11ac px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 13 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2005 and maximum value is 2017.
label int The label for the dimension value. Column label has 13 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2005 and maximum value is 2017.
orig_extractdate string The date when the data was originally fetched from the source.

Dim country of departure or arrival, Statfin muutl pxt 11ac px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 180 rows, out of which 2 are empty, making the null percent 1.11. Minimum value is 4 and maximum value is 894.
label string The label for the dimension value. Column label has 180 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Afghanistan and maximum string is Unknown.

Dim country of departure or arrival, Statfin muutl pxt 11ac px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 180 rows, out of which 2 are empty, making the null percent 1.11. Minimum value is 4 and maximum value is 894.
label string The label for the dimension value. Column label has 180 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Afghanistan and maximum string is Unknown.
orig_extractdate string The date when the data was originally fetched from the source.

Dim level of education, Statfin muutl pxt 11ac px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 8 rows, out of which 2 are empty, making the null percent 25.00. Minimum value is 3 and maximum value is 8.
label string The label for the dimension value. Column label has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Bachelor's or equivalent ... and first 25 characters of maximum string: Unknown...
orig_extractdate string The date when the data was originally fetched from the source.

Dim sex, Statfin muutl pxt 11ac px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 3 rows, out of which 1 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
label string The label for the dimension value. Column label has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Females and maximum string is Total.
orig_extractdate string The date when the data was originally fetched from the source.

Dim sex, Statfin muutl pxt 11ac px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 3 rows, out of which 1 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
label string The label for the dimension value. Column label has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Females and maximum string is Total.

Dim age, Statfin muutl pxt 11ac px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 18- and maximum string is 75-.
label string The label for the dimension value. Column label has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 18 - and maximum string is 75 -.
orig_extractdate string The date when the data was originally fetched from the source.

Dim age, Statfin muutl pxt 11ac px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 18- and maximum string is 75-.
label string The label for the dimension value. Column label has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 18 - and maximum string is 75 -.

Additional Info

Last Updated July 10, 2019
Created July 10, 2019