MTA LIRR Delay Verification: Beginning 2010

This dataset lists all LIRR trains that are delayed, with information on whether a train is cancelled, partially cancelled, or late (in a rounded number of minutes), the train number, and the branch the train operates on. For the cause of delays, use dataset https://data.ny.gov/Transportation/MTA-LIRR-Delays-Beginning-2010/e32g-kbe9, which is updated monthly.

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-lirr-delay-verification-beginning-2010-wkbk-y3dt\".\"mta_lirr_delay_verification_beginning_2010\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.