Employer Business Demography By Size Class And Metropolitan Regions

Eurostat code: met_bd_slg1_sizer · (2013 - 2022)

@eurostat.met_bd_slg1_sizer

Table List

2 tables(440.23 KB)

Employer Business Demography By Size Class And Metropolitan Regions - Raw

Employer Business Demography By Size Class And Metropolitan Regions - Unpivoted

Employer Business Demography By Size Class And Metropolitan Regions - Unpivoted

@eurostat.met_bd_slg1_sizer.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.

203.81 KB
51009 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
Annual	Number	Employment share of enterprises having the first employee - persons employed in enterprises having the first employee divided by persons employed in enterprises having at least one employee - percentage	From 1 to 9 employees	Industry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations)	Finland	2013	5.54
Annual	Number	Employment share of enterprises having the first employee - persons employed in enterprises having the first employee divided by persons employed in enterprises having at least one employee - percentage	From 1 to 9 employees	Industry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations)	Helsinki	2013	6.04
Annual	Number	Employment share of enterprises having the first employee - persons employed in enterprises having the first employee divided by persons employed in enterprises having at least one employee - percentage	From 1 to 9 employees	Industry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations)	Tampere	2013	5.78
Annual	Number	Employment share of enterprises having the first employee - persons employed in enterprises having the first employee divided by persons employed in enterprises having at least one employee - percentage	From 1 to 9 employees	Industry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations)	Turku	2013	5.34
Annual	Number	Employment share of enterprises having the first employee - persons employed in enterprises having the first employee divided by persons employed in enterprises having at least one employee - percentage	From 1 to 9 employees	Industry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations)	Non-metropolitan regions in Finland	2013	5.18
Annual	Number	Employment share of enterprises having the first employee - persons employed in enterprises having the first employee divided by persons employed in enterprises having at least one employee - percentage	10 employees or more	Industry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations)	Finland	2013	1.03
Annual	Number	Employment share of enterprises having the first employee - persons employed in enterprises having the first employee divided by persons employed in enterprises having at least one employee - percentage	10 employees or more	Industry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations)	Helsinki	2013	0.87
Annual	Number	Employment share of enterprises having the first employee - persons employed in enterprises having the first employee divided by persons employed in enterprises having at least one employee - percentage	10 employees or more	Industry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations)	Tampere	2013	1.48
Annual	Number	Employment share of enterprises having the first employee - persons employed in enterprises having the first employee divided by persons employed in enterprises having at least one employee - percentage	10 employees or more	Industry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations)	Turku	2013	1.61
Annual	Number	Employment share of enterprises having the first employee - persons employed in enterprises having the first employee divided by persons employed in enterprises having at least one employee - percentage	10 employees or more	Industry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations)	Non-metropolitan regions in Finland	2013	1.11


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