Gross Value Added At Basic Prices By Metropolitan Region

Eurostat code: met_10r_3gva · (1995 - 2022)

@eurostat.met_10r_3gva

Table List

2 tables(1.78 MB)

Gross Value Added At Basic Prices By Metropolitan Region - Raw

Gross Value Added At Basic Prices By Metropolitan Region - Unpivoted

Gross Value Added At Basic Prices By Metropolitan Region - Unpivoted

@eurostat.met_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.

930 KB
170908 rows
6 columns

freq Freq	currency Currency	nace_r2 Nace R2	metroreg Metroreg	time_period Time Period	value Value
Annual	Million euro	Agriculture, forestry and fishing	Czechia	1995	1856.93
Annual	Million euro	Agriculture, forestry and fishing	Praha	1995	235.79
Annual	Million euro	Agriculture, forestry and fishing	Brno	1995	228.5
Annual	Million euro	Agriculture, forestry and fishing	Ostrava	1995	149.04
Annual	Million euro	Agriculture, forestry and fishing	Plzen	1995	147.19
Annual	Million euro	Agriculture, forestry and fishing	Non-metropolitan regions in Czech Republic	1995	1096.41
Annual	Million euro	Agriculture, forestry and fishing	Estonia	1995	123.42
Annual	Million euro	Agriculture, forestry and fishing	Tallinn	1995	16.29
Annual	Million euro	Agriculture, forestry and fishing	Non-metropolitan regions in Estonia	1995	107.13
Annual	Million euro	Agriculture, forestry and fishing	Italy	1995	26748.73


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

Share link

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