Economic data in high-tech sectors by NACE Rev.1.1 activity - htec_eco_sbs

Data - Eurostat

Author

François Geerolf

indic_sb

Code 
htec_eco_sbs %>%
  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 2723
V12120 Production value - million euro 2694
V13110 Total purchases of goods and services - million euro 2646
V12150 Value added at factor cost - million euro 2641
V15110 Gross investment in tangible goods - million euro 2568
V12170 Gross operating surplus - million euro 2493
V15150 Gross investment in machinery and equipment - million euro 1406

nace_r1

Code 
htec_eco_sbs %>%
  left_join(nace_r1, by = "nace_r1") %>%
  group_by(nace_r1, Nace_r1) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  print_table_conditional
nace_r1 Nace_r1 Nobs
D Manufacturing 2219
D_LTC Low-technology manufacturing (DA to DE and DN) 2177
D_LTC_M Medium low-technology manufacturing (DF, DH to DJ and DM35.1) 2129
D_HTC High-technology manufacturing (DG24.4, DL30, DL32, DL33, DM35.3) 2096
HTC High-technology sectors (high-technology manufacturing and knowledge-intensive high-technology services) 1818
LKIS_MKT Less knowledge-intensive market services 1759
KIS_HTC Knowledge-intensive high-technology services (I64, K72 and K73) 1709
KIS_MKT_OTH Knowledge-intensive market services (except financial intermediation and high-technology services) 1703
D_HTC_M Medium high-technology manufacturing (DG (except DG24.4); DK, DL31, DM34, DM35.2, DM35.4, DM35.5) 1561

currency

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

geo

Code 
htec_eco_sbs %>%
  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_sbs %>%
  group_by(time) %>%
  summarise(Nobs = n()) %>%
  arrange(desc(time)) %>%
  print_table_conditional()
time Nobs
2007 1531
2006 1607
2005 1594
2004 1596
2003 1542
2002 1445
2001 1489
2000 1493
1999 1299
1998 1125
1997 1040
1996 877
1995 533