Gas Prices Components For Non-household Consumers - Annual Data

Eurostat code: nrg_pc_203_c · (2017 - 2024)

@eurostat.nrg_pc_203_c

Table List

2 tables(462.17 KB)

Gas Prices Components For Non-household Consumers - Annual Data - Raw

Gas Prices Components For Non-household Consumers - Annual Data - Unpivoted

Gas Prices Components For Non-household Consumers - Annual Data - Unpivoted

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

218.77 KB
69447 rows
8 columns

freq Freq	nrg_prc Nrg Prc	nrg_cons Nrg Cons	currency Currency	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Other allowance	Consumption of GJ - all bands	Euro	Gigajoule (gross calorific value - GCV)	Sweden	2017
Annual	Other allowance	Consumption of GJ - all bands	National currency	Gigajoule (gross calorific value - GCV)	Sweden	2017
Annual	Other allowance	Consumption of GJ - all bands	Purchasing Power Standard	Gigajoule (gross calorific value - GCV)	Sweden	2017
Annual	Network costs	Consumption from 1 000 GJ to 9 999 GJ -band I2	Euro	Gigajoule (gross calorific value - GCV)	Austria	2017	3.1561
Annual	Network costs	Consumption from 1 000 GJ to 9 999 GJ -band I2	Euro	Gigajoule (gross calorific value - GCV)	Bosnia and Herzegovina	2017	3.3336
Annual	Network costs	Consumption from 1 000 GJ to 9 999 GJ -band I2	Euro	Gigajoule (gross calorific value - GCV)	Belgium	2017	2.3286
Annual	Network costs	Consumption from 1 000 GJ to 9 999 GJ -band I2	Euro	Gigajoule (gross calorific value - GCV)	Bulgaria	2017	2.658
Annual	Network costs	Consumption from 1 000 GJ to 9 999 GJ -band I2	Euro	Gigajoule (gross calorific value - GCV)	Czechia	2017	1.821
Annual	Network costs	Consumption from 1 000 GJ to 9 999 GJ -band I2	Euro	Gigajoule (gross calorific value - GCV)	Denmark	2017	3.1004
Annual	Network costs	Consumption from 1 000 GJ to 9 999 GJ -band I2	Euro	Gigajoule (gross calorific value - GCV)	Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)	2017	2.3525


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

Share link

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