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

002 -- Kivihiilen ja maakaasun käyttäjähinnat energiantuotannossa (ei sis. alv:a)

002 -- Kivihiilen ja maakaasun käyttäjähinnat energiantuotannossa (ei sis. alv:a)

Tables

Column Descriptions

Fact, Statfin ehi pxt 002 fi px, Latest

Column Type Comment
polttoaine string Datasource did not contain a description for Polttoaine. Column polttoaine has 8640 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A and maximum string is L.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 8640 rows, out of which 576 are empty, making the null percent 6.67. Minimum value is 1990 and maximum value is 2017.
jakso int Datasource did not contain a description for Jakso. Column jakso has 8640 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.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 8640 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.
kivihiilen_ja_maakaasun_kayttajahinnat_energiantuotannossa_ei_sis_alva int Datasource did not contain a description for Kivihiilen_ja_maakaasun_kayttajahinnat_energiantuotannossa_ei_sis_alva. Column kivihiilen_ja_maakaasun_kayttajahinnat_energiantuotannossa_ei_sis_alva has 8640 rows, out of which 360 are empty, making the null percent 4.17. Minimum value is -60 and maximum value is 532.

Dim jakso, Statfin ehi pxt 002 fi 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 Elokuu and maximum string is Joulukuu.

Dim jakso, Statfin ehi pxt 002 fi 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 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 002 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 29 rows, out of which 1 are empty, making the null percent 3.45. Minimum value is 1990 and maximum value is 2017.
label int The label for the dimension value. Column label has 29 rows, out of which 1 are empty, making the null percent 3.45. Minimum value is 1990 and maximum value is 2017.
orig_extractdate string The date when the data was originally fetched from the source.

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

Dim polttoaine, Statfin ehi pxt 002 fi px, Latest

Column Type Comment
code string 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 string is A and maximum string is L.
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. First 25 characters of minimum string: Kivihiili rannikolla, €/M... and first 25 characters of maximum string: Maakaasun hinta (ylempi l...

Dim vuosi, Statfin ehi pxt 002 fi px, Latest

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

Dim tiedot, Statfin ehi pxt 002 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 Hinta and maximum string is Vuosimuutos, %.

Dim polttoaine, Statfin ehi pxt 002 fi px, Full history

Column Type Comment
code string 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 string is A and maximum string is L.
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. First 25 characters of minimum string: Kivihiili rannikolla, €/M... and first 25 characters of maximum string: Maakaasun hinta (ylempi l...
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfin ehi pxt 002 fi px, Full history

Column Type Comment
polttoaine string Datasource did not contain a description for Polttoaine. Column polttoaine has 8640 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A and maximum string is L.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 8640 rows, out of which 576 are empty, making the null percent 6.67. Minimum value is 1990 and maximum value is 2017.
jakso int Datasource did not contain a description for Jakso. Column jakso has 8640 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.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 8640 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.
kivihiilen_ja_maakaasun_kayttajahinnat_energiantuotannossa_ei_sis_alva int Datasource did not contain a description for Kivihiilen_ja_maakaasun_kayttajahinnat_energiantuotannossa_ei_sis_alva. Column kivihiilen_ja_maakaasun_kayttajahinnat_energiantuotannossa_ei_sis_alva has 8640 rows, out of which 360 are empty, making the null percent 4.17. Minimum value is -60 and maximum value is 532.
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