data-act-gov-au/light-rail-patronage-x7dn-77he
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 1 month ago
Indexed 1 month ago

Light Rail Patronage

This dataset contains information relating to the daily patronage figure (number of boardings) on the Light Rail Network in Canberra. The dataset contains patronage data since light rail operations commenced with the first fiscal week beginning on Monday 22nd of April 2019. This dataset contains boardings calculated using MyWay Card and Paper Tickets.

Note: Due to delays in data processing, final number may take up to three days to accurately report on all passenger boardings

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/light-rail-patronage-x7dn-77he\".\"light_rail_patronage\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • light_rail_patronage
     
     
     
     
     
Upstream Metadata