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

Eurostat code: nrg_pc_202_h · (1985-S1 - 2007-S2)

@eurostat.nrg_pc_202_h

Table List

2 tables(252.27 KB)

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

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

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

@eurostat.nrg_pc_202_h.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.

105.85 KB
23196 rows
9 columns

freq Freq	product Product	consom Consom	unit Unit	tax Tax	currency Currency	geo Geo	time_period Time Period	value Value
Half-yearly, semesterly	Natural gas	Households - D1 (annual consumption: 8.37 GJ)	Gigajoule (gross calorific value - GCV)	All taxes and levies included	Euro	Germany	1985-S1	18.123
Half-yearly, semesterly	Natural gas	Households - D1 (annual consumption: 8.37 GJ)	Gigajoule (gross calorific value - GCV)	All taxes and levies included	National currency	Germany	1985-S1	20.6102
Half-yearly, semesterly	Natural gas	Households - D1 (annual consumption: 8.37 GJ)	Gigajoule (gross calorific value - GCV)	All taxes and levies included	National currency (former currencies of the euro area countries)	Germany	1985-S1	40.31
Half-yearly, semesterly	Natural gas	Households - D1 (annual consumption: 8.37 GJ)	Gigajoule (gross calorific value - GCV)	All taxes and levies included	Purchasing Power Standard	Germany	1985-S1	17.2846
Half-yearly, semesterly	Natural gas	Households - D1 (annual consumption: 8.37 GJ)	Gigajoule (gross calorific value - GCV)	Excluding taxes and levies	Euro	Germany	1985-S1	15.8976
Half-yearly, semesterly	Natural gas	Households - D1 (annual consumption: 8.37 GJ)	Gigajoule (gross calorific value - GCV)	Excluding taxes and levies	National currency	Germany	1985-S1	18.0793
Half-yearly, semesterly	Natural gas	Households - D1 (annual consumption: 8.37 GJ)	Gigajoule (gross calorific value - GCV)	Excluding taxes and levies	National currency (former currencies of the euro area countries)	Germany	1985-S1	35.36
Half-yearly, semesterly	Natural gas	Households - D1 (annual consumption: 8.37 GJ)	Gigajoule (gross calorific value - GCV)	Excluding taxes and levies	Purchasing Power Standard	Germany	1985-S1	15.1621
Half-yearly, semesterly	Natural gas	Households - D1 (annual consumption: 8.37 GJ)	Gigajoule (gross calorific value - GCV)	Excluding VAT and other recoverable taxes and levies	Euro	Germany	1985-S1	15.8976
Half-yearly, semesterly	Natural gas	Households - D1 (annual consumption: 8.37 GJ)	Gigajoule (gross calorific value - GCV)	Excluding VAT and other recoverable taxes and levies	National currency	Germany	1985-S1	18.0793


CREATE TABLE tidy (
  "freq" VARCHAR,
  "product" VARCHAR,
  "consom" 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.