Icon for Socrata external plugin
Open repository in Console
Updated almost 9 years ago
Indexed 4 hours ago

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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"colorado-gov/transit-ridership-in-colorado-j24f-h6ie\".\"transit_ridership_in_colorado\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • transit_ridership_in_colorado