Environmental protection expenditure by size class (NACE Rev. 2, B-E) - sbs_env_sc_r2

Data - Eurostat

Author

François Geerolf

Info

LAST_DOWNLOAD

Code 
tibble(LAST_DOWNLOAD = as.Date(file.info("~/Library/Mobile\ Documents/com~apple~CloudDocs/website/data/eurostat/sbs_env_sc_r2.RData")$mtime)) %>%
  print_table_conditional()
LAST_DOWNLOAD
2024-11-21

LAST_COMPILE

LAST_COMPILE
2024-11-22

Last

Code 
sbs_env_sc_r2 %>%
  group_by(time) %>%
  summarise(Nobs = n()) %>%
  arrange(desc(time)) %>%
  head(1) %>%
  print_table_conditional()
time Nobs
2018 7504

nace_r2

Code 
sbs_env_sc_r2 %>%
  left_join(nace_r2, by = "nace_r2") %>%
  group_by(nace_r2, Nace_r2) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  print_table_conditional()

indic_sb

Code 
sbs_env_sc_r2 %>%
  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
V21110 Investment in equipment and plant for pollution control - million euro 38998
V21120 Investment in equipment and plant linked to cleaner technology ('integrated technology') - million euro 38682

time

Code 
sbs_env_sc_r2 %>%
  group_by(time) %>%
  summarise(Nobs = n()) %>%
  arrange(desc(time)) %>%
  print_table_conditional
time Nobs
2018 7504
2017 7264
2016 7319
2015 6992
2014 6998
2013 7202
2012 6962
2011 6964
2010 6780
2009 7011
2008 6684

geo

Code 
sbs_env_sc_r2 %>%
  left_join(geo, by = "geo") %>%
  group_by(geo, Geo) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  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 .}