Crop Production

Eurostat code: med_ag2 · (2005 - 2019)

@eurostat.med_ag2

Table List

2 tables(45.07 KB)

Crop Production - Unpivoted

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

18.48 KB
1979 rows
6 columns

freq Freq	crop_pro Crop Pro	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Cereals (excluding rice)	Tonne	Algeria	2005	3525100
Annual	Cereals (excluding rice)	Tonne	Egypt	2005	16890429
Annual	Cereals (excluding rice)	Tonne	Israel	2005	262173
Annual	Cereals (excluding rice)	Tonne	Jordan	2005	102331
Annual	Cereals (excluding rice)	Tonne	Lebanon	2005	394300
Annual	Cereals (excluding rice)	Tonne	Morocco	2005	4227020
Annual	Cereals (excluding rice)	Tonne	Palestine*	2005	79077
Annual	Cereals (excluding rice)	Tonne	Tunisia	2005	2097000
Annual	Common wheat and spelt	Tonne	Algeria	2005	846018.5
Annual	Common wheat and spelt	Tonne	Israel	2005	213626


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

Share link

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