MTA NYCT Paratransit Drop-off On-Time Performance: Beginning 2018

Drop-off On-Time Performance (OTP) measures the quality of provider service, comparing actual to customer-requested drop-off time for trips scheduled with an appointment time. Trips are considered on-time if they are no more than 30 minutes early, and no later than the appointment time.

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-nyct-paratransit-dropoff-ontime-performance-nxai-wcbd\".\"mta_nyct_paratransit_dropoff_ontime_performance\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.