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

11 a 8 -- Immigration and emigration by nationality, origin and language, 1990-2017

11 a 8 -- Immigration and emigration by nationality, origin and language, 1990-2017

Tables

Column Descriptions

Dim sex, Statfin muutl pxt 11a8 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 11a8 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 year, Statfin muutl pxt 11a8 px, Full history

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

Dim nationality, Statfin muutl pxt 11a8 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 188 rows, out of which 3 are empty, making the null percent 1.60. Minimum value is 4 and maximum value is 991.
label string The label for the dimension value. Column label has 188 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 nationality, Statfin muutl pxt 11a8 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 188 rows, out of which 3 are empty, making the null percent 1.60. Minimum value is 4 and maximum value is 991.
label string The label for the dimension value. Column label has 188 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 origin, Statfin muutl pxt 11a8 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 7 rows, out of which 1 are empty, making the null percent 14.29. Minimum value is 1 and maximum value is 22.
label string The label for the dimension value. Column label has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Persons with Finnish back... and first 25 characters of maximum string: Persons with foreign back...

Dim language, Statfin muutl pxt 11a8 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 FOREIGN LANGUAGES, TOTAL and maximum string is Total.
orig_extractdate string The date when the data was originally fetched from the source.

Dim language, Statfin muutl pxt 11a8 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 FOREIGN LANGUAGES, TOTAL and maximum string is Total.

Dim year, Statfin muutl pxt 11a8 px, Latest

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

Dim origin, Statfin muutl pxt 11a8 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 7 rows, out of which 1 are empty, making the null percent 14.29. Minimum value is 1 and maximum value is 22.
label string The label for the dimension value. Column label has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Persons with Finnish back... and first 25 characters of maximum string: Persons with foreign back...
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated July 22, 2019
Created July 19, 2019