Energy Market Indicator

Eurostat code: nrg_ind_market · (2013 - 2023)

@eurostat.nrg_ind_market

Table List

2 tables(69.2 KB)

Energy Market Indicator - Unpivoted

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

30.51 KB
6812 rows
7 columns

freq Freq	siec Siec	indic_nrgm Indic Nrgm	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Electricity	Companies with at least 5% of the electricity capacity	Percentage	Austria	2013	62
Annual	Electricity	Companies with at least 5% of the electricity capacity	Percentage	Bosnia and Herzegovina	2013	96.64
Annual	Electricity	Companies with at least 5% of the electricity capacity	Percentage	Belgium	2013	66
Annual	Electricity	Companies with at least 5% of the electricity capacity	Percentage	Bulgaria	2013	59.27
Annual	Electricity	Companies with at least 5% of the electricity capacity	Percentage	Cyprus	2013	89.06
Annual	Electricity	Companies with at least 5% of the electricity capacity	Percentage	Czechia	2013	61.8
Annual	Electricity	Companies with at least 5% of the electricity capacity	Percentage	Germany	2013	67
Annual	Electricity	Companies with at least 5% of the electricity capacity	Percentage	Denmark	2013	57
Annual	Electricity	Companies with at least 5% of the electricity capacity	Percentage	Estonia	2013	77
Annual	Electricity	Companies with at least 5% of the electricity capacity	Percentage	Greece	2013	67.4


CREATE TABLE tidy (
  "freq" VARCHAR,
  "siec" VARCHAR,
  "indic_nrgm" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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