Use And Risk Of Chemical Pesticides

Eurostat code: sdg_02_53 · (2011 - 2022)

@eurostat.sdg_02_53

Table List

2 tables(18.62 KB)

Use And Risk Of Chemical Pesticides - Raw

Use And Risk Of Chemical Pesticides - Unpivoted

Use And Risk Of Chemical Pesticides - Unpivoted

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

6 KB
204 rows
6 columns

freq Freq	subst_cat Subst Cat	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Pesticides - farm to fork strategy indicator 1 (all chemical active substances)	Index, 2015-2017 average =100	Austria	2011	92
Annual	Pesticides - farm to fork strategy indicator 1 (all chemical active substances)	Index, 2015-2017 average =100	Bulgaria	2011	288
Annual	Pesticides - farm to fork strategy indicator 1 (all chemical active substances)	Index, 2015-2017 average =100	Germany	2011	102
Annual	Pesticides - farm to fork strategy indicator 1 (all chemical active substances)	Index, 2015-2017 average =100	Denmark	2011	169
Annual	Pesticides - farm to fork strategy indicator 1 (all chemical active substances)	Index, 2015-2017 average =100	Spain	2011	127
Annual	Pesticides - farm to fork strategy indicator 1 (all chemical active substances)	Index, 2015-2017 average =100	European Union - 27 countries (from 2020)	2011	116
Annual	Pesticides - farm to fork strategy indicator 1 (all chemical active substances)	Index, 2015-2017 average =100	France	2011	102
Annual	Pesticides - farm to fork strategy indicator 1 (all chemical active substances)	Index, 2015-2017 average =100	Croatia	2011	133
Annual	Pesticides - farm to fork strategy indicator 1 (all chemical active substances)	Index, 2015-2017 average =100	Ireland	2011	112
Annual	Pesticides - farm to fork strategy indicator 1 (all chemical active substances)	Index, 2015-2017 average =100	Italy	2011	117


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

Share link

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