Name: Gas Prices For Industrial Consumers - Bi-annual Data (until 2007)
Creator: Eurostat
License: https://ec.europa.eu/eurostat/statistics-explained/index.php?title=Copyright/licence_policy

About this Dataset

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

This Eurostat dataset contains data on gas 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

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

@eurostat.nrg_pc_203_h.raw

162.15 kB
1,908 rows
47 columns

CREATE TABLE raw (
  "freq" VARCHAR,
  "product" VARCHAR,
  "consom" VARCHAR,
  "unit" VARCHAR,
  "tax" VARCHAR,
  "currency" VARCHAR,
  "geo" VARCHAR,
  "n_1985_s1" DOUBLE  -- 1985-S1,
  "n_1986_s1" DOUBLE  -- 1986-S1,
  "n_1987_s1" DOUBLE  -- 1987-S1,
  "n_1988_s1" DOUBLE  -- 1988-S1,
  "n_1989_s1" DOUBLE  -- 1989-S1,
  "n_1990_s1" DOUBLE  -- 1990-S1,
  "n_1991_s1" DOUBLE  -- 1991-S1,
  "n_1991_s2" DOUBLE  -- 1991-S2,
  "n_1992_s1" DOUBLE  -- 1992-S1,
  "n_1992_s2" DOUBLE  -- 1992-S2,
  "n_1993_s1" DOUBLE  -- 1993-S1,
  "n_1993_s2" DOUBLE  -- 1993-S2,
  "n_1994_s1" DOUBLE  -- 1994-S1,
  "n_1994_s2" DOUBLE  -- 1994-S2,
  "n_1995_s1" DOUBLE  -- 1995-S1,
  "n_1995_s2" DOUBLE  -- 1995-S2,
  "n_1996_s1" DOUBLE  -- 1996-S1,
  "n_1996_s2" DOUBLE  -- 1996-S2,
  "n_1997_s1" DOUBLE  -- 1997-S1,
  "n_1997_s2" DOUBLE  -- 1997-S2,
  "n_1998_s1" DOUBLE  -- 1998-S1,
  "n_1998_s2" DOUBLE  -- 1998-S2,
  "n_1999_s1" DOUBLE  -- 1999-S1,
  "n_1999_s2" DOUBLE  -- 1999-S2,
  "n_2000_s1" DOUBLE  -- 2000-S1,
  "n_2000_s2" DOUBLE  -- 2000-S2,
  "n_2001_s1" DOUBLE  -- 2001-S1,
  "n_2001_s2" DOUBLE  -- 2001-S2,
  "n_2002_s1" DOUBLE  -- 2002-S1,
  "n_2002_s2" DOUBLE  -- 2002-S2,
  "n_2003_s1" DOUBLE  -- 2003-S1,
  "n_2003_s2" DOUBLE  -- 2003-S2,
  "n_2004_s1" DOUBLE  -- 2004-S1,
  "n_2004_s2" DOUBLE  -- 2004-S2,
  "n_2005_s1" DOUBLE  -- 2005-S1,
  "n_2005_s2" DOUBLE  -- 2005-S2,
  "n_2006_s1" DOUBLE  -- 2006-S1,
  "n_2006_s2" DOUBLE  -- 2006-S2,
  "n_2007_s1" DOUBLE  -- 2007-S1,
  "n_2007_s2" DOUBLE  -- 2007-S2
);

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

@eurostat.nrg_pc_203_h.tidy

123.75 kB
29,718 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
);