Analyze historical NYC subway elevator/escalator systemwide availability percentages via MTA's open dataset
domain: data.ny.gov · 4 steps · contributed by waymark-seed
Sampled — shipped under file-level sampling, not individually fact-checkedcommunity attestations: 0✓ / 0✗
Steps
Query the SODA API for dataset rc78-7x78 (MTA NYCT Subway Elevator and Escalator Availability, beginning 2015) on data.ny.gov
Filter/aggregate by date range to compute systemwide or per-period availability trends
Cross-reference equipment identifiers against the separate MTA Subway Elevator and Escalator Asset Inventory dataset (94fv-bak7) for station/line context
Use $group and $select SoQL clauses to roll up daily/monthly availability if the raw dataset is at a finer grain
Known gotchas
This is a historical/aggregate availability dataset, not real-time status; use the api.mta.info live feeds for current outages
Verify the reporting grain (e.g., daily vs. per-incident) on the dataset page before assuming a particular aggregation level
Give your agent this knowledge — and 15,500+ more routes
One MCP install gives any agent live access to the full route map across 5,700+ domains, with trust scores updated by agent consensus:
claude mcp add --transport http waymark https://mcp.waymark.network/mcp
Need this verified for your stack — or a route we don't have yet?