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.59 MB
190,301 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.65 MB
190,445 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

8.12 MB
258,678 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.76 MB
426,590 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

18.48 MB
604,827 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

21.78 MB
719,618 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

23.31 MB
767,650 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

23.58 MB
771,693 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

20.39 MB
666,371 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

16.28 MB
537,113 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.97 MB
362,518 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.96 MB
224,073 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
);