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) - Unpivoted

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

73.58 KB
25326 rows
9 columns

freq Freq	product Product	consom Consom	unit Unit	tax Tax	currency Currency	geo Geo	time_period Time Period	value Value
Half-yearly, semesterly	Electrical energy	Households - Da (annual consumption: 600 kWh)	Kilowatt-hour	All taxes and levies included	Euro	Belgium	1985-S1	0.199
Half-yearly, semesterly	Electrical energy	Households - Da (annual consumption: 600 kWh)	Kilowatt-hour	All taxes and levies included	Euro	Denmark	1985-S1	0.1877
Half-yearly, semesterly	Electrical energy	Households - Da (annual consumption: 600 kWh)	Kilowatt-hour	All taxes and levies included	Euro	Luxembourg	1985-S1	0.1817
Half-yearly, semesterly	Electrical energy	Households - Da (annual consumption: 600 kWh)	Kilowatt-hour	All taxes and levies included	National currency	Belgium	1985-S1	0.2196
Half-yearly, semesterly	Electrical energy	Households - Da (annual consumption: 600 kWh)	Kilowatt-hour	All taxes and levies included	National currency	Denmark	1985-S1	1.4922
Half-yearly, semesterly	Electrical energy	Households - Da (annual consumption: 600 kWh)	Kilowatt-hour	All taxes and levies included	National currency	Luxembourg	1985-S1	0.2005
Half-yearly, semesterly	Electrical energy	Households - Da (annual consumption: 600 kWh)	Kilowatt-hour	All taxes and levies included	Purchasing Power Standard	Belgium	1985-S1	0.2037
Half-yearly, semesterly	Electrical energy	Households - Da (annual consumption: 600 kWh)	Kilowatt-hour	All taxes and levies included	Purchasing Power Standard	Denmark	1985-S1	0.1491
Half-yearly, semesterly	Electrical energy	Households - Da (annual consumption: 600 kWh)	Kilowatt-hour	All taxes and levies included	Purchasing Power Standard	Luxembourg	1985-S1	0.1689
Half-yearly, semesterly	Electrical energy	Households - Da (annual consumption: 600 kWh)	Kilowatt-hour	Excluding taxes and levies	Euro	Belgium	1985-S1	0.17


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

Share link

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