Baselight

Under Glass By NUTS 2 Region

Eurostat code: ef_lus_unglass ยท (2013 - 2016)

@eurostat.ef_lus_unglass

Under Glass By NUTS 2 Region - Unpivoted
@eurostat.ef_lus_unglass.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.

  • 1.28 MB
  • 1049085 rows
  • 9 columns
freq

Freq

so_eur

So Eur

croparea

Croparea

crops

Crops

unit

Unit

agrarea

Agrarea

geo

Geo

time_period

Time Period

value

Value

AnnualZero eurosZero haFlowers and ornamental plants (excluding nurseries) - under glass or high accessible coverHectareZero haBelgium2013
AnnualZero eurosZero haFlowers and ornamental plants (excluding nurseries) - under glass or high accessible coverHectareZero haProv. Limburg (BE)2013
AnnualZero eurosZero haFlowers and ornamental plants (excluding nurseries) - under glass or high accessible coverHectareZero haProv. Oost-Vlaanderen2013
AnnualZero eurosZero haFlowers and ornamental plants (excluding nurseries) - under glass or high accessible coverHectareZero haProv. West-Vlaanderen2013
AnnualZero eurosZero haFlowers and ornamental plants (excluding nurseries) - under glass or high accessible coverHectareZero haDenmark2013
AnnualZero eurosZero haFlowers and ornamental plants (excluding nurseries) - under glass or high accessible coverHectareZero haSyddanmark2013
AnnualZero eurosZero haFlowers and ornamental plants (excluding nurseries) - under glass or high accessible coverHectareZero haMidtjylland2013
AnnualZero eurosZero haFlowers and ornamental plants (excluding nurseries) - under glass or high accessible coverHectareZero haFrance2013
AnnualZero eurosZero haFlowers and ornamental plants (excluding nurseries) - under glass or high accessible coverHectareZero haIle de France2013
AnnualZero eurosZero haFlowers and ornamental plants (excluding nurseries) - under glass or high accessible coverHectareZero haPicardie (NUTS 2013)2013

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

Share link

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