MTA Metro-North Elevator and Escalator Availability: Beginning 2021

The percent of the time that elevators and escalators are operational systemwide.

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-metronorth-elevator-and-escalator-availability-ax67-8386\".\"mta_metronorth_elevator_and_escalator_availability\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.