Grassland Butterfly Index - EU Aggregate

Eurostat code: sdg_15_61 · (1991 - 2020)

@eurostat.sdg_15_61

Table List

2 tables(28.09 KB)

Grassland Butterfly Index - EU Aggregate - Raw

Grassland Butterfly Index - EU Aggregate - Unpivoted

Grassland Butterfly Index - EU Aggregate - Unpivoted

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

5.48 KB
60 rows
6 columns

freq Freq	statinfo Statinfo	geo Geo	unit Unit	time_period Time Period	value Value
Annual	Smoothed estimate	European Union (aggregate changing according to the context)	Index, 2000=100	1991	107.73
Annual	Smoothed estimate	European Union (aggregate changing according to the context)	Index, 1991=100	1991	100
Annual	Smoothed estimate	European Union (aggregate changing according to the context)	Index, 2000=100	1992	107.18
Annual	Smoothed estimate	European Union (aggregate changing according to the context)	Index, 1991=100	1992	99.49
Annual	Smoothed estimate	European Union (aggregate changing according to the context)	Index, 2000=100	1993	106.62
Annual	Smoothed estimate	European Union (aggregate changing according to the context)	Index, 1991=100	1993	98.97
Annual	Smoothed estimate	European Union (aggregate changing according to the context)	Index, 2000=100	1994	105.99
Annual	Smoothed estimate	European Union (aggregate changing according to the context)	Index, 1991=100	1994	98.39
Annual	Smoothed estimate	European Union (aggregate changing according to the context)	Index, 2000=100	1995	105.25
Annual	Smoothed estimate	European Union (aggregate changing according to the context)	Index, 1991=100	1995	97.7


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

Share link

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