Last observation: Q2 2026 (N = 3330) · 2025 (N = 7196)
First observation: 1999 (N = 1090) · Q1 1999 (N = 1091)
Last data update: 04 oct. 2026, 22:41
Last compile: 09 oct. 2026, 22:07
bop_eu6_q |>
filter(freq == "Q",
geo == "EU27_2020",
bop_item == "CA",
stk_flow == "BAL",
partner == "EXT_EU27_2020",
sector10 == "S1",
sectpart == "S1",
s_adj == "SCA") |>
quarter_to_date() |>
mutate(values = values/1000) |>
ggplot() + geom_line(aes(x = date, y = values)) +
theme_minimal() +
scale_x_date(breaks = as.Date(paste0(seq(1999, 2100, 2), "-01-01")),
labels = date_format("%Y")) +
xlab("") + ylab("Current account balance, vs. Extra-EU27 (Bn€)") +
geom_hline(yintercept = 0, linetype = "dashed", color = "black")
bop_eu6_q |>
filter(freq == "Q",
geo == "EU27_2020",
bop_item == "CA",
stk_flow == "BAL",
partner %in% c("US", "UK", "CN_X_HK", "JP", "CH"),
sector10 == "S1",
sectpart == "S1",
s_adj == "NSA") |>
quarter_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(2015, 2100, 1), "-01-01")),
labels = date_format("%Y")) +
xlab("") + ylab("Current account balance (Bn€)") +
geom_hline(yintercept = 0, linetype = "dashed", color = "black")
latest_q <- bop_eu6_q |>
filter(freq == "Q",
geo == "EU27_2020",
bop_item == "CA",
stk_flow == "BAL",
partner %in% c("US", "UK", "CN_X_HK", "JP", "CH", "RU"),
sector10 == "S1",
sectpart == "S1",
s_adj == "NSA",
!is.na(values)) |>
summarise(m = max(time)) |>
pull(m)
bop_eu6_q |>
filter(freq == "Q",
geo == "EU27_2020",
bop_item %in% c("CA", "GS", "G", "S"),
stk_flow == "BAL",
partner %in% c("US", "UK", "CN_X_HK", "JP", "CH", "RU"),
sector10 == "S1",
sectpart == "S1",
s_adj == "NSA",
time == latest_q) |>
mutate(values = values/1000) |>
select(bop_item, Bop_item, Partner, values) |>
spread(Partner, values) |>
print_table_conditional()| bop_item | Bop_item | China except Hong Kong | Japan | Russia | Switzerland | United Kingdom | United States |
|---|---|---|---|---|---|---|---|
| CA | Current account | -66.6048 | 0.7931 | 1.8652 | 23.9109 | 89.8238 | -30.3224 |
| G | Goods | -78.2734 | 1.8934 | 1.4179 | 14.2572 | 53.8658 | 58.4762 |
| GS | Goods and services | -72.3331 | 7.3157 | 1.8403 | 32.6691 | 75.4016 | 9.2409 |
| S | Services | 5.9403 | 5.4223 | 0.4224 | 18.4119 | 21.5358 | -49.2354 |