Key Variables By Type Of Farming (1-digit), Economic Size Of Farm (ESU) And Objective Zone 1999

Eurostat code: ef_ov_kvftob99 · (2000 - 2000)

@eurostat.ef_ov_kvftob99

Table List

2 tables(187.17 KB)

Key Variables By Type Of Farming (1-digit), Economic Size Of Farm (ESU) And Objective Zone 1999 - Raw

Key Variables By Type Of Farming (1-digit), Economic Size Of Farm (ESU) And Objective Zone 1999 - Unpivoted

Key Variables By Type Of Farming (1-digit), Economic Size Of Farm (ESU) And Objective Zone 1999 - Unpivoted

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

93.87 KB
27584 rows
8 columns

freq Freq	esu Esu	obzone Obzone	farmtype Farmtype	variable Variable	geo Geo	time_period Time Period	value Value
Annual	From 1 to 1.9 ESU	Not in any objective zone (as defined up to 1999)	Specialist field crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Austria	2000	3800
Annual	From 1 to 1.9 ESU	Not in any objective zone (as defined up to 1999)	Specialist field crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Germany	2000	7920
Annual	From 1 to 1.9 ESU	Not in any objective zone (as defined up to 1999)	Specialist field crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Spain	2000	2700
Annual	From 1 to 1.9 ESU	Not in any objective zone (as defined up to 1999)	Specialist field crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Finland	2000	2750
Annual	From 1 to 1.9 ESU	Not in any objective zone (as defined up to 1999)	Specialist field crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Metropolitan France	2000	4270
Annual	From 1 to 1.9 ESU	Not in any objective zone (as defined up to 1999)	Specialist field crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Luxembourg	2000	40
Annual	From 1 to 1.9 ESU	Not in any objective zone (as defined up to 1999)	Specialist field crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Netherlands	2000	10
Annual	From 1 to 1.9 ESU	Not in any objective zone (as defined up to 1999)	Specialist field crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Sweden	2000	20130
Annual	From 1 to 1.9 ESU	Not in any objective zone (as defined up to 1999)	Specialist field crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	United Kingdom	2000	4340
Annual	From 1 to 1.9 ESU	Not in any objective zone (as defined up to 1999)	Specialist field crops (calculated with Standard Gross Margin)	hold: No. of holdings	Austria	2000	850


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