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

007 -- Household income: structure by household type according to number of adults, children and economically active persons in household 1987-2017

007 -- Household income: structure by household type according to number of adults, children and economically active persons in household 1987-2017

Tables

Column Descriptions

Dim number of adults and children, Statfin tjt pxt 007 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 16 rows, out of which 1 are empty, making the null percent 6.25. Minimum value is 1 and maximum value is 15.
label string 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. First 25 characters of minimum string: 1 adult, economically act... and first 25 characters of maximum string: 3 adults, 3 economically ...
orig_extractdate string The date when the data was originally fetched from the source.

Dim year, Statfin tjt pxt 007 px, Full history

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

Dim year, Statfin tjt pxt 007 px, Latest

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

Dim data, Statfin tjt pxt 007 px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 33 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ailunum_mean and maximum string is Ktu_mean.
label string The label for the dimension value. Column label has 33 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1. Wages and salaries and maximum string is Disposable income.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfin tjt pxt 007 px, Full history

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 16368 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1987 and maximum value is 2017.
data string Datasource did not contain a description for Data. Column data has 16368 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ailunum_mean and maximum string is Ktu_mean.
number_of_adults_and_children int Datasource did not contain a description for Number_of_adults_and_children. Column number_of_adults_and_children has 16368 rows, out of which 1023 are empty, making the null percent 6.25. Minimum value is 1 and maximum value is 15.
household_income_structure int Datasource did not contain a description for Household_income_structure. Column household_income_structure has 16368 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -258 and maximum value is 2713300.
orig_extractdate string The date when the data was originally fetched from the source.

Dim data, Statfin tjt pxt 007 px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 33 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ailunum_mean and maximum string is Ktu_mean.
label string The label for the dimension value. Column label has 33 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1. Wages and salaries and maximum string is Disposable income.

Dim number of adults and children, Statfin tjt pxt 007 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 16 rows, out of which 1 are empty, making the null percent 6.25. Minimum value is 1 and maximum value is 15.
label string 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. First 25 characters of minimum string: 1 adult, economically act... and first 25 characters of maximum string: 3 adults, 3 economically ...

Fact, Statfin tjt pxt 007 px, Latest

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 16368 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1987 and maximum value is 2017.
data string Datasource did not contain a description for Data. Column data has 16368 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ailunum_mean and maximum string is Ktu_mean.
number_of_adults_and_children int Datasource did not contain a description for Number_of_adults_and_children. Column number_of_adults_and_children has 16368 rows, out of which 1023 are empty, making the null percent 6.25. Minimum value is 1 and maximum value is 15.
household_income_structure int Datasource did not contain a description for Household_income_structure. Column household_income_structure has 16368 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -258 and maximum value is 2713300.

Additional Info

Last Updated July 22, 2019
Created July 19, 2019