Consumption Footprint - Single Weighted Score

Eurostat code: sdg_12_31 · (2010 - 2023)

@eurostat.sdg_12_31

Table List

2 tables(23.94 KB)

Consumption Footprint - Single Weighted Score - Raw

Consumption Footprint - Single Weighted Score - Unpivoted

Consumption Footprint - Single Weighted Score - Unpivoted

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

7.08 KB
784 rows
6 columns

freq Freq	cons_fp Cons Fp	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Single weighted score	Planetary Boundary	Austria	2010	3.44
Annual	Single weighted score	Planetary Boundary	Belgium	2010	3.59
Annual	Single weighted score	Planetary Boundary	Bulgaria	2010	1.91
Annual	Single weighted score	Planetary Boundary	Cyprus	2010	3.76
Annual	Single weighted score	Planetary Boundary	Czechia	2010	2.91
Annual	Single weighted score	Planetary Boundary	Germany	2010	3.93
Annual	Single weighted score	Planetary Boundary	Denmark	2010	3.92
Annual	Single weighted score	Planetary Boundary	Estonia	2010	3.12
Annual	Single weighted score	Planetary Boundary	Greece	2010	2.85
Annual	Single weighted score	Planetary Boundary	Spain	2010	3.27


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

Share link

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