WhyLine Denver
RTD Transit Analytics — ask anything, get real answers.
Free & open-source. Powered by DuckDB, BigQuery, dbt, and plain-English AI queries.
Launch DashboardWhat You Can Analyze
Bus Reliability (RTD Denver)
Which routes are most reliable? When do delays peak? Slice by route, stop, hour, and date.
Equity Gaps
Where do vulnerable communities bear the worst service? Access scores layered with Census data.
Safety Proximity
Which bus stops are near high-crash corridors? Identify safety risks along transit routes.
Weather Impacts
Quantify how snow, rain, and fog degrade on-time performance across Denver's RTD network.
Downloadable Data
Export any result as CSV or download the full DuckDB warehouse for offline analysis.
Natural Language to SQL
Type a question. Get trusted SQL auto-generated, validated, and ready to run against live data.
How It Works
- 1
Ask a question
Type anything: Worst 10 routes in snow last 30 days
- 2
Review the SQL
AI generates validated SQL. Edit it in the full CodeMirror editor.
- 3
Run and explore
Table, chart, or map. Then download as CSV or DuckDB warehouse.
FAQ
- What is WhyLine Denver?
- A free, open-source RTD Denver transit analytics app. Ask questions in plain English and get charts, maps, and downloadable data powered by DuckDB and BigQuery.
- Does it cover RTD Denver reliability?
- Yes. Explore on-time performance, delay trends by route, stop, hour of day, and long-term seasonal patterns.
- Can I analyze transit Denver equity and safety?
- Yes. Equity scores from Census ACS, crash-proximity from Denver Open Data, and weather from NOAA are all pre-joined and queryable.
- Is a login or API key required?
- No login required. The DuckDB engine runs on fast local data. BigQuery requires no user credentials — queries run through the backend.
Ready to explore Denver transit data?
Open WhyLine Denver