Baselight

Supply, Transformation And Consumption Of Gas

Eurostat code: nrg_cb_gas · (1990 - 2023)

@eurostat.nrg_cb_gas

Supply, Transformation And Consumption Of Gas - Unpivoted
@eurostat.nrg_cb_gas.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.

  • 698.95 KB
  • 620108 rows
  • 7 columns
freq

Freq

nrg_bal

Nrg Bal

siec

Siec

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualDistribution lossesCoke oven gasTerajoule (gross calorific value - GCV)Albania1990
AnnualDistribution lossesCoke oven gasTerajoule (gross calorific value - GCV)Austria1990
AnnualDistribution lossesCoke oven gasTerajoule (gross calorific value - GCV)Belgium1990
AnnualDistribution lossesCoke oven gasTerajoule (gross calorific value - GCV)Bulgaria1990
AnnualDistribution lossesCoke oven gasTerajoule (gross calorific value - GCV)Cyprus1990
AnnualDistribution lossesCoke oven gasTerajoule (gross calorific value - GCV)Czechia1990
AnnualDistribution lossesCoke oven gasTerajoule (gross calorific value - GCV)Germany199090
AnnualDistribution lossesCoke oven gasTerajoule (gross calorific value - GCV)Denmark1990
AnnualDistribution lossesCoke oven gasTerajoule (gross calorific value - GCV)Euro area – 20 countries (from 2023)19902475
AnnualDistribution lossesCoke oven gasTerajoule (gross calorific value - GCV)Estonia1990

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.