Baselight
Sign In

Cyclistic Ride Data - Aug 2024 To Jul 2025

Cyclistic bike-share analysis case study! Used in Google Data Analytics Capstone

@kaggle.hshah724_cyclistic_ride_data_aug_2024_to_jul_2025

Loading...
Loading...

About this Dataset

Cyclistic Ride Data - Aug 2024 To Jul 2025

Cyclistic is a bike-share program that features more than 5,800 bicycles and 600 docking stations. The director of marketing of the company has set a clear goal, to convert casual riders into annual members, which will make the company earn more profits. In order to do that the analyst team needs to better understand how annual and casual riders differ, why casual riders would buy a membership, and how digital media could affect the marketing tactics. So the marketing director wants to guide the future program with the following 3 question:

How do annual members and casual riders use Cyclistic bikes differently?
Why would casual riders buy Cyclistic annual memberships?
How can Cyclistic use digital media to influence casual riders to become members?

Data Source: https://divvy-tripdata.s3.amazonaws.com/index.html
Data License Agreement: https://www.divvybikes.com/data-license-agreement

Tables

N 202408 Divvy Tripdata

@kaggle.hshah724_cyclistic_ride_data_aug_2024_to_jul_2025.n_202408_divvy_tripdata
  • 26.74 MB
  • 755,639 rows
  • 13 columns
Loading... 
CREATE TABLE n_202408_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" VARCHAR,
  "ended_at" VARCHAR,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202409 Divvy Tripdata

@kaggle.hshah724_cyclistic_ride_data_aug_2024_to_jul_2025.n_202409_divvy_tripdata
  • 28.83 MB
  • 821,276 rows
  • 13 columns
Loading... 
CREATE TABLE n_202409_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" VARCHAR,
  "ended_at" VARCHAR,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202410 Divvy Tripdata

@kaggle.hshah724_cyclistic_ride_data_aug_2024_to_jul_2025.n_202410_divvy_tripdata
  • 21.48 MB
  • 616,281 rows
  • 13 columns
Loading... 
CREATE TABLE n_202410_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" VARCHAR,
  "ended_at" VARCHAR,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202411 Divvy Tripdata

@kaggle.hshah724_cyclistic_ride_data_aug_2024_to_jul_2025.n_202411_divvy_tripdata
  • 12.25 MB
  • 335,075 rows
  • 13 columns
Loading... 
CREATE TABLE n_202411_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" VARCHAR,
  "ended_at" VARCHAR,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202412 Divvy Tripdata

@kaggle.hshah724_cyclistic_ride_data_aug_2024_to_jul_2025.n_202412_divvy_tripdata
  • 6.33 MB
  • 178,372 rows
  • 13 columns
Loading... 
CREATE TABLE n_202412_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" VARCHAR,
  "ended_at" VARCHAR,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202501 Divvy Tripdata

@kaggle.hshah724_cyclistic_ride_data_aug_2024_to_jul_2025.n_202501_divvy_tripdata
  • 5.14 MB
  • 138,689 rows
  • 13 columns
Loading... 
CREATE TABLE n_202501_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" VARCHAR,
  "ended_at" VARCHAR,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202502 Divvy Tripdata

@kaggle.hshah724_cyclistic_ride_data_aug_2024_to_jul_2025.n_202502_divvy_tripdata
  • 5.48 MB
  • 151,880 rows
  • 13 columns
Loading... 
CREATE TABLE n_202502_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" VARCHAR,
  "ended_at" VARCHAR,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202503 Divvy Tripdata

@kaggle.hshah724_cyclistic_ride_data_aug_2024_to_jul_2025.n_202503_divvy_tripdata
  • 10.46 MB
  • 298,155 rows
  • 13 columns
Loading... 
CREATE TABLE n_202503_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" VARCHAR,
  "ended_at" VARCHAR,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202504 Divvy Tripdata

@kaggle.hshah724_cyclistic_ride_data_aug_2024_to_jul_2025.n_202504_divvy_tripdata
  • 13.27 MB
  • 371,341 rows
  • 13 columns
Loading... 
CREATE TABLE n_202504_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" VARCHAR,
  "ended_at" VARCHAR,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202505 Divvy Tripdata

@kaggle.hshah724_cyclistic_ride_data_aug_2024_to_jul_2025.n_202505_divvy_tripdata
  • 17.91 MB
  • 502,456 rows
  • 13 columns
Loading... 
CREATE TABLE n_202505_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" VARCHAR,
  "ended_at" VARCHAR,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202506 Divvy Tripdata

@kaggle.hshah724_cyclistic_ride_data_aug_2024_to_jul_2025.n_202506_divvy_tripdata
  • 24 MB
  • 678,904 rows
  • 13 columns
Loading... 
CREATE TABLE n_202506_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" VARCHAR,
  "ended_at" VARCHAR,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202507 Divvy Tripdata

@kaggle.hshah724_cyclistic_ride_data_aug_2024_to_jul_2025.n_202507_divvy_tripdata
  • 26.78 MB
  • 763,432 rows
  • 13 columns
Loading... 
CREATE TABLE n_202507_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" VARCHAR,
  "ended_at" VARCHAR,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

Share link

Anyone who has the link will be able to view this.