Electricity Prices By Type Of User

Eurostat code: ten00117 · (2013 - 2024)

@eurostat.ten00117

Table List

2 tables(33.59 KB)

Electricity Prices By Type Of User - Raw

Electricity Prices By Type Of User - Unpivoted

Electricity Prices By Type Of User - Unpivoted

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

12.65 KB
958 rows
8 columns

freq Freq	product Product	currency Currency	unit Unit	indic_en Indic En	geo Geo	time_period Time Period	value Value
Annual	Electrical energy	Euro	Kilowatt-hour	Medium size households	Albania	2013	0.1156
Annual	Electrical energy	Euro	Kilowatt-hour	Medium size households	Austria	2013	0.2082
Annual	Electrical energy	Euro	Kilowatt-hour	Medium size households	Bosnia and Herzegovina	2013	0.0803
Annual	Electrical energy	Euro	Kilowatt-hour	Medium size households	Belgium	2013	0.2173
Annual	Electrical energy	Euro	Kilowatt-hour	Medium size households	Bulgaria	2013	0.0924
Annual	Electrical energy	Euro	Kilowatt-hour	Medium size households	Cyprus	2013	0.276
Annual	Electrical energy	Euro	Kilowatt-hour	Medium size households	Czechia	2013	0.1681
Annual	Electrical energy	Euro	Kilowatt-hour	Medium size households	Germany	2013	0.2919
Annual	Electrical energy	Euro	Kilowatt-hour	Medium size households	Denmark	2013	0.3
Annual	Electrical energy	Euro	Kilowatt-hour	Medium size households	Estonia	2013	0.1351


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

Share link

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