Metro Madison ridership has not recovered from COVID

transit Madison (WI) time series chart

A quick time series chart of Metro ridership going back to 2002

Harald Kliems https://haraldkliems.netlify.app/
2022-03-27

A very quick chart: There are large differences between how transit agencies (in the US and in Europe) have managed to recover their pre-COVID ridership. Madison Metro’s general manager has always been very open about the fact that recovery would take several years: Metro is facing staffing shortages, which prevents them from expanding service. Funding right now is not a problem, but once pandemic recovery funds run out it will be. Finally, UW-Madison as well local and state government agency have been large drivers of ridership – it remains to be seen if a loss of peak commutes can be substituted with other transit trips.

But first we have to ask: What do the ridership numbers look like? The National Transit Database provides monthly ridership time series data all the way back to 2002. Here is a time series plot of that data:

Show code
library(readxl)
bus <- read_excel("data/January 2022 Ajusted Database.xlsx", sheet = 3)
library(tidyverse)
library(lubridate)
bus_long <- bus %>% 
  pivot_longer(cols = 10:250, names_to = "month", values_to = "value") %>% 
  mutate(date = my(month)) %>% 
  filter(Agency == "City of Madison" & Modes == "MB")

bus_long %>%
  ggplot(aes(date, value/1000)) +
  geom_line() +
  labs(title = "Monthly unlinked passenger trips for Madison Metro",
       subtitle = "In January 2022, ridership still was only 23% of that in January 2020",
       caption = "Data: National Transit Database Monthly Module Adjusted Data Release\nVisualization: Harald Kliems") +
  ylab("Trips (1000s)") +
   scale_x_date(
    NULL,
    breaks = scales::breaks_width("2 years"), 
    labels = scales::label_date("'%y")
  ) +
  scale_y_continuous(
     labels = scales::label_comma(),
     limits = c(0, 1600)) +
  geom_line(data = bus_long %>% filter(date == "2020-01-01" | date == "2022-01-01"), color = "red", size = 1.5, linetype = 2,
            alpha = 0.4) +
  geom_point(data = bus_long %>% filter(date == "2020-01-01" | date == "2022-01-01"), color = "red", size = 2.5) +
  theme_minimal()

We can see: While ridership is well above its worst pandemic lows, there still is a long way to go until we get back to pre-pandemic numbers. In January 2022, the latest month available, ridership was less than a quarter than what it was in January 2020.

Corrections

If you see mistakes or want to suggest changes, please create an issue on the source repository.

Reuse

Text and figures are licensed under Creative Commons Attribution CC BY-SA 4.0. Source code is available at https://github.com/vgXhc/quick-chart-metro-ridership, unless otherwise noted. The figures that have been reused from other sources don't fall under this license and can be recognized by a note in their caption: "Figure from ...".

Citation

For attribution, please cite this work as

Kliems (2022, March 27). Harald Kliems: Metro Madison ridership has not recovered from COVID. Retrieved from https://haraldkliems.netlify.app/posts/metro-madison-ridership-has-not-recovered-from-covid/

BibTeX citation

@misc{kliems2022metro,
  author = {Kliems, Harald},
  title = {Harald Kliems: Metro Madison ridership has not recovered from COVID},
  url = {https://haraldkliems.netlify.app/posts/metro-madison-ridership-has-not-recovered-from-covid/},
  year = {2022}
}