Icon for Socrata external plugin
Open repository in Console
Updated over 1 year ago
Indexed 3 hours ago

Fare Card History for Metropolitan Transportation Authority (MTA): Beginning 2010

These files show the number of MetroCard swipes made each week by customers entering each station of the New York City Subway, PATH, AirTrain JFK and the Roosevelt Island Tram, broken out to show the relative popularity of the various types of MetroCards. MTA New York City Transit posts the latest data every Saturday by 1 a.m., and the dates listed in the links reference the date the data is posted. The data in the files covers seven-day periods beginning on the Saturday two weeks prior to the posting date and ending on the following Friday.

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" \
{"sql": "
    SELECT *
    FROM \"ny-gov/fare-card-history-for-metropolitan-transportation-v7qc-gwpn\".\"fare_card_history_for_metropolitan_transportation\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • fare_card_history_for_metropolitan_transportation
Upstream Metadata