Environmental Subsidies And Similar Transfers From General Government, By Environmental Activity, Sector Of Recipient And ESA Category Of Transfer

Eurostat code: env_esst_gg · (2011 - 2023)

@eurostat.env_esst_gg

Table List

2 tables(555.6 KB)

Environmental Subsidies And Similar Transfers From General Government, By Environmental Activity, Sector Of Recipient And ESA Category Of Transfer - Raw

Environmental Subsidies And Similar Transfers From General Government, By Environmental Activity, Sector Of Recipient And ESA Category Of Transfer - Unpivoted

Environmental Subsidies And Similar Transfers From General Government, By Environmental Activity, Sector Of Recipient And ESA Category Of Transfer - Unpivoted

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

262.84 KB
206037 rows
8 columns

freq Freq	sector Sector	na_item Na Item	ceparema Ceparema	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Total economy	Subsidies	Protection of ambient air and climate; protection and remediation of soil, groundwater and surface water; noise and vibration abatement; protection against radiation	Million euro	Ireland	2011	1.93
Annual	Total economy	Subsidies	Protection of ambient air and climate; protection and remediation of soil, groundwater and surface water; noise and vibration abatement; protection against radiation	Million euro	Lithuania	2011	4.42
Annual	Total economy	Subsidies	Protection of ambient air and climate; protection and remediation of soil, groundwater and surface water; noise and vibration abatement; protection against radiation	Million euro	Luxembourg	2011	13
Annual	Total economy	Subsidies	Protection of ambient air and climate; protection and remediation of soil, groundwater and surface water; noise and vibration abatement; protection against radiation	Million euro	Latvia	2011	28.14
Annual	Total economy	Subsidies	Protection of ambient air and climate; protection and remediation of soil, groundwater and surface water; noise and vibration abatement; protection against radiation	Million units of national currency	Ireland	2011	1.93
Annual	Total economy	Subsidies	Protection of ambient air and climate; protection and remediation of soil, groundwater and surface water; noise and vibration abatement; protection against radiation	Million units of national currency	Lithuania	2011	4.42
Annual	Total economy	Subsidies	Protection of ambient air and climate; protection and remediation of soil, groundwater and surface water; noise and vibration abatement; protection against radiation	Million units of national currency	Luxembourg	2011	13
Annual	Total economy	Subsidies	Protection of ambient air and climate; protection and remediation of soil, groundwater and surface water; noise and vibration abatement; protection against radiation	Million units of national currency	Latvia	2011	28.28
Annual	Total economy	Subsidies	Protection of ambient air and climate; protection and remediation of soil, groundwater and surface water; noise and vibration abatement; protection against radiation	Percentage of gross domestic product (GDP)	Ireland	2011
Annual	Total economy	Subsidies	Protection of ambient air and climate; protection and remediation of soil, groundwater and surface water; noise and vibration abatement; protection against radiation	Percentage of gross domestic product (GDP)	Lithuania	2011	0.01


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

Share link

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