Dataset: Electricity Prices For Industrial Consumers - Bi-annual Data (until 2007)

About this Dataset

Electricity Prices For Industrial Consumers - Bi-annual Data (until 2007)

This Eurostat dataset contains data on electricity prices for industrial consumers - bi-annual data (until 2007), as collected and published by the Statistical Office of the European Union.

Tables included:

raw: Original table as downloaded from Eurostat.
tidy: A cleaned and transformed version of the raw table, where time period values appear as rows instead of columns (unpivoted format).

Last updated: 2021-05-28T23:00:00+0200

Tables

Electricity Prices For Industrial Consumers - Bi-annual Data (until 2007) - Raw

@eurostat.nrg_pc_205_h.raw

188.99 KB
1884 rows
47 columns


CREATE TABLE raw (
  "freq" VARCHAR,
  "product" VARCHAR,
  "consom" VARCHAR,
  "unit" VARCHAR,
  "tax" VARCHAR,
  "currency" VARCHAR,
  "geo" VARCHAR,
  "n_1985_s1" DOUBLE,
  "n_1986_s1" DOUBLE,
  "n_1987_s1" DOUBLE,
  "n_1988_s1" DOUBLE,
  "n_1989_s1" DOUBLE,
  "n_1990_s1" DOUBLE,
  "n_1991_s1" DOUBLE,
  "n_1991_s2" DOUBLE,
  "n_1992_s1" DOUBLE,
  "n_1992_s2" DOUBLE,
  "n_1993_s1" DOUBLE,
  "n_1993_s2" DOUBLE,
  "n_1994_s1" DOUBLE,
  "n_1994_s2" DOUBLE,
  "n_1995_s1" DOUBLE,
  "n_1995_s2" DOUBLE,
  "n_1996_s1" DOUBLE,
  "n_1996_s2" DOUBLE,
  "n_1997_s1" DOUBLE,
  "n_1997_s2" DOUBLE,
  "n_1998_s1" DOUBLE,
  "n_1998_s2" DOUBLE,
  "n_1999_s1" DOUBLE,
  "n_1999_s2" DOUBLE,
  "n_2000_s1" DOUBLE,
  "n_2000_s2" DOUBLE,
  "n_2001_s1" DOUBLE,
  "n_2001_s2" DOUBLE,
  "n_2002_s1" DOUBLE,
  "n_2002_s2" DOUBLE,
  "n_2003_s1" DOUBLE,
  "n_2003_s2" DOUBLE,
  "n_2004_s1" DOUBLE,
  "n_2004_s2" DOUBLE,
  "n_2005_s1" DOUBLE,
  "n_2005_s2" DOUBLE,
  "n_2006_s1" DOUBLE,
  "n_2006_s2" DOUBLE,
  "n_2007_s1" DOUBLE,
  "n_2007_s2" DOUBLE
);

Electricity Prices For Industrial Consumers - Bi-annual Data (until 2007) - Unpivoted

@eurostat.nrg_pc_205_h.tidy

80.51 KB
31908 rows
9 columns


CREATE TABLE tidy (
  "freq" VARCHAR,
  "product" VARCHAR,
  "consom" VARCHAR,
  "unit" VARCHAR,
  "tax" VARCHAR,
  "currency" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);