Baselight

Organic Operators By Status Of The Registration Process (until 2011)

Eurostat code: org_coptyp_h ยท (1997 - 2011)

@eurostat.org_coptyp_h

About this Dataset

Organic Operators By Status Of The Registration Process (until 2011)

This Eurostat dataset contains data on organic operators by status of the registration process (until 2011), 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: 2019-02-15T23:00:00+0100

Tables

Organic Operators By Status Of The Registration Process (until 2011) - Raw

@eurostat.org_coptyp_h.raw
  • 33.95 KB
  • 869 rows
  • 20 columns

CREATE TABLE raw (
  "freq" VARCHAR,
  "procstat" VARCHAR,
  "operator" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_1997" DOUBLE,
  "n_1998" DOUBLE,
  "n_1999" DOUBLE,
  "n_2000" DOUBLE,
  "n_2001" DOUBLE,
  "n_2002" DOUBLE,
  "n_2003" DOUBLE,
  "n_2004" DOUBLE,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE
);

Organic Operators By Status Of The Registration Process (until 2011) - Unpivoted

@eurostat.org_coptyp_h.tidy
  • 22.25 KB
  • 5385 rows
  • 7 columns

CREATE TABLE tidy (
  "freq" VARCHAR,
  "procstat" VARCHAR,
  "operator" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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