For 2016 Q1 (Jan 1 — Mar 31), the dataset is comprised of 552,399 rows with 9 variables. The variables they provide are:

Duration(ms)

Start Date

End Date

Start/End Station Number

Start/End Station Location

Bike Number

Member Type

A quick look at the dataset

Capital Bikeshare 2016 Q1 snapshot

The first thing I wanted to see was the breakout of Registered users Vs. Casual users.

A registered user is someone with their personal day key, a month, or an annual membership. A casual user is someone that only has a single 24 hour, or 3-day membership.

Looking at the breakdown should not surprise anyone. Registered users hopped on a bike 467,432 times compared to casual users at 84,967. Together, those riders logged some impressive minutes!

(Estimated due to rounding conversion from millisecond to second)