Gross Value Added At Basic Prices By Other Typologies

Eurostat code: urt_10r_3gva · (1995 - 2022)

@eurostat.urt_10r_3gva

Table List

2 tables(2.5 MB)

Gross Value Added At Basic Prices By Other Typologies - Raw

Gross Value Added At Basic Prices By Other Typologies - Unpivoted

Gross Value Added At Basic Prices By Other Typologies - Unpivoted

@eurostat.urt_10r_3gva.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.27 MB
234494 rows
7 columns

freq Freq	currency Currency	nace_r2 Nace R2	terrtypo Terrtypo	geo Geo	time_period Time Period	value Value
Annual	Million euro	Agriculture, forestry and fishing	Border regions	Czechia	1995	1426.13
Annual	Million euro	Agriculture, forestry and fishing	Border regions	Estonia	1995	78
Annual	Million euro	Agriculture, forestry and fishing	Border regions	Luxembourg	1995	149.04
Annual	Million euro	Agriculture, forestry and fishing	Border regions	Portugal	1995	1658.82
Annual	Million euro	Agriculture, forestry and fishing	Coastal regions	Estonia	1995	83.74
Annual	Million euro	Agriculture, forestry and fishing	Coastal regions	Portugal	1995	2861.45
Annual	Million euro	Agriculture, forestry and fishing	Intermediate regions	Czechia	1995	957.98
Annual	Million euro	Agriculture, forestry and fishing	Intermediate regions	Luxembourg	1995	149.04
Annual	Million euro	Agriculture, forestry and fishing	Intermediate regions	Portugal	1995	851.03
Annual	Million euro	Agriculture, forestry and fishing	Intermediate regions - close to city	Czechia	1995	957.98


CREATE TABLE tidy (
  "freq" VARCHAR,
  "currency" VARCHAR,
  "nace_r2" VARCHAR,
  "terrtypo" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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