MTA Express Bus Capacity: April 2023 - September 2023

This dataset provides the load percentage for each express bus route at its maximum load point (the bus stop where the highest number of passengers are on the bus) by direction, hour, day type (weekday, weekends and holidays), aggregated by week.

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-express-bus-capacity-april-2023-september-2023-4tpr-3bvc\".\"mta_express_bus_capacity_april_2023_september_2023\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.