MTA Bus Customer Journey-Focused Metrics: 2017-2019
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 between 2017 and 2019. For data from 2020 on, use https://data.ny.gov/Transportation/MTA-Bus-Customer-Journey-Focused-Metrics-Beginning/wrt8-4b59/about_data.
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-20172019-8mkn-d32t\".\"mta_bus_customer_journeyfocused_metrics_20172019\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.