Baselight

Raw Material Consumption (RMC)

Eurostat code: sdg_12_21 ยท (2000 - 2023)

@eurostat.sdg_12_21

Raw Material Consumption (RMC) - Unpivoted
@eurostat.sdg_12_21.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.

  • 13.37 KB
  • 1018 rows
  • 7 columns
freq

Freq

indic_env

Indic Env

material

Material

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualRaw material consumptionTotalThousand tonnesSwitzerland2000144812.095
AnnualRaw material consumptionTotalThousand tonnesEuropean Union - 27 countries (from 2020)20006991168.875
AnnualRaw material consumptionTotalThousand tonnesLuxembourg200013596.403
AnnualRaw material consumptionTotalThousand tonnesLatvia200018418.902
AnnualRaw material consumptionTotalTonnes per capitaSwitzerland200020.157
AnnualRaw material consumptionTotalTonnes per capitaEuropean Union - 27 countries (from 2020)200016.299
AnnualRaw material consumptionTotalTonnes per capitaLuxembourg200031.163
AnnualRaw material consumptionTotalTonnes per capitaLatvia20007.78
AnnualRaw material consumptionTotalThousand tonnesSwitzerland2001151240.39
AnnualRaw material consumptionTotalThousand tonnesEuropean Union - 27 countries (from 2020)20017202980.718

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.