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

009 -- Citizenship of foreign spouses and cohabiting partners of Finnish women in 2002 to 2017

009 -- Citizenship of foreign spouses and cohabiting partners of Finnish women in 2002 to 2017

Tables

Column Descriptions

Dim nationality of man, Statfin perh pxt 009 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 man, Statfin perh pxt 009 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.

Fact, Statfin perh pxt 009 px, Full history

Column Type Comment
nationality_of_man int Nationality of the married or cohabiting man or the older partner of a same-sex married couple or a registered couple. . Column nationality_of_man 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_woman string When tabulating same-sex married couples or registered partnerships together with married or cohabiting couples opposite sexes, woman refers to the younger partner of a same-sex married couple or a registered couple. . Column age_of_woman 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: kansa246n_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 26393.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfin perh pxt 009 px, Latest

Column Type Comment
nationality_of_man int Nationality of the married or cohabiting man or the older partner of a same-sex married couple or a registered couple. . Column nationality_of_man 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_woman string When tabulating same-sex married couples or registered partnerships together with married or cohabiting couples opposite sexes, woman refers to the younger partner of a same-sex married couple or a registered couple. . Column age_of_woman 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: kansa246n_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 26393.

Additional Info

Last Updated July 21, 2019
Created July 19, 2019