Capital Bikeshare Trip History Data -- Results Roundup

[caywood]

Hey everyone and welcome to the forum,

In late 2011, Daniel Gohlke of CaBiTracker.com, Tom Fairchild of Arlington's Mobility Lab, and I got Capital Bikeshare to agree to release a data set containing anonymous trip history data. At the beginning of 2012, they released data covering 2010 and 2011, about 14 months of the system's history (it was launched on September 20, 2010). This made CaBi the second system to release trip history data, after London's TFL. (Boston has recently released two days of data).

People have been publishing their analysis of this data all over the web, and I wanted to bring together in a single place some of the analyses that have been done, and some data sources so you all can do more. I've tried to be comprehensive but have missed a few things -- go ahead and add them in comments!

Everyone is credited by name, if I could find it, or username if I couldn't.

-- Matt Caywood

Data

• Original source data (CSV files): http://capitalbikeshare.com/trip_history_data
• Google Fusion Tables: http://www.dylanbarlett.com/2012/01/...-history-data/ (Dylan Barlett)
• CSV files (cleaned and merged data set): www.coreyholman.com/flat.csv with station ID data at www.coreyholman.com/stations.txt. Description of cleaning process is here: http://greatergreaterwashington.org/...comment-127243 (Corey Holman)
• SQL file:
  https://dl.dropbox.com/u/1643312/bikeshare.sql. Description here: http://greatergreaterwashington.org/...comment-127768 (JMC on Greater Greater Washington)
  

Analysis


Corey Holman on Greater Greater Washington was the first to dive into the data.

• Downhill flow, last mile trips, and tourist usage are summarized here: http://greatergreaterwashington.org/...resting-facts/ (Corey)
  
• Most common one-way (origin, destination) pairs: http://greatergreaterwashington.org/...comment-127227 (Corey)
  
• Ward-to-ward flow patterns here: http://greatergreaterwashington.org/...comment-127248 (Corey)
  

Many others jumped in shortly after:

• An incredibly cool visualization of route fluxes on a map using a trip planner, throwing in London and Boston:
  http://oliverobrien.co.uk/2012/01/bi...-route-fluxes/ (Oliver O'Brien)
  
• The propensity of casual users to pay overage fees. http://bikesharestation.com/capital-bikeshare-data/ (Eric O.)
  
• One bike's peregrinations in the city, for kicks: http://www.jdland.com/dc/index.cfm/3...W01000s-Trips/ (Jacqueline Dupree, JDLand)
  
• Monthly usage: http://www.washingtoncitypaper.com/b...are-ridership/ (Lydia DePillis)
  
• Neat look at how sunrise & sunset hours affected ridership, with a partial look at weather patterns: http://goo.gl/pQQaU ("Bilsko" commenting on JDAntos)
  

Finally, Justin Antos (JDAntos) has done a lot of pro work, and has written an (ongoing) series of posts about his results.

• Graphs showing seasonal and time usage patterns: https://jdantos.wordpress.com/2012/0...e-data-part-1/ (Justin Antos)
  
• Trip duration: https://jdantos.wordpress.com/2012/0...e-data-part-2/ (Justin Antos)
  
• Usage patterns for single bikes: https://jdantos.wordpress.com/2012/0...e-data-part-3/ (Justin Antos)
  
• Flows between geographic regions (not wards) with (origin, destination) data: https://jdantos.wordpress.com/2012/0...-riders-going/
  

Discussion threads of interest

• http://greatergreaterwashington.org/...ous-trip-data/
  
• http://greatergreaterwashington.org/...resting-facts/
  
• http://greatergreaterwashington.org/...rom-cabi-data/
  
• https://jdantos.wordpress.com/2012/0...e-data-part-1/

[Justin Antos]

Hi all, I've put together a few more visualizations on this:
-The "balanced-ness" of the system - net trips sent/(received): here and here
-Some maps showing where the casual users are, length of trip, and "balanced-ness" by stations here

[Justin Antos]

Does anyone have change in elevation, and distance between stations?

[dgohlke]

Add this to the list: http://terpconnect.umd.edu/~rahul/CABI/

[caywood]

Justin, Corey's flat.csv file (linked above) has trip elevation changes and Euclidean distances.

[caywood]

I just received clarification from CaBi that rebalancing trips are excluded from the trip data.

Bikes are "ghosted" by the service techs' keys and are not recorded in the trip database.

[caywood]

I've posted the results of a trip data analysis showing how bicycling speed compares to other modes, based on a sample of station pairs at Greater Greater Washington.

[mvs202]

Here's my own visualization: Looking at CaBi Stats with a Bubble Map.

I went through 3 iterations while writing the code, so the data started making my head spin - holler if anything looks amiss.

[mvs202]

Here's another project from the cabi data: A Day in the Life of Capital Bikeshare. Please check to see if the data looks right... Does it make sense there are no CaBi trips on this November Sunday in the Rosslyn corridor? I'll make another movie for a weekday when the new quarter comes in. Also, does it sound right that so many people return their cabi bikes to the same station? 63% for casual riders, and 32% for registered???

[mvs202]

Got a couple of new CaBi movies... latest animated CaBi data from March 23, 2012: Animating a Busy Day for Capital Bikeshare