MTA Subway Customer Journey-Focused Metrics: 2015-2019

Additional Platform Time is the estimated average time that

customers spend waiting at a station beyond their scheduled wait time. Additional Train Time is the estimated average time

customers spend onboard a train beyond their scheduled travel

time. Customer Journey Time Performance (CJTP) estimates the percentage of customer trips with a total travel time within 5

minutes of the scheduled time.

To make this data more accessible to a wider range of users, larger datasets are capped in 5-year increments for easier usability. Additional data on this topic may be found by searching the catalog. Fields across the same types of data will remain the same whenever possible.

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-subway-customer-journeyfocused-metrics-r7qk-6tcy\".\"mta_subway_customer_journeyfocused_metrics\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.