Gross Fixed Capital Formation By NUTS 2 Regions For Total Economy And General Government

Eurostat code: nama_10r_2gfcf · (1995 - 2023)

@eurostat.nama_10r_2gfcf

Table List

2 tables(2.48 MB)

Gross Fixed Capital Formation By NUTS 2 Regions For Total Economy And General Government - Raw

Gross Fixed Capital Formation By NUTS 2 Regions For Total Economy And General Government - Unpivoted

Gross Fixed Capital Formation By NUTS 2 Regions For Total Economy And General Government - Unpivoted

@eurostat.nama_10r_2gfcf.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.24 MB
281244 rows
7 columns

freq Freq	sector Sector	currency Currency	nace_r2 Nace R2	geo Geo	time_period Time Period	value Value
Annual	Total economy	Million euro	Agriculture, forestry and fishing	Cyprus	1995	56.19
Annual	Total economy	Million euro	Agriculture, forestry and fishing	Kýpros	1995	56.19
Annual	Total economy	Million euro	Agriculture, forestry and fishing	Kýpros	1995	56.19
Annual	Total economy	Million euro	Agriculture, forestry and fishing	Czechia	1995	636.73
Annual	Total economy	Million euro	Agriculture, forestry and fishing	Česko	1995	636.73
Annual	Total economy	Million euro	Agriculture, forestry and fishing	Praha	1995	1.93
Annual	Total economy	Million euro	Agriculture, forestry and fishing	Střední Čechy	1995	86.21
Annual	Total economy	Million euro	Agriculture, forestry and fishing	Jihozápad	1995	125.69
Annual	Total economy	Million euro	Agriculture, forestry and fishing	Severozápad	1995	37.04
Annual	Total economy	Million euro	Agriculture, forestry and fishing	Severovýchod	1995	115.95


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

Share link

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