MTA Metro-North Delay Verification: Beginning 2012

This dataset lists all Metro-North trains that are delayed, defined as those that are canceled, terminated, substituted by bus service during unplanned circumstances, or arrive at their destination with a delay of a specified number of minutes, the train number, and the branch the train operates on.

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-metronorth-delay-verification-beginning-2012-crxu-7hda\".\"mta_metronorth_delay_verification_beginning_2012\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.