Supply, Transformation And Consumption Of Gas - Monthly Data

Eurostat code: nrg_cb_gasm · (2008-01 - 2025-03)

@eurostat.nrg_cb_gasm

Table List

2 tables(1.06 MB)

Supply, Transformation And Consumption Of Gas - Monthly Data - Raw

Supply, Transformation And Consumption Of Gas - Monthly Data - Unpivoted

Supply, Transformation And Consumption Of Gas - Monthly Data - Unpivoted

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

445.93 KB
109468 rows
7 columns

freq Freq	nrg_bal Nrg Bal	siec Siec	unit Unit	geo Geo	time_period Time Period	value Value
Monthly	Distribution losses	Natural gas	Terajoule (gross calorific value - GCV)	Austria	2008-01	2273
Monthly	Distribution losses	Natural gas	Terajoule (gross calorific value - GCV)	Belgium	2008-01	548
Monthly	Distribution losses	Natural gas	Terajoule (gross calorific value - GCV)	Bulgaria	2008-01	1681
Monthly	Distribution losses	Natural gas	Terajoule (gross calorific value - GCV)	Cyprus	2008-01
Monthly	Distribution losses	Natural gas	Terajoule (gross calorific value - GCV)	Czechia	2008-01	937
Monthly	Distribution losses	Natural gas	Terajoule (gross calorific value - GCV)	Germany	2008-01
Monthly	Distribution losses	Natural gas	Terajoule (gross calorific value - GCV)	Denmark	2008-01	59
Monthly	Distribution losses	Natural gas	Terajoule (gross calorific value - GCV)	Estonia	2008-01
Monthly	Distribution losses	Natural gas	Terajoule (gross calorific value - GCV)	Greece	2008-01	100
Monthly	Distribution losses	Natural gas	Terajoule (gross calorific value - GCV)	Spain	2008-01	274


CREATE TABLE tidy (
  "freq" VARCHAR,
  "nrg_bal" VARCHAR,
  "siec" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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