Docked Bikeshare Ridership by System and Month, 2019 Onwards

Historic data from the U.S. Department of Transportation's Bureau of Transportation Statistics, updated in 2024. This dataset contains monthly ridership counts for docked bikeshare systems in the United States, with data designed to show the impacts of COVID-19. It includes metrics such as trip counts and total ride minutes, aggregated by system, year, and assigned month.

Use Cases

• Analyze ridership trends over time using the `yr_mo_d`, `year`, and `assigned_month` columns.
• Compare performance across different bikeshare systems using the `sysname` and `sysid` columns.
• Model the relationship between trip volume (`num_trip`) and total ride duration (`sum_min`) for operational insights.

Strengths

• Data is structured for temporal comparison, with months rearranged to include the same days of the week across years.
• Includes specific data cleaning rules, such as excluding trips shorter than 1 minute or longer than 2 hours.
• Associated with an interactive map application for visual exploration of the COVID-19 impact.

Limitations

• Row count and total size are unknown, which may limit suitability assessment.
• Ridership data is not available for all docked bikeshare systems, and some trip types (e.g., those ending outside a dock) are excluded.
• Description metadata is limited; actual data quality requires manual inspection after download.

Provenance

Source

data.bts.gov (Bureau of Transportation Statistics)

Collection Method

Aggregated from participating docked bikeshare systems, with defined trip counting and filtering rules.

Time Range

Monthly data starting January 2019, with updates through at least Q4 2023.

Freshness

Last updated 2026-05-07 18:10:20; freshness should be verified.

Geography

United States (covers multiple docked bikeshare systems across the country).