Bicycle Counts

Bicycle counts conducted around New York City at key locations. For the counter locations, please refer to the <a href="https://data.cityofnewyork.us/d/smn3-rzf9/">Bicycle Counters dataset</a>.

The data may have lapses due to transmission issues cause by weather, connection interruptions, equipment malfunctions, vandalism, etc. The data will update as soon as it is feasible. The City makes no presentation as to the accuracy of the content and assumes no liability for omissions or errors in information contains on the website. Time is captured in GMT/UTC timezone.

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 \"cityofnewyork-us/bicycle-counts-uczf-rk3c\".\"bicycle_counts\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.