Economic data in high-tech sectors by NACE Rev.2 activity - htec_eco_sbs2

Data - Eurostat

indic_sb

Code
htec_eco_sbs2 %>%
  left_join(indic_sb, by = "indic_sb") %>%
  group_by(indic_sb, Indic_sb) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  print_table_conditional
indic_sb Indic_sb Nobs
V12110 Turnover or gross premiums written - million euro 1947
V12120 Production value - million euro 1946
V13110 Total purchases of goods and services - million euro 1946
V13320 Wages and Salaries - million euro 1941
V12150 Value added at factor cost - million euro 1937
V12170 Gross operating surplus - million euro 1935
V13310 Personnel costs - million euro 1931
V13330 Social security costs - million euro 1931
V15110 Gross investment in tangible goods - million euro 1896
V91210 Average personnel costs (personnel costs per employee) - thousand euro 1832

nace_r2

Code
htec_eco_sbs2 %>%
  left_join(nace_r2, by = "nace_r2") %>%
  group_by(nace_r2, Nace_r2) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  print_table_conditional
nace_r2 Nace_r2 Nobs
C Manufacturing 2155
C_HTC_M Medium high-technology manufacturing 2155
C_HTC High-technology manufacturing 2154
C_LTC_M Medium low-technology manufacturing 2148
KIS_HTC Knowledge-intensive high-technology services 2143
HTC High-technology sectors (high-technology manufacturing and knowledge-intensive high-technology services) 2140
KIS_MKT_OTH Knowledge-intensive market services (except financial intermediation and high-technology services) 2140
C_LTC Low-technology manufacturing 2123
LKIS_MKT Less knowledge-intensive market services 2084

currency

Code
htec_eco_sbs2 %>%
  left_join(currency, by = "currency") %>%
  group_by(currency, Currency) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  print_table_conditional
currency Currency Nobs
MIO_EUR Million euro 19242

geo

Code
htec_eco_sbs2 %>%
  left_join(geo, by = "geo") %>%
  group_by(geo, Geo) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  mutate(Geo = ifelse(geo == "DE", "Germany", Geo)) %>%
  mutate(Flag = gsub(" ", "-", str_to_lower(Geo)),
         Flag = paste0('<img src="../../bib/flags/vsmall/', Flag, '.png" alt="Flag">')) %>%
  select(Flag, everything()) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F, escape = F) else .}

time

Code
htec_eco_sbs2 %>%
  group_by(time) %>%
  summarise(Nobs = n()) %>%
  arrange(desc(time)) %>%
  print_table_conditional()
time Nobs
2014 2609
2013 2707
2012 2761
2011 2920
2010 2760
2009 2853
2008 2632