Balance of Payments statistics, national data - ST1

Data - ECB

Author

François Geerolf

Info

Last observation: Q: 2014-Q2 (N = 51)

First observation: Q: 1970-Q1 (N = 3)

Last data update: 17 aoû 2026, 03:31. Last compile: 18 aoû 2026, 01:49

Structure

Overview

Code

freq_dominant <- ST1 |>
  filter(!is.na(OBS_VALUE)) |>
  count(FREQ, sort = TRUE) |>
  slice(1) |>
  pull(FREQ)

convert_fn <- switch(freq_dominant,
  "A" = year_to_date, "Q" = quarter_to_date, "M" = month_to_date,
  "H" = semester_to_date, "W" = week_to_date, "D" = day_to_date, "B" = day_to_date,
  year_to_date)

ST1 |>
  filter(!is.na(OBS_VALUE), FREQ == freq_dominant) |>
  group_by(TIME_PERIOD) |>
  summarise(OBS_VALUE = mean(OBS_VALUE, na.rm = TRUE), .groups = "drop") |>
  convert_fn() |>
  ggplot() + theme_minimal() + xlab("") + ylab("Average value across all series") +
  geom_line(aes(x = date, y = OBS_VALUE)) +
  scale_x_date(date_labels = "%Y")