Common Bird Index By Type Of Species - EU Aggregate

Eurostat code: sdg_15_60 · (1990 - 2023)

@eurostat.sdg_15_60

Table List

2 tables(33.68 KB)

Common Bird Index By Type Of Species - EU Aggregate - Raw

Common Bird Index By Type Of Species - EU Aggregate - Unpivoted

Common Bird Index By Type Of Species - EU Aggregate - Unpivoted

@eurostat.sdg_15_60.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.96 KB
204 rows
7 columns

freq Freq	statinfo Statinfo	geo Geo	comspec Comspec	unit Unit	time_period Time Period	value Value
Annual	Smoothed estimate	European Union - 27 countries (from 2020)	All common species	Index, 2000=100	1990	102.56
Annual	Smoothed estimate	European Union - 27 countries (from 2020)	All common species	Index, 1990=100	1990	100
Annual	Smoothed estimate	European Union - 27 countries (from 2020)	Common farmland species	Index, 2000=100	1990	119.17
Annual	Smoothed estimate	European Union - 27 countries (from 2020)	Common farmland species	Index, 1990=100	1990	100
Annual	Smoothed estimate	European Union - 27 countries (from 2020)	Common forest species	Index, 2000=100	1990	106
Annual	Smoothed estimate	European Union - 27 countries (from 2020)	Common forest species	Index, 1990=100	1990	100
Annual	Smoothed estimate	European Union - 27 countries (from 2020)	All common species	Index, 2000=100	1991	102.64
Annual	Smoothed estimate	European Union - 27 countries (from 2020)	All common species	Index, 1990=100	1991	100.07
Annual	Smoothed estimate	European Union - 27 countries (from 2020)	Common farmland species	Index, 2000=100	1991	116.78
Annual	Smoothed estimate	European Union - 27 countries (from 2020)	Common farmland species	Index, 1990=100	1991	97.99


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

Share link

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