1. Home
  2. Datasets
  3. 005 -- Migration between ...
To download the data set, please sign up or log in

005 -- Migration between regions by age, sex and region of exit or entry in 1990 to 2016

005 -- Migration between regions by age, sex and region of exit or entry in 1990 to 2016

Tables

Column Descriptions

Dim year, Statfinpas muutl pxt 005 201600 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 27 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 2016.
label int The label for the dimension value. Column label has 27 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 2016.

Fact, Statfinpas muutl pxt 005 201600 px, Latest

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 550800 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 2016.
region_of_entry string Datasource did not contain a description for Region_of_entry. Column region_of_entry has 550800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MK01 and maximum string is MK21.
region_of_exit string Datasource did not contain a description for Region_of_exit. Column region_of_exit has 550800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MK01 and maximum string is MK21.
sex int Datasource did not contain a description for Sex. Column sex has 550800 rows, out of which 183600 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 550800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0-4 and maximum string is 75-.
information string Datasource did not contain a description for Information. Column information has 550800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: L.
migration_between_regions int Datasource did not contain a description for Migration_between_regions. Column migration_between_regions has 550800 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 133230.

Dim sex, Statfinpas muutl pxt 005 201600 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 Both sexes and maximum string is Females.
orig_extractdate string The date when the data was originally fetched from the source.

Dim region of exit, Statfinpas muutl pxt 005 201600 px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 20 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MK01 and maximum string is MK21.
label string The label for the dimension value. Column label has 20 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Out - Ahvenanmaa - Åland and maximum string is Out - Lapland.
orig_extractdate string The date when the data was originally fetched from the source.

Dim age, Statfinpas muutl pxt 005 201600 px, Latest

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

Dim region of entry, Statfinpas muutl pxt 005 201600 px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 20 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MK01 and maximum string is MK21.
label string The label for the dimension value. Column label has 20 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is In - Ahvenanmaa - Åland and maximum string is In - Lapland.
orig_extractdate string The date when the data was originally fetched from the source.

Dim information, Statfinpas muutl pxt 005 201600 px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: L.
label string The label for the dimension value. Column label has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Migration between regions.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfinpas muutl pxt 005 201600 px, Full history

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 550800 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 2016.
region_of_entry string Datasource did not contain a description for Region_of_entry. Column region_of_entry has 550800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MK01 and maximum string is MK21.
region_of_exit string Datasource did not contain a description for Region_of_exit. Column region_of_exit has 550800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MK01 and maximum string is MK21.
sex int Datasource did not contain a description for Sex. Column sex has 550800 rows, out of which 183600 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 550800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0-4 and maximum string is 75-.
information string Datasource did not contain a description for Information. Column information has 550800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: L.
migration_between_regions int Datasource did not contain a description for Migration_between_regions. Column migration_between_regions has 550800 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 133230.
orig_extractdate string The date when the data was originally fetched from the source.

Dim information, Statfinpas muutl pxt 005 201600 px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: L.
label string The label for the dimension value. Column label has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Migration between regions.

Dim age, Statfinpas muutl pxt 005 201600 px, Full history

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

Dim sex, Statfinpas muutl pxt 005 201600 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 Both sexes and maximum string is Females.

Dim year, Statfinpas muutl pxt 005 201600 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 27 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 2016.
label int The label for the dimension value. Column label has 27 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 2016.
orig_extractdate string The date when the data was originally fetched from the source.

Dim region of entry, Statfinpas muutl pxt 005 201600 px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 20 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MK01 and maximum string is MK21.
label string The label for the dimension value. Column label has 20 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is In - Ahvenanmaa - Åland and maximum string is In - Lapland.

Dim region of exit, Statfinpas muutl pxt 005 201600 px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 20 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MK01 and maximum string is MK21.
label string The label for the dimension value. Column label has 20 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Out - Ahvenanmaa - Åland and maximum string is Out - Lapland.

Additional Info

Last Updated September 20, 2019
Created August 3, 2019