Gas Prices Components For Household Consumers - Annual Data

Eurostat code: nrg_pc_202_c · (2017 - 2024)

@eurostat.nrg_pc_202_c

Table List

2 tables(320.05 KB)

Gas Prices Components For Household Consumers - Annual Data - Raw

Gas Prices Components For Household Consumers - Annual Data - Unpivoted

Gas Prices Components For Household Consumers - Annual Data - Unpivoted

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

148.8 KB
48318 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	Network costs	Consumption from 20 GJ to 199 GJ - band D2	Euro	Gigajoule (gross calorific value - GCV)	Austria	2017	5.95
Annual	Network costs	Consumption from 20 GJ to 199 GJ - band D2	Euro	Gigajoule (gross calorific value - GCV)	Bosnia and Herzegovina	2017	1.0796
Annual	Network costs	Consumption from 20 GJ to 199 GJ - band D2	Euro	Gigajoule (gross calorific value - GCV)	Belgium	2017	4.4333
Annual	Network costs	Consumption from 20 GJ to 199 GJ - band D2	Euro	Gigajoule (gross calorific value - GCV)	Bulgaria	2017	3.4972
Annual	Network costs	Consumption from 20 GJ to 199 GJ - band D2	Euro	Gigajoule (gross calorific value - GCV)	Czechia	2017	3.1511
Annual	Network costs	Consumption from 20 GJ to 199 GJ - band D2	Euro	Gigajoule (gross calorific value - GCV)	Denmark	2017	4.3697
Annual	Network costs	Consumption from 20 GJ to 199 GJ - band D2	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	4.5387
Annual	Network costs	Consumption from 20 GJ to 199 GJ - band D2	Euro	Gigajoule (gross calorific value - GCV)	Estonia	2017	2.3851
Annual	Network costs	Consumption from 20 GJ to 199 GJ - band D2	Euro	Gigajoule (gross calorific value - GCV)	European Union - 27 countries (from 2020)	2017	4.0378
Annual	Network costs	Consumption from 20 GJ to 199 GJ - band D2	Euro	Gigajoule (gross calorific value - GCV)	France	2017	5.6031


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.