Baselight
Sign In

Multi-yearly Enterprise Statistics - Subcontracting By Size Class (NACE Rev. 1.1, C-F) (2002-2007)

Eurostat code: sbs_is_2k_sub02 ยท (2002 - 2007)

@eurostat.sbs_is_2k_sub02

Multi-yearly Enterprise Statistics - Subcontracting By Size Class (NACE Rev. 1.1, C-F) (2002-2007) - Unpivoted
@eurostat.sbs_is_2k_sub02.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.

  • 59.15 KB
  • 22162 rows
  • 7 columns
freq

Freq

nace_r1

Nace R1

indic_sb

Indic Sb

size_emp

Size Emp

geo

Geo

time_period

Time Period

value

Value

AnnualMining and quarryingPayments to sub-contractors - million euroFrom 1 to 9 persons employedAustria20022
AnnualMining and quarryingPayments to sub-contractors - million euroFrom 1 to 9 persons employedBulgaria20020.2
AnnualMining and quarryingPayments to sub-contractors - million euroFrom 1 to 9 persons employedDenmark20021.9
AnnualMining and quarryingPayments to sub-contractors - million euroFrom 1 to 9 persons employedEstonia2002
AnnualMining and quarryingPayments to sub-contractors - million euroFrom 1 to 9 persons employedSpain20024
AnnualMining and quarryingPayments to sub-contractors - million euroFrom 1 to 9 persons employedFrance20027.9
AnnualMining and quarryingPayments to sub-contractors - million euroFrom 1 to 9 persons employedHungary2002
AnnualMining and quarryingPayments to sub-contractors - million euroFrom 1 to 9 persons employedLatvia2002
AnnualMining and quarryingPayments to sub-contractors - million euroFrom 1 to 9 persons employedMalta20020.3
AnnualMining and quarryingPayments to sub-contractors - million euroFrom 1 to 9 persons employedPortugal20024.4

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