Energy Import Dependency By Products

Eurostat code: sdg_07_50 · (2000 - 2023)

@eurostat.sdg_07_50

Table List

2 tables(72.67 KB)

Energy Import Dependency By Products - Raw

Energy Import Dependency By Products - Unpivoted

Energy Import Dependency By Products - Unpivoted

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

27.42 KB
3612 rows
6 columns

freq Freq	siec Siec	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Solid fossil fuels	Percentage	Albania	2000	58.904
Annual	Solid fossil fuels	Percentage	Austria	2000	83.931
Annual	Solid fossil fuels	Percentage	Belgium	2000	91.241
Annual	Solid fossil fuels	Percentage	Bulgaria	2000	35.2
Annual	Solid fossil fuels	Percentage	Cyprus	2000	102.041
Annual	Solid fossil fuels	Percentage	Czechia	2000	-21.976
Annual	Solid fossil fuels	Percentage	Germany	2000	25.567
Annual	Solid fossil fuels	Percentage	Denmark	2000	94.921
Annual	Solid fossil fuels	Percentage	Euro area – 20 countries (from 2023)	2000	52.459
Annual	Solid fossil fuels	Percentage	Estonia	2000	125.209


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

Share link

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