Households With Access To Secure Tenure By Simplified Degree Of Urbanisation

Eurostat code: enps_ilc_secure · (2005 - 2015)

@eurostat.enps_ilc_secure

Table List

2 tables(15.31 KB)

Households With Access To Secure Tenure By Simplified Degree Of Urbanisation - Raw

Households With Access To Secure Tenure By Simplified Degree Of Urbanisation - Unpivoted

Households With Access To Secure Tenure By Simplified Degree Of Urbanisation - Unpivoted

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

4.86 KB
49 rows
6 columns

freq Freq	unit Unit	deg_urb Deg Urb	geo Geo	time_period Time Period	value Value
Annual	Percentage	Urban areas	Egypt	2005	82.5
Annual	Percentage	Urban areas	Morocco	2005	66
Annual	Percentage	Rural areas	Morocco	2005	91.7
Annual	Percentage	Total	Morocco	2005	76.1
Annual	Percentage	Urban areas	Algeria	2006	96.2
Annual	Percentage	Urban areas	Jordan	2006	65.2
Annual	Percentage	Urban areas	Morocco	2006	64.6
Annual	Percentage	Rural areas	Algeria	2006	92.2
Annual	Percentage	Rural areas	Jordan	2006	84.2
Annual	Percentage	Rural areas	Morocco	2006	88.7


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

Share link

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