Name: Cyclistic Ride Data - Aug 2024 To Jul 2025
Creator: Kaggle
License: http://opendatacommons.org/licenses/odbl/1.0/

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

25.5 MB
755639 rows
13 columns


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

27.5 MB
821276 rows
13 columns


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

20.49 MB
616281 rows
13 columns


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

11.68 MB
335075 rows
13 columns


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.03 MB
178372 rows
13 columns


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

4.91 MB
138689 rows
13 columns


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.22 MB
151880 rows
13 columns


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

9.98 MB
298155 rows
13 columns


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

12.66 MB
371341 rows
13 columns


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.08 MB
502456 rows
13 columns


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

22.89 MB
678904 rows
13 columns


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

25.54 MB
763432 rows
13 columns


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
);