Baselight
Sign In

Enterprises By Extended Size Classes (including Small Mid Caps) And NACE Rev. 2 Activity

Eurostat code: sbs_ovw_smc ยท (2023 - 2023)

@eurostat.sbs_ovw_smc

Enterprises By Extended Size Classes (including Small Mid Caps) And NACE Rev. 2 Activity - Unpivoted
@eurostat.sbs_ovw_smc.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.

  • 32.1 KB
  • 4795 rows
  • 7 columns
freq

Freq

size_emp

Size Emp

nace_r2

Nace R2

indic_sbs

Indic Sbs

geo

Geo

time_period

Time Period

value

Value

AnnualFrom 0 to 9 persons employedMining and quarryingPersons employed per enterprise - numberBulgaria20233
AnnualFrom 0 to 9 persons employedMining and quarryingPersons employed per enterprise - numberGermany20234
AnnualFrom 0 to 9 persons employedMining and quarryingPersons employed per enterprise - numberFinland20231
AnnualFrom 0 to 9 persons employedMining and quarryingPersons employed per enterprise - numberCroatia20233
AnnualFrom 0 to 9 persons employedMining and quarryingPersons employed per enterprise - numberItaly20233
AnnualFrom 0 to 9 persons employedMining and quarryingPersons employed per enterprise - numberLithuania20233
AnnualFrom 0 to 9 persons employedMining and quarryingPersons employed per enterprise - numberLatvia20232
AnnualFrom 0 to 9 persons employedMining and quarryingPersons employed per enterprise - numberMalta20232
AnnualFrom 0 to 9 persons employedMining and quarryingPersons employed - numberBulgaria2023423
AnnualFrom 0 to 9 persons employedMining and quarryingPersons employed - numberGermany20233804

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

Share link

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