Capital Formation By Industry (NACE Rev.2) And Detailed Asset Type

Eurostat code: nama_10_a64_p5 · (1975 - 2024)

@eurostat.nama_10_a64_p5

Table List

2 tables(117.36 MB)

Capital Formation By Industry (NACE Rev.2) And Detailed Asset Type - Raw

Capital Formation By Industry (NACE Rev.2) And Detailed Asset Type - Unpivoted

Capital Formation By Industry (NACE Rev.2) And Detailed Asset Type - Unpivoted

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

59.83 MB
17277499 rows
8 columns

freq Freq	unit Unit	nace_r2 Nace R2	asset10 Asset10	na_item Na Item	geo Geo	time_period Time Period	value Value
Annual	Chain linked volumes (2005), million euro	Agriculture, forestry and fishing	Dwellings (gross)	Gross fixed capital formation	Norway	1975
Annual	Chain linked volumes (2005), million euro	Agriculture, forestry and fishing	Other buildings and structures (gross)	Gross fixed capital formation	Denmark	1975	958.8
Annual	Chain linked volumes (2005), million euro	Agriculture, forestry and fishing	Other buildings and structures (gross)	Gross fixed capital formation	Norway	1975	774.8
Annual	Chain linked volumes (2005), million euro	Agriculture, forestry and fishing	Transport equipment (gross)	Gross fixed capital formation	Denmark	1975	117.6
Annual	Chain linked volumes (2005), million euro	Agriculture, forestry and fishing	Transport equipment (gross)	Gross fixed capital formation	Norway	1975	213.8
Annual	Chain linked volumes (2005), million euro	Agriculture, forestry and fishing	Computer hardware (gross)	Gross fixed capital formation	Norway	1975
Annual	Chain linked volumes (2005), million euro	Agriculture, forestry and fishing	Telecommunications equipment (gross)	Gross fixed capital formation	Norway	1975
Annual	Chain linked volumes (2005), million euro	Agriculture, forestry and fishing	ICT equipment (gross)	Gross fixed capital formation	Norway	1975
Annual	Chain linked volumes (2005), million euro	Agriculture, forestry and fishing	Cultivated biological resources (gross)	Gross fixed capital formation	Denmark	1975	-68.3
Annual	Chain linked volumes (2005), million euro	Agriculture, forestry and fishing	Cultivated biological resources (gross)	Gross fixed capital formation	Norway	1975	-0.7


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "nace_r2" VARCHAR,
  "asset10" VARCHAR,
  "na_item" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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