006 -- Household consumption expenditure by size and structure of household 1985-2016

Tables

Dim Consumption Unit, T006 Household Consumption Expenditure By Size And Structure Of Household 1985 2016TSV
Dimension Consumption_unit (Kulutustyyppi)
Dim Price, T006 Household Consumption Expenditure By Size And Structure Of Household 1985 2016TSV
Dimension Price (Hinta)
Dim Size And Structure Of Household, T006 Household Consumption Expenditure By Size And Structure Of Household 1985 2016TSV
Dimension Size_and_structure_of_household (Kotitalouden koko ja rakenne)
Dim Year, T006 Household Consumption Expenditure By Size And Structure Of Household 1985 2016TSV
Dimension Year (Vuosi)
Fact, T006 Household Consumption Expenditure By Size And Structure Of Household 1985 2016TSV
Household consumption expenditure by size and structure of household by Consumption expenditure, Price, Year, Size and structure of household and Consumption unit

Column Descriptions

Fact, T006 Household Consumption Expenditure By Size And Structure Of Household 1985 2016

Column	Type	Comment
consumption_expenditure	string	The interview question of public healthcare charges has been changed (affects groups A0621102, A06311S1 ja A06311S2). The data are comparable to previous years when the above-mentioned groups are summed up. . Column consumption_expenditure has 320640 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 320640 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.
year	int	Datasource did not contain a description for Year. Column year has 320640 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 2016.
size_and_structure_of_household	int	Datasource did not contain a description for Size_and_structure_of_household. Column size_and_structure_of_household has 320640 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 10.
consumption_unit	int	Datasource did not contain a description for Consumption_unit. Column consumption_unit has 320640 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.
household_consumption_expenditure_by_size_and_structure_of_household	int	Datasource did not contain a description for Household_consumption_expenditure_by_size_and_structure_of_household. Column household_consumption_expenditure_by_size_and_structure_of_household has 320640 rows, out of which 148476 are empty, making the null percent 46.31. Minimum value is 0 and maximum value is 2677100.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim Price, T006 Household Consumption Expenditure By Size And Structure Of Household 1985 2016

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 2016 prices and maximum string is At current prices.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim Year, T006 Household Consumption Expenditure By Size And Structure Of Household 1985 2016

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

Dim Size And Structure Of Household, T006 Household Consumption Expenditure By Size And Structure Of Household 1985 2016

Column	Type	Comment
code	int	The code for the dimension value. Column code has 10 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 10.
label	string	The label for the dimension value. Column label has 10 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1 adult and maximum string is Others.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim Consumption Unit, T006 Household Consumption Expenditure By Size And Structure Of Household 1985 2016

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

Additional Info

Last Updated	April 24, 2019
Created	April 22, 2019