MTA NYCT MetroCard History: 2010 - 2021

This archival dataset shows the number of MetroCard swipes made each week by customers entering each station of the New York City Subway, Staten Island Railway, PATH, AirTrain JFK and the Roosevelt Island Tram, broken out to show the relative popularity of the various types of MetroCards. Please use the subway hourly ridership dataset (https://data.ny.gov/Transportation/MTA-Subway-Hourly-Ridership-Beginning-February-202/wujg-7c2s/) for up-to-date data which includes OMNY fares

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-nyct-metrocard-history-2010-2021-v7qc-gwpn\".\"mta_nyct_metrocard_history_2010_2021\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.