Structure of consumption expenditure by degree of urbanisation and COICOP consumption purpose - hbs_str_t226

Data - Eurostat

Author

François Geerolf

Info

Last observation: Annual: 2020 (N = 4,686)

First observation: Annual: 1988 (N = 1,449)

Last data update: 23 jul 2026, 22:17. Last compile: 24 jul 2026, 01:49

Structure

coicop

Food share by degree of urbanisation: France

Code

hbs_str_t226 %>%
  filter(geo == "FR",
         coicop == "CP01",
         deg_urb %in% c("DEG1", "DEG2", "DEG3")) %>%
  year_to_date %>%
  mutate(values = values/1000) %>%
  ggplot + geom_line(aes(x = date, y = values, color = Deg_urb)) +
  geom_point(aes(x = date, y = values, color = Deg_urb)) +
  theme_minimal() +
  scale_x_date(breaks = as.Date(paste0(seq(1985, 2100, 5), "-01-01")),
               labels = date_format("%Y")) +
  theme(legend.position = c(0.8, 0.85),
        legend.title = element_blank()) +
  xlab("") + ylab("Food and non-alcoholic beverages (share of expenditure)") +
  scale_y_continuous(labels = scales::percent_format(accuracy = 0.1))

Expenditure structure over time: Cities, France

Code

hbs_str_t226 %>%
  filter(geo == "FR",
         deg_urb == "DEG1",
         coicop %in% c("CP01", "CP04", "CP07", "CP09")) %>%
  year_to_date %>%
  mutate(values = values/1000) %>%
  ggplot + geom_line(aes(x = date, y = values, color = Coicop)) +
  geom_point(aes(x = date, y = values, color = Coicop)) +
  theme_minimal() +
  scale_x_date(breaks = as.Date(paste0(seq(1985, 2100, 5), "-01-01")),
               labels = date_format("%Y")) +
  theme(legend.position = "right") +
  xlab("") + ylab("Share of household expenditure, Cities (France)") +
  scale_y_continuous(labels = scales::percent_format(accuracy = 1))

2015

France, Germany, Italy

Code

hbs_str_t226 %>%
  filter(geo %in% c("FR", "DE", "IT"),
         time == "2015",
         coicop == "CP01",
         deg_urb %in% c("DEG1", "DEG2", "DEG3")) %>%
  mutate(values = round(values/1000, 3)) %>%
  select(Geo, Deg_urb, values) %>%
  spread(Deg_urb, values) %>%
  print_table_conditional()

Geo	Cities	Rural areas	Towns and suburbs
France	0.135	0.153	0.145
Germany	0.115	0.117	0.117
Italy	0.169	0.196	0.180