Alightings By Stop By Hr

Provides the average number of passenger alightings by day broken down by stop and hour for May 2017. Patronage is measured through unique alightings recorded in the MyWay ticketing system on scheduled services. This includes alightings by passengers with MyWay cards. This dataset excludes passenger alightings 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/alightings-by-stop-by-hr-4gsk-t7z5\".\"alightings_by_stop_by_hr\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.