Baselight
Sign In

Capital Stocks By Sector And Detailed Asset Type

Eurostat code: nama_10_nfa_bs ยท (1975 - 2023)

@eurostat.nama_10_nfa_bs

Capital Stocks By Sector And Detailed Asset Type - Unpivoted
@eurostat.nama_10_nfa_bs.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.

  • 517.23 KB
  • 105474 rows
  • 7 columns
freq

Freq

unit

Unit

sector

Sector

asset10

Asset10

geo

Geo

time_period

Time Period

value

Value

AnnualCurrent prices, million units of national currencyTotal economyDwellings (net)Portugal19754634.8
AnnualCurrent prices, million units of national currencyTotal economyOther buildings and structures (net)Portugal19752441
AnnualCurrent prices, million units of national currencyTotal economyCultivated biological resources (net)Portugal1975240.1
AnnualCurrent prices, million units of national currencyTotal economyIntellectual property products (net)Portugal197541.2
AnnualCurrent prices, million units of national currencyTotal economyMachinery and equipment and weapons systems (net)Portugal19751134.1
AnnualCurrent prices, million units of national currencyTotal economyTotal fixed assets (net)Portugal19758491.1
AnnualCurrent prices, million euroTotal economyDwellings (net)Portugal197635344.7
AnnualCurrent prices, million euroTotal economyOther buildings and structures (net)Portugal197618763.4
AnnualCurrent prices, million euroTotal economyCultivated biological resources (net)Portugal19761619.1
AnnualCurrent prices, million euroTotal economyIntellectual property products (net)Portugal1976276.7

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

Share link

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