008 -- Citizenship of foreign spouses and cohabiting partners of Finnish men in 2002 to 2017

Tables

Dim age of man, Statfin perh pxt 008 px, Full historyTSV
Dimension Age_of_man (Miehen ikä)
Dim age of man, Statfin perh pxt 008 px, LatestTSV
Dimension Age_of_man (Miehen ikä)
Dim family type, Statfin perh pxt 008 px, Full historyTSV
Dimension Family_type (Perhetyyppi)
Dim family type, Statfin perh pxt 008 px, LatestTSV
Dimension Family_type (Perhetyyppi)
Dim information, Statfin perh pxt 008 px, Full historyTSV
Dimension Information (Tiedot)
Dim information, Statfin perh pxt 008 px, LatestTSV
Dimension Information (Tiedot)
Dim nationality of woman, Statfin perh pxt 008 px, Full historyTSV
Dimension Nationality_of_woman (Naisen kansalaisuus)
Dim nationality of woman, Statfin perh pxt 008 px, LatestTSV
Dimension Nationality_of_woman (Naisen kansalaisuus)
Dim year, Statfin perh pxt 008 px, Full historyTSV
Dimension Year (Vuosi)
Dim year, Statfin perh pxt 008 px, LatestTSV
Dimension Year (Vuosi)
Fact, Statfin perh pxt 008 px, Full historyTSV
Families by Nationality of woman, Year, Family type, Age of man and Information
Fact, Statfin perh pxt 008 px, LatestTSV
Families by Nationality of woman, Year, Family type, Age of man and Information

Column Descriptions

Fact, Statfin perh pxt 008 px, Full history

Column	Type	Comment
nationality_of_woman	int	Nationality of the married or cohabiting woman or the younger partner of a same-sex married couple or a registered couple. . Column nationality_of_woman has 77568 rows, out of which 3072 are empty, making the null percent 3.96. Minimum value is 4 and maximum value is 999.
year	int	Datasource did not contain a description for Year. Column year has 77568 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2002 and maximum value is 2017.
family_type	int	Datasource did not contain a description for Family_type. Column family_type has 77568 rows, out of which 25856 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
age_of_man	string	When tabulating same-sex married couples or registered partnerships together with married or cohabiting couples of opposite sexes, a man refers to the older partner of a same-sex married couple or a registered couple. . Column age_of_man has 77568 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is - 29 and maximum string is 80 -.
information	string	Datasource did not contain a description for Information. Column information has 77568 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: kansa246m_puo.
families	int	Datasource did not contain a description for Families. Column families has 77568 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 26596.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim year, Statfin perh pxt 008 px, Latest

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

Dim year, Statfin perh pxt 008 px, Full history

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

Dim nationality of woman, Statfin perh pxt 008 px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 202 rows, out of which 8 are empty, making the null percent 3.96. Minimum value is 4 and maximum value is 999.
label	string	The label for the dimension value. Column label has 202 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 nationality of woman, Statfin perh pxt 008 px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 202 rows, out of which 8 are empty, making the null percent 3.96. Minimum value is 4 and maximum value is 999.
label	string	The label for the dimension value. Column label has 202 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 family type, Statfin perh pxt 008 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. First 25 characters of minimum string: Cohabiting couples... and first 25 characters of maximum string: Married couples and regis...

Fact, Statfin perh pxt 008 px, Latest

Column	Type	Comment
nationality_of_woman	int	Nationality of the married or cohabiting woman or the younger partner of a same-sex married couple or a registered couple. . Column nationality_of_woman has 77568 rows, out of which 3072 are empty, making the null percent 3.96. Minimum value is 4 and maximum value is 999.
year	int	Datasource did not contain a description for Year. Column year has 77568 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2002 and maximum value is 2017.
family_type	int	Datasource did not contain a description for Family_type. Column family_type has 77568 rows, out of which 25856 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
age_of_man	string	When tabulating same-sex married couples or registered partnerships together with married or cohabiting couples of opposite sexes, a man refers to the older partner of a same-sex married couple or a registered couple. . Column age_of_man has 77568 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is - 29 and maximum string is 80 -.
information	string	Datasource did not contain a description for Information. Column information has 77568 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: kansa246m_puo.
families	int	Datasource did not contain a description for Families. Column families has 77568 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 26596.

Dim family type, Statfin perh pxt 008 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. First 25 characters of minimum string: Cohabiting couples... and first 25 characters of maximum string: Married couples and regis...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim age of man, Statfin perh pxt 008 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 - 29 and maximum string is 80 -.
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 - 29 and maximum string is 80 -.

Dim age of man, Statfin perh pxt 008 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 - 29 and maximum string is 80 -.
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 - 29 and maximum string is 80 -.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim information, Statfin perh pxt 008 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: kansa246m_puo.
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: Families.

Dim information, Statfin perh pxt 008 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: kansa246m_puo.
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: Families.
orig_extractdate	string	The date when the data was originally fetched from the source.

Additional Info

Last Updated	July 12, 2019
Created	July 12, 2019