Key Variables By Type Of Farming (1-digit), Economic Size Of Farm (ESU) And LFA Status

Eurostat code: ef_ov_kvesuft · (2000 - 2007)

@eurostat.ef_ov_kvesuft

Table List

2 tables(1.03 MB)

Key Variables By Type Of Farming (1-digit), Economic Size Of Farm (ESU) And LFA Status - Raw

Key Variables By Type Of Farming (1-digit), Economic Size Of Farm (ESU) And LFA Status - Unpivoted

Key Variables By Type Of Farming (1-digit), Economic Size Of Farm (ESU) And LFA Status - Unpivoted

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

511.54 KB
168823 rows
8 columns

freq Freq	esu Esu	terrtypo Terrtypo	farmtype Farmtype	variable Variable	geo Geo	time_period Time Period	value Value
Annual	From 1 to 1.9 ESU	Less favoured areas - mountainous	Specialist field crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Austria	2000	6190
Annual	From 1 to 1.9 ESU	Less favoured areas - mountainous	Specialist field crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Germany	2000	80
Annual	From 1 to 1.9 ESU	Less favoured areas - mountainous	Specialist field crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Greece	2000	10850
Annual	From 1 to 1.9 ESU	Less favoured areas - mountainous	Specialist field crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Spain	2000	22170
Annual	From 1 to 1.9 ESU	Less favoured areas - mountainous	Specialist field crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Finland	2000	21120
Annual	From 1 to 1.9 ESU	Less favoured areas - mountainous	Specialist field crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Metropolitan France	2000	1190
Annual	From 1 to 1.9 ESU	Less favoured areas - mountainous	Specialist field crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Italy	2000	56080
Annual	From 1 to 1.9 ESU	Less favoured areas - mountainous	Specialist field crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Portugal	2000	9030
Annual	From 1 to 1.9 ESU	Less favoured areas - mountainous	Specialist field crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Sweden	2000	9880
Annual	From 1 to 1.9 ESU	Less favoured areas - mountainous	Specialist field crops (calculated with Standard Gross Margin)	hold: No. of holdings	Austria	2000	1020


CREATE TABLE tidy (
  "freq" VARCHAR,
  "esu" VARCHAR,
  "terrtypo" VARCHAR,
  "farmtype" VARCHAR,
  "variable" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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