Elevators and escalators

The MTA's list of every elevator and escalator in the subway, kept as change events since October 2026.

Rows: 707
Size: 77.4 KB
Covers: October 2026 onward
Updated: Daily
Source: MTA elevator and escalator feed
License: CC BY 4.0

Fileshttps://data.transitlab.nyc/v1/elevator_equipment/year=YYYY/month=MM/YYYY-MM.parquetOne file a month. In the database as transitlab.elevator_equipment.

Rows and size from catalog.json, 2026-10-06.

What a row is

One machine, written when it first appears each hour and again whenever its record changes. event works as for bus positions. The full MTA record, with fields we don’t pull out, is in record as JSON.

Query it

-- Elevators per station, from the latest list
WITH latest AS (
  SELECT *
  FROM transitlab.elevator_equipment
  QUALIFY row_number() OVER (PARTITION BY equipment ORDER BY observed_at DESC) = 1
)
SELECT station, count(*) AS elevators
FROM latest
WHERE equipment_type = 'EL' AND event <> 'removed'
GROUP BY station
ORDER BY elevators DESC;

Join with outages on equipment.

Columns

row_idvarchar

Stable ID of the row. If a row appears twice, keep one.

observed_attimestamp

When we fetched the feed snapshot this row came from (UTC).

eventvarchar

baseline, added, changed or removed. See reading change events.

equipmentvarchar

MTA equipment number.

stationvarchar

Station name.

equipment_typevarchar

EL (elevator) or ES (escalator).

recordvarchar

The whole record as the MTA gives it.