002 -- Income of household by life-cycle 1989-2017

Tables

Dim data, Statfin tjt pxt 002 px, Full historyTSV
Dimension Data (Tiedot)
Dim data, Statfin tjt pxt 002 px, LatestTSV
Dimension Data (Tiedot)
Dim income unit, Statfin tjt pxt 002 px, Full historyTSV
Dimension Income_unit (Tulonkäyttöyksikkö)
Dim income unit, Statfin tjt pxt 002 px, LatestTSV
Dimension Income_unit (Tulonkäyttöyksikkö)
Dim lifecycle of household, Statfin tjt pxt 002 px, Full historyTSV
Dimension Lifecycle_of_household (Kotitalouden elinvaihe)
Dim lifecycle of household, Statfin tjt pxt 002 px, LatestTSV
Dimension Lifecycle_of_household (Kotitalouden elinvaihe)
Dim year, Statfin tjt pxt 002 px, Full historyTSV
Dimension Year (Vuosi)
Dim year, Statfin tjt pxt 002 px, LatestTSV
Dimension Year (Vuosi)
Fact, Statfin tjt pxt 002 px, Full historyTSV
Income of household by Year, Life-cycle of household, Income unit and Data
Fact, Statfin tjt pxt 002 px, LatestTSV
Income of household by Year, Life-cycle of household, Income unit and Data

Column Descriptions

Dim data, Statfin tjt pxt 002 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 lifecycle of household, Statfin tjt pxt 002 px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 18 rows, out of which 1 are empty, making the null percent 5.56. Minimum value is 1 and maximum value is 35.
label	string	The label for the dimension value. Column label has 18 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.1 One-person households... and first 25 characters of maximum string: 6. Other households...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim income unit, Statfin tjt pxt 002 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 lifecycle of household, Statfin tjt pxt 002 px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 18 rows, out of which 1 are empty, making the null percent 5.56. Minimum value is 1 and maximum value is 35.
label	string	The label for the dimension value. Column label has 18 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.1 One-person households... and first 25 characters of maximum string: 6. Other households...

Dim income unit, Statfin tjt pxt 002 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.

Fact, Statfin tjt pxt 002 px, Full history

Column	Type	Comment
year	int	Datasource did not contain a description for Year. Column year has 7308 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1989 and maximum value is 2017.
lifecycle_of_household	int	Datasource did not contain a description for Lifecycle_of_household. Column lifecycle_of_household has 7308 rows, out of which 406 are empty, making the null percent 5.56. Minimum value is 1 and maximum value is 35.
income_unit	int	Datasource did not contain a description for Income_unit. Column income_unit has 7308 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 7308 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 7308 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 2713300.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim year, Statfin tjt pxt 002 px, Latest

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

Dim year, Statfin tjt pxt 002 px, Full history

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

Fact, Statfin tjt pxt 002 px, Latest

Column	Type	Comment
year	int	Datasource did not contain a description for Year. Column year has 7308 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1989 and maximum value is 2017.
lifecycle_of_household	int	Datasource did not contain a description for Lifecycle_of_household. Column lifecycle_of_household has 7308 rows, out of which 406 are empty, making the null percent 5.56. Minimum value is 1 and maximum value is 35.
income_unit	int	Datasource did not contain a description for Income_unit. Column income_unit has 7308 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 7308 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 7308 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 2713300.

Dim data, Statfin tjt pxt 002 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...

Additional Info

Last Updated	September 22, 2019
Created	August 6, 2019