Cereals: Number Of Farms, Areas And Combine Harvestors By Size Of Farm (UAA) And Size Of Cereal Area

Eurostat code: ef_lu_alcereal · (1990 - 2007)

@eurostat.ef_lu_alcereal

Table List

2 tables(1012.63 KB)

Cereals: Number Of Farms, Areas And Combine Harvestors By Size Of Farm (UAA) And Size Of Cereal Area - Raw

Cereals: Number Of Farms, Areas And Combine Harvestors By Size Of Farm (UAA) And Size Of Cereal Area - Unpivoted

Cereals: Number Of Farms, Areas And Combine Harvestors By Size Of Farm (UAA) And Size Of Cereal Area - Unpivoted

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

475.18 KB
248256 rows
8 columns

freq Freq	agrarea Agrarea	croparea Croparea	variable Variable	unit Unit	geo Geo	time_period Time Period
Annual	Zero ha	Zero ha	Utilised agricultural area	Hectare	Belgium	1990
Annual	Zero ha	Zero ha	Utilised agricultural area	Hectare	Denmark	1990
Annual	Zero ha	Zero ha	Utilised agricultural area	Hectare	Greece	1990
Annual	Zero ha	Zero ha	Utilised agricultural area	Hectare	Spain	1990
Annual	Zero ha	Zero ha	Utilised agricultural area	Hectare	Metropolitan France	1990
Annual	Zero ha	Zero ha	Utilised agricultural area	Hectare	Ireland	1990
Annual	Zero ha	Zero ha	Utilised agricultural area	Hectare	Italy	1990
Annual	Zero ha	Zero ha	Utilised agricultural area	Hectare	Luxembourg	1990
Annual	Zero ha	Zero ha	Utilised agricultural area	Hectare	Netherlands	1990
Annual	Zero ha	Zero ha	Utilised agricultural area	Hectare	Portugal	1990


CREATE TABLE tidy (
  "freq" VARCHAR,
  "agrarea" VARCHAR,
  "croparea" VARCHAR,
  "variable" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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