11 a 4 -- Migration between regions by age, sex and region of arrival and departure, 1990-2017

Tables

Dim age, Statfin muutl pxt 11a4 px, Full historyTSV
Dimension Age (Ikä)
Dim age, Statfin muutl pxt 11a4 px, LatestTSV
Dimension Age (Ikä)
Dim region of arrival, Statfin muutl pxt 11a4 px, Full historyTSV
Dimension Region_of_arrival (Tulomaakunta)
Dim region of arrival, Statfin muutl pxt 11a4 px, LatestTSV
Dimension Region_of_arrival (Tulomaakunta)
Dim region of departure, Statfin muutl pxt 11a4 px, Full historyTSV
Dimension Region_of_departure (Lähtömaakunta)
Dim region of departure, Statfin muutl pxt 11a4 px, LatestTSV
Dimension Region_of_departure (Lähtömaakunta)
Dim sex, Statfin muutl pxt 11a4 px, Full historyTSV
Dimension Sex (Sukupuoli)
Dim sex, Statfin muutl pxt 11a4 px, LatestTSV
Dimension Sex (Sukupuoli)
Dim year, Statfin muutl pxt 11a4 px, Full historyTSV
Dimension Year (Vuosi)
Dim year, Statfin muutl pxt 11a4 px, LatestTSV
Dimension Year (Vuosi)
Fact, Statfin muutl pxt 11a4 px, Full historyTSV
Migration between regions by Year, Region of arrival, Region of departure, Sex, Age and Information
Fact, Statfin muutl pxt 11a4 px, LatestTSV
Migration between regions by Year, Region of arrival, Region of departure, Sex, Age and Information

Column Descriptions

Fact, Statfin muutl pxt 11a4 px, Full history

Column	Type	Comment
year	int	Datasource did not contain a description for Year. Column year has 591600 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 2018.
region_of_arrival	string	These statistics apply the regional division of 1 January 2019 to the whole time series. . Column region_of_arrival has 591600 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_departure	string	These statistics apply the regional division of 1 January 2019 to the whole time series. . Column region_of_departure has 591600 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 591600 rows, out of which 197200 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 591600 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-.
migration_between_regions	int	These statistics apply the regional division of 1 January 2019 to the whole time series. . Column migration_between_regions has 591600 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 136684.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim year, Statfin muutl pxt 11a4 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 age, Statfin muutl pxt 11a4 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 10 - 14 and maximum string is 75 -.

Dim region of departure, Statfin muutl pxt 11a4 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 Departure - MK01 Uusimaa and maximum string is Departure - MK21 Åland.

Dim region of departure, Statfin muutl pxt 11a4 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 Departure - MK01 Uusimaa and maximum string is Departure - MK21 Åland.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim sex, Statfin muutl pxt 11a4 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.

Fact, Statfin muutl pxt 11a4 px, Latest

Column	Type	Comment
year	int	Datasource did not contain a description for Year. Column year has 591600 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 2018.
region_of_arrival	string	These statistics apply the regional division of 1 January 2019 to the whole time series. . Column region_of_arrival has 591600 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_departure	string	These statistics apply the regional division of 1 January 2019 to the whole time series. . Column region_of_departure has 591600 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 591600 rows, out of which 197200 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 591600 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-.
migration_between_regions	int	These statistics apply the regional division of 1 January 2019 to the whole time series. . Column migration_between_regions has 591600 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 136684.

Dim sex, Statfin muutl pxt 11a4 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 region of arrival, Statfin muutl pxt 11a4 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 Arrival - MK01 Uusimaa and maximum string is Arrival - MK21 Åland.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim region of arrival, Statfin muutl pxt 11a4 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 Arrival - MK01 Uusimaa and maximum string is Arrival - MK21 Åland.

Dim age, Statfin muutl pxt 11a4 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 10 - 14 and maximum string is 75 -.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim year, Statfin muutl pxt 11a4 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.

Additional Info

Last Updated	September 20, 2019
Created	August 5, 2019