Vegetables, Melons, Strawberries And Greenhouses: Number Of Farms And Areas By Size Of Farm (UAA) And Size Of Vegetable, Melon And Strawberry Outdoor Area

Eurostat code: ef_lu_alvegout · (1990 - 2007)

@eurostat.ef_lu_alvegout

Table List

2 tables(708.04 KB)

Vegetables, Melons, Strawberries And Greenhouses: Number Of Farms And Areas By Size Of Farm (UAA) And Size Of Vegetable, Melon And Strawberry Outdoor Area - Raw

Vegetables, Melons, Strawberries And Greenhouses: Number Of Farms And Areas By Size Of Farm (UAA) And Size Of Vegetable, Melon And Strawberry Outdoor Area - Unpivoted

Vegetables, Melons, Strawberries And Greenhouses: Number Of Farms And Areas By Size Of Farm (UAA) And Size Of Vegetable, Melon And Strawberry Outdoor Area - Unpivoted

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

344.14 KB
191916 rows
8 columns

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


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

Share link

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