3.206 - Dépenses et recettes des collectivités locales (S13131) - t_3206

Données - INSEE

Structure

Dépenses et recettes (% du PIB)

Communes, départements, régions, groupements de communes.

Code
D |>
  filter(label %in% c("Total des dépenses", "Total des recettes")) |>
  left_join(pib, by = "year") |>
  ggplot() + theme_minimal() + xlab("") + ylab("% du PIB") +
  geom_line(aes(x = year, y = value / pib, color = label)) +
  scale_x_continuous(breaks = seq(1950, 2030, 10)) +
  scale_y_continuous(labels = percent_format(accuracy = 1)) +
  theme(legend.title = element_blank(), legend.position = "bottom")

Capacité (+) ou besoin (−) de financement

Code
D |>
  filter(grepl("^Capacité .+ financement", label)) |>
  left_join(pib, by = "year") |>
  ggplot() + theme_minimal() + xlab("") + ylab("% du PIB") +
  geom_hline(yintercept = 0, color = "grey60") +
  geom_col(aes(x = year, y = value / pib), fill = "#2b6cb0") +
  scale_x_continuous(breaks = seq(1950, 2030, 10)) +
  scale_y_continuous(labels = percent_format(accuracy = 1))

Structure des dépenses (% du PIB)

Code
D |>
  filter(code %in% c("D1", "D62", "D41", "P2", "D3", "P51g", "D73"), value != 0) |>
  distinct(code, year, .keep_all = TRUE) |>
  left_join(pib, by = "year") |>
  arrange(desc(code)) |> mutate(label = factor(label, levels = unique(label))) |>
  ggplot() + theme_minimal() + xlab("") + ylab("% du PIB") +
  geom_area(aes(x = year, y = value / pib, fill = label)) +
  scale_x_continuous(breaks = seq(1950, 2030, 10)) +
  scale_y_continuous(labels = percent_format(accuracy = 1)) +
  scale_fill_viridis_d() +
  theme(legend.title = element_blank(), legend.position = "bottom",
        legend.text = element_text(size = 7)) +
  guides(fill = guide_legend(ncol = 2))

Le compte en 2025

Code
D |> filter(year == last_y) |>
  transmute(Ligne = line, Poste = label, Code = code, `Mds €` = round(value, 1)) |>
  print_table_conditional()