Docked Bikeshare Trip Summaries by System and Time

Historic docked bikeshare ridership data starting in January 2019, updated through Q4 2023. The dataset summarizes trips by system, month, day, and hour, provided by the U.S. Bureau of Transportation Statistics. Data includes metrics like trip counts, average durations, and system identifiers.

Use Cases

• Analyze seasonal ridership trends using the `year`, `assigned_month`, and `total_trips` columns.
• Compare system performance across different cities by aggregating `num_trip` and `avg_min` per `sysname`.
• Model hourly demand patterns for station rebalancing using the `hour` and `num_trip` fields.
• Assess the impact of membership programs on trip volume by filtering `total_trips` based on the `membership` column.
• Calculate year-over-year growth rates for specific systems using `pct_change` and `point_change` metrics.

Strengths

• Data spans multiple years, from January 2019 through Q4 2023.
• Provides three levels of temporal aggregation: month, day, and hour.
• Includes data cleaning rules, such as excluding trips shorter than 1 minute or longer than 2 hours.

Limitations

• Ridership data is not available for all docked bikeshare systems, creating coverage gaps.
• Sample size and total row count are unknown.
• The methodology for aligning days of the week across years in monthly summaries adds complexity.

Provenance

Source

U.S. Bureau of Transportation Statistics (data.bts.gov).

Collection Method

Aggregated from participating docked bikeshare systems.

Time Range

January 2019 through Q4 2023.

Freshness

Data updated on 06/04/2024 for recent periods.

Geography

Covers multiple U.S. bikeshare systems, but specific geographic coverage is not detailed.