Water Supplied And Used By Economic Sectors

Eurostat code: med_en44 · (2005 - 2018)

@eurostat.med_en44

Table List

2 tables(22.24 KB)

Water Supplied And Used By Economic Sectors - Raw

Water Supplied And Used By Economic Sectors - Unpivoted

Water Supplied And Used By Economic Sectors - Unpivoted

@eurostat.med_en44.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.

7.32 KB
238 rows
7 columns

freq Freq	unit Unit	src Src	cons Cons	geo Geo	time_period Time Period	value Value
Annual	Million cubic metres	Public water supply	Population connected to public water supply (% of national population) - (only available for public water supply)	Algeria	2005	90
Annual	Million cubic metres	Public water supply	Population connected to public water supply (% of national population) - (only available for public water supply)	Israel	2005	100
Annual	Million cubic metres	Public water supply	Population connected to public water supply (% of national population) - (only available for public water supply)	Jordan	2005	82.4
Annual	Million cubic metres	Public water supply	Population connected to public water supply (% of national population) - (only available for public water supply)	Morocco	2005	70.9
Annual	Million cubic metres	Public water supply	Population connected to public water supply (% of national population) - (only available for public water supply)	Palestine*	2005	95.9
Annual	Million cubic metres	Public water supply	Population connected to public water supply (% of national population) - (only available for public water supply)	Tunisia	2005	80.6
Annual	Million cubic metres	Total water use from all supply categories (public/self/other)	Total supply	Jordan	2005	940.5
Annual	Million cubic metres	Total water use from all supply categories (public/self/other)	Total supply	Tunisia	2005	2092
Annual	Million cubic metres	Total water use from all supply categories (public/self/other)	Supply to agriculture, forestry, fishing (total)	Jordan	2005	610.5
Annual	Million cubic metres	Total water use from all supply categories (public/self/other)	Supply to agriculture, forestry, fishing (total)	Morocco	2005	9415


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "src" VARCHAR,
  "cons" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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