The processed bike share ridership data consists of the following files
- 2018, 2019
- eight quarterly CSV files
- 2020, 2021, 2022
- 36 monthly CSV files
- 2023
- 12 monthly CSV files
Raw bike share ridership data contains the following columns per trip
Trip Id
- bike share trip identifier
- this is a nominal value
- in data from 2018, this is
trip_id
Trip Duration
- trip length in seconds
- in data from 2018, this is
trip_duration_seconds
Start Station Id
- identifier for station from which bike was checked out to start trip
- in data from 2018, this is
from_station_id
Start Time
- date and time at which trip started
- in data from 2018, this is
trip_start_time
Start Station Name
- name of station from which bike was checked out to start trip
- in data from 2018, this is
from_station_name
End Station Id
- identifier of station at which bike was returned at end of trip
- in data from 2018, this is
to_station_id
End Time
- date and time at which trip ended
- in data from 2018, this is
trip_stop_time
End Station Name
- name of station from which bike was returned at end of trip
- in data from 2018, this is
to_station_name
Bike Id
- identifier for bike used in bike share trip
- in data from 2018, this is column is missing
User Type
- type of bike share member
- one of
Annual Member
or Casual Member
- in data from 2018, this is
user_type