Baselight

Business Demography By Size Class And Metropolitan Regions

Eurostat code: met_bd_size_r ยท (2013 - 2022)

@eurostat.met_bd_size_r

Business Demography By Size Class And Metropolitan Regions - Unpivoted
@eurostat.met_bd_size_r.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.

  • 238.83 KB
  • 65734 rows
  • 8 columns
freq

Freq

unit

Unit

indic_sbs

Indic Sbs

sizeclas

Sizeclas

nace_r2

Nace R2

metroreg

Metroreg

time_period

Time Period

value

Value

AnnualNumberEmployment share of enterprise births - persons employed in newly born enterprises divided by persons employed in active enterprises - percentageZeroIndustry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations)Finland20134.44
AnnualNumberEmployment share of enterprise births - persons employed in newly born enterprises divided by persons employed in active enterprises - percentageZeroIndustry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations)Helsinki20135.02
AnnualNumberEmployment share of enterprise births - persons employed in newly born enterprises divided by persons employed in active enterprises - percentageZeroIndustry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations)Tampere20134.81
AnnualNumberEmployment share of enterprise births - persons employed in newly born enterprises divided by persons employed in active enterprises - percentageZeroIndustry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations)Turku20134.12
AnnualNumberEmployment share of enterprise births - persons employed in newly born enterprises divided by persons employed in active enterprises - percentageZeroIndustry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations)Non-metropolitan regions in Finland20134.07
AnnualNumberEmployment share of enterprise births - persons employed in newly born enterprises divided by persons employed in active enterprises - percentageFrom 1 to 9 employeesIndustry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations)Finland20132.15
AnnualNumberEmployment share of enterprise births - persons employed in newly born enterprises divided by persons employed in active enterprises - percentageFrom 1 to 9 employeesIndustry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations)Helsinki20132.61
AnnualNumberEmployment share of enterprise births - persons employed in newly born enterprises divided by persons employed in active enterprises - percentageFrom 1 to 9 employeesIndustry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations)Tampere20132.03
AnnualNumberEmployment share of enterprise births - persons employed in newly born enterprises divided by persons employed in active enterprises - percentageFrom 1 to 9 employeesIndustry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations)Turku20131.98
AnnualNumberEmployment share of enterprise births - persons employed in newly born enterprises divided by persons employed in active enterprises - percentageFrom 1 to 9 employeesIndustry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations)Non-metropolitan regions in Finland20131.87

CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "indic_sbs" VARCHAR,
  "sizeclas" VARCHAR,
  "nace_r2" VARCHAR,
  "metroreg" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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