Euro area19 trade by SITC product group since 1999 - ext_st_easitc

Data - Eurostat

Structure

Euro Area Trade with Extra-EA Partners

Exports vs. Imports

Code
ext_st_easitc |>
  filter(partner == "EXT_EA21",
         sitc06 == "TOTAL",
         stk_flow %in% c("EXP", "IMP"),
         indic_et == "TRD_VAL_SCA") |>
  month_to_date() |>
  mutate(values = values/1000) |>
  ggplot() + geom_line(aes(x = date, y = values, color = Stk_flow)) +
  theme_minimal() +
  scale_x_date(breaks = as.Date(paste0(seq(2000, 2100, 2), "-01-01")),
               labels = date_format("%Y")) +
  theme(legend.position = c(0.2, 0.85),
        legend.title = element_blank()) +
  xlab("") + ylab("Euro area trade with extra-EA21 (Bn€, s.a.)")

Trade Balance

Code
ext_st_easitc |>
  filter(partner == "EXT_EA21",
         sitc06 == "TOTAL",
         stk_flow == "BAL_RT",
         indic_et == "TRD_VAL_SCA") |>
  month_to_date() |>
  mutate(values = values/1000) |>
  ggplot() + geom_line(aes(x = date, y = values)) +
  theme_minimal() +
  scale_x_date(breaks = as.Date(paste0(seq(2000, 2100, 2), "-01-01")),
               labels = date_format("%Y")) +
  xlab("") + ylab("Euro area trade balance with extra-EA21 (Bn€, s.a.)") +
  geom_hline(yintercept = 0, linetype = "dashed", color = "black")

Latest Month by Product Group

Code
latest_m <- ext_st_easitc |>
  filter(partner == "EXT_EA21",
         stk_flow == "EXP",
         indic_et == "TRD_VAL_SCA",
         sitc06 == "TOTAL",
         !is.na(values)) |>
  summarise(m = max(time)) |>
  pull(m)

ext_st_easitc |>
  filter(partner == "EXT_EA21",
         indic_et == "TRD_VAL_SCA",
         stk_flow %in% c("EXP", "IMP"),
         sitc06 != "TOTAL",
         time == latest_m) |>
  mutate(values = values/1000) |>
  select(sitc06, Sitc06, Stk_flow, values) |>
  spread(Stk_flow, values) |>
  arrange(-Exports) |>
  print_table_conditional()
sitc06 Sitc06 Exports Imports
SITC5-8 Manufactured goods 210.2248 184.8831
SITC7 Machinery and transport equipment 99.7734 93.1641
SITC6_8 Other manufactured goods 56.5324 56.9454
SITC5 Chemicals and related products, n.e.s. 53.9190 34.7736
SITC8 Miscellaneous manufactured articles 29.9881 33.7276
SITC6 Manufactured goods classified chiefly by material 26.5443 23.2178
SITC0_1 Food, drinks and tobacco 20.6148 17.4227
SITC0 Food and live animals 16.7650 15.7072
SITC3 Mineral fuels, lubricants and related materials 14.0182 37.5499
SITC9 Commodities and transactions not classified elsewhere in the SITC 8.7164 6.6989
SITC2_4 Raw materials 7.1773 9.1659
SITC2 Crude materials, inedible, except fuels 6.1160 7.4651
SITC1 Beverages and tobacco 3.8498 1.7155
SITC4 Animal and vegetable oils, fats and waxes 1.0612 1.7008