MTA Subway Turnstile Usage Data: 2015
This retired dataset contains information on entry/exit values for individual control areas and is posted purely for archival purposes. More detailed subway ridership data is now supported through the Subway hourly dataset (https://data.ny.gov/Transportation/MTA-Subway-Hourly-Ridership-Beginning-February-202/wujg-7c2s).
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-turnstile-usage-data-2015-ug6q-shqc\".\"mta_subway_turnstile_usage_data_2015\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.