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

  1. id — A unique integer that serves as a reference for each trip
  2. duration — The duration of the trip, measured in seconds
  3. start_date — The date and time the trip began
  4. start_station — Foreign key for Trip Starting Station ID
  5. end_date — The date and time the trip ended
  6. end_station — Foreign key for Trip ending Station ID
  7. bike_number — Hubway'sunique identifier for the bike used on the trip
  8. sub_type — The subscription type of the user. "Registered" for users with a membership, "Casual" for users without a membership
  9. zip_code — The zip code of the user (only available for registered members)
  10. birth_date — The birth year of the user (only available for registered members)
  11. gender — The gender of the user (only available for registered members)

Data Dictionary: Station Table

  1. id — A unique identifier for each station (corresponds to the start_station and end_stationcolumns in the trips table)
  2. station — The station name
  3. municipality — The municipality that the station is in (Boston, Brookline, Cambridge or Somerville)
  4. lat — The latitude of the station
  5. 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
Publishedimage
public datasets
Advanced features
Insights
What columns are included in the document?
Based on the provided information of the dataset, would it be possible to provide some relevant inquiries?
How many rows does the document contain?

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

  1. id — A unique integer that serves as a reference for each trip
  2. duration — The duration of the trip, measured in seconds
  3. start_date — The date and time the trip began
  4. start_station — Foreign key for Trip Starting Station ID
  5. end_date — The date and time the trip ended
  6. end_station — Foreign key for Trip ending Station ID
  7. bike_number — Hubway'sunique identifier for the bike used on the trip
  8. sub_type — The subscription type of the user. "Registered" for users with a membership, "Casual" for users without a membership
  9. zip_code — The zip code of the user (only available for registered members)
  10. birth_date — The birth year of the user (only available for registered members)
  11. gender — The gender of the user (only available for registered members)

Data Dictionary: Station Table

  1. id — A unique identifier for each station (corresponds to the start_station and end_stationcolumns in the trips table)
  2. station — The station name
  3. municipality — The municipality that the station is in (Boston, Brookline, Cambridge or Somerville)
  4. lat — The latitude of the station
  5. lng — The longitude of the station
Scan the QR code to ask more questions about the paper
© 2025 Powerdrill. All rights reserved.