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

Eurostat code: nama_10_nfa_st$dv_647

@eurostat.nama_10_nfa_st_dv_647

Table List

2 tables(157.78 KB)

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

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

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

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

74 KB
11786 rows
7 columns

freq Freq	unit Unit	nace_r2 Nace R2	asset10 Asset10	geo Geo	time_period Time Period	value Value
Annual	Current replacement costs, million euro	Manufacture of computer, electronic and optical products	Computer hardware (gross)	Austria	2013	46.9
Annual	Current replacement costs, million euro	Manufacture of computer, electronic and optical products	Computer hardware (gross)	Belgium	2013	37.7
Annual	Current replacement costs, million euro	Manufacture of computer, electronic and optical products	Computer hardware (gross)	Czechia	2013	1992.1
Annual	Current replacement costs, million euro	Manufacture of computer, electronic and optical products	Computer hardware (gross)	Denmark	2013	107.4
Annual	Current replacement costs, million euro	Manufacture of computer, electronic and optical products	Computer hardware (gross)	Greece	2013	1.7
Annual	Current replacement costs, million euro	Manufacture of computer, electronic and optical products	Computer hardware (gross)	Finland	2013	99
Annual	Current replacement costs, million euro	Manufacture of computer, electronic and optical products	Computer hardware (gross)	France	2013	24
Annual	Current replacement costs, million euro	Manufacture of computer, electronic and optical products	Computer hardware (gross)	Italy	2013	317
Annual	Current replacement costs, million euro	Manufacture of computer, electronic and optical products	Computer hardware (gross)	Latvia	2013	1.1
Annual	Current replacement costs, million euro	Manufacture of computer, electronic and optical products	Computer hardware (gross)	Netherlands	2013	60


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.