Structural Information

Eurostat code: med_ag1 · (2005 - 2018)

@eurostat.med_ag1

Table List

2 tables(17.97 KB)

Structural Information - Unpivoted

@eurostat.med_ag1.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.29 KB
138 rows
5 columns

freq Freq	indic_md Indic Md	geo Geo	time_period Time Period	value Value
Annual	Total utilised agricultural area (UAA) (ha)	Algeria	2005	8389640
Annual	Total utilised agricultural area (UAA) (ha)	Jordan	2005	285759
Annual	Total utilised agricultural area (UAA) (ha)	Morocco	2005	8988300
Annual	Total utilised agricultural area (UAA) (ha)	Palestine*	2005	183335
Annual	Total utilised agricultural area (UAA) (ha)	Tunisia	2005	9304620
Annual	Total irrigated agricultural land (ha)	Algeria	2005	803880
Annual	Total irrigated agricultural land (ha)	Egypt	2005	4400000
Annual	Total irrigated agricultural land (ha)	Jordan	2005	80045.2
Annual	Total irrigated agricultural land (ha)	Lebanon	2005	136300
Annual	Total irrigated agricultural land (ha)	Palestine*	2005	23854


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.