Info
Last observation: 2025 (N = 14,095)
First observation: 1960 (N = 14,095)
Last data update: 14 aoû 2026, 20:25. Last compile: 14 aoû 2026, 21:41
Nobs - Javascript
Code
TG.VAL.TOTL.GD.ZS |>
left_join(iso2c, by = "iso2c") |>
group_by(iso2c, Iso2c) |>
mutate(value = round(value, 2)) |>
summarise(Nobs = n(),
`Year 1` = first(year),
`NX 1 (%)` = first(value),
`Year 2` = last(year),
`NX 2 (%)` = last(value)) |>
arrange(-Nobs) |>
mutate(Flag = gsub(" ", "-", str_to_lower(Iso2c)),
Flag = paste0('<img src="../../bib/flags/vsmall/', Flag, '.png" alt="Flag">')) |>
select(Flag, everything()) %>%
{if (is_html_output()) datatable(., filter = 'top', rownames = F, escape = F) else .}
France, Germany, Italy
Code
TG.VAL.TOTL.GD.ZS |>
filter(iso2c %in% c("IT", "FR", "DE")) |>
left_join(iso2c, by = "iso2c") |>
year_to_date() |>
left_join(colors, by = c("Iso2c" = "country")) |>
mutate(value = value/100) |>
ggplot() + geom_line(aes(x = date, y = value, color = color)) +
xlab("") + ylab("Merchandise trade (% of GDP)") +
theme_minimal() + scale_color_identity() + add_flags +
scale_x_date(breaks = seq(1950, 2100, 5) |> paste0("-01-01") |> as.Date(),
labels = date_format("%Y")) +
scale_y_continuous(breaks = 0.01*seq(-60, 120, 5),
labels = scales::percent_format(accuracy = 1))
Germany, France, Switzerland
Code
TG.VAL.TOTL.GD.ZS |>
left_join(iso2c, by = "iso2c") |>
year_to_date() |>
filter(iso2c %in% c("CH", "FR", "DE"),
date >= as.Date("1970-01-01")) |>
left_join(colors, by = c("Iso2c" = "country")) |>
mutate(value = value/100) |>
ggplot() + geom_line(aes(x = date, y = value, color = color)) +
xlab("") + ylab("Merchandise trade (% of GDP)") +
theme_minimal() + scale_color_identity() + add_flags +
scale_x_date(breaks = seq(1950, 2100, 5) |> paste0("-01-01") |> as.Date(),
labels = date_format("%Y")) +
scale_y_continuous(breaks = 0.01*seq(-60, 150, 5),
labels = scales::percent_format(accuracy = 1))
France, Germany, United States, World, China
Code
TG.VAL.TOTL.GD.ZS |>
filter(iso2c %in% c("US", "FR", "DE", "CN", "1W")) |>
left_join(iso2c, by = "iso2c") |>
year_to_date() |>
left_join(colors, by = c("Iso2c" = "country")) |>
mutate(value = value/100,
color = ifelse(iso2c == "DE", color2, color)) |>
ggplot() + geom_line(aes(x = date, y = value, color = color)) +
xlab("") + ylab("Merchandise trade (% of GDP)") +
theme_minimal() + scale_color_identity() + add_flags +
scale_x_date(breaks = seq(1950, 2100, 5) |> paste0("-01-01") |> as.Date(),
labels = date_format("%Y")) +
scale_y_continuous(breaks = 0.01*seq(-60, 120, 5),
labels = scales::percent_format(accuracy = 1))