Baselight
Sign In

Wine-grower Holdings By Size Class

Eurostat code: vit_t2 ยท (1999 - 2020)

@eurostat.vit_t2

Wine-grower Holdings By Size Class - Unpivoted
@eurostat.vit_t2.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.

  • 30.44 KB
  • 5852 rows
  • 7 columns
freq

Freq

vinetype

Vinetype

agrarea

Agrarea

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualVines for raisinsFrom 0.10 to 0.49 haHectareAustria1999
AnnualVines for raisinsFrom 0.10 to 0.49 haHectareGermany1999
AnnualVines for raisinsFrom 0.10 to 0.49 haHectareGreece19993868
AnnualVines for raisinsFrom 0.10 to 0.49 haHectareSpain1999237
AnnualVines for raisinsFrom 0.10 to 0.49 haHectareEuropean Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)19994107
AnnualVines for raisinsFrom 0.10 to 0.49 haHectareFrance1999
AnnualVines for raisinsFrom 0.10 to 0.49 haHectareItaly1999
AnnualVines for raisinsFrom 0.10 to 0.49 haHectareLuxembourg1999
AnnualVines for raisinsFrom 0.10 to 0.49 haHectarePortugal19992
AnnualVines for raisinsFrom 0.10 to 0.49 haHectareUnited Kingdom1999

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

Share link

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