Metropolitan Transportation Authority (MTA) Performance Indicators per Agency: 2008-2021

This is a retired dataset that is no longer supported by the MTA. This dataset combines a variety of performance metrics back to 2008 that are now mostly found elsewhere on the open data portal. View MTA’s open data catalog (https://data.ny.gov/Transportation/MTA-Open-Data-Catalog-and-Publication-Schedule/f462-ka72) find more recent information.

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/metropolitan-transportation-authority-mta-cy9b-i9w9\".\"metropolitan_transportation_authority_mta\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.