datahub-smcgov/transit-total-monthly-ridership-tve3-bg52
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated almost 5 years ago
Indexed 26 days ago

Transit Total Monthly Ridership

Total monthly transit ridership data. Includes counts for SamTrans bus, paratransit, CalTrain, Shuttles, and the BART extension without the Daly City stop. This data is from 2011 to the present.

Shuttle data for July, 2015 is an average of July data from 2011 through 2017.

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 \"datahub-smcgov/transit-total-monthly-ridership-tve3-bg52\".\"transit_total_monthly_ridership\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • transit_total_monthly_ridership
     
     
     
     
     
Upstream Metadata