Landuse

Eurostat code: med_en61 · (2005 - 2019)

@eurostat.med_en61

Table List

2 tables(18.23 KB)

Landuse - Unpivoted

@eurostat.med_en61.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.82 KB
112 rows
6 columns

freq Freq	unit Unit	la La	geo Geo	time_period Time Period	value Value
Annual	Square kilometre	Land area	Israel	2005	21643
Annual	Square kilometre	Land area	Jordan	2005	88778
Annual	Square kilometre	Land area	Palestine*	2005	6020
Annual	Square kilometre	Total area	Algeria	2005	2381741
Annual	Square kilometre	Total area	Egypt	2005	1009450
Annual	Square kilometre	Total area	Israel	2005	22072
Annual	Square kilometre	Total area	Jordan	2005	89318
Annual	Square kilometre	Total area	Lebanon	2005	10452
Annual	Square kilometre	Total area	Morocco	2005	710850
Annual	Square kilometre	Total area	Tunisia	2005	164150


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

Share link

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