CTA - Ridership - 'L' Station Entries - Monthly Day-Type Averages & Totals

This dataset lists monthly station entry averages, by day type (Weekday, Saturday or Sunday/Holiday), as well as monthly totals, beginning in 2001. Note that some stations (such as on the Cermak Branch--now Pink Line) and Skokie did not have Saturday and/or Sunday/holiday service until more recent years, although, in cases where weekday service ran past midnight, late evening fares may appear as part of Saturday tallies.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cityofchicago/cta-ridership-l-station-entries-monthly-daytype-t2rn-p8d7\".\"cta_ridership_l_station_entries_monthly_daytype\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.