Baselight
Sign In

Services By Employment Size Class (NACE Rev. 1.1, H-K) (2002-2007)

Eurostat code: sbs_sc_1b_se02 ยท (2002 - 2007)

@eurostat.sbs_sc_1b_se02

Services By Employment Size Class (NACE Rev. 1.1, H-K) (2002-2007) - Unpivoted
@eurostat.sbs_sc_1b_se02.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.1 MB
  • 322869 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

AnnualHotels and restaurantsEnterprises - number1 person employedAustria200210565
AnnualHotels and restaurantsEnterprises - number1 person employedBulgaria200211930
AnnualHotels and restaurantsEnterprises - number1 person employedCyprus20022859
AnnualHotels and restaurantsEnterprises - number1 person employedCzechia200223363
AnnualHotels and restaurantsEnterprises - number1 person employedGermany200227704
AnnualHotels and restaurantsEnterprises - number1 person employedDenmark20026741
AnnualHotels and restaurantsEnterprises - number1 person employedEstonia2002254
AnnualHotels and restaurantsEnterprises - number1 person employedSpain2002115921
AnnualHotels and restaurantsEnterprises - number1 person employedFinland20026353
AnnualHotels and restaurantsEnterprises - number1 person employedFrance2002100695

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