MTA Bus Customer Journey-Focused Metrics: Beginning 2020

Additional Bus Stop Time is the average time that customers spend waiting at a stop beyond their scheduled wait time.

Additional Travel Time is the average time customers spend onboard a bus beyond their scheduled travel time.

Customer Journey Time Performance is the percentage of customers whose journeys are completed within 5 minutes of their scheduled time.

This dataset covers data from 2020 and on. For data between 2017 and 2019, use dataset https://data.ny.gov/Transportation/MTA-Bus-Customer-Journey-Focused-Metrics-2017-2019/8mkn-d32t.

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 \"ny-gov/mta-bus-customer-journeyfocused-metrics-beginning-wrt8-4b59\".\"mta_bus_customer_journeyfocused_metrics_beginning\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.