Hubway Bikes Dataset
mesum·January 22, 2025
Description
Summary
This tutorial we'll be working with a dataset from the bike-sharing service Hubway, which includes data on over 1.5 million trips made with the service.
Data Dictionary: Trip Table
- id — A unique integer that serves as a reference for each trip
- duration — The duration of the trip, measured in seconds
- start_date — The date and time the trip began
- start_station — Foreign key for Trip Starting Station ID
- end_date — The date and time the trip ended
- end_station — Foreign key for Trip ending Station ID
- bike_number — Hubway'sunique identifier for the bike used on the trip
- sub_type — The subscription type of the user. "Registered" for users with a membership, "Casual" for users without a membership
- zip_code — The zip code of the user (only available for registered members)
- birth_date — The birth year of the user (only available for registered members)
- gender — The gender of the user (only available for registered members)
Data Dictionary: Station Table
- id — A unique identifier for each station (corresponds to the start_station and end_stationcolumns in the trips table)
- station — The station name
- municipality — The municipality that the station is in (Boston, Brookline, Cambridge or Somerville)
- lat — The latitude of the station
- lng — The longitude of the station
Basic info
Author
mesum
Shared withEveryone
CreatedJanuary 22, 2023
Size131 MB
LicenseN/A
Dictionary3 tables
Original URLGo to check
Published
public datasets
Advanced features