Download this dataset

Choose the version that fits your project. You do not need to download every file.

Analysis-ready dataDownload Excel workbookStart with prepared data for reporting, charts, and spreadsheet analysis.bike-sharing-v1.0.0-analysis.xlsx · 987.1 KB
Source tables for SQLDownload SQLite databaseOpen every related source table in one portable SQLite database.bike-sharing-v1.0.0.sqlite · 1.3 MB
Related source tablesDownload source tablesPractice joins, transformations, and data modeling with documented CSV files.bike-sharing-v1.0.0-source-csv.zip · 278.2 KB

View all files and formats

Preview the data

Explore a sample before downloading. Select a table to see its columns, row count, relationships, and what each row represents.

Hour

One row represents: One row per observed hour.

Rows in this table: 17,379
Connects to: Day

This preview shows a sample, not the full download.

Sample rows from hour. This preview is not the full download.
instant	dteday	season	mnth	hr	weekday	weathersit	temp	atemp
1	2011-01-01	1	1	0	6	1	0.24	0.2879
2	2011-01-01	1	1	1	6	1	0.22	0.2727
3	2011-01-01	1	1	2	6	1	0.22	0.2727
4	2011-01-01	1	1	3	6	1	0.24	0.2879
5	2011-01-01	1	1	4	6	1	0.24	0.2879

Hour data dictionary

Check identifiers, dates, numeric fields, and missing values before writing a query or building a chart.

Column	What it means	Data type	Key or requirement
instant	Source row number.	integer	Required
dteday	Calendar date.	date	Required
season	Season code 1-4.	integer	Required
yr	0 for 2011; 1 for 2012.	integer	Required
mnth	Month 1-12.	integer	Required
hr	Hour 0-23.	integer	Required
holiday	Holiday indicator.	integer	Required
weekday	Weekday code.	integer	Required
workingday	Working-day indicator.	integer	Required
weathersit	Weather situation code.	integer	Required
temp	Normalized temperature.	decimal	Required
atemp	Normalized apparent temperature.	decimal	Required
hum	Normalized humidity.	decimal	Required
windspeed	Normalized wind speed.	decimal	Required
casual	Casual rentals.	integer	Required
registered	Registered rentals.	integer	Required
cnt	Total rentals.	integer	Required

View the full data dictionary

hour

One row represents: One row per observed hour.

Column	What it means	Data type	Key or requirement
instant	Source row number.	integer	Required
dteday	Calendar date.	date	Required
season	Season code 1-4.	integer	Required
yr	0 for 2011; 1 for 2012.	integer	Required
mnth	Month 1-12.	integer	Required
hr	Hour 0-23.	integer	Required
holiday	Holiday indicator.	integer	Required
weekday	Weekday code.	integer	Required
workingday	Working-day indicator.	integer	Required
weathersit	Weather situation code.	integer	Required
temp	Normalized temperature.	decimal	Required
atemp	Normalized apparent temperature.	decimal	Required
hum	Normalized humidity.	decimal	Required
windspeed	Normalized wind speed.	decimal	Required
casual	Casual rentals.	integer	Required
registered	Registered rentals.	integer	Required
cnt	Total rentals.	integer	Required

day

One row represents: One row per calendar date.

Column	What it means	Data type	Key or requirement
instant	Source row number.	integer	Required
dteday	Calendar date.	date	Required
season	Season code 1-4.	integer	Required
yr	0 for 2011; 1 for 2012.	integer	Required
mnth	Month 1-12.	integer	Required
holiday	Holiday indicator.	integer	Required
weekday	Weekday code.	integer	Required
workingday	Working-day indicator.	integer	Required
weathersit	Weather situation code.	integer	Required
temp	Normalized temperature.	decimal	Required
atemp	Normalized apparent temperature.	decimal	Required
hum	Normalized humidity.	decimal	Required
windspeed	Normalized wind speed.	decimal	Required
casual	Casual rentals.	integer	Required
registered	Registered rentals.	integer	Required
cnt	Total rentals.	integer	Required

About the data

These historical observations are useful for exploring patterns over time. Start with the daily file for a simpler analysis, or use hourly records for more detailed comparisons.

Consult the source definitions before interpreting encoded categories or normalized measurements. The hourly and daily files summarize the same underlying system at different levels of detail.

What one row represents: Varies by source table
Data covers: Start: 2011-01-01 · End: 2012-12-31
Dataset version: 1.0.0
Release published: 2026-09-05

How the tables connect

Generated from the same relationship metadata as the table documentation.

HourdtedayDaydteday

many-to-one

Start your first analysis

Open a download, inspect the table, and answer one question. Each example identifies the file and dataset version it uses.

Start with Excel

Use the prepared hourly workbook to build a simple demand profile.

Download Excel

File used: bike-sharing-v1.0.0-analysis.xlsx
Dataset version: 1.0.0
File size: 987.1 KB

01Open "bike-sharing-v1.0.0-analysis.xlsx" and select the "Bike Sharing Demand Dataset" sheet.
02Place hour in Rows and total_rentals in Values summarized as an average.
03Add is_working_day as a filter or Columns field and label the 2011–2012 coverage.

What you can build

Finished output from this release

How does average hourly demand vary by season and working-day status?

season	workingday	average_hourly_rentals	total_rentals
1	0	95.1	137683
1	1	119.4	333665
2	0	214.4	287976
2	1	205.7	630613
3	0	230.3	312056
3	1	238.5	749073

View the checked SQL

SELECT season,
       workingday,
       ROUND(AVG(cnt), 1) AS average_hourly_rentals,
       SUM(cnt) AS total_rentals
FROM hour
GROUP BY season, workingday
ORDER BY season, workingday;

Daily demand report

Plot daily rentals and compare the patterns visible across the coverage period.

Hourly profile

Compare average rentals by hour, stating which days are included in the calculation.

Weather comparison

Explore how recorded demand differs across documented weather categories without describing the comparison as proof of causation.

Time-based validation exercise

Use earlier observations for fitting and later observations for assessment.

Questions about this dataset

Is this current bike-sharing data?

No. It covers Capital Bikeshare activity in 2011–2012 and should not be presented as current ridership.

Should I combine the hourly and daily files?

Use either level for a given total. The files describe the same activity at different levels of detail, so adding their rental counts would double-count.

Source, license, and versions

Before you interpret the results

The source omits 165 zero-activity hours.
Weather values are normalized.
Counts cover Washington, D.C. in 2011-2012 and should not be generalized without validation.

Source, license, and version

Use the version number when sharing your work so others can reproduce it with the same files. Coverage dates describe the records; the release date describes when this package was published.

Maintainer: UCI Machine Learning Repository; prepared formats by Analytics Engineering
License: CC BY 4.0
Version: 1.0.0
Published: 2026-09-05T16:52:57.785Z

View the original source →

Cite this dataset

Fanaee-T, H. (2013). Bike Sharing [Dataset]. UCI Machine Learning Repository. https://doi.org/10.24432/C5W894

Found an issue?

Tell us which dataset, version, and file you used, and what you expected to happen. A small example helps us investigate.

Report a dataset issue →

Keep learning

Compare hourly and seasonal demand while preserving UCI's original historical scope and variable definitions.

This exercise uses a smaller teaching example, not the full downloadable dataset.

Bike Sharing Demand Dataset