Bike Sharing in Washington D.C. Dataset

  • by user1
  • 05 March, 2022

Rental bikes in 2011 and 2012 with corresponding weather and seasonal info

LicenseCC0: Public Domain

Tagsretail and shoppingdata visualizationexploratory data analysiscategorical datacyclingand 1 more


Bike sharing systems are a new generation of traditional bike rentals where the whole process from membership, rental and return back has become automatic. Through these systems, user is able to easily rent a bike from a particular position and return back to another position. Currently, there are about over 500 bike-sharing programs around the world which are composed of over 500 thousands bicycles. Today, there exists great interest in these systems due to their important role in traffic, environmental and health issues.

Apart from interesting real-world applications of bike sharing systems, the characteristics of data being generated by these systems make them attractive for the research. Opposed to other transport services such as bus or subway, the duration of travel, departure and arrival position is explicitly recorded in these systems. This feature turns bike sharing system into a virtual sensor network that can be used for sensing mobility in the city. Hence, it is expected that most of important events in the city could be detected via monitoring these data.

This dataset contains the hourly and daily count of rental bikes between years 2011 and 2012 in Capital bikeshare system in Washington, DC with the corresponding weather and seasonal information.


Both hour.csv and day.csv have the following fields, except hr which is not available in day.csv

  • instant: Record index
  • dteday: Date
  • season: Season (1:springer, 2:summer, 3:fall, 4:winter)
  • yr: Year (0: 2011, 1:2012)
  • mnth: Month (1 to 12)
  • hr: Hour (0 to 23)
  • holiday: weather day is holiday or not (extracted from Holiday Schedule)
  • weekday: Day of the week
  • workingday: If day is neither weekend nor holiday is 1, otherwise is 0.
  • weathersit: (extracted from Freemeteo)
  • 1: Clear, Few clouds, Partly cloudy, Partly cloudy
  • 2: Mist + Cloudy, Mist + Broken clouds, Mist + Few clouds, Mist
  • 3: Light Snow, Light Rain + Thunderstorm + Scattered clouds, Light Rain + Scattered clouds
  • 4: Heavy Rain + Ice Pallets + Thunderstorm + Mist, Snow + Fog
  • temp: Normalized temperature in Celsius. The values are derived via (t-tmin)/(tmax-tmin), tmin=-8, t_max=+39 (only in hourly scale)
  • atemp: Normalized feeling temperature in Celsius. The values are derived via (t-tmin)/(tmax-tmin), tmin=-16, t_max=+50 (only in hourly scale)
  • hum: Normalized humidity. The values are divided to 100 (max)
  • windspeed: Normalized wind speed. The values are divided to 67 (max)
  • casual: count of casual users
  • registered: count of registered users
  • cnt: count of total rental bikes including both casual and registered


Hadi Fanaee-T
Laboratory of Artificial Intelligence and Decision Support (LIAAD), University of Porto
INESC Porto, Campus da FEUP
Rua Dr. Roberto Frias, 378
4200 – 465 Porto, Portugal

Original Source:

Weather Information:

Holiday Schedule:

Size: 573 KB Price: Free Author: Mark Kaghazgarian Data source: