Calgary Transit Ridership

Transit ridership including system-level ridership, sub groups, and by fare product. Sub groups include adult, youth, seniors, low income, free fare zone, and internal recoveries. Fare products include single ride fares, monthly passes, daily passes, annual passes, semester passes (U-Pass), and airport passes.

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 \"calgary-ca/calgary-transit-ridership-iema-jbc4\".\"calgary_transit_ridership\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.