Light Rail Ridership

Breakdown of light rail ridership on a monthly basis per station in Mesa (data lags for approximately 30 days) and is provided by Valley Metro, an external agency who is responsible for both light rail and bus services in Mesa. For a regional view of both light rail and bus ridership, please go to their website, under their Publications/Reports section. Valley Metro uses APC (Automatic People Counter) technology to generate the number of riders that they report on.

Data reporting can be delayed up to 60 days.

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 \"citydata-mesaaz-gov/light-rail-ridership-pdpe-wbxu\".\"light_rail_ridership\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.