To download the data set, please sign up or log in

001 -- Migration by month and sex in 1990 to 2016

001 -- Migration by month and sex in 1990 to 2016

Tables

Column Descriptions

Fact, Statfinpas muutl pxt 001 201600 px, Latest

Column Type Comment
information int Datasource did not contain a description for Information. Column information has 4212 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 41 and maximum value is 44.
year int Datasource did not contain a description for Year. Column year has 4212 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.
sex int Datasource did not contain a description for Sex. Column sex has 4212 rows, out of which 1404 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
month_of_occurrence string Datasource did not contain a description for Month_of_occurrence. Column month_of_occurrence has 4212 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is M01 and maximum string is M12.
migration int Datasource did not contain a description for Migration. Column migration has 4212 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 162 and maximum value is 624030.

Dim information, Statfinpas muutl pxt 001 201600 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 41 and maximum value is 44.
label string The label for the dimension value. Column label has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Emigration from Finland and maximum string is Intramunicipal migration.

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

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

Fact, Statfinpas muutl pxt 001 201600 px, Full history

Column Type Comment
information int Datasource did not contain a description for Information. Column information has 4212 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 41 and maximum value is 44.
year int Datasource did not contain a description for Year. Column year has 4212 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.
sex int Datasource did not contain a description for Sex. Column sex has 4212 rows, out of which 1404 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
month_of_occurrence string Datasource did not contain a description for Month_of_occurrence. Column month_of_occurrence has 4212 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is M01 and maximum string is M12.
migration int Datasource did not contain a description for Migration. Column migration has 4212 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 162 and maximum value is 624030.
orig_extractdate string The date when the data was originally fetched from the source.

Dim year, Statfinpas muutl pxt 001 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 year, Statfinpas muutl pxt 001 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.

Dim sex, Statfinpas muutl pxt 001 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 sex, Statfinpas muutl pxt 001 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 month of occurrence, Statfinpas muutl pxt 001 201600 px, Full history

Column Type Comment
code string 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 string is M01 and maximum string is M12.
label string 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 string is April and maximum string is December.
orig_extractdate string The date when the data was originally fetched from the source.

Dim month of occurrence, Statfinpas muutl pxt 001 201600 px, Latest

Column Type Comment
code string 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 string is M01 and maximum string is M12.
label string 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 string is April and maximum string is December.

Additional Info

Last Updated July 18, 2019
Created July 12, 2019