Baselight

Ammonia Emissions From Agriculture

Eurostat code: sdg_02_60 ยท (1990 - 2022)

@eurostat.sdg_02_60

Ammonia Emissions From Agriculture - Unpivoted
@eurostat.sdg_02_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.

  • 14.85 KB
  • 2048 rows
  • 5 columns
freq

Freq

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualKilograms per hectareAustria199020.6
AnnualKilograms per hectareBelgium199087.9
AnnualKilograms per hectareBulgaria199023.1
AnnualKilograms per hectareCyprus199052.2
AnnualKilograms per hectareCzechia199030.8
AnnualKilograms per hectareGermany199038.3
AnnualKilograms per hectareDenmark199050.3
AnnualKilograms per hectareEstonia199015.6
AnnualKilograms per hectareGreece199017.3
AnnualKilograms per hectareSpain199014.6

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

Share link

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