Household consumption expenditure by type of household 1985-2012

Tables

Dim Consumption Expenditure, Household Consumption Expenditure By Type Of Household 1985 2012TSV
Dimension Consumption_expenditure (Kulutusmenot)
Dim Consumption Unit, Household Consumption Expenditure By Type Of Household 1985 2012TSV
Dimension Consumption_unit (Kulutustyyppi)
Dim Price, Household Consumption Expenditure By Type Of Household 1985 2012TSV
Dimension Price (Hinta)
Dim Type Of Household, Household Consumption Expenditure By Type Of Household 1985 2012TSV
Dimension Type_of_household (Kotitaloustyyppi)
Dim Year, Household Consumption Expenditure By Type Of Household 1985 2012TSV
Dimension Year (Vuosi)
Fact, Household Consumption Expenditure By Type Of Household 1985 2012TSV
Household consumption expenditure by type of household by Consumption expenditure, Price, Consumption unit, Type of household and Year

Column Descriptions

Fact, Household Consumption Expenditure By Type Of Household 1985 2012

Column	Type	Comment
consumption_expenditure	string	Datasource did not contain a description for Consumption_expenditure. Column consumption_expenditure has 194236 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A01 and maximum string is Kaytetmk.
price	string	Datasource did not contain a description for Price. Column price has 194236 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kaypa_Hinta and maximum string is Viitev_Hinta.
consumption_unit	int	Datasource did not contain a description for Consumption_unit. Column consumption_unit has 194236 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.
type_of_household	int	Datasource did not contain a description for Type_of_household. Column type_of_household has 194236 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 7.
year	int	Datasource did not contain a description for Year. Column year has 194236 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1985 and maximum value is 2012.
household_consumption_expenditure_by_type_of_household	int	Datasource did not contain a description for Household_consumption_expenditure_by_type_of_household. Column household_consumption_expenditure_by_type_of_household has 194236 rows, out of which 90880 are empty, making the null percent 46.79. Minimum value is 0 and maximum value is 2595000.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim Consumption Expenditure, Household Consumption Expenditure By Type Of Household 1985 2012

Column	Type	Comment
code	string	The code for the dimension value. Column code has 991 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A01 and maximum string is Kaytetmk.
label	string	The label for the dimension value. Column label has 991 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: A01_12 Total consumption... and first 25 characters of maximum string: BACKGROUND DATA: Househol...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim Price, Household Consumption Expenditure By Type Of Household 1985 2012

Column	Type	Comment
code	string	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 string is Kaypa_Hinta and maximum string is Viitev_Hinta.
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. Minimum string is At 2012 prices and maximum string is At current prices.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim Year, Household Consumption Expenditure By Type Of Household 1985 2012

Column	Type	Comment
code	int	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 value is 1985 and maximum value is 2012.
label	int	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. Minimum value is 1985 and maximum value is 2012.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim Consumption Unit, Household Consumption Expenditure By Type Of Household 1985 2012

Column	Type	Comment
code	string	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 string is 1 and maximum string 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. Minimum string is Consumption unit and maximum string is Household.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim Type Of Household, Household Consumption Expenditure By Type Of Household 1985 2012

Column	Type	Comment
code	int	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 value is 1 and maximum value is 7.
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: Couple without children, ... and first 25 characters of maximum string: Other households...
orig_extractdate	string	The date when the data was originally fetched from the source.

Additional Info

Last Updated	April 12, 2019
Created	November 27, 2018