MTA Key Performance Indicators: 2008-2021

This dataset combines Key Performance Indicator data that was reported starting with the creation of the MTA Stat performance metric dashboard in 2008 through 2021. Most of the metrics in the dataset available elsewhere on the open data portal.

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-key-performance-indicators-20082021-cy9b-i9w9\".\"mta_key_performance_indicators_20082021\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.