Bus Ridership

***NOTE: There are problems with data accuracy on bus ridership counts for June 2019, July 2019, and August 2019 as Phoenix and Valley Metro attempt to integrate new hardware with the existing system. For Mesa this is clearly impacting routes 156, 531, and 541, however, there are minor anomalies with some of the other routes.

Breakdown of bus service ridership on a monthly basis per route in Mesa (data lags for approximately 30 days) and data is provided by Valley Metro, an external agency who is responsible for both bus service and light rail in Mesa. For a regional view of both bus service and light rail ridership, please go to their website, under their Publications/Reports section. Valley Metro tracks bus riders as they board. Bus service expands the scope and range of light rail, in addition to being a geographically more flexible means of public transportation in comparison to light rail.

The data set captures information starting in July 2013. Effective October 24, 2016, AZ Link has been consolidated with route 112, and the Main Street Link consolidated with route 40.

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/bus-ridership-nmjv-498y\".\"bus_ridership\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.