Total Area

Eurostat code: enps_reg_area3 · (2005 - 2022)

@eurostat.enps_reg_area3

Table List

2 tables(20.47 KB)

Total Area - Unpivoted

@eurostat.enps_reg_area3.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.97 KB
139 rows
6 columns

freq Freq	unit Unit	landuse Landuse	geo Geo	time_period Time Period	value Value
Annual	Square kilometre	Land area - total	Israel	2005	21643
Annual	Square kilometre	Land area - total	Jordan	2005	88778
Annual	Square kilometre	Land area - total	Palestine*	2005	6020
Annual	Square kilometre	Total area	Algeria	2005	2381741
Annual	Square kilometre	Total area	Egypt	2005	1009449.9
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,
  "landuse" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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