Open repository in Console
Readme
Updated almost 9 years ago
‧ Indexed 1 hour 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 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.