Key Variables By Type Of Farming (2-digit) And Economic Size Of Farm (ESU)

Eurostat code: ef_ov_kvftesu · (2000 - 2007)

@eurostat.ef_ov_kvftesu

Table List

2 tables(769.38 KB)

Key Variables By Type Of Farming (2-digit) And Economic Size Of Farm (ESU) - Raw

Key Variables By Type Of Farming (2-digit) And Economic Size Of Farm (ESU) - Unpivoted

Key Variables By Type Of Farming (2-digit) And Economic Size Of Farm (ESU) - Unpivoted

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

369.97 KB
134890 rows
7 columns

freq Freq	esu Esu	farmtype Farmtype	variable Variable	geo Geo	time_period Time Period	value Value
Annual	From 1 to 1.9 ESU	Specialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Austria	2000	22380
Annual	From 1 to 1.9 ESU	Specialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Belgium	2000	400
Annual	From 1 to 1.9 ESU	Specialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Germany	2000	11000
Annual	From 1 to 1.9 ESU	Specialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Denmark	2000	570
Annual	From 1 to 1.9 ESU	Specialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Greece	2000	50960
Annual	From 1 to 1.9 ESU	Specialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Spain	2000	91230
Annual	From 1 to 1.9 ESU	Specialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Finland	2000	14100
Annual	From 1 to 1.9 ESU	Specialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Metropolitan France	2000	11240
Annual	From 1 to 1.9 ESU	Specialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Hungary	2000	85750
Annual	From 1 to 1.9 ESU	Specialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Ireland	2000	610


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