Household consumption expenditure by major region 1985-2012 (NUTS 2)

Tables

Dim Consumption Expenditure, Household Consumption Expenditure By Major Region 1985 2012 Nuts2TSV
Dimension Consumption_expenditure (Kulutusmenot)
Dim Consumption Unit, Household Consumption Expenditure By Major Region 1985 2012 Nuts2TSV
Dimension Consumption_unit (Kulutustyyppi)
Dim Major Region, Household Consumption Expenditure By Major Region 1985 2012 Nuts2TSV
Dimension Major_region (Alue)
Dim Price, Household Consumption Expenditure By Major Region 1985 2012 Nuts2TSV
Dimension Price (Hinta)
Dim Year, Household Consumption Expenditure By Major Region 1985 2012 Nuts2TSV
Dimension Year (Vuosi)
Fact, Household Consumption Expenditure By Major Region 1985 2012 Nuts2TSV
Household consumption expenditure by major region by Consumption expenditure, Price, Consumption unit, Major region and Year

Column Descriptions

Fact, Household Consumption Expenditure By Major Region 1985 2012 Nuts2

Column	Type	Comment
consumption_expenditure	string	Datasource did not contain a description for Consumption_expenditure. Column consumption_expenditure has 166488 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 166488 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 166488 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.
major_region	int	Datasource did not contain a description for Major_region. Column major_region has 166488 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 166488 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_major_region	int	Datasource did not contain a description for Household_consumption_expenditure_by_major_region. Column household_consumption_expenditure_by_major_region has 166488 rows, out of which 78476 are empty, making the null percent 47.14. 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 Major Region 1985 2012 Nuts2

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 Kaytetmk and maximum string is Perusjoukossa.
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: BACKGROUND DATA: Average ... 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 Major Region 1985 2012 Nuts2

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 Consumption Unit, Household Consumption Expenditure By Major Region 1985 2012 Nuts2

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.

Dim Major Region, Household Consumption Expenditure By Major Region 1985 2012 Nuts2

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

Dim Year, Household Consumption Expenditure By Major Region 1985 2012 Nuts2

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.

Additional Info

Last Updated	April 12, 2019
Created	November 30, 2018