Access To Basic Services And Housing

Eurostat code: med_ps32 · (2005 - 2018)

@eurostat.med_ps32

Table List

2 tables(18.22 KB)

Access To Basic Services And Housing - Raw

Access To Basic Services And Housing - Unpivoted

Access To Basic Services And Housing - Unpivoted

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

5.31 KB
155 rows
5 columns

freq Freq	indic_md Indic Md	geo Geo	time_period Time Period	value Value
Annual	Proportion of households with sustainable access to improved sanitation, urban (%)	Israel	2005	100
Annual	Proportion of households with sustainable access to improved sanitation, urban (%)	Morocco	2005	87.2
Annual	Proportion of households with sustainable access to improved sanitation, urban (%)	Palestine*	2005	99.2
Annual	Proportion of households with sustainable access to improved sanitation, urban (%)	Tunisia	2005	80.1
Annual	Proportion of households with sustainable access to improved sanitation, rural (%)	Israel	2005	99
Annual	Proportion of households with sustainable access to improved sanitation, rural (%)	Palestine*	2005	99.5
Annual	Proportion of households with sustainable access to improved sanitation, total (%)	Israel	2005	99
Annual	Proportion of households with sustainable access to improved sanitation, total (%)	Morocco	2005	54
Annual	Proportion of households with sustainable access to improved sanitation, total (%)	Palestine*	2005	99.4
Annual	Proportion of households with access to secure tenure, urban (%)	Egypt	2005	82.5


CREATE TABLE tidy (
  "freq" VARCHAR,
  "indic_md" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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