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 211.7752 191.0529
SITC7 Machinery and transport equipment 102.1434 98.9688
SITC6_8 Other manufactured goods 57.4287 60.1650
SITC5 Chemicals and related products, n.e.s. 52.2032 31.9191
SITC8 Miscellaneous manufactured articles 30.3564 34.8572
SITC6 Manufactured goods classified chiefly by material 27.0723 25.3078
SITC0_1 Food, drinks and tobacco 21.0302 18.3264
SITC0 Food and live animals 17.1157 16.6042
SITC3 Mineral fuels, lubricants and related materials 14.9602 47.5926
SITC9 Commodities and transactions not classified elsewhere in the SITC 7.3970 3.7379
SITC2_4 Raw materials 7.0764 10.2067
SITC2 Crude materials, inedible, except fuels 5.9699 8.5783
SITC1 Beverages and tobacco 3.9145 1.7222
SITC4 Animal and vegetable oils, fats and waxes 1.1065 1.6284