To download the data set, please sign up or log in

002 -- Total energy consumption by source (detailed)

002 -- Total energy consumption by source (detailed)

Tables

Column Descriptions

Dim source, Statfin ehk pxt 002 px, Full history

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

Dim tiedot, Statfin ehk pxt 002 px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 4 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 4 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 Share %.

Dim source, Statfin ehk pxt 002 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 26 rows, out of which 2 are empty, making the null percent 7.69. Minimum value is 1 and maximum value is 24.
label string The label for the dimension value. Column label has 26 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aurinkoenergia and maximum string is Total.

Fact, Statfin ehk pxt 002 px, Latest

Column Type Comment
year int Year . Column year has 4992 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1970 and maximum value is 2017.
source int Energy source . Column source has 4992 rows, out of which 384 are empty, making the null percent 7.69. Minimum value is 1 and maximum value is 24.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 4992 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.
total_energy_consumption_by_source_detailed int Datasource did not contain a description for Total_energy_consumption_by_source_detailed. Column total_energy_consumption_by_source_detailed has 4992 rows, out of which 109 are empty, making the null percent 2.18. Minimum value is -100 and maximum value is 1496490.

Dim year, Statfin ehk pxt 002 px, Full history

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

Dim year, Statfin ehk pxt 002 px, Latest

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

Dim tiedot, Statfin ehk pxt 002 px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 4 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 4 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 Share %.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfin ehk pxt 002 px, Full history

Column Type Comment
year int Year . Column year has 4992 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1970 and maximum value is 2017.
source int Energy source . Column source has 4992 rows, out of which 384 are empty, making the null percent 7.69. Minimum value is 1 and maximum value is 24.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 4992 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.
total_energy_consumption_by_source_detailed int Datasource did not contain a description for Total_energy_consumption_by_source_detailed. Column total_energy_consumption_by_source_detailed has 4992 rows, out of which 109 are empty, making the null percent 2.18. Minimum value is -100 and maximum value is 1496490.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated September 22, 2019
Created June 12, 2019