Household consumption expenditure by statistical grouping of municipalities 1985-2012

Tables

Dim Consumption Expenditure, Household Consumption Expenditure By Statistical Grouping Of Municipalities 1985 2012TSV
Dimension Consumption_expenditure (Kulutusmenot)
Dim Consumption Unit, Household Consumption Expenditure By Statistical Grouping Of Municipalities 1985 2012TSV
Dimension Consumption_unit (Kulutustyyppi)
Dim Price, Household Consumption Expenditure By Statistical Grouping Of Municipalities 1985 2012TSV
Dimension Price (Hinta)
Dim Year, Household Consumption Expenditure By Statistical Grouping Of Municipalities 1985 2012TSV
Dimension Year (Vuosi)
Fact, Household Consumption Expenditure By Statistical Grouping Of Municipalities 1985 2012TSV
Household consumption expenditure by statistical grouping of municipalities by Consumption expenditure, Price, Consumption unit, Statistical grouping of municipalities and Year

Column Descriptions

Fact, Household Consumption Expenditure By Statistical Grouping Of Municipalities 1985 2012

Column	Type	Comment
consumption_expenditure	string	Datasource did not contain a description for Consumption_expenditure. Column consumption_expenditure has 110992 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 110992 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	No description available. Column consumption_unit has 110992 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.
statistical_grouping_of_municipalities	int	No description available. Column statistical_grouping_of_municipalities has 110992 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	No description available. Column year has 110992 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_statistical_grouping_of_municipalities	int	Datasource did not contain a description for Household_consumption_expenditure_by_statistical_grouping_of_municipalities. Column household_consumption_expenditure_by_statistical_grouping_of_municipalities has 110992 rows, out of which 48804 are empty, making the null percent 43.97. 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 Statistical Grouping Of Municipalities 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 Statistical Grouping Of Municipalities 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 Consumption Unit, Household Consumption Expenditure By Statistical Grouping Of Municipalities 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 Year, Household Consumption Expenditure By Statistical Grouping Of Municipalities 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.

Additional Info

Last Updated	April 12, 2019
Created	November 29, 2018