Key Variables By Type Of Farming (2-digit) And NUTS 2 Region

Eurostat code: ef_ov_kvftreg · (2000 - 2007)

@eurostat.ef_ov_kvftreg

Table List

2 tables(827.29 KB)

Key Variables By Type Of Farming (2-digit) And NUTS 2 Region - Raw

Key Variables By Type Of Farming (2-digit) And NUTS 2 Region - Unpivoted

Key Variables By Type Of Farming (2-digit) And NUTS 2 Region - Unpivoted

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

401.69 KB
133474 rows
6 columns

freq Freq	farmtype Farmtype	variable Variable	geo Geo	time_period Time Period	value Value
Annual	Specialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Austria	2000	407450
Annual	Specialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Ostösterreich	2000	290170
Annual	Specialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Südösterreich	2000	61580
Annual	Specialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Westösterreich	2000	55710
Annual	Specialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Belgium	2000	28240
Annual	Specialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Région de Bruxelles-Capitale/Brussels Hoofdstedelijk Gewest and Vlaams Gewest	2000	11260
Annual	Specialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Région wallonne	2000	16980
Annual	Specialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Germany	2000	3645140
Annual	Specialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Baden-Württemberg	2000	202480
Annual	Specialist cereals, oilseed and protein crops (calculated with Standard Gross Margin)	Utilised agricultural area (ha)	Bayern	2000	441850


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