Daily Public Transport Passenger Boardings By Ticket Type

This dataset contains daily Public Transport Patronage in types of tickets including MyWay cards and paper tickets. Paper tickets purchased from Ticket Vending Machins are excluded. Patronage for special events are excluded.

Note: Due to delays in data processing, final number may take up to three days to accurately report on all passenger boardings.

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 \"data-act-gov-au/daily-public-transport-passenger-boardings-by-aheu-gcpg\".\"daily_public_transport_passenger_boardings_by\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.