National Expenditure On Environmental Protection

Eurostat code: ten00135 · (2012 - 2023)

@eurostat.ten00135

Table List

2 tables(20.88 KB)

National Expenditure On Environmental Protection - Raw

National Expenditure On Environmental Protection - Unpivoted

National Expenditure On Environmental Protection - Unpivoted

@eurostat.ten00135.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.21 KB
456 rows
6 columns

freq Freq	sector Sector	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Total economy	Million euro	European Union - 27 countries (from 2020)	2012	238225.8
Annual	Total economy	Percentage of gross domestic product (GDP)	European Union - 27 countries (from 2020)	2012	2.1
Annual	Total economy	Million euro	European Union - 27 countries (from 2020)	2013	235989.2
Annual	Total economy	Percentage of gross domestic product (GDP)	European Union - 27 countries (from 2020)	2013	2
Annual	Total economy	Million euro	Belgium	2014	12858.8
Annual	Total economy	Million euro	Bulgaria	2014	1398.5
Annual	Total economy	Million euro	Switzerland	2014	8147.7
Annual	Total economy	Million euro	Estonia	2014	527.4
Annual	Total economy	Million euro	Spain	2014	16038.9
Annual	Total economy	Million euro	European Union - 27 countries (from 2020)	2014	237161.1


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

Share link

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