Dataset: Electricity Prices For Household Consumers - Bi-annual Data (from 2007 Onwards)

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.

freq Freq	product Product	nrg_cons Nrg Cons	unit Unit	tax Tax	currency Currency	geo Geo	time_period Time Period	value Value
Half-yearly, semesterly	Electrical energy	Consumption from 1 000 kWh to 2 499 kWh - band DB	Kilowatt-hour	All taxes and levies included	Euro	Czechia	2007-S1	0.1573
Half-yearly, semesterly	Electrical energy	Consumption from 1 000 kWh to 2 499 kWh - band DB	Kilowatt-hour	All taxes and levies included	Euro	Germany	2007-S1	0.2258
Half-yearly, semesterly	Electrical energy	Consumption from 1 000 kWh to 2 499 kWh - band DB	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)	2007-S1	0.2138
Half-yearly, semesterly	Electrical energy	Consumption from 1 000 kWh to 2 499 kWh - band DB	Kilowatt-hour	All taxes and levies included	Euro	European Union - 27 countries (from 2020)	2007-S1	0.1974
Half-yearly, semesterly	Electrical energy	Consumption from 1 000 kWh to 2 499 kWh - band DB	Kilowatt-hour	All taxes and levies included	Euro	Croatia	2007-S1	0.1223
Half-yearly, semesterly	Electrical energy	Consumption from 1 000 kWh to 2 499 kWh - band DB	Kilowatt-hour	All taxes and levies included	Euro	Luxembourg	2007-S1	0.2219
Half-yearly, semesterly	Electrical energy	Consumption from 1 000 kWh to 2 499 kWh - band DB	Kilowatt-hour	All taxes and levies included	Euro	Netherlands	2007-S1	0.1377
Half-yearly, semesterly	Electrical energy	Consumption from 1 000 kWh to 2 499 kWh - band DB	Kilowatt-hour	All taxes and levies included	Euro	Sweden	2007-S1	0.1567
Half-yearly, semesterly	Electrical energy	Consumption from 1 000 kWh to 2 499 kWh - band DB	Kilowatt-hour	All taxes and levies included	National currency	Czechia	2007-S1	4.43
Half-yearly, semesterly	Electrical energy	Consumption from 1 000 kWh to 2 499 kWh - band DB	Kilowatt-hour	All taxes and levies included	National currency	Germany	2007-S1	0.2258

freq

Freq

product

Product

nrg_cons

Nrg Cons

unit

Unit

tax

Tax

currency

Currency

geo

Geo

time_period

Time Period

value

Value

Half-yearly, semesterly

Electrical energy

Consumption from 1 000 kWh to 2 499 kWh - band DB

Kilowatt-hour

All taxes and levies included

Euro

Czechia

2007-S1

0.1573

Half-yearly, semesterly

Electrical energy

Consumption from 1 000 kWh to 2 499 kWh - band DB

Kilowatt-hour

All taxes and levies included

Euro

Germany

2007-S1

0.2258

Half-yearly, semesterly

Electrical energy

Consumption from 1 000 kWh to 2 499 kWh - band DB

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)

2007-S1

0.2138

Half-yearly, semesterly

Electrical energy

Consumption from 1 000 kWh to 2 499 kWh - band DB

Kilowatt-hour

All taxes and levies included

Euro

European Union - 27 countries (from 2020)

2007-S1

0.1974

Half-yearly, semesterly

Electrical energy

Consumption from 1 000 kWh to 2 499 kWh - band DB

Kilowatt-hour

All taxes and levies included

Euro

Croatia

2007-S1

0.1223

Half-yearly, semesterly

Electrical energy

Consumption from 1 000 kWh to 2 499 kWh - band DB

Kilowatt-hour

All taxes and levies included

Euro

Luxembourg

2007-S1

0.2219

Half-yearly, semesterly

Electrical energy

Consumption from 1 000 kWh to 2 499 kWh - band DB

Kilowatt-hour

All taxes and levies included

Euro

Netherlands

2007-S1

0.1377

Half-yearly, semesterly

Electrical energy

Consumption from 1 000 kWh to 2 499 kWh - band DB

Kilowatt-hour

All taxes and levies included

Euro

Sweden

2007-S1

0.1567

Half-yearly, semesterly

Electrical energy

Consumption from 1 000 kWh to 2 499 kWh - band DB

Kilowatt-hour

All taxes and levies included

National currency

Czechia

2007-S1

4.43

Half-yearly, semesterly

Electrical energy

Consumption from 1 000 kWh to 2 499 kWh - band DB

Kilowatt-hour

All taxes and levies included

National currency

Germany

2007-S1

0.2258

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

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

Table List

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

@eurostat.nrg_pc_204.tidy

freq

product

nrg_cons

unit

tax

currency

geo

time_period

value

Share link