Employer Business Demography By Size Class And NACE Rev. 2 Activity
Eurostat code: bd_salge1_size ยท (2015 - 2022)
@eurostat.bd_salge1_size
Employer Business Demography By Size Class And NACE Rev. 2 Activity - Unpivoted
@eurostat.bd_salge1_size.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.
- 6.31 MB
- 2397575 rows
- 8 columns
freqFreq | ageAge | sizeclasSizeclas | indic_sbsIndic Sbs | nace_r2Nace R2 | geoGeo | time_periodTime Period | valueValue |
|---|---|---|---|---|---|---|---|
| Annual | Total | From 1 to 4 employees | 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 | Mining and quarrying | Finland | 2015 | 4.69 |
| Annual | Total | From 1 to 4 employees | 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 | Mining and quarrying | Iceland | 2015 | |
| Annual | Total | From 1 to 4 employees | 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 | Industry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations) | Finland | 2015 | 6.79 |
| Annual | Total | From 1 to 4 employees | 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 | Industry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations) | Iceland | 2015 | 14.13 |
| Annual | Total | From 1 to 4 employees | 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 | Manufacturing | Finland | 2015 | 5.35 |
| Annual | Total | From 1 to 4 employees | 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 | Manufacturing | Iceland | 2015 | 8.78 |
| Annual | Total | From 1 to 4 employees | 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 | Manufacture of food products; beverages and tobacco products | Finland | 2015 | 6.48 |
| Annual | Total | From 1 to 4 employees | 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 | Manufacture of food products; beverages and tobacco products | Iceland | 2015 | 12.61 |
| Annual | Total | From 1 to 4 employees | 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 | Manufacture of textiles and wearing apparel | Finland | 2015 | 5.96 |
| Annual | Total | From 1 to 4 employees | 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 | Manufacture of textiles and wearing apparel | Iceland | 2015 | 4.76 |
CREATE TABLE tidy (
"freq" VARCHAR,
"age" VARCHAR,
"sizeclas" VARCHAR,
"indic_sbs" VARCHAR,
"nace_r2" VARCHAR,
"geo" VARCHAR,
"time_period" VARCHAR,
"value" DOUBLE
);