Baselight
Sign In

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

Eurostat code: nama_10_nfa_st ยท (1975 - 2024)

@eurostat.nama_10_nfa_st

Capital Stocks By Industry (NACE Rev.2) And Detailed Asset Type - Unpivoted
@eurostat.nama_10_nfa_st.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.

  • 31.12 MB
  • 8451236 rows
  • 7 columns
freq

Freq

unit

Unit

nace_r2

Nace R2

asset10

Asset10

geo

Geo

time_period

Time Period

value

Value

AnnualChain linked volumes (2015), million euroAgriculture, forestry and fishingOther buildings and structures (gross)Denmark197534067.8
AnnualChain linked volumes (2015), million euroAgriculture, forestry and fishingOther buildings and structures (net)Denmark197522082.5
AnnualChain linked volumes (2015), million euroAgriculture, forestry and fishingOther buildings and structures (net)Norway197515771.4
AnnualChain linked volumes (2015), million euroAgriculture, forestry and fishingTransport equipment (gross)Denmark19752140.7
AnnualChain linked volumes (2015), million euroAgriculture, forestry and fishingTransport equipment (net)Denmark1975735.5
AnnualChain linked volumes (2015), million euroAgriculture, forestry and fishingTransport equipment (net)Norway19753826
AnnualChain linked volumes (2015), million euroAgriculture, forestry and fishingCultivated biological resources (gross)Denmark19751365.6
AnnualChain linked volumes (2015), million euroAgriculture, forestry and fishingCultivated biological resources (net)Denmark19751515.7
AnnualChain linked volumes (2015), million euroAgriculture, forestry and fishingCultivated biological resources (net)Norway19751315.8
AnnualChain linked volumes (2015), million euroAgriculture, forestry and fishingResearch and development (gross)Denmark19755.2

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

Share link

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