004 -- Price of Electricity by Type of Consumer, c/kWh (Prices include electrical energy, distribution of electricity, and taxes.)

Tables

Dim data, Statfin ehi pxt 004 en px, Full historyTSV
Dimension Data (Data)
Dim data, Statfin ehi pxt 004 en px, LatestTSV
Dimension Data (Data)
Dim month, Statfin ehi pxt 004 en px, Full historyTSV
Dimension Month (Month)
Dim month, Statfin ehi pxt 004 en px, LatestTSV
Dimension Month (Month)
Dim type of consumer, Statfin ehi pxt 004 en px, Full historyTSV
Dimension Type_of_Consumer (Type of Consumer)
Dim type of consumer, Statfin ehi pxt 004 en px, LatestTSV
Dimension Type_of_Consumer (Type of Consumer)
Dim year, Statfin ehi pxt 004 en px, Full historyTSV
Dimension Year (Year)
Dim year, Statfin ehi pxt 004 en px, LatestTSV
Dimension Year (Year)
Fact, Statfin ehi pxt 004 en px, Full historyTSV
Price of Electricity by Type of Consumer, c/kWh (Prices include electrical energy, distribution of electricity, and taxes.) by Type of Consumer, Year, Month and Data
Fact, Statfin ehi pxt 004 en px, LatestTSV
Price of Electricity by Type of Consumer, c/kWh (Prices include electrical energy, distribution of electricity, and taxes.) by Type of Consumer, Year, Month and Data

Column Descriptions

Dim type of consumer, Statfin ehi pxt 004 en px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is K1 and maximum string is T10.
label	string	The label for the dimension value. Column label has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: K1 (Apartment house, no e... and first 25 characters of maximum string: T10 (Enterprise and corpo...

Dim data, Statfin ehi pxt 004 en px, Latest

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 Arvo and maximum string is Muutos.
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 Annual change, % and maximum string is c/kWh.

Dim year, Statfin ehi pxt 004 en px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 27 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1992 and maximum value is 2018.
label	int	The label for the dimension value. Column label has 27 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1992 and maximum value is 2018.

Dim type of consumer, Statfin ehi pxt 004 en px, Full history

Column	Type	Comment
code	string	The code for the dimension value. Column code has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is K1 and maximum string is T10.
label	string	The label for the dimension value. Column label has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: K1 (Apartment house, no e... and first 25 characters of maximum string: T10 (Enterprise and corpo...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim data, Statfin ehi pxt 004 en px, Full history

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 Arvo and maximum string is Muutos.
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 Annual change, % and maximum string is c/kWh.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim year, Statfin ehi pxt 004 en px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 27 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1992 and maximum value is 2018.
label	int	The label for the dimension value. Column label has 27 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1992 and maximum value is 2018.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim month, Statfin ehi pxt 004 en px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 12 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 12.
label	string	The label for the dimension value. Column label has 12 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is April and maximum string is December.

Dim month, Statfin ehi pxt 004 en px, Full history

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

Fact, Statfin ehi pxt 004 en px, Full history

Column	Type	Comment
type_of_consumer	string	Datasource did not contain a description for Type_of_Consumer. Column type_of_consumer has 10752 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is K1 and maximum string is T10.
year	int	Datasource did not contain a description for Year. Column year has 10752 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1992 and maximum value is 2019.
month	int	Datasource did not contain a description for Month. Column month has 10752 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 12.
data	string	Datasource did not contain a description for Data. Column data has 10752 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Arvo and maximum string is Muutos.
price_of_electricity_by_type_of_consumer_ckwh_prices_include_electrical_energy_distribution_of_electricity_and_taxes	int	Datasource did not contain a description for Price_of_Electricity_by_Type_of_Consumer_ckWh_Prices_include_electrical_energy_distribution_of_electricity_and_taxes. Column price_of_electricity_by_type_of_consumer_ckwh_prices_include_electrical_energy_distribution_of_electricity_and_taxes has 10752 rows, out of which 5134 are empty, making the null percent 47.75. Minimum value is -16 and maximum value is 45.
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, Statfin ehi pxt 004 en px, Latest

Column	Type	Comment
type_of_consumer	string	Datasource did not contain a description for Type_of_Consumer. Column type_of_consumer has 10752 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is K1 and maximum string is T10.
year	int	Datasource did not contain a description for Year. Column year has 10752 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1992 and maximum value is 2019.
month	int	Datasource did not contain a description for Month. Column month has 10752 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 12.
data	string	Datasource did not contain a description for Data. Column data has 10752 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Arvo and maximum string is Muutos.
price_of_electricity_by_type_of_consumer_ckwh_prices_include_electrical_energy_distribution_of_electricity_and_taxes	int	Datasource did not contain a description for Price_of_Electricity_by_Type_of_Consumer_ckWh_Prices_include_electrical_energy_distribution_of_electricity_and_taxes. Column price_of_electricity_by_type_of_consumer_ckwh_prices_include_electrical_energy_distribution_of_electricity_and_taxes has 10752 rows, out of which 5134 are empty, making the null percent 47.75. Minimum value is -16 and maximum value is 45.

Additional Info

Last Updated	September 22, 2019
Created	August 6, 2019