Boardings by Stop by Hour 2018 - 2019

Provides the number of passenger boardings by month broken down by stop and hour for July 2018 - June 2019. Patronage is measured through unique boardings recorded in the MyWay ticketing system on scheduled services. This includes boardings by passengers with MyWay cards and passengers who choose to purchase a ticket or transfer on board a vehicle. This dataset excludes passenger boardings on dedicated school routes.

Data was sourced from the MyWay ticketing system which records passenger validations and cash sales using the netBI business intelligence software.

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/boardings-by-stop-by-hour-2018-2019-6a2h-u24h\".\"boardings_by_stop_by_hour_2018_2019\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.