Farm Indicators By Other Gainful Activities Related To The Holder, Utilized Agricultural Area, Type And Economic Size Of The Farm And NUTS 2 Region

Eurostat code: ef_oga_main · (2010 - 2020)

@eurostat.ef_oga_main

Table List

2 tables(144.17 MB)

Farm Indicators By Other Gainful Activities Related To The Holder, Utilized Agricultural Area, Type And Economic Size Of The Farm And NUTS 2 Region - Raw

Farm Indicators By Other Gainful Activities Related To The Holder, Utilized Agricultural Area, Type And Economic Size Of The Farm And NUTS 2 Region - Unpivoted

Farm Indicators By Other Gainful Activities Related To The Holder, Utilized Agricultural Area, Type And Economic Size Of The Farm And NUTS 2 Region - Unpivoted

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

70.67 MB
22093870 rows
10 columns

freq Freq	statinfo Statinfo	so_eur So Eur	farmtype Farmtype	uaarea Uaarea	oga_hld Oga Hld	unit Unit	geo Geo	time_period Time Period
Annual	Above threshold	Zero euros	Non-classified farms (calculated with Standard Output)	Zero ha	Holder not having other gainful activities	Euro	Iceland	2010
Annual	Above threshold	Zero euros	Non-classified farms (calculated with Standard Output)	Zero ha	Holder not having other gainful activities	Euro	Ísland	2010
Annual	Above threshold	Zero euros	Non-classified farms (calculated with Standard Output)	Zero ha	Holder not having other gainful activities	Hectare	Iceland	2010
Annual	Above threshold	Zero euros	Non-classified farms (calculated with Standard Output)	Zero ha	Holder not having other gainful activities	Hectare	Ísland	2010
Annual	Above threshold	Zero euros	Non-classified farms (calculated with Standard Output)	Zero ha	Holder not having other gainful activities	Livestock unit (LSU)	Iceland	2010
Annual	Above threshold	Zero euros	Non-classified farms (calculated with Standard Output)	Zero ha	Holder not having other gainful activities	Livestock unit (LSU)	Ísland	2010
Annual	Above threshold	Zero euros	Non-classified farms (calculated with Standard Output)	Zero ha	Total	Euro	Iceland	2010
Annual	Above threshold	Zero euros	Non-classified farms (calculated with Standard Output)	Zero ha	Total	Euro	Ísland	2010
Annual	Above threshold	Zero euros	Non-classified farms (calculated with Standard Output)	Zero ha	Total	Hectare	Iceland	2010
Annual	Above threshold	Zero euros	Non-classified farms (calculated with Standard Output)	Zero ha	Total	Hectare	Ísland	2010


CREATE TABLE tidy (
  "freq" VARCHAR,
  "statinfo" VARCHAR,
  "so_eur" VARCHAR,
  "farmtype" VARCHAR,
  "uaarea" VARCHAR,
  "oga_hld" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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