MTA Subway Customer Journey-Focused Metrics: 2015-2019
Additional Platform Time (APT) is the estimated average extra time that customers spend waiting on the platform for a train, compared with their scheduled wait time.
Additional Train Time (ATT) is the estimated average extra time that customers spend onboard a train, compared to the time they would have spent onboard a train if trains were running according to schedule.
Additional Journey Time (AJT) is the estimated average extra time that customers spend on their journey, compared with the scheduled time. It is the sum of the additional time spent waiting on platforms (APT) and the additional time spent onboard a train (ATT).
Journey Time is the average total time a customer spends on their journey waiting for and riding a specific train line.
Customer Journey Time Performance (CJTP) is the estimated percentage of rider trips that are completed within 5 minutes of their scheduled time.
These measures are estimated for each individual train a customer uses in their journey, also known as an unlinked trip, not all trains in their journey combined.
This dataset covers data between 2015 and 2019. For data from 2020 on, use dataset https://data.ny.gov/Transportation/MTA-Subway-Customer-Journey-Focused-Metrics-Beginn/4apg-4kt9.
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
"}
EOFSee the Splitgraph documentation
for more information.
