{"results":[{"month":"2025-01","route_id":"R1","route_name":"Airport Line","route_type":"Rail","total_riders":"284710","weekday_avg":"9823","weekend_avg":"7241","on_time_pct":"91.2","avg_delay_minutes":"2.4","revenue_usd":"1138840","operating_cost_usd":"1892000"},{"month":"2025-01","route_id":"R2","route_name":"Media/Elwyn Line","route_type":"Rail","total_riders":"198340","weekday_avg":"6841","weekend_avg":"5124","on_time_pct":"88.7","avg_delay_minutes":"3.1","revenue_usd":"793360","operating_cost_usd":"1342000"},{"month":"2025-01","route_id":"R3","route_name":"Paoli/Thorndale Line","route_type":"Rail","total_riders":"312480","weekday_avg":"10782","weekend_avg":"8124","on_time_pct":"89.4","avg_delay_minutes":"2.8","revenue_usd":"1249920","operating_cost_usd":"1987000"},{"month":"2025-01","route_id":"MFL","route_name":"Market-Frankford Line","route_type":"Subway","total_riders":"1842300","weekday_avg":"63941","weekend_avg":"48234","on_time_pct":"94.1","avg_delay_minutes":"1.8","revenue_usd":"7369200","operating_cost_usd":"8241000"},{"month":"2025-01","route_id":"BSL","route_name":"Broad Street Line","route_type":"Subway","total_riders":"1124700","weekday_avg":"38912","weekend_avg":"29847","on_time_pct":"93.2","avg_delay_minutes":"2.1","revenue_usd":"4498800","operating_cost_usd":"5124000"},{"month":"2025-01","route_id":"BUS001","route_name":"Route 1 - Roosevelt Blvd","route_type":"Bus","total_riders":"87420","weekday_avg":"2841","weekend_avg":"2124","on_time_pct":"78.4","avg_delay_minutes":"6.2","revenue_usd":"349680","operating_cost_usd":"512000"},{"month":"2025-01","route_id":"BUS023","route_name":"Route 23 - Germantown Ave","route_type":"Bus","total_riders":"124380","weekday_avg":"4123","weekend_avg":"2987","on_time_pct":"76.8","avg_delay_minutes":"7.1","revenue_usd":"497520","operating_cost_usd":"698000"},{"month":"2025-01","route_id":"BUS042","route_name":"Route 42 - Chester Ave","route_type":"Bus","total_riders":"68940","weekday_avg":"2241","weekend_avg":"1724","on_time_pct":"79.2","avg_delay_minutes":"5.8","revenue_usd":"275760","operating_cost_usd":"412000"},{"month":"2025-02","route_id":"R1","route_name":"Airport Line","route_type":"Rail","total_riders":"261480","weekday_avg":"9412","weekend_avg":"6987","on_time_pct":"90.8","avg_delay_minutes":"2.6","revenue_usd":"1045920","operating_cost_usd":"1892000"},{"month":"2025-02","route_id":"R2","route_name":"Media/Elwyn Line","route_type":"Rail","total_riders":"182140","weekday_avg":"6512","weekend_avg":"4987","on_time_pct":"87.9","avg_delay_minutes":"3.3","revenue_usd":"728560","operating_cost_usd":"1342000"},{"month":"2025-02","route_id":"R3","route_name":"Paoli/Thorndale Line","route_type":"Rail","total_riders":"287240","weekday_avg":"10241","weekend_avg":"7841","on_time_pct":"88.9","avg_delay_minutes":"3.0","revenue_usd":"1148960","operating_cost_usd":"1987000"},{"month":"2025-02","route_id":"MFL","route_name":"Market-Frankford Line","route_type":"Subway","total_riders":"1698400","weekday_avg":"60712","weekend_avg":"44821","on_time_pct":"93.8","avg_delay_minutes":"1.9","revenue_usd":"6793600","operating_cost_usd":"8241000"},{"month":"2025-02","route_id":"BSL","route_name":"Broad Street Line","route_type":"Subway","total_riders":"1034200","weekday_avg":"37124","weekend_avg":"27412","on_time_pct":"92.7","avg_delay_minutes":"2.3","revenue_usd":"4136800","operating_cost_usd":"5124000"},{"month":"2025-02","route_id":"BUS001","route_name":"Route 1 - Roosevelt Blvd","route_type":"Bus","total_riders":"80340","weekday_avg":"2712","weekend_avg":"1987","on_time_pct":"77.9","avg_delay_minutes":"6.4","revenue_usd":"321360","operating_cost_usd":"512000"},{"month":"2025-02","route_id":"BUS023","route_name":"Route 23 - Germantown Ave","route_type":"Bus","total_riders":"114280","weekday_avg":"3987","weekend_avg":"2741","on_time_pct":"76.2","avg_delay_minutes":"7.3","revenue_usd":"457120","operating_cost_usd":"698000"},{"month":"2025-02","route_id":"BUS042","route_name":"Route 42 - Chester Ave","route_type":"Bus","total_riders":"63420","weekday_avg":"2124","weekend_avg":"1587","on_time_pct":"78.8","avg_delay_minutes":"6.1","revenue_usd":"253680","operating_cost_usd":"412000"},{"month":"2025-03","route_id":"R1","route_name":"Airport Line","route_type":"Rail","total_riders":"298420","weekday_avg":"10123","weekend_avg":"7512","on_time_pct":"91.7","avg_delay_minutes":"2.2","revenue_usd":"1193680","operating_cost_usd":"1892000"},{"month":"2025-03","route_id":"R2","route_name":"Media/Elwyn Line","route_type":"Rail","total_riders":"207840","weekday_avg":"7012","weekend_avg":"5412","on_time_pct":"89.2","avg_delay_minutes":"2.9","revenue_usd":"831360","operating_cost_usd":"1342000"},{"month":"2025-03","route_id":"R3","route_name":"Paoli/Thorndale Line","route_type":"Rail","total_riders":"324180","weekday_avg":"11024","weekend_avg":"8412","on_time_pct":"90.1","avg_delay_minutes":"2.7","revenue_usd":"1296720","operating_cost_usd":"1987000"},{"month":"2025-03","route_id":"MFL","route_name":"Market-Frankford Line","route_type":"Subway","total_riders":"1924700","weekday_avg":"66812","weekend_avg":"50124","on_time_pct":"94.4","avg_delay_minutes":"1.7","revenue_usd":"7698800","operating_cost_usd":"8241000"},{"month":"2025-03","route_id":"BSL","route_name":"Broad Street Line","route_type":"Subway","total_riders":"1178400","weekday_avg":"40712","weekend_avg":"31247","on_time_pct":"93.6","avg_delay_minutes":"2.0","revenue_usd":"4713600","operating_cost_usd":"5124000"},{"month":"2025-03","route_id":"BUS001","route_name":"Route 1 - Roosevelt Blvd","route_type":"Bus","total_riders":"91240","weekday_avg":"2987","weekend_avg":"2241","on_time_pct":"79.1","avg_delay_minutes":"5.9","revenue_usd":"364960","operating_cost_usd":"512000"},{"month":"2025-03","route_id":"BUS023","route_name":"Route 23 - Germantown Ave","route_type":"Bus","total_riders":"129840","weekday_avg":"4287","weekend_avg":"3124","on_time_pct":"77.4","avg_delay_minutes":"6.8","revenue_usd":"519360","operating_cost_usd":"698000"},{"month":"2025-03","route_id":"BUS042","route_name":"Route 42 - Chester Ave","route_type":"Bus","total_riders":"71820","weekday_avg":"2341","weekend_avg":"1812","on_time_pct":"79.8","avg_delay_minutes":"5.6","revenue_usd":"287280","operating_cost_usd":"412000"}],"count":24,"schema":{"3b465d90-1e63-5ebd-8a61-d32e8a0c2bad":{"fields":{"month":{"type":"text","mysql_type":"text"},"route_id":{"type":"text","mysql_type":"text"},"route_name":{"type":"text","mysql_type":"text"},"route_type":{"type":"text","mysql_type":"text"},"total_riders":{"type":"text","mysql_type":"text"},"weekday_avg":{"type":"text","mysql_type":"text"},"weekend_avg":{"type":"text","mysql_type":"text"},"on_time_pct":{"type":"text","mysql_type":"text"},"avg_delay_minutes":{"type":"text","mysql_type":"text"},"revenue_usd":{"type":"text","mysql_type":"text"},"operating_cost_usd":{"type":"text","mysql_type":"text"}}}},"query":{"resources":[{"id":"3b465d90-1e63-5ebd-8a61-d32e8a0c2bad","alias":"t"}],"limit":500,"offset":0,"count":true,"results":true,"schema":true,"keys":true,"format":"json","rowIds":false,"properties":["month","route_id","route_name","route_type","total_riders","weekday_avg","weekend_avg","on_time_pct","avg_delay_minutes","revenue_usd","operating_cost_usd"]}}