Passenger Journeys By Week By Ticket Type

Provides a total number of passenger journeys by fiscal week on the Transport Canberra network, broken down by the ticket type used.

Note, a journey may be comprised of multiple individual trips.

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/passenger-journeys-by-week-by-ticket-type-jia3-rxue\".\"passenger_journeys_by_week_by_ticket_type\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.