Washington DC's Capital Bikeshare program provides real-time streaming access to data on trips via its API (https://gbfs.capitalbikeshare.com/gbfs/gbfs.json). In the current iteration of the system, this data is aggregated and published as monthly .csv files in a AWS S3 bucket (https://s3.amazonaws.com/capitalbikeshare-data/index.html).

This Kaggle dataset includes all currently-available .csv files as of March 13 2023 (i.e. September 2010 to Feb 2023). Beginning in April 2020, the system changed its table schema, altering the spelling of some columns but also adding several new ones. I've concatenated all the files with the first version schema and all those with the second into two separate .csv files for you to download.

Apart from changing the column names in the version 1 data, I've left the data unmodified from the source.

LICENSE: https://ride.capitalbikeshare.com/data-license-agreement

Header/thumbnail credits: Alejandro Castro (https://www.flickr.com/photos/gtps/13961153170/)