Transit Ridership in Colorado

Passengers took almost 120 million trips in 2012 on Colorado’s public transportation vehicles, which include buses, light rail and vehicles used by services that transport disabled people. A trip is counted each time a passenger boards a vehicle, no matter how many vehicles the passenger takes to reach a destination.

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 \"colorado-gov/transit-ridership-in-colorado-j24f-h6ie\".\"transit_ridership_in_colorado\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.