1.1 Company Profile
| – Company Name: Capital Bikeshare – Provides a bikesharing system to lend bikes for rides – Different offers: Single Trip, 24h Hour Pass, Annual Membership, … – +5000 Bikes – +600 Stations – Accessible for riders: 24 hours a day, 7 days a week, 365 days a year – Location: USA over 7 different jurisdictions around Washington DC – Website: capitalbikeshare.com – Part of Motivate: motivateco.com |
1.2 The Data
Capital bikeshare provides a set of their system data on the website: System Data
The License Agreement can be found here: Data License Agreement
| – Duration: Duration of the trip – Start Date: Includes start date and time – End Date: Includes end date and time – Start Station: Includes starting station name and number – End Station: Includes ending station name and number – Bike Number: Includes ID number of bike used for the trip – Member Type: Indicates whether user was a “registered” member (Annual Member, 30-Day Member or Day Key Member) or a “casual” rider (Single Trip, 24-Hour Pass, 3-Day Pass or 5-Day Pass) |
The data are provided in the CSV-format per month from the year 2018 on until today. From 2010 to 2017 one file contains a whole year.
The files are coming as a zip-file. Included in it is also a separate CSV-file for MacOS. That’s caused by the usage of different end-of-line characters by Windows and Mac. Explanation from stackoverflow here.