Baselight

Multi-yearly Enterprise Statistics - Subcontracting For Industry And Construction (NACE Rev. 2, B-F) (2008-2020)

Eurostat code: sbs_is_subc_r2 · (2008 - 2020)

@eurostat.sbs_is_subc_r2

Loading...
Loading...

About this Dataset

Multi-yearly Enterprise Statistics - Subcontracting For Industry And Construction (NACE Rev. 2, B-F) (2008-2020)

This Eurostat dataset contains data on multi-yearly enterprise statistics - subcontracting for industry and construction (nace rev. 2, b-f) (2008-2020), 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: 2024-03-01T23:00:00+0100

Tables

Multi-yearly Enterprise Statistics - Subcontracting For Industry And Construction (NACE Rev. 2, B-F) (2008-2020) - Raw

@eurostat.sbs_is_subc_r2.raw
  • 138.16 KB
  • 14102 rows
  • 9 columns
Loading...

CREATE TABLE raw (
  "freq" VARCHAR,
  "nace_r2" VARCHAR,
  "indic_sb" VARCHAR,
  "geo" VARCHAR,
  "n_2008" DOUBLE,
  "n_2011" DOUBLE,
  "n_2014" DOUBLE,
  "n_2017" DOUBLE,
  "n_2020" DOUBLE
);

Multi-yearly Enterprise Statistics - Subcontracting For Industry And Construction (NACE Rev. 2, B-F) (2008-2020) - Unpivoted

@eurostat.sbs_is_subc_r2.tidy
  • 137.74 KB
  • 48828 rows
  • 6 columns
Loading...

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

Share link

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