Baselight

Domestic Material Consumption Per Capita

Eurostat code: ten00137 ยท (2012 - 2023)

@eurostat.ten00137

Domestic Material Consumption Per Capita - Unpivoted
@eurostat.ten00137.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.

  • 8.62 KB
  • 418 rows
  • 7 columns
freq

Freq

indic_env

Indic Env

material

Material

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualDomestic material consumptionTotalTonnes per capitaAlbania20127.226
AnnualDomestic material consumptionTotalTonnes per capitaAustria201218.602
AnnualDomestic material consumptionTotalTonnes per capitaBelgium201213.439
AnnualDomestic material consumptionTotalTonnes per capitaBulgaria201217.591
AnnualDomestic material consumptionTotalTonnes per capitaSwitzerland201212.215
AnnualDomestic material consumptionTotalTonnes per capitaCyprus201219.228
AnnualDomestic material consumptionTotalTonnes per capitaCzechia201214.989
AnnualDomestic material consumptionTotalTonnes per capitaGermany201215.876
AnnualDomestic material consumptionTotalTonnes per capitaDenmark201223.555
AnnualDomestic material consumptionTotalTonnes per capitaEstonia201226.817

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

Share link

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