Olive Plantations: Number Of Farms And Areas By Agricultural Size Of Farm (UAA) And Size Of Olive Plantation Area by Eurostat | Environmental and Climate Sciences

About this Dataset

Olive Plantations: Number Of Farms And Areas By Agricultural Size Of Farm (UAA) And Size Of Olive Plantation Area

This Eurostat dataset contains data on olive plantations: number of farms and areas by agricultural size of farm (uaa) and size of olive plantation area, as collected and published by the Statistical Office of the European Union.

Tables included:

raw: Original table as downloaded from Eurostat.
tidy: A cleaned and transformed version of the raw table, where time period values appear as rows instead of columns (unpivoted format).

Last updated: 2017-01-16T23:00:00+0100

Tables

Olive Plantations: Number Of Farms And Areas By Agricultural Size Of Farm (UAA) And Size Of Olive Plantation Area - Raw

@eurostat.ef_poolive.raw

73.76 KB
8394 rows
9 columns


CREATE TABLE raw (
  "freq" VARCHAR,
  "agrarea" VARCHAR,
  "croparea" VARCHAR,
  "indic_ef" VARCHAR,
  "geo" VARCHAR,
  "n_2005" DOUBLE,
  "n_2007" DOUBLE,
  "n_2010" DOUBLE,
  "n_2013" DOUBLE
);

Olive Plantations: Number Of Farms And Areas By Agricultural Size Of Farm (UAA) And Size Of Olive Plantation Area - Unpivoted

@eurostat.ef_poolive.tidy

67.46 KB
30540 rows
7 columns


CREATE TABLE tidy (
  "freq" VARCHAR,
  "agrarea" VARCHAR,
  "croparea" VARCHAR,
  "indic_ef" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);