Name: Cyclistic 2023
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Cyclistic 2023

This case study uses first party data from a bikeshare company called Divvy to evaluate the behaviour of sharebike users in the city of Chicago in 2023 and determine the difference in behaviour between casual riders and members. Causes for these differences were theorized and an action plan and recommendations for the company were provided

Tables

N 202301 Divvy Tripdata Cleaned

@kaggle.shintarosneath_cyclistic_2023.n_202301_divvy_tripdata_cleaned

5.33 MB
190301 rows
11 columns


CREATE TABLE n_202301_divvy_tripdata_cleaned (
  "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,
  "member_casual" VARCHAR,
  "ride_length" VARCHAR,
  "day_of_week" BIGINT
);

N 202302 Divvy Tripdata Cleaned

@kaggle.shintarosneath_cyclistic_2023.n_202302_divvy_tripdata_cleaned

5.39 MB
190445 rows
11 columns


CREATE TABLE n_202302_divvy_tripdata_cleaned (
  "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,
  "member_casual" VARCHAR,
  "ride_length" VARCHAR,
  "day_of_week" BIGINT
);

N 202303 Divvy Tripdata Cleaned

@kaggle.shintarosneath_cyclistic_2023.n_202303_divvy_tripdata_cleaned

7.74 MB
258678 rows
11 columns


CREATE TABLE n_202303_divvy_tripdata_cleaned (
  "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,
  "member_casual" VARCHAR,
  "ride_length" VARCHAR,
  "day_of_week" BIGINT
);

N 202304 Divvy Tripdata Cleaned

@kaggle.shintarosneath_cyclistic_2023.n_202304_divvy_tripdata_cleaned

12.17 MB
426590 rows
11 columns


CREATE TABLE n_202304_divvy_tripdata_cleaned (
  "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,
  "member_casual" VARCHAR,
  "ride_length" VARCHAR,
  "day_of_week" BIGINT
);

N 202305 Divvy Tripdata Cleaned

@kaggle.shintarosneath_cyclistic_2023.n_202305_divvy_tripdata_cleaned

17.62 MB
604827 rows
11 columns


CREATE TABLE n_202305_divvy_tripdata_cleaned (
  "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,
  "member_casual" VARCHAR,
  "ride_length" VARCHAR,
  "day_of_week" BIGINT
);

N 202306 Divvy Tripdata Cleaned

@kaggle.shintarosneath_cyclistic_2023.n_202306_divvy_tripdata_cleaned

20.77 MB
719618 rows
11 columns


CREATE TABLE n_202306_divvy_tripdata_cleaned (
  "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,
  "member_casual" VARCHAR,
  "ride_length" VARCHAR,
  "day_of_week" BIGINT
);

N 202307 Divvy Tripdata Cleaned

@kaggle.shintarosneath_cyclistic_2023.n_202307_divvy_tripdata_cleaned

22.23 MB
767650 rows
11 columns


CREATE TABLE n_202307_divvy_tripdata_cleaned (
  "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,
  "member_casual" VARCHAR,
  "ride_length" VARCHAR,
  "day_of_week" BIGINT
);

N 202308 Divvy Tripdata Cleaned

@kaggle.shintarosneath_cyclistic_2023.n_202308_divvy_tripdata_cleaned

22.49 MB
771693 rows
11 columns


CREATE TABLE n_202308_divvy_tripdata_cleaned (
  "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,
  "member_casual" VARCHAR,
  "ride_length" VARCHAR,
  "day_of_week" BIGINT
);

N 202309 Divvy Tripdata Cleaned

@kaggle.shintarosneath_cyclistic_2023.n_202309_divvy_tripdata_cleaned

19.45 MB
666371 rows
11 columns


CREATE TABLE n_202309_divvy_tripdata_cleaned (
  "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,
  "member_casual" VARCHAR,
  "ride_length" VARCHAR,
  "day_of_week" BIGINT
);

N 202310 Divvy Tripdata Cleaned

@kaggle.shintarosneath_cyclistic_2023.n_202310_divvy_tripdata_cleaned

15.53 MB
537113 rows
11 columns


CREATE TABLE n_202310_divvy_tripdata_cleaned (
  "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,
  "member_casual" VARCHAR,
  "ride_length" VARCHAR,
  "day_of_week" BIGINT
);

N 202311 Divvy Tripdata Cleaned

@kaggle.shintarosneath_cyclistic_2023.n_202311_divvy_tripdata_cleaned

10.47 MB
362518 rows
11 columns


CREATE TABLE n_202311_divvy_tripdata_cleaned (
  "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,
  "member_casual" VARCHAR,
  "ride_length" VARCHAR,
  "day_of_week" BIGINT
);

N 202312 Divvy Tripdata Cleaned

@kaggle.shintarosneath_cyclistic_2023.n_202312_divvy_tripdata_cleaned

6.63 MB
224073 rows
11 columns


CREATE TABLE n_202312_divvy_tripdata_cleaned (
  "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,
  "member_casual" VARCHAR,
  "ride_length" VARCHAR,
  "day_of_week" BIGINT
);