Drugs In Municipal Wastewater In Selected European And International Cities

European Monitoring Centre for Drugs and Drug Addiction

@euda.drugs_in_municipal_wastewater_in_selected_european_cities

Table List

1 table(201.08 KB)

Table 1

@euda.drugs_in_municipal_wastewater_in_selected_european_cities.table_1

This resources includes all of the data including daily measurements and means. The resource includes methodological notes. All data is in CSV format and is released under the

201.08 KB
3607 rows
15 columns

year Year	metabolite Metabolite	site_id Site ID	country Country	city City	wednesday Wednesday	thursday Thursday	friday Friday	saturday Saturday	sunday Sunday	monday Monday	tuesday Tuesday	weekday_mean Weekday Mean	weekend_mean Weekend Mean	daily_mean Daily Mean
2023	MDMA	AT001	AT	Graz	9.46	7.43	8.36	27.5	42.4	35.19	35.8	17.56	28.36	23.73
2023	MDMA	AT002	AT	Hall-Wattens	3.07	2.51	2.84	6.62	21.06	10.55	6.62	4.07	10.27	7.61
2023	MDMA	AT004	AT	Innsbruck	7.9	6.15	8.82	33.85	48.1	21.87	10.33	8.13	28.16	19.57
2023	MDMA	AT005	AT	Kapfenberg	3.59	3.58	5.6	7.18	8.56	7.35	4.53	3.9	7.17	5.77
2023	MDMA	AT006	AT	Klagenfurt	6.39	5.46	2.8	8.36	11.79	8.41	6.4	6.09	7.84	7.09
2023	MDMA	AT008	AT	Knittelfeld	5.78	4.41	4.24	9.62	7.38	8.44	5.58	5.26	7.42	6.49
2023	MDMA	AT010	AT	Kufstein	8.47	5.28	4.29	15.98	14.57	5.92	5.6	6.45	10.19	8.59
2023	MDMA	AT013	AT	Purgstall	2.95	4.94	12.55	13.79	24.73	25.33	8.26	5.38	19.1	13.22
2023	MDMA	AT011	AT	Region Millstättersee	3.49	5.73	2.39	1.84	3.49	4.56	3.32	4.18	3.07	3.55
2023	MDMA	AT014	AT	Salzburg	3.06	3.4	3.99	9.1	15.81	7.09	5.84	4.1	9	6.9


CREATE TABLE table_1 (
  "year" BIGINT,
  "metabolite" VARCHAR,
  "site_id" VARCHAR,
  "country" VARCHAR,
  "city" VARCHAR,
  "wednesday" DOUBLE,
  "thursday" DOUBLE,
  "friday" DOUBLE,
  "saturday" DOUBLE,
  "sunday" DOUBLE,
  "monday" DOUBLE,
  "tuesday" DOUBLE,
  "weekday_mean" DOUBLE,
  "weekend_mean" DOUBLE,
  "daily_mean" DOUBLE
);

Share link

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