002 -- Household consumption expenditure by socio-economic status and division 1990-2016

Tables

Dim Consumption Expenditure, T002 Household Consumption Expenditure By Socio Economic Status And Division 1990 2016TSV
Dimension Consumption_expenditure (Kulutusmenot)
Dim Consumption Unit, T002 Household Consumption Expenditure By Socio Economic Status And Division 1990 2016TSV
Dimension Consumption_unit (Kulutustyyppi)
Dim Price, T002 Household Consumption Expenditure By Socio Economic Status And Division 1990 2016TSV
Dimension Price (Hinta)
Dim Year, T002 Household Consumption Expenditure By Socio Economic Status And Division 1990 2016TSV
Dimension Year (Vuosi)
Fact, T002 Household Consumption Expenditure By Socio Economic Status And Division 1990 2016TSV
Household consumption expenditure by socio-economic status and division by Consumption expenditure, Price, Year, Reference personŽs socioeconomic status and division and Consumption unit

Column Descriptions

Fact, T002 Household Consumption Expenditure By Socio Economic Status And Division 1990 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 280560 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 280560 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 280560 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1990 and maximum value is 2016.
reference_personzs_socioeconomic_status_and_division	int	Datasource did not contain a description for Reference_personZs_socioeconomic_status_and_division. Column reference_personzs_socioeconomic_status_and_division has 280560 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 10 and maximum value is 90.
consumption_unit	int	Datasource did not contain a description for Consumption_unit. Column consumption_unit has 280560 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_socioeconomic_status_and_division	int	Datasource did not contain a description for Household_consumption_expenditure_by_socioeconomic_status_and_division. Column household_consumption_expenditure_by_socioeconomic_status_and_division has 280560 rows, out of which 133208 are empty, making the null percent 47.48. Minimum value is 0 and maximum value is 2677100.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim Consumption Expenditure, T002 Household Consumption Expenditure By Socio Economic Status And Division 1990 2016

Column	Type	Comment
code	string	The code for the dimension value. Column code has 1002 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 1002 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, T002 Household Consumption Expenditure By Socio Economic Status And Division 1990 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, T002 Household Consumption Expenditure By Socio Economic Status And Division 1990 2016

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

Dim Consumption Unit, T002 Household Consumption Expenditure By Socio Economic Status And Division 1990 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 21, 2019
Created	April 10, 2019