Crop Production

Eurostat code: med_ag2 · (2005 - 2019)

@eurostat.med_ag2

Table List

2 tables(45.07 KB)

Crop Production - Raw

Crop Production - Unpivoted

Crop Production - Raw

@eurostat.med_ag2.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

26.59 KB
178 rows
19 columns

freq Freq	crop_pro Crop Pro	unit Unit	geo Geo	n_2005 2005	n_2006 2006	n_2007 2007	n_2008 2008	n_2009 2009	n_2010 2010	n_2011 2011	n_2012 2012	n_2013 2013	n_2014 2014	n_2015 2015	n_2016 2016	n_2017 2017	n_2018 2018	n_2019 2019
Annual	Cereals (excluding rice)	Tonne	Algeria	3525100	4012800	3597800	1533600	5252200	4001600	4245700	5133648	4910973.5	3432178	3755489.5	3432300	3470200	6057000
Annual	Cereals (excluding rice)	Tonne	Egypt	16890429	16222462	15329784	16394647	17138938	15170776	16208488	17753804	18317822	18244782	18232000	17984000	17869000
Annual	Cereals (excluding rice)	Tonne	Israel	262173	180728	203318	111942	287975	267931	280144	356812	372776.9	344935	326100	298100	229700	195600
Annual	Cereals (excluding rice)	Tonne	Jordan	102331	61856	53289	47461	60907	87266	83042	84014	102147	77827	88773	99000	98300	81000
Annual	Cereals (excluding rice)	Tonne	Lebanon	394300	429600	391500	383500	416500							182400
Annual	Cereals (excluding rice)	Tonne	Morocco	4227020	9192760	2462860	5277420	10401890	7774870	8604158.4	5231639	9825912	6897620	11690200	3479800	9679700	10380000	5186500
Annual	Cereals (excluding rice)	Tonne	Palestine*	79077	71189	69693	54076
Annual	Cereals (excluding rice)	Tonne	Tunisia	2097000	1610300	1988400	1188093	2533600	1079646	2310300	2273000	1295100	2317100	1307800
Annual	Common wheat and spelt	Tonne	Algeria	846018.5	915130	789964	297221	952000	796200	715100	1025112.5	966679.6	591863.4	636791.6	502500	445500	803200
Annual	Common wheat and spelt	Tonne	Israel	213626	142840	170293	85754.4	132963	112324	122024	189487	151800	173000	157000	168000	70500	72180


CREATE TABLE raw (
  "freq" VARCHAR,
  "crop_pro" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE
);

Share link

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