Crop Production

Eurostat code: enps_apro_cpnh1 · (2005 - 2022)

@eurostat.enps_apro_cpnh1

Table List

2 tables(47.43 KB)

Crop Production - Unpivoted

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

17.95 KB
2424 rows
6 columns

freq Freq	unit Unit	crops Crops	geo Geo	time_period Time Period	value Value
Annual	Thousand tonnes	Cereals (excluding rice) for the production of grain (including seed)	Algeria	2005	3525.1
Annual	Thousand tonnes	Cereals (excluding rice) for the production of grain (including seed)	Egypt	2005	16890.4
Annual	Thousand tonnes	Cereals (excluding rice) for the production of grain (including seed)	Israel	2005	262.2
Annual	Thousand tonnes	Cereals (excluding rice) for the production of grain (including seed)	Jordan	2005	102.3
Annual	Thousand tonnes	Cereals (excluding rice) for the production of grain (including seed)	Lebanon	2005	394.3
Annual	Thousand tonnes	Cereals (excluding rice) for the production of grain (including seed)	Morocco	2005	4227
Annual	Thousand tonnes	Cereals (excluding rice) for the production of grain (including seed)	Palestine*	2005	79.1
Annual	Thousand tonnes	Cereals (excluding rice) for the production of grain (including seed)	Tunisia	2005	2097
Annual	Thousand tonnes	Common wheat and spelt	Algeria	2005	846
Annual	Thousand tonnes	Common wheat and spelt	Israel	2005	213.6


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

Share link

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