1. Home
  2. Datasets
  3. 001 -- Families by type of ...
To download the data set, please sign up or log in

001 -- Families by type of family, number of persons in families and by area in 1992 to 2018

001 -- Families by type of family, number of persons in families and by area in 1992 to 2018

Tables

Column Descriptions

Fact, Statfin perh pxt 001 px, Full history

Column Type Comment
area int Datasource did not contain a description for Area. Column area has 530712 rows, out of which 1701 are empty, making the null percent 0.32. Minimum value is 5 and maximum value is 992.
number_of_persons int Datasource did not contain a description for Number_of_persons. Column number_of_persons has 530712 rows, out of which 58968 are empty, making the null percent 11.11. Minimum value is 2 and maximum value is 9.
year int Datasource did not contain a description for Year. Column year has 530712 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1992 and maximum value is 2018.
family_type string Families are grouped into the following types: - married couple without children, opposite sexes - married couple without children, same sex - cohabiting couple without children, opposite sexes - married couple with children, opposite sexes - married couple with children, same sex - cohabiting couple with children, opposite sexes - registered male couple without children - registered male couple with children - registered female couple without children - registered female couple with children - mother and children - father and children Without children refers to a couple that has never had children or whose children no longer live with their parents. Married and cohabiting couple with children includes not only couples with common children but
information string Datasource did not contain a description for Information. Column information has 530712 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: perhlkm.
families_31_12 int Datasource did not contain a description for Families_31_12. Column families_31_12 has 530712 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 1475583.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfin perh pxt 001 px, Latest

Column Type Comment
area int Datasource did not contain a description for Area. Column area has 530712 rows, out of which 1701 are empty, making the null percent 0.32. Minimum value is 5 and maximum value is 992.
number_of_persons int Datasource did not contain a description for Number_of_persons. Column number_of_persons has 530712 rows, out of which 58968 are empty, making the null percent 11.11. Minimum value is 2 and maximum value is 9.
year int Datasource did not contain a description for Year. Column year has 530712 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1992 and maximum value is 2018.
family_type string Families are grouped into the following types: - married couple without children, opposite sexes - married couple without children, same sex - cohabiting couple without children, opposite sexes - married couple with children, opposite sexes - married couple with children, same sex - cohabiting couple with children, opposite sexes - registered male couple without children - registered male couple with children - registered female couple without children - registered female couple with children - mother and children - father and children Without children refers to a couple that has never had children or whose children no longer live with their parents. Married and cohabiting couple with children includes not only couples with common children but
information string Datasource did not contain a description for Information. Column information has 530712 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: perhlkm.
families_31_12 int Datasource did not contain a description for Families_31_12. Column families_31_12 has 530712 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 1475583.

Dim number of persons, Statfin perh pxt 001 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 9 rows, out of which 1 are empty, making the null percent 11.11. Minimum value is 2 and maximum value is 9.
label int The label for the dimension value. Column label has 9 rows, out of which 2 are empty, making the null percent 22.22. Minimum value is 2 and maximum value is 8.
orig_extractdate string The date when the data was originally fetched from the source.

Dim number of persons, Statfin perh pxt 001 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 9 rows, out of which 1 are empty, making the null percent 11.11. Minimum value is 2 and maximum value is 9.
label int The label for the dimension value. Column label has 9 rows, out of which 2 are empty, making the null percent 22.22. Minimum value is 2 and maximum value is 8.

Dim area, Statfin perh pxt 001 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 312 rows, out of which 1 are empty, making the null percent 0.32. Minimum value is 5 and maximum value is 992.
label string The label for the dimension value. Column label has 312 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Akaa and maximum string is Äänekoski.

Dim area, Statfin perh pxt 001 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 312 rows, out of which 1 are empty, making the null percent 0.32. Minimum value is 5 and maximum value is 992.
label string The label for the dimension value. Column label has 312 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Akaa and maximum string is Äänekoski.
orig_extractdate string The date when the data was originally fetched from the source.

Dim year, Statfin perh pxt 001 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 1992 and maximum value is 2018.
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 1992 and maximum value is 2018.
orig_extractdate string The date when the data was originally fetched from the source.

Dim year, Statfin perh pxt 001 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 1992 and maximum value is 2018.
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 1992 and maximum value is 2018.

Dim family type, Statfin perh pxt 001 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 7 rows, out of which 1 are empty, making the null percent 14.29. Minimum value is 1 and maximum value is 6.
label string The label for the dimension value. Column label has 7 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 couple with ch... and first 25 characters of maximum string: Father and children...

Dim family type, Statfin perh pxt 001 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 7 rows, out of which 1 are empty, making the null percent 14.29. Minimum value is 1 and maximum value is 6.
label string The label for the dimension value. Column label has 7 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 couple with ch... and first 25 characters of maximum string: Father and children...
orig_extractdate string The date when the data was originally fetched from the source.

Dim information, Statfin perh pxt 001 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: perhlkm.
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, number.

Additional Info

Last Updated September 22, 2019
Created August 6, 2019