Irrigation: Number Of Farms, Areas And Equipment By Size Of Farm (UAA) And NUTS 2 Region

Eurostat code: ef_lu_ofirrig · (1990 - 2007)

@eurostat.ef_lu_ofirrig

Table List

2 tables(184.38 KB)

Irrigation: Number Of Farms, Areas And Equipment By Size Of Farm (UAA) And NUTS 2 Region - Raw

Irrigation: Number Of Farms, Areas And Equipment By Size Of Farm (UAA) And NUTS 2 Region - Unpivoted

Irrigation: Number Of Farms, Areas And Equipment By Size Of Farm (UAA) And NUTS 2 Region - Unpivoted

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

81.46 KB
21949 rows
6 columns

freq Freq	variable Variable	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Utilised agricultural area	Hectare	Belgium	1990	1344500
Annual	Utilised agricultural area	Hectare	Région de Bruxelles-Capitale/Brussels Hoofdstedelijk Gewest and Vlaams Gewest	1990	598970
Annual	Utilised agricultural area	Hectare	Région wallonne	1990	745520
Annual	Utilised agricultural area	Hectare	Denmark	1990	2779020
Annual	Utilised agricultural area	Hectare	Greece	1990	3661210
Annual	Utilised agricultural area	Hectare	Anatoliki Makedonia, Thraki (NUTS 2010)	1990	360400
Annual	Utilised agricultural area	Hectare	Kentriki Makedonia (NUTS 2010)	1990	612640
Annual	Utilised agricultural area	Hectare	Dytiki Makedonia (NUTS 2010)	1990	200530
Annual	Utilised agricultural area	Hectare	Thessalia (NUTS 2010)	1990	420190
Annual	Utilised agricultural area	Hectare	Ipeiros (NUTS 2010)	1990	128000


CREATE TABLE tidy (
  "freq" 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.