003 -- Income of household by age of reference person 1966-2017

Tables

Dim age of reference person, Statfin tjt pxt 003 px, Full historyTSV
Dimension Age_of_reference_person (Viitehenkilön ikä)
Dim age of reference person, Statfin tjt pxt 003 px, LatestTSV
Dimension Age_of_reference_person (Viitehenkilön ikä)
Dim data, Statfin tjt pxt 003 px, Full historyTSV
Dimension Data (Tiedot)
Dim data, Statfin tjt pxt 003 px, LatestTSV
Dimension Data (Tiedot)
Dim income unit, Statfin tjt pxt 003 px, Full historyTSV
Dimension Income_unit (Tulonkäyttöyksikkö)
Dim income unit, Statfin tjt pxt 003 px, LatestTSV
Dimension Income_unit (Tulonkäyttöyksikkö)
Dim year, Statfin tjt pxt 003 px, Full historyTSV
Dimension Year (Vuosi)
Dim year, Statfin tjt pxt 003 px, LatestTSV
Dimension Year (Vuosi)
Fact, Statfin tjt pxt 003 px, Full historyTSV
Income of household by Year, Age of reference person, Income unit and Data
Fact, Statfin tjt pxt 003 px, LatestTSV
Income of household by Year, Age of reference person, Income unit and Data

Column Descriptions

Dim data, Statfin tjt pxt 003 px, Full history

Column	Type	Comment
code	string	The code for the dimension value. Column code has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Amlunum_mean and maximum string is Ktu_mean.
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: Disposable cash income, m... and first 25 characters of maximum string: Disposable income, mean...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim data, Statfin tjt pxt 003 px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Amlunum_mean and maximum string is Ktu_mean.
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: Disposable cash income, m... and first 25 characters of maximum string: Disposable income, mean...

Dim year, Statfin tjt pxt 003 px, Latest

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

Dim year, Statfin tjt pxt 003 px, Full history

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

Dim income unit, Statfin tjt pxt 003 px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 2.
label	string	The label for the dimension value. Column label has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Income per consumption un... and first 25 characters of maximum string: Income per household...

Dim age of reference person, Statfin tjt pxt 003 px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 8 rows, out of which 1 are empty, making the null percent 12.50. Minimum value is 1 and maximum value is 7.
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 -24 and maximum string is 75-.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim age of reference person, Statfin tjt pxt 003 px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 8 rows, out of which 1 are empty, making the null percent 12.50. Minimum value is 1 and maximum value is 7.
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 -24 and maximum string is 75-.

Fact, Statfin tjt pxt 003 px, Full history

Column	Type	Comment
year	int	Datasource did not contain a description for Year. Column year has 4032 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1966 and maximum value is 2017.
age_of_reference_person	int	Datasource did not contain a description for Age_of_reference_person. Column age_of_reference_person has 4032 rows, out of which 504 are empty, making the null percent 12.50. Minimum value is 1 and maximum value is 7.
income_unit	int	Datasource did not contain a description for Income_unit. Column income_unit has 4032 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 2.
data	string	Datasource did not contain a description for Data. Column data has 4032 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Amlunum_mean and maximum string is Ktu_mean.
income_of_household	int	Datasource did not contain a description for Income_of_household. Column income_of_household has 4032 rows, out of which 64 are empty, making the null percent 1.59. Minimum value is 0 and maximum value is 2713300.
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, Statfin tjt pxt 003 px, Latest

Column	Type	Comment
year	int	Datasource did not contain a description for Year. Column year has 4032 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1966 and maximum value is 2017.
age_of_reference_person	int	Datasource did not contain a description for Age_of_reference_person. Column age_of_reference_person has 4032 rows, out of which 504 are empty, making the null percent 12.50. Minimum value is 1 and maximum value is 7.
income_unit	int	Datasource did not contain a description for Income_unit. Column income_unit has 4032 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 2.
data	string	Datasource did not contain a description for Data. Column data has 4032 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Amlunum_mean and maximum string is Ktu_mean.
income_of_household	int	Datasource did not contain a description for Income_of_household. Column income_of_household has 4032 rows, out of which 64 are empty, making the null percent 1.59. Minimum value is 0 and maximum value is 2713300.

Dim income unit, Statfin tjt pxt 003 px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 2.
label	string	The label for the dimension value. Column label has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Income per consumption un... and first 25 characters of maximum string: Income per household...
orig_extractdate	string	The date when the data was originally fetched from the source.

Additional Info

Last Updated	July 21, 2019
Created	July 20, 2019