Baselight

Capital Stock Based Productivity Indicators By Industry (NACE Rev.2)

Eurostat code: nama_10_cp_a21 ยท (1975 - 2023)

@eurostat.nama_10_cp_a21

Capital Stock Based Productivity Indicators By Industry (NACE Rev.2) - Unpivoted
@eurostat.nama_10_cp_a21.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.

  • 1.22 MB
  • 351936 rows
  • 8 columns
freq

Freq

asset10

Asset10

nace_r2

Nace R2

na_item

Na Item

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualICT equipment (net)Total - all NACE activitiesNet fixed assets per employed personIndex, 2015=100Denmark19750.679
AnnualICT equipment (net)Total - all NACE activitiesNet fixed assets per employed personIndex, 2015=100Norway197512.148
AnnualICT equipment (net)Total - all NACE activitiesNet fixed assets per employed personIndex, 2020=100Denmark19750.541
AnnualICT equipment (net)Total - all NACE activitiesNet fixed assets per employed personIndex, 2020=100Norway197511.299
AnnualICT equipment (net)Total - all NACE activitiesNet fixed assets per employed personPercentage change (t/t-3)Denmark197560.4
AnnualICT equipment (net)Total - all NACE activitiesNet fixed assets per employed personPercentage change (t/t-3)Norway197568.2
AnnualICT equipment (net)Total - all NACE activitiesNet fixed assets per employed personPercentage change (t/t-5)Denmark1975122.5
AnnualICT equipment (net)Total - all NACE activitiesNet fixed assets per employed personPercentage change (t/t-5)Norway1975109.4
AnnualICT equipment (net)Total - all NACE activitiesNet fixed assets per employed personPercentage change on previous periodDenmark197516.6
AnnualICT equipment (net)Total - all NACE activitiesNet fixed assets per employed personPercentage change on previous periodNorway197522.4

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

Share link

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