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

Eurostat code: ef_ov_kvftob00 · (2000 - 2005)

@eurostat.ef_ov_kvftob00

Table List

2 tables(533.33 KB)

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

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

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

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

255.2 KB
82879 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 from 2000)	Specialist field crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Belgium	2000	790
Annual	From 1 to 1.9 ESU	Not in any objective zone (as defined from 2000)	Specialist field crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Denmark	2000	490
Annual	From 1 to 1.9 ESU	Not in any objective zone (as defined from 2000)	Specialist field crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Italy	2000	52640
Annual	From 1 to 1.9 ESU	Not in any objective zone (as defined from 2000)	Specialist field crops (calculated with Standard Gross Margin)	hold: No. of holdings	Belgium	2000	470
Annual	From 1 to 1.9 ESU	Not in any objective zone (as defined from 2000)	Specialist field crops (calculated with Standard Gross Margin)	hold: No. of holdings	Denmark	2000	60
Annual	From 1 to 1.9 ESU	Not in any objective zone (as defined from 2000)	Specialist field crops (calculated with Standard Gross Margin)	hold: No. of holdings	Italy	2000	34470
Annual	From 1 to 1.9 ESU	Not in any objective zone (as defined from 2000)	Specialist field crops (calculated with Standard Gross Margin)	LSU: Livestock	Belgium	2000	90
Annual	From 1 to 1.9 ESU	Not in any objective zone (as defined from 2000)	Specialist field crops (calculated with Standard Gross Margin)	LSU: Livestock	Denmark	2000	30
Annual	From 1 to 1.9 ESU	Not in any objective zone (as defined from 2000)	Specialist field crops (calculated with Standard Gross Margin)	LSU: Livestock	Italy	2000	4970
Annual	From 1 to 1.9 ESU	Not in any objective zone (as defined from 2000)	Specialist field crops (calculated with Standard Gross Margin)	AWU: Labour force - directly employed by the holding	Belgium	2000	170


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.