Employer Business Demography By NACE Rev. 2 Activity And Metropolitan Regions
Eurostat code: met_bd_slg1_nr ยท (2013 - 2022)
@eurostat.met_bd_slg1_nr
Employer Business Demography By NACE Rev. 2 Activity And Metropolitan Regions - Unpivoted
@eurostat.met_bd_slg1_nr.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.
- 557.61 KB
- 174404 rows
- 7 columns
freqFreq | unitUnit | indic_sbsIndic Sbs | nace_r2Nace R2 | metroregMetroreg | time_periodTime Period | valueValue |
|---|---|---|---|---|---|---|
| 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 | Industry (except construction) | Finland | 2013 | 1.17 |
| 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 | Industry (except construction) | Helsinki | 2013 | 1.1 |
| 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 | Industry (except construction) | Tampere | 2013 | 0.82 |
| 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 | Industry (except construction) | Turku | 2013 | 2.82 |
| 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 | Industry (except construction) | Non-metropolitan regions in Finland | 2013 | 0.97 |
| 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 | Industry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations) | Finland | 2013 | 2.09 |
| 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 | Industry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations) | Helsinki | 2013 | 1.68 |
| 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 | Industry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations) | Tampere | 2013 | 2.74 |
| 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 | Industry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations) | Turku | 2013 | 2.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 | Industry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations) | Non-metropolitan regions in Finland | 2013 | 2.46 |
CREATE TABLE tidy (
"freq" VARCHAR,
"unit" VARCHAR,
"indic_sbs" VARCHAR,
"nace_r2" VARCHAR,
"metroreg" VARCHAR,
"time_period" VARCHAR,
"value" DOUBLE
);