Baselight

Generation Of Waste By Hazardousness

Eurostat code: sdg_12_51 ยท (2004 - 2022)

@eurostat.sdg_12_51

Generation Of Waste By Hazardousness - Unpivoted
@eurostat.sdg_12_51.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.

  • 12.15 KB
  • 1092 rows
  • 8 columns
freq

Freq

waste

Waste

hazard

Hazard

nace_r2

Nace R2

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualTotal wasteHazardousAll NACE activities plus householdsKilograms per capitaAustria2004124
AnnualTotal wasteHazardousAll NACE activities plus householdsKilograms per capitaBelgium2004499
AnnualTotal wasteHazardousAll NACE activities plus householdsKilograms per capitaBulgaria20041542
AnnualTotal wasteHazardousAll NACE activities plus householdsKilograms per capitaCyprus2004153
AnnualTotal wasteHazardousAll NACE activities plus householdsKilograms per capitaCzechia2004142
AnnualTotal wasteHazardousAll NACE activities plus householdsKilograms per capitaGermany2004242
AnnualTotal wasteHazardousAll NACE activities plus householdsKilograms per capitaDenmark200459
AnnualTotal wasteHazardousAll NACE activities plus householdsKilograms per capitaEstonia20045382
AnnualTotal wasteHazardousAll NACE activities plus householdsKilograms per capitaGreece200431
AnnualTotal wasteHazardousAll NACE activities plus householdsKilograms per capitaSpain200473

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

Share link

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