data-act-gov-au/boardings-by-stop-by-hour-2019-2020-4frr-dtuk
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated over 2 years ago
Indexed 8 days ago

Boardings by Stop by Hour 2019 - 2020

Provides the number of passenger boardings by month broken down by stop and hour for July 2019 - June 2020. 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-2019-2020-4frr-dtuk\".\"boardings_by_stop_by_hour_2019_2020\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • boardings_by_stop_by_hour_2019_2020
     
     
     
     
     
Upstream Metadata