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

About this Dataset

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

This Eurostat dataset contains data on capital stock based productivity indicators by industry (nace rev.2), as collected and published by the Statistical Office of the European Union.

Tables included:

raw: Original table as downloaded from Eurostat.
tidy: A cleaned and transformed version of the raw table, where time period values appear as rows instead of columns (unpivoted format).

Last updated: 2025-06-04T23:00:00+0200

Tables

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

@eurostat.nama_10_cp_a21.raw

1.44 MB
13254 rows
55 columns


CREATE TABLE raw (
  "freq" VARCHAR,
  "asset10" VARCHAR,
  "nace_r2" VARCHAR,
  "na_item" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_1975" DOUBLE,
  "n_1976" DOUBLE,
  "n_1977" DOUBLE,
  "n_1978" DOUBLE,
  "n_1979" DOUBLE,
  "n_1980" DOUBLE,
  "n_1981" DOUBLE,
  "n_1982" DOUBLE,
  "n_1983" DOUBLE,
  "n_1984" DOUBLE,
  "n_1985" DOUBLE,
  "n_1986" DOUBLE,
  "n_1987" DOUBLE,
  "n_1988" DOUBLE,
  "n_1989" DOUBLE,
  "n_1990" DOUBLE,
  "n_1991" DOUBLE,
  "n_1992" DOUBLE,
  "n_1993" DOUBLE,
  "n_1994" DOUBLE,
  "n_1995" DOUBLE,
  "n_1996" DOUBLE,
  "n_1997" DOUBLE,
  "n_1998" DOUBLE,
  "n_1999" DOUBLE,
  "n_2000" DOUBLE,
  "n_2001" DOUBLE,
  "n_2002" DOUBLE,
  "n_2003" DOUBLE,
  "n_2004" DOUBLE,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE,
  "n_2023" DOUBLE
);

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

@eurostat.nama_10_cp_a21.tidy

1.22 MB
351936 rows
8 columns


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