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 205.0628 187.3639
SITC7 Machinery and transport equipment 98.6763 96.6487
SITC6_8 Other manufactured goods 56.4735 57.4956
SITC5 Chemicals and related products, n.e.s. 49.9130 33.2196
SITC8 Miscellaneous manufactured articles 29.9541 33.6716
SITC6 Manufactured goods classified chiefly by material 26.5194 23.8240
SITC0_1 Food, drinks and tobacco 20.5907 17.4942
SITC0 Food and live animals 16.7474 15.7883
SITC3 Mineral fuels, lubricants and related materials 15.0460 40.6814
SITC9 Commodities and transactions not classified elsewhere in the SITC 9.7974 8.1778
SITC2_4 Raw materials 6.7040 10.3103
SITC2 Crude materials, inedible, except fuels 5.6105 8.8531
SITC1 Beverages and tobacco 3.8434 1.7059
SITC4 Animal and vegetable oils, fats and waxes 1.0936 1.4572