1. Home
  2. Datasets
  3. 010 -- Pohjoismaisen ...
To download the data set, please sign up or log in

010 -- Pohjoismaisen sähköpörssin spot-hintoja hinta-alueittain

010 -- Pohjoismaisen sähköpörssin spot-hintoja hinta-alueittain

Tables

Column Descriptions

Dim tiedot, Statfin ehi pxt 010 fi 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 €/MWh and maximum string is Vuosimuutos %.

Dim alue, Statfin ehi pxt 010 fi px, Full history

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

Fact, Statfin ehi pxt 010 fi px, Full history

Column Type Comment
alue string Datasource did not contain a description for Alue. Column alue has 11362 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Bergen and maximum string is LT.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 11362 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1997 and maximum value is 2019.
jakso int Datasource did not contain a description for Jakso. Column jakso has 11362 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 12.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 11362 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.
pohjoismaisen_sahkoporssin_spothintoja_hintaalueittain int Datasource did not contain a description for Pohjoismaisen_sahkoporssin_spothintoja_hintaalueittain. Column pohjoismaisen_sahkoporssin_spothintoja_hintaalueittain has 11362 rows, out of which 4664 are empty, making the null percent 41.05. Minimum value is -92 and maximum value is 811.
orig_extractdate string The date when the data was originally fetched from the source.

Dim jakso, Statfin ehi pxt 010 fi px, Latest

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

Dim tiedot, Statfin ehi pxt 010 fi 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 €/MWh and maximum string is Vuosimuutos %.
orig_extractdate string The date when the data was originally fetched from the source.

Dim jakso, Statfin ehi pxt 010 fi px, Full history

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

Dim vuosi, Statfin ehi pxt 010 fi px, Full history

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

Fact, Statfin ehi pxt 010 fi px, Latest

Column Type Comment
alue string Datasource did not contain a description for Alue. Column alue has 11362 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Bergen and maximum string is LT.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 11362 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1997 and maximum value is 2019.
jakso int Datasource did not contain a description for Jakso. Column jakso has 11362 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 12.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 11362 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.
pohjoismaisen_sahkoporssin_spothintoja_hintaalueittain int Datasource did not contain a description for Pohjoismaisen_sahkoporssin_spothintoja_hintaalueittain. Column pohjoismaisen_sahkoporssin_spothintoja_hintaalueittain has 11362 rows, out of which 4664 are empty, making the null percent 41.05. Minimum value is -92 and maximum value is 811.

Dim alue, Statfin ehi pxt 010 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 19 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Bergen and maximum string is LT.
label string The label for the dimension value. Column label has 19 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Bergen and maximum string is Liettua.

Dim vuosi, Statfin ehi pxt 010 fi px, Latest

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

Additional Info

Last Updated July 20, 2019
Created July 16, 2019