Citywide Bicycle Counts

This bicycle count data is collected as part of the City of Cambridge’s regular citywide bicycle counts. These counts are typically done on weekdays (Tuesday-Thursday) in September, annually between 2002-2006 and every other year since 2008, with an additional count in 2019 due to poor weather in 2018. See also <a href="https://cityofcambridge.shinyapps.io/CitywideBicycleCounts/" target="_blank">this web app with data visualization tools</a> and more background information on using and interpreting the data.

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 \"cambridgema-gov/citywide-bicycle-counts-ijm6-q7em\".\"citywide_bicycle_counts\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.