MTA Bus Fare Evasion: Beginning 2019

The bus fare evasion (BFE) rate is the estimated percentage of riders who illegally board buses. It is calculated systemwide quarterly using Automated Passenger Counters. Rates are calculated and reported separately for Local/Limited, Express and Select Bus Service. Prior to Q1 2020, fare evasion was estimated using surveys conducted by traffic checkers.

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-bus-fare-evasion-beginning-2019-uv5h-dfhp\".\"mta_bus_fare_evasion_beginning_2019\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.