Baselight
Sign In

Gas Prices For Non-household Consumers - Bi-annual Data (from 2007 Onwards)

Eurostat code: nrg_pc_203 ยท (2007-S1 - 2024-S2)

@eurostat.nrg_pc_203

Gas Prices For Non-household Consumers - Bi-annual Data (from 2007 Onwards) - Unpivoted
@eurostat.nrg_pc_203.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

  • 450.41 KB
  • 101628 rows
  • 9 columns
freq

Freq

product

Product

nrg_cons

Nrg Cons

unit

Unit

tax

Tax

currency

Currency

geo

Geo

time_period

Time Period

value

Value

Half-yearly, semesterlyNatural gasConsumption from 1 000 GJ to 9 999 GJ -band I2Gigajoule (gross calorific value - GCV)All taxes and levies includedEuroDenmark2007-S121.2382
Half-yearly, semesterlyNatural gasConsumption from 1 000 GJ to 9 999 GJ -band I2Gigajoule (gross calorific value - GCV)All taxes and levies includedEuroEuro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)2007-S114.3248
Half-yearly, semesterlyNatural gasConsumption from 1 000 GJ to 9 999 GJ -band I2Gigajoule (gross calorific value - GCV)All taxes and levies includedEuroEuropean Union - 27 countries (from 2020)2007-S114.5253
Half-yearly, semesterlyNatural gasConsumption from 1 000 GJ to 9 999 GJ -band I2Gigajoule (gross calorific value - GCV)All taxes and levies includedEuroCroatia2007-S18.314
Half-yearly, semesterlyNatural gasConsumption from 1 000 GJ to 9 999 GJ -band I2Gigajoule (gross calorific value - GCV)All taxes and levies includedEuroItaly2007-S112.69
Half-yearly, semesterlyNatural gasConsumption from 1 000 GJ to 9 999 GJ -band I2Gigajoule (gross calorific value - GCV)All taxes and levies includedEuroNetherlands2007-S117.45
Half-yearly, semesterlyNatural gasConsumption from 1 000 GJ to 9 999 GJ -band I2Gigajoule (gross calorific value - GCV)All taxes and levies includedEuroSweden2007-S121.9757
Half-yearly, semesterlyNatural gasConsumption from 1 000 GJ to 9 999 GJ -band I2Gigajoule (gross calorific value - GCV)All taxes and levies includedEuroUnited Kingdom2007-S112.5832
Half-yearly, semesterlyNatural gasConsumption from 1 000 GJ to 9 999 GJ -band I2Gigajoule (gross calorific value - GCV)All taxes and levies includedNational currencyDenmark2007-S1158.25
Half-yearly, semesterlyNatural gasConsumption from 1 000 GJ to 9 999 GJ -band I2Gigajoule (gross calorific value - GCV)All taxes and levies includedNational currencyCroatia2007-S161.17

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

Share link

Anyone who has the link will be able to view this.