1. Home
  2. Datasets
  3. 003 -- Sähkön hankinta ja ...
To download the data set, please sign up or log in

003 -- Sähkön hankinta ja kokonaiskulutus, GWh

003 -- Sähkön hankinta ja kokonaiskulutus, GWh

Tables

Column Descriptions

Dim jakso, Statfin ehk pxt 003 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 20 rows, out of which 8 are empty, making the null percent 40.00. Minimum value is 1 and maximum value is 12.
label string The label for the dimension value. Column label has 20 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1. Vuosineljännes and maximum string is Tammi-joulukuu kum.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfin ehk pxt 003 fi px, Full history

Column Type Comment
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 172800 rows, out of which 5760 are empty, making the null percent 3.33. Minimum value is 1960 and maximum value is 2017.
jakso int Datasource did not contain a description for Jakso. Column jakso has 172800 rows, out of which 69120 are empty, making the null percent 40.00. Minimum value is 1 and maximum value is 12.
tuotantohankinta int Datasource did not contain a description for TuotantoHankinta. Column tuotantohankinta has 172800 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 27.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 172800 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 Osuuskt.
sahkon_hankinta_ja_kokonaiskulutus_gwh int Datasource did not contain a description for Sahkon_hankinta_ja_kokonaiskulutus_GWh. Column sahkon_hankinta_ja_kokonaiskulutus_gwh has 172800 rows, out of which 119879 are empty, making the null percent 69.37. Minimum value is -18683 and maximum value is 84157821.
orig_extractdate string The date when the data was originally fetched from the source.

Dim tuotantohankinta, Statfin ehk pxt 003 fi px, Latest

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

Dim tiedot, Statfin ehk pxt 003 fi px, Full history

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 Arvo and maximum string is Osuuskt.
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. First 25 characters of minimum string: Kuukausimuutos %... and first 25 characters of maximum string: Osuus kokonaiskulutuksest...
orig_extractdate string The date when the data was originally fetched from the source.

Dim tuotantohankinta, Statfin ehk pxt 003 fi px, Full history

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

Dim vuosi, Statfin ehk pxt 003 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 59 rows, out of which 1 are empty, making the null percent 1.69. Minimum value is 1960 and maximum value is 2017.
label int The label for the dimension value. Column label has 59 rows, out of which 1 are empty, making the null percent 1.69. Minimum value is 1960 and maximum value is 2017.

Dim tiedot, Statfin ehk pxt 003 fi px, Latest

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 Arvo and maximum string is Osuuskt.
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. First 25 characters of minimum string: Kuukausimuutos %... and first 25 characters of maximum string: Osuus kokonaiskulutuksest...

Dim jakso, Statfin ehk pxt 003 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 20 rows, out of which 8 are empty, making the null percent 40.00. Minimum value is 1 and maximum value is 12.
label string The label for the dimension value. Column label has 20 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1. Vuosineljännes and maximum string is Tammi-joulukuu kum.

Additional Info

Last Updated September 22, 2019
Created August 6, 2019