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

004 -- Sähkön hinta kuluttajatyypeittäin, snt/kWh (Hinnat sisältävät sähköenergian, siirtomaksun ja verot.)

004 -- Sähkön hinta kuluttajatyypeittäin, snt/kWh (Hinnat sisältävät sähköenergian, siirtomaksun ja verot.)

Tables

Column Descriptions

Dim kuluttajatyyppi, Statfin ehi pxt 004 fi 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 (Kerrostalohuoneisto, ... and first 25 characters of maximum string: T10 (Yritys- ja yhteisöas...

Fact, Statfin ehi pxt 004 fi px, Latest

Column Type Comment
kuluttajatyyppi string Datasource did not contain a description for Kuluttajatyyppi. Column kuluttajatyyppi 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.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi 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.
kuukausi int Datasource did not contain a description for Kuukausi. Column kuukausi 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.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot 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.
sahkon_hinta_kuluttajatyypeittain_sntkwh_hinnat_sisaltavat_sahkoenergian_siirtomaksun_ja_verot int Datasource did not contain a description for Sahkon_hinta_kuluttajatyypeittain_sntkWh_Hinnat_sisaltavat_sahkoenergian_siirtomaksun_ja_verot. Column sahkon_hinta_kuluttajatyypeittain_sntkwh_hinnat_sisaltavat_sahkoenergian_siirtomaksun_ja_verot has 10752 rows, out of which 5134 are empty, making the null percent 47.75. Minimum value is -16 and maximum value is 45.

Dim kuluttajatyyppi, Statfin ehi pxt 004 fi 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 (Kerrostalohuoneisto, ... and first 25 characters of maximum string: T10 (Yritys- ja yhteisöas...
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfin ehi pxt 004 fi px, Full history

Column Type Comment
kuluttajatyyppi string Datasource did not contain a description for Kuluttajatyyppi. Column kuluttajatyyppi 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.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi 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.
kuukausi int Datasource did not contain a description for Kuukausi. Column kuukausi 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.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot 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.
sahkon_hinta_kuluttajatyypeittain_sntkwh_hinnat_sisaltavat_sahkoenergian_siirtomaksun_ja_verot int Datasource did not contain a description for Sahkon_hinta_kuluttajatyypeittain_sntkWh_Hinnat_sisaltavat_sahkoenergian_siirtomaksun_ja_verot. Column sahkon_hinta_kuluttajatyypeittain_sntkwh_hinnat_sisaltavat_sahkoenergian_siirtomaksun_ja_verot 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.

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

Dim kuukausi, Statfin ehi pxt 004 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 kuukausi, Statfin ehi pxt 004 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 vuosi, Statfin ehi pxt 004 fi 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 vuosi, Statfin ehi pxt 004 fi 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 tiedot, Statfin ehi pxt 004 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 snt/kWh and maximum string is Vuosimuutos %.

Additional Info

Last Updated August 4, 2019
Created August 2, 2019