Gas Prices For Household Consumers - Bi-annual Data (from 2007 Onwards)

Eurostat code: nrg_pc_202 · (2007-S1 - 2024-S2)

@eurostat.nrg_pc_202

Table List

2 tables(600.29 KB)

Gas Prices For Household Consumers - Bi-annual Data (from 2007 Onwards) - Raw

Gas Prices For Household Consumers - Bi-annual Data (from 2007 Onwards) - Unpivoted

Gas Prices For Household Consumers - Bi-annual Data (from 2007 Onwards) - Raw

@eurostat.nrg_pc_202.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

352.65 KB
2286 rows
43 columns

freq Freq	product Product	nrg_cons Nrg Cons	unit Unit	tax Tax	currency Currency	geo Geo	n_2007_s1 2007-S1	n_2007_s2 2007-S2	n_2008_s1 2008-S1	n_2008_s2 2008-S2	n_2009_s1 2009-S1	n_2009_s2 2009-S2	n_2010_s1 2010-S1	n_2010_s2 2010-S2	n_2011_s1 2011-S1	n_2011_s2 2011-S2	n_2012_s1 2012-S1	n_2012_s2 2012-S2	n_2013_s1 2013-S1	n_2013_s2 2013-S2	n_2014_s1 2014-S1	n_2014_s2 2014-S2	n_2015_s1 2015-S1	n_2015_s2 2015-S2	n_2016_s1 2016-S1	n_2016_s2 2016-S2	n_2017_s1 2017-S1	n_2017_s2 2017-S2	n_2018_s1 2018-S1	n_2018_s2 2018-S2	n_2019_s1 2019-S1	n_2019_s2 2019-S2	n_2020_s1 2020-S1	n_2020_s2 2020-S2	n_2021_s1 2021-S1	n_2021_s2 2021-S2	n_2022_s1 2022-S1	n_2022_s2 2022-S2	n_2023_s1 2023-S1	n_2023_s2 2023-S2	n_2024_s1 2024-S1	n_2024_s2 2024-S2
Half-yearly, semesterly	Natural gas	Consumption from 20 GJ to 199 GJ - band D2	Gigajoule (gross calorific value - GCV)	All taxes and levies included	Euro	Albania
Half-yearly, semesterly	Natural gas	Consumption from 20 GJ to 199 GJ - band D2	Gigajoule (gross calorific value - GCV)	All taxes and levies included	Euro	Austria		16.95	16.27	17.11	18.03	17.23	17.29	16.71	19.29	20.03	21.05	21.2	21.32	20.96	20.78	20.28	20.28	19.75	19.17	18.71	18.71	19.401	18.585	19.4767	18.34	18.7267	17.9895	18.2267	17.6667	19.3023	21.2942	34.31	43.3257	41.036	38.3186	31.9654
Half-yearly, semesterly	Natural gas	Consumption from 20 GJ to 199 GJ - band D2	Gigajoule (gross calorific value - GCV)	All taxes and levies included	Euro	Bosnia and Herzegovina							10.4796	12.4286	12.551	14.898	15.4082	15.4082	15.4082	14.2347	14.2347	14.2347	14.265	14.265	10.8598	9.3311	8.5335	9.079	9.0462	9.0493	9.3109	9.2525	10.3855	9.5979	8.9115	10.1061	12.1719	18.1913	16.3328	14.2874	14.9237	14.2636
Half-yearly, semesterly	Natural gas	Consumption from 20 GJ to 199 GJ - band D2	Gigajoule (gross calorific value - GCV)	All taxes and levies included	Euro	Belgium		13.89	16.26	20.24	16.82	14.33	14.7	16.78	17.6	20.31	19.13	20.39	18.32	18.55	18.27	18.06	16.23	17.24	15.19	14.83	14.5114	15.3241	14.8847	17.3583	15.3755	15.9178	13.7697	13.8374	13.0023	18.7807	26.1811	37.8523	31.8275	27.6013	22.2514	25.0862
Half-yearly, semesterly	Natural gas	Consumption from 20 GJ to 199 GJ - band D2	Gigajoule (gross calorific value - GCV)	All taxes and levies included	Euro	Bulgaria		8.9784	9.8476	10.86	13.1404	9.6687	10.2107	11.9781	11.944	13.1046	13.7233	15.4413	14.2397	14.3931	13.6261	13.4421	13.258	10.86	10.226	8.6512	9.1778	10.421	10.5356	12.1462	12.4631	12.2712	11.011	9.6658	10.2154	19.6549	21.211	32.5875	24.4176	19.5192	17.1954	18.0292
Half-yearly, semesterly	Natural gas	Consumption from 20 GJ to 199 GJ - band D2	Gigajoule (gross calorific value - GCV)	All taxes and levies included	Euro	Czechia		10.0601	12.2018	14.6866	13.748	13.1137	13.0395	14.352	15.1247	16.5298	18.3111	18.3554	17.8029	15.9818	15.2285	15.6282	15.9493	16.2059	16.1879	15.6484	15.2685	15.7333	15.9675	15.795	16.2682	16.3205	15.9069	15.5124	15.6045	15.4004	19.3386	29.6077	31.6191	31.2625	30.1251	28.5842
Half-yearly, semesterly	Natural gas	Consumption from 20 GJ to 199 GJ - band D2	Gigajoule (gross calorific value - GCV)	All taxes and levies included	Euro	Germany		17.04	17.81	21.17	18	16.35	15.7	15.86	16.34	17.77	17.7	18.01	18.35	19.13	18.84	18.93	18.78	18.93	18.36	17.83	16.98	16.929	16.901	16.8777	17.5503	16.3256	16.5765	17.2123	17.9618	19.2318	22.3901	26.1491	34.1544	31.8039	33.2776	34.3838
Half-yearly, semesterly	Natural gas	Consumption from 20 GJ to 199 GJ - band D2	Gigajoule (gross calorific value - GCV)	All taxes and levies included	Euro	Denmark	22.6474	24.5874	26.6286	27.2065	22.2989	23.6401	26.4979	26.8147	28.6448	28.5862	27.2187	26.5285	27.5854	27.1403	25.2216	24.3822	25.5584	24.4829	23.1489	23.829	24.672	24.2971	24.2095	25.3678	23.7451	21.4069	20.8287	20.7421	24.8473	34.642	41.9111	57.8873	45.9819	33.8947	33.9807	36.4752
Half-yearly, semesterly	Natural gas	Consumption from 20 GJ to 199 GJ - band D2	Gigajoule (gross calorific value - GCV)	All taxes and levies included	Euro	Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)	18.7883	16.4753	16.8943	19.375	18.4629	15.9991	16.0415	17.7413	17.3393	19.9503	19.0441	21.4967	20.1217	21.8504	20.1501	21.9501	19.6655	21.3585	18.8839	19.8738	18.0398	19.955	18.3483	21.0323	19.6828	21.434	19.0535	20.8522	18.9925	23.3124	25.232	31.6037	36.7812	33.8335	32.4841
Half-yearly, semesterly	Natural gas	Consumption from 20 GJ to 199 GJ - band D2	Gigajoule (gross calorific value - GCV)	All taxes and levies included	Euro	Estonia		7.304	9.2997	10.3041	10.9601	10.0725	10.068	11.1386	11.64	12.14	13.88	14.38	14.57	13.21	13.64	13.71	12.67	10.68	9.62	9.1	11.6133	11.4589	11.1426	11.8001	12.7321	12.3807	12.2553	11.4294	12.0958	20.8218	30.721	30.2534	30.5282	21.9662	19.1855


CREATE TABLE raw (
  "freq" VARCHAR,
  "product" VARCHAR,
  "nrg_cons" VARCHAR,
  "unit" VARCHAR,
  "tax" VARCHAR,
  "currency" VARCHAR,
  "geo" VARCHAR,
  "n_2007_s1" DOUBLE,
  "n_2007_s2" DOUBLE,
  "n_2008_s1" DOUBLE,
  "n_2008_s2" DOUBLE,
  "n_2009_s1" DOUBLE,
  "n_2009_s2" DOUBLE,
  "n_2010_s1" DOUBLE,
  "n_2010_s2" DOUBLE,
  "n_2011_s1" DOUBLE,
  "n_2011_s2" DOUBLE,
  "n_2012_s1" DOUBLE,
  "n_2012_s2" DOUBLE,
  "n_2013_s1" DOUBLE,
  "n_2013_s2" DOUBLE,
  "n_2014_s1" DOUBLE,
  "n_2014_s2" DOUBLE,
  "n_2015_s1" DOUBLE,
  "n_2015_s2" DOUBLE,
  "n_2016_s1" DOUBLE,
  "n_2016_s2" DOUBLE,
  "n_2017_s1" DOUBLE,
  "n_2017_s2" DOUBLE,
  "n_2018_s1" DOUBLE,
  "n_2018_s2" DOUBLE,
  "n_2019_s1" DOUBLE,
  "n_2019_s2" DOUBLE,
  "n_2020_s1" DOUBLE,
  "n_2020_s2" DOUBLE,
  "n_2021_s1" DOUBLE,
  "n_2021_s2" DOUBLE,
  "n_2022_s1" DOUBLE,
  "n_2022_s2" DOUBLE,
  "n_2023_s1" DOUBLE,
  "n_2023_s2" DOUBLE,
  "n_2024_s1" DOUBLE,
  "n_2024_s2" DOUBLE
);