Joe's RTD Data Sandbox

RTD publishes ridership data through an interactive PowerBI dashboard but does not offer a direct data download. The files below are compiled from that dashboard for the period January 2025 through September 2025, and were last updated Feb. 10, 2026. I plan to soon include the scripts used to extract these data from the dashboards, which require manual filtering of the dashboards but will otherwise extract the data for any given user-selected filter automatically. It is a sloppy, vibe-coded product and I still have some clean-up to do before they are publicly useable.

Data covers total monthly boardings by route and schedule day (Weekday, Saturday, and Sunday/holiday) for January - September 2025. Keep in mind that these numbers are boardings, otherwise known as 'Unlinked Passenger Trips'. As such, this is the raw number of times that a person got onto a vehicle, and is not representative of the number of unique passengers. That doesn't mean these data are not useful, just that we can't say how many different individuals use a route simply by the number of boardings. Please don't take this to mean that this form of transit ridership data is less accurate than other modes though; the most common metric used to measure vehicle traffic on a roadway, 'Average Annual Daily Traffic (AADT)' has the same flaw wherein it only measures the number of vehicles passing a certain point but does not know which ones are unique. Anyway, that's my soapbox. Feel free to use these data as you find useful and I will try to keep this page up to date as the RTD dashboards are modified. I'll also be adding to this page as I sort through more types of relevant data.