Gross Fixed Capital Formation By Main Asset Type

Eurostat code: namq_10_an6 · (1978-Q1 - 2024-Q4)

@eurostat.namq_10_an6

Table List

2 tables(23.36 MB)

Gross Fixed Capital Formation By Main Asset Type - Raw

Gross Fixed Capital Formation By Main Asset Type - Unpivoted

Gross Fixed Capital Formation By Main Asset Type - Unpivoted

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

11.36 MB
2635419 rows
7 columns

freq Freq	unit Unit	asset10 Asset10	s_adj S Adj	geo Geo	time_period Time Period	value Value
Quarterly	Chain linked volumes (2005), million euro	Dwellings (gross)	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Norway	1978-Q1	1621.9
Quarterly	Chain linked volumes (2005), million euro	Dwellings (gross)	Seasonally and calendar adjusted data	Norway	1978-Q1	1790.2
Quarterly	Chain linked volumes (2005), million euro	Other buildings and structures (gross)	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Norway	1978-Q1	3031.9
Quarterly	Chain linked volumes (2005), million euro	Other buildings and structures (gross)	Seasonally and calendar adjusted data	Norway	1978-Q1	3308.7
Quarterly	Chain linked volumes (2005), million euro	Transport equipment (gross)	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Norway	1978-Q1	1667.4
Quarterly	Chain linked volumes (2005), million euro	Transport equipment (gross)	Seasonally and calendar adjusted data	Norway	1978-Q1	1636.7
Quarterly	Chain linked volumes (2005), million euro	Cultivated biological resources (gross)	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Norway	1978-Q1	0.5
Quarterly	Chain linked volumes (2005), million euro	Cultivated biological resources (gross)	Seasonally and calendar adjusted data	Norway	1978-Q1	0.5
Quarterly	Chain linked volumes (2005), million euro	Intellectual property products (gross)	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Norway	1978-Q1	365.7
Quarterly	Chain linked volumes (2005), million euro	Intellectual property products (gross)	Seasonally and calendar adjusted data	Norway	1978-Q1	376.5


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

Share link

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