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
"}
EOFSee the Splitgraph documentation
for more information.
