Mean consumption expenditure per household by COICOP consumption purpose

Data - Eurostat

Info

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

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

Last data update: 23 jul 2026, 22:45. Last compile: 24 jul 2026, 01:47

Structure

freq

coicop

unit

geo

Food Expenditure per Household (PPS)

France, Germany, Italy, Spain

hbs_exp_t121 %>%
  filter(geo %in% c("FR", "DE", "IT", "ES"),
         coicop == "CP01") %>%
  year_to_date %>%

  left_join(colors, by = c("Geo" = "country")) %>%
  mutate(color = ifelse(geo == "DE", color2, color)) %>%
  ggplot + geom_line(aes(x = date, y = values, color = color)) +
  theme_minimal() + scale_color_identity() + add_4flags +
  scale_x_date(breaks = as.Date(paste0(seq(1985, 2100, 5), "-01-01")),
               labels = date_format("%Y")) +
  xlab("") + ylab("Food and non-alcoholic beverages (PPS per household)")

Household Budget Structure, Latest Year

latest_year <- hbs_exp_t121 %>%
  filter(coicop == "CP01", !is.na(values)) %>%
  summarise(m = max(time)) %>%
  pull(m)

hbs_exp_t121 %>%
  filter(time == latest_year,
         geo %in% c("FR", "DE", "IT", "ES", "NL"),
         coicop %in% c("CP01", "CP04", "CP07", "CP09")) %>%
  select(geo, Geo, coicop, values) %>%
  spread(coicop, values) %>%
  print_table_conditional()

geo	Geo	CP01	CP04	CP07	CP09
DE	Germany	3608	10087	4330	3467
ES	Spain	4695	9867	2811	1155
FR	France	4136	8365	3822	2240
IT	Italy	5538	10286	2576	1107
NL	Netherlands	3835	10156	3426	2549

Example

hbs_exp_t121 %>%
  filter(time == "2015",
         coicop %in% c("CP0722", "CP072"))

# # A tibble: 68 × 10
#    freq  Freq   coicop Coicop               unit  Unit  geo   Geo   time  values
#    <chr> <chr>  <chr>  <chr>                <chr> <chr> <chr> <chr> <chr>  <dbl>
#  1 A     Annual CP072  Operation of person… PPS_… Purc… AT    Aust… 2015    2613
#  2 A     Annual CP072  Operation of person… PPS_… Purc… BE    Belg… 2015    2368
#  3 A     Annual CP072  Operation of person… PPS_… Purc… BG    Bulg… 2015     646
#  4 A     Annual CP072  Operation of person… PPS_… Purc… CY    Cypr… 2015    2811
#  5 A     Annual CP072  Operation of person… PPS_… Purc… CZ    Czec… 2015    1060
#  6 A     Annual CP072  Operation of person… PPS_… Purc… DE    Germ… 2015    2128
#  7 A     Annual CP072  Operation of person… PPS_… Purc… DK    Denm… 2015    1838
#  8 A     Annual CP072  Operation of person… PPS_… Purc… EE    Esto… 2015     856
#  9 A     Annual CP072  Operation of person… PPS_… Purc… EL    Gree… 2015    1441
# 10 A     Annual CP072  Operation of person… PPS_… Purc… ES    Spain 2015    2147
# # ℹ 58 more rows