Daily Public Transport Passenger Boardings by Service Type

This dataset contains daily Public Transport Patronage in types of services. Paper tickets sold by Ticket Vending Machines are excluded except for the ones on light rail platforms. This dataset can be aggregated to provide daily Light Rail and bus patronage number.

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-4f52-nub8\".\"daily_public_transport_passenger_boardings_by\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.