EU27 (from 2020) trade by SITC product group - ext_st_eu27_2020sitc

Data - Eurostat

Author

François Geerolf

Info

Last observation: 2026M06 (N = 20724)

First observation: 2002M01 (N = 12107)

Last data update: 14 aoû 2026, 21:19. Last compile: 18 aoû 2026, 00:55

Structure

Trade Balance by Partner

US, China, UK, Japan

Code

ext_st_eu27_2020sitc |>
  filter(stk_flow == "BAL_RT",
         indic_et == "TRD_VAL",
         sitc06 == "TOTAL",
         partner %in% c("US", "CN_X_HK", "UK", "JP")) |>
  month_to_date() |>
  mutate(values = values/1000) |>
  ggplot() + geom_line(aes(x = date, y = values, color = Partner)) +
  theme_minimal() +
  scale_x_date(breaks = as.Date(paste0(seq(2002, 2100, 2), "-01-01")),
               labels = date_format("%Y")) +
  theme(legend.position = c(0.2, 0.2),
        legend.title = element_blank()) +
  xlab("") + ylab("EU27 trade balance (Bn€)") +
  geom_hline(yintercept = 0, linetype = "dashed", color = "black")

Extra-EU27 Exports by Product Group

Machinery, Chemicals, Manufactured Goods, Mineral Fuels

Code

ext_st_eu27_2020sitc |>
  filter(stk_flow == "EXP",
         indic_et == "TRD_VAL",
         partner == "EXT_EU27_2020",
         sitc06 %in% c("SITC7", "SITC6", "SITC5", "SITC3")) |>
  month_to_date() |>
  mutate(values = values/1000) |>
  ggplot() + geom_line(aes(x = date, y = values, color = Sitc06)) +
  theme_minimal() +
  scale_x_date(breaks = as.Date(paste0(seq(2002, 2100, 2), "-01-01")),
               labels = date_format("%Y")) +
  theme(legend.position = "right") +
  xlab("") + ylab("EU27 exports to Extra-EU27 (Bn€)")

Latest Month by Partner

Code

latest_m <- ext_st_eu27_2020sitc |>
  filter(stk_flow == "BAL_RT",
         indic_et == "TRD_VAL",
         sitc06 == "TOTAL",
         partner == "EXT_EU27_2020",
         !is.na(values)) |>
  summarise(m = max(time)) |>
  pull(m)

ext_st_eu27_2020sitc |>
  filter(stk_flow == "BAL_RT",
         indic_et == "TRD_VAL",
         sitc06 == "TOTAL",
         partner %in% c("EXT_EU27_2020", "US", "CN_X_HK", "UK", "JP"),
         time == latest_m) |>
  mutate(values = values/1000) |>
  select(partner, Partner, values) |>
  arrange(values) |>
  print_table_conditional()

partner	Partner	values
CN_X_HK	China except Hong Kong	-35.1159
JP	Japan	0.1165
EXT_EU27_2020	Extra-EU27 (from 2020)	3.8525
US	United States	11.2069
UK	United Kingdom	17.1199