Electricity Prices For Domestic Consumers - Bi-annual Data (until 2007)

Eurostat code: nrg_pc_204_h · (1985-S1 - 2007-S2)

@eurostat.nrg_pc_204_h

Table List

2 tables(254.07 KB)

Electricity Prices For Domestic Consumers - Bi-annual Data (until 2007) - Raw

Electricity Prices For Domestic Consumers - Bi-annual Data (until 2007) - Unpivoted

Electricity Prices For Domestic Consumers - Bi-annual Data (until 2007) - Raw

@eurostat.nrg_pc_204_h.raw

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

180.48 KB
1461 rows
47 columns

freq Freq	product Product	consom Consom	unit Unit	tax Tax	currency Currency	geo Geo	n_1985_s1 1985-S1	n_1986_s1 1986-S1	n_1987_s1 1987-S1	n_1988_s1 1988-S1	n_1989_s1 1989-S1	n_1990_s1 1990-S1	n_1991_s1 1991-S1	n_1991_s2 1991-S2	n_1992_s1 1992-S1	n_1992_s2 1992-S2	n_1993_s1 1993-S1	n_1993_s2 1993-S2	n_1994_s1 1994-S1	n_1994_s2 1994-S2	n_1995_s1 1995-S1	n_1995_s2 1995-S2	n_1996_s1 1996-S1	n_1996_s2 1996-S2	n_1997_s1 1997-S1	n_1997_s2 1997-S2	n_1998_s1 1998-S1	n_1998_s2 1998-S2	n_1999_s1 1999-S1	n_1999_s2 1999-S2	n_2000_s1 2000-S1	n_2000_s2 2000-S2	n_2001_s1 2001-S1	n_2001_s2 2001-S2	n_2002_s1 2002-S1	n_2002_s2 2002-S2	n_2003_s1 2003-S1	n_2003_s2 2003-S2	n_2004_s1 2004-S1	n_2004_s2 2004-S2	n_2005_s1 2005-S1	n_2005_s2 2005-S2	n_2006_s1 2006-S1	n_2006_s2 2006-S2	n_2007_s1 2007-S1	n_2007_s2 2007-S2
Half-yearly, semesterly	Electrical energy	Households - Da (annual consumption: 600 kWh)	Kilowatt-hour	All taxes and levies included	Euro	Austria																																	0.1946	0.1958	0.1972	0.1937	0.1732	0.1973	0.2324	0.2393
Half-yearly, semesterly	Electrical energy	Households - Da (annual consumption: 600 kWh)	Kilowatt-hour	All taxes and levies included	Euro	Belgium	0.199	0.206	0.2034	0.2058	0.2055	0.2135	0.2149	0.2171	0.2186	0.226	0.2382	0.2385	0.2166	0.2216	0.2289	0.2326	0.232	0.2261	0.2167	0.2154	0.2085	0.2104	0.2095	0.2087	0.203	0.1824	0.1855	0.1805	0.1877	0.1803	0.1822	0.1825	0.1873	0.194	0.2107	0.2115	0.2124	0.2161	0.2503	0.2526
Half-yearly, semesterly	Electrical energy	Households - Da (annual consumption: 600 kWh)	Kilowatt-hour	All taxes and levies included	Euro	Bulgaria																																	0.0542	0.0578	0.0583	0.0588	0.0583	0.0603	0.067	0.067
Half-yearly, semesterly	Electrical energy	Households - Da (annual consumption: 600 kWh)	Kilowatt-hour	All taxes and levies included	Euro	Cyprus																							0.0743		0.1098		0.127		0.1104	0.1187	0.1236	0.1221	0.1243	0.1205	0.1224	0.1353	0.1581	0.1576	0.1527	0.1486
Half-yearly, semesterly	Electrical energy	Households - Da (annual consumption: 600 kWh)	Kilowatt-hour	All taxes and levies included	Euro	Czechia																									0.1047	0.1059	0.1161	0.1122	0.1297	0.1399	0.1324	0.1309	0.1323	0.1357	0.1449	0.1455	0.1772	0.1789	0.1965	0.1929
Half-yearly, semesterly	Electrical energy	Households - Da (annual consumption: 600 kWh)	Kilowatt-hour	All taxes and levies included	Euro	Germany																																	0.2629	0.2591	0.2751	0.2776	0.2819	0.2862	0.2953
Half-yearly, semesterly	Electrical energy	Households - Da (annual consumption: 600 kWh)	Kilowatt-hour	All taxes and levies included	Euro	Denmark	0.1877	0.187	0.1887	0.2062	0.2169	0.2187	0.2073	0.2061	0.209	0.2168	0.226	0.2249	0.2272	0.227	0.2313	0.2381	0.2479	0.2457	0.2537	0.2504	0.274	0.2771	0.288	0.2944	0.3032	0.3035	0.3045	0.3076	0.3277	0.3237	0.3435	0.3244	0.3298	0.3282	0.3327	0.3411	0.3492	0.3671	0.3905	0.3651
Half-yearly, semesterly	Electrical energy	Households - Da (annual consumption: 600 kWh)	Kilowatt-hour	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)																																0.1793	0.183	0.1826	0.1894	0.1902	0.1934	0.1956	0.2015	0.2027
Half-yearly, semesterly	Electrical energy	Households - Da (annual consumption: 600 kWh)	Kilowatt-hour	All taxes and levies included	Euro	Estonia																													0.0575		0.0735		0.0735	0.0842	0.0842	0.087	0.0896	0.0906	0.0906	0.0908
Half-yearly, semesterly	Electrical energy	Households - Da (annual consumption: 600 kWh)	Kilowatt-hour	All taxes and levies included	Euro	Greece																																		0.0838	0.0859	0.0867	0.0867	0.0867	0.0925	0.0925


CREATE TABLE raw (
  "freq" VARCHAR,
  "product" VARCHAR,
  "consom" VARCHAR,
  "unit" VARCHAR,
  "tax" VARCHAR,
  "currency" VARCHAR,
  "geo" VARCHAR,
  "n_1985_s1" DOUBLE,
  "n_1986_s1" DOUBLE,
  "n_1987_s1" DOUBLE,
  "n_1988_s1" DOUBLE,
  "n_1989_s1" DOUBLE,
  "n_1990_s1" DOUBLE,
  "n_1991_s1" DOUBLE,
  "n_1991_s2" DOUBLE,
  "n_1992_s1" DOUBLE,
  "n_1992_s2" DOUBLE,
  "n_1993_s1" DOUBLE,
  "n_1993_s2" DOUBLE,
  "n_1994_s1" DOUBLE,
  "n_1994_s2" DOUBLE,
  "n_1995_s1" DOUBLE,
  "n_1995_s2" DOUBLE,
  "n_1996_s1" DOUBLE,
  "n_1996_s2" DOUBLE,
  "n_1997_s1" DOUBLE,
  "n_1997_s2" DOUBLE,
  "n_1998_s1" DOUBLE,
  "n_1998_s2" DOUBLE,
  "n_1999_s1" DOUBLE,
  "n_1999_s2" DOUBLE,
  "n_2000_s1" DOUBLE,
  "n_2000_s2" DOUBLE,
  "n_2001_s1" DOUBLE,
  "n_2001_s2" DOUBLE,
  "n_2002_s1" DOUBLE,
  "n_2002_s2" DOUBLE,
  "n_2003_s1" DOUBLE,
  "n_2003_s2" DOUBLE,
  "n_2004_s1" DOUBLE,
  "n_2004_s2" DOUBLE,
  "n_2005_s1" DOUBLE,
  "n_2005_s2" DOUBLE,
  "n_2006_s1" DOUBLE,
  "n_2006_s2" DOUBLE,
  "n_2007_s1" DOUBLE,
  "n_2007_s2" DOUBLE
);