MTA Subway Origin-Destination Ridership Estimate: 2024
This dataset provides an estimate of subway travel patterns based on scaled-up OMNY and MetroCard return swipe data. It provides estimated passenger volumes for all populated origin-destination (O-D) pairs aggregated by month, day of the week, and hour of day. It also provides the name, ID, and approximate latitude and longitude of the origin and destination subway complexes.
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-subway-origindestination-ridership-estimate-jsu2-fbtj\".\"mta_subway_origindestination_ridership_estimate\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
