Gas Prices By Type Of User

Eurostat code: ten00118 · (2013 - 2024)

@eurostat.ten00118

Table List

2 tables(32.21 KB)

Gas Prices By Type Of User - Unpivoted

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

12.75 KB
789 rows
8 columns

freq Freq	product Product	currency Currency	unit Unit	indic_en Indic En	geo Geo	time_period Time Period	value Value
Annual	Natural gas	Euro	Gigajoule (gross calorific value - GCV)	Medium size households	Austria	2013	21.32
Annual	Natural gas	Euro	Gigajoule (gross calorific value - GCV)	Medium size households	Bosnia and Herzegovina	2013	15.4082
Annual	Natural gas	Euro	Gigajoule (gross calorific value - GCV)	Medium size households	Belgium	2013	18.32
Annual	Natural gas	Euro	Gigajoule (gross calorific value - GCV)	Medium size households	Bulgaria	2013	14.2397
Annual	Natural gas	Euro	Gigajoule (gross calorific value - GCV)	Medium size households	Czechia	2013	17.8029
Annual	Natural gas	Euro	Gigajoule (gross calorific value - GCV)	Medium size households	Germany	2013	18.35
Annual	Natural gas	Euro	Gigajoule (gross calorific value - GCV)	Medium size households	Denmark	2013	27.5854
Annual	Natural gas	Euro	Gigajoule (gross calorific value - GCV)	Medium size households	Estonia	2013	14.57
Annual	Natural gas	Euro	Gigajoule (gross calorific value - GCV)	Medium size households	Greece	2013	21.44
Annual	Natural gas	Euro	Gigajoule (gross calorific value - GCV)	Medium size households	Spain	2013	20.34


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

Share link

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