MTA Metro-North Mean Distance Between Failures: Beginning 2018

Mean Distance Between Failures represents the number of miles a rail car travels before a mechanical failure makes the train arrive at its final destination more than 5 minutes and 59 seconds later than scheduled. This measures the reliability of equipment in revenue service.

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-mean-distance-between-failures-4qd6-ptxx\".\"mta_metronorth_mean_distance_between_failures\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.