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.