Consumption Of Chemicals By Hazardousness - EU Aggregate

Eurostat code: sdg_12_10 · (2004 - 2023)

@eurostat.sdg_12_10

Table List

2 tables(23.32 KB)

Consumption Of Chemicals By Hazardousness - EU Aggregate - Raw

Consumption Of Chemicals By Hazardousness - EU Aggregate - Unpivoted

Consumption Of Chemicals By Hazardousness - EU Aggregate - Unpivoted

@eurostat.sdg_12_10.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.11 KB
80 rows
7 columns

freq Freq	indic_env Indic Env	unit Unit	geo Geo	hazard Hazard	time_period Time Period	value Value
Annual	Consumption of chemicals	Million tonnes	European Union - 27 countries (from 2020)	Hazardous to the environment	2004	84.4
Annual	Consumption of chemicals	Million tonnes	European Union - 27 countries (from 2020)	Hazardous	2004	244.3
Annual	Consumption of chemicals	Million tonnes	European Union - 27 countries (from 2020)	Hazardous and non-hazardous - total	2004	317
Annual	Consumption of chemicals	Million tonnes	European Union - 27 countries (from 2020)	Hazardous to health	2004	243.4
Annual	Consumption of chemicals	Million tonnes	European Union - 27 countries (from 2020)	Hazardous to the environment	2005	89.6
Annual	Consumption of chemicals	Million tonnes	European Union - 27 countries (from 2020)	Hazardous	2005	251.9
Annual	Consumption of chemicals	Million tonnes	European Union - 27 countries (from 2020)	Hazardous and non-hazardous - total	2005	327.2
Annual	Consumption of chemicals	Million tonnes	European Union - 27 countries (from 2020)	Hazardous to health	2005	251.1
Annual	Consumption of chemicals	Million tonnes	European Union - 27 countries (from 2020)	Hazardous to the environment	2006	87.7
Annual	Consumption of chemicals	Million tonnes	European Union - 27 countries (from 2020)	Hazardous	2006	246.6


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

Share link

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