data-act-gov-au/boardings-by-stop-by-hr-tf32-54vh
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated over 2 years ago
Indexed 10 days ago

Boardings By Stop By Hr

Provides the average number of passenger boardings by day broken down by stop and hour for May 2017. 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-hr-tf32-54vh\".\"boardings_by_stop_by_hr\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • boardings_by_stop_by_hr
     
     
     
     
     
Upstream Metadata