Caltrain Average Weekly Ridership Per Day 2009-2013
The 2013 annual Caltrain passenger counts, which were conducted from January 22 to February 22, 2013, followed the same methodology that has been used since the counts commenced in 1994. Physical headcounts of all boarding and alighting passengers, and bikes per station, are collected for all weekday and weekend trains. Weekday trains are counted five times each, once each day, Monday through Friday. Figures given are an average of the five days. On weekends, each train is counted once on Saturday and once on Sunday. Counts are conducted in February to avoid special events, especially Giant’s baseball games at AT&T Park in San Francisco, which can distort average ridership and interfere in sound planning.
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 \"performance-smcgov/caltrain-average-weekly-ridership-per-day-20092013-nem3-yjgt\".\"caltrain_average_weekly_ridership_per_day_20092013\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
