Baselight
Sign In

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

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

@eurostat.nrg_pc_202

Gas Prices For Household Consumers - Bi-annual Data (from 2007 Onwards) - Unpivoted
@eurostat.nrg_pc_202.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.

  • 247.64 KB
  • 56848 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 20 GJ to 199 GJ - band D2Gigajoule (gross calorific value - GCV)All taxes and levies includedEuroDenmark2007-S122.6474
Half-yearly, semesterlyNatural gasConsumption from 20 GJ to 199 GJ - band D2Gigajoule (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-S118.7883
Half-yearly, semesterlyNatural gasConsumption from 20 GJ to 199 GJ - band D2Gigajoule (gross calorific value - GCV)All taxes and levies includedEuroEuropean Union - 27 countries (from 2020)2007-S118.679
Half-yearly, semesterlyNatural gasConsumption from 20 GJ to 199 GJ - band D2Gigajoule (gross calorific value - GCV)All taxes and levies includedEuroCroatia2007-S18.1984
Half-yearly, semesterlyNatural gasConsumption from 20 GJ to 199 GJ - band D2Gigajoule (gross calorific value - GCV)All taxes and levies includedEuroItaly2007-S118.18
Half-yearly, semesterlyNatural gasConsumption from 20 GJ to 199 GJ - band D2Gigajoule (gross calorific value - GCV)All taxes and levies includedEuroNetherlands2007-S120.1
Half-yearly, semesterlyNatural gasConsumption from 20 GJ to 199 GJ - band D2Gigajoule (gross calorific value - GCV)All taxes and levies includedEuroSweden2007-S125.8724
Half-yearly, semesterlyNatural gasConsumption from 20 GJ to 199 GJ - band D2Gigajoule (gross calorific value - GCV)All taxes and levies includedNational currencyDenmark2007-S1168.75
Half-yearly, semesterlyNatural gasConsumption from 20 GJ to 199 GJ - band D2Gigajoule (gross calorific value - GCV)All taxes and levies includedNational currencyCroatia2007-S160.32
Half-yearly, semesterlyNatural gasConsumption from 20 GJ to 199 GJ - band D2Gigajoule (gross calorific value - GCV)All taxes and levies includedNational currencyItaly2007-S118.18

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.