Air emissions accounts for greenhouse gases by NACE Rev. 2 activity - quarterly data - env_ac_aigg_q

Data - Eurostat

Structure

Greenhouse Gas Emissions

France, Germany, Italy, Spain

Code
env_ac_aigg_q |>
  filter(geo %in% c("FR", "DE", "IT", "ES"),
         nace_r2 == "TOTAL_HH",
         unit == "THS_T",
         s_adj == "SA") |>
  quarter_to_date() |>
  add_flag_color("Geo") |>
  mutate(values = values/1000) |>
  ggplot() + geom_line(aes(x = date, y = values, color = color)) +
  theme_minimal() + scale_color_identity() + add_flags +
  scale_x_date(breaks = as.Date(paste0(seq(2010, 2100, 2), "-01-01")),
               labels = date_format("%Y")) +
  xlab("") + ylab("Greenhouse gas emissions (Mt CO2 eq., SA)")

EU27: By Activity

Code
env_ac_aigg_q |>
  filter(geo == "EU27_2020",
         nace_r2 %in% c("A", "C", "D", "H"),
         unit == "THS_T",
         s_adj == "SA") |>
  quarter_to_date() |>
  mutate(values = values/1000) |>
  ggplot() + geom_line(aes(x = date, y = values, color = Nace_r2)) +
  theme_minimal() +
  scale_x_date(breaks = as.Date(paste0(seq(2010, 2100, 2), "-01-01")),
               labels = date_format("%Y")) +
  theme(legend.position = "right") +
  xlab("") + ylab("Greenhouse gas emissions (Mt CO2 eq., SA)")

Latest Quarter by Country

Code
latest_q <- env_ac_aigg_q |>
  filter(nace_r2 == "TOTAL_HH", unit == "THS_T", s_adj == "SA", !is.na(values)) |>
  summarise(m = max(time)) |>
  pull(m)

env_ac_aigg_q |>
  filter(nace_r2 == "TOTAL_HH",
         unit %in% c("THS_T", "T_HAB"),
         s_adj == "SA",
         time == latest_q) |>
  mutate(values = ifelse(unit == "THS_T", values/1000, values),
         unit_label = ifelse(unit == "THS_T", "Mt CO2 eq.", "Tonnes per capita")) |>
  select(Geo, unit_label, values) |>
  spread(unit_label, values) |>
  arrange(desc(`Mt CO2 eq.`)) |>
  print_table_conditional()
Geo Mt CO2 eq. Tonnes per capita
European Union - 27 countries (from 2020) 833.173491 1.841
Germany 171.097416 2.053
France 99.934663 1.445
Italy 94.617409 1.605
Poland 91.486359 2.457
Spain 73.080685 1.469
Netherlands 41.916850 2.311
Romania 30.502900 1.602
Belgium 26.472200 2.217
Czechia 24.168991 2.217
Denmark 21.958786 3.641
Greece 20.114481 1.907
Ireland 18.316944 3.315
Austria 17.735826 1.924
Hungary 16.455297 1.738
Sweden 13.751155 1.286
Portugal 13.641767 1.254
Bulgaria 11.866390 1.853
Finland 9.806311 1.734
Slovakia 8.261051 1.519
Lithuania 6.136120 2.127
Croatia 5.916483 1.519
Slovenia 3.661448 1.714
Latvia 2.648379 1.443
Malta 2.590215 4.350
Estonia 2.378246 1.748
Luxembourg 2.368357 3.408
Cyprus 2.288763 2.288