Table 2.6. Personal Income and Its Disposition, Monthly (M) - T20600

Data - BEA

Author

François Geerolf

Last observation: août 2022 (N = 40)

First observation: janv. 1959 (N = 38)

Last data update: 25 juil. 2026, 12:36

Last compile: 05 sept. 2026, 22:42

Layout

  • NIPA Website. html

Ex 1: Rental income of persons with capital consumption adjustment

Code 
T20600_M |>
  month_to_date() |>
  arrange(date, LineNumber) |>
  group_by(date) |>
  mutate(value = DataValue/DataValue[LineNumber == 27]) |>
  filter(LineNumber %in% c(12, 13, 14, 15)) |>
  ggplot() + theme_minimal() + 
  geom_line(aes(x = date, y = value, color = LineDescription, linetype = LineDescription)) +
  theme(legend.title = element_blank(),
        legend.position = c(0.3, 0.9)) +
  geom_rect(data = nber_recessions |>
              filter(Peak > as.Date("1959-01-01")), 
            aes(xmin = Peak, xmax = Trough, ymin = -Inf, ymax = +Inf), 
            fill = 'grey', alpha = 0.5) + 
  scale_x_date(breaks = seq(1930, 2100, 5) |> paste0("-01-01") |> as.Date(),
               labels = date_format("%Y")) +
  ylab("% of Disposable personal income") + xlab("") +
  scale_color_manual(values = viridis(5)[1:4]) +
  scale_y_continuous(breaks = 0.01*seq(0, 25, 1),
                     labels = scales::percent_format(accuracy = 1))

Ex 2: Compensation of Employees

Code 
T20600_M |>
  month_to_date() |>
  group_by(date) |>
  mutate(value = DataValue/DataValue[LineNumber == 27]) |>
  filter(LineNumber %in% c(2, 3, 6, 9)) |>
  ggplot() + theme_minimal() + 
  geom_line(aes(x = date, y = value, color = LineDescription, linetype = LineDescription)) +
  theme(legend.title = element_blank(),
        legend.position = c(0.45, 0.5)) +
  geom_rect(data = nber_recessions |>
              filter(Peak > as.Date("1959-01-01")), 
            aes(xmin = Peak, xmax = Trough, ymin = -Inf, ymax = +Inf), 
            fill = 'grey', alpha = 0.5) + 
  scale_x_date(breaks = seq(1930, 2100, 5) |> paste0("-01-01") |> as.Date(),
               labels = date_format("%Y")) +
  ylab("% of Disposable personal income") + xlab("") +
  scale_color_manual(values = viridis(5)[1:4]) +
  scale_y_continuous(breaks = 0.01*seq(0, 90, 10),
                     labels = scales::percent_format(accuracy = 1))

Ex 3: Government

Code 
T20600_M |>
  month_to_date() |>
  group_by(date) |>
  mutate(value = DataValue/DataValue[LineNumber == 27]) |>
  filter(LineNumber %in% c(25, 17, 26)) |>
  ggplot() + theme_minimal() + 
  geom_line(aes(x = date, y = value, color = LineDescription, linetype = LineDescription)) +
  theme(legend.title = element_blank(),
        legend.position = c(0.35, 0.9)) +
  geom_rect(data = nber_recessions |>
              filter(Peak > as.Date("1959-01-01")), 
            aes(xmin = Peak, xmax = Trough, ymin = -Inf, ymax = +Inf), 
            fill = 'grey', alpha = 0.5) + 
  scale_x_date(breaks = seq(1930, 2100, 5) |> paste0("-01-01") |> as.Date(),
               labels = date_format("%Y")) +
  ylab("% of Disposable personal income") + xlab("") +
  scale_color_manual(values = viridis(5)[1:4]) +
  scale_y_continuous(breaks = 0.01*seq(0, 90, 2),
                     labels = scales::percent_format(accuracy = 1))

Ex 4: Government social benefits to persons

Code 
T20600_M |>
  month_to_date() |>
  group_by(date) |>
  mutate(value = DataValue/DataValue[LineNumber == 27]) |>
  filter(LineNumber %in% c(18:23)) |>
  ggplot() + theme_minimal() + 
  geom_line(aes(x = date, y = value, color = LineDescription, linetype = LineDescription)) +
  theme(legend.title = element_blank(),
        legend.position = c(0.15, 0.8)) +
  geom_rect(data = nber_recessions |>
              filter(Peak > as.Date("1959-01-01")), 
            aes(xmin = Peak, xmax = Trough, ymin = -Inf, ymax = +Inf), 
            fill = 'grey', alpha = 0.5) + 
  scale_x_date(breaks = seq(1930, 2100, 5) |> paste0("-01-01") |> as.Date(),
               limits = c(1959, 2022) |> paste0("-01-01") |> as.Date(),
               labels = date_format("%Y")) +
  ylab("% of Disposable personal income") + xlab("") +
  scale_color_manual(values = viridis(7)[1:6]) +
  scale_y_continuous(breaks = 0.01*seq(0, 90, 1),
                     labels = scales::percent_format(accuracy = 1))