Name: Cyclistic Rider Behavior Analysis & Membership
Creator: Kaggle
License: https://opendatacommons.org/licenses/pddl/1.0/

About this Dataset

Cyclistic Rider Behavior Analysis & Membership

This dataset is a cleaned and aggregated summary of Cyclistic bike-share usage, segmented by rider type and day of the week. It was extracted from the larger(all_trips_V2) dataset and prepared for executive-level analysis.

Tables

Avg Ride Length

@kaggle.emmanueldansoagyei_cyclistic_dataset.avg_ride_length

4.28 kB
14 rows
4 columns

CREATE TABLE avg_ride_length (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "all_trips_v2_member_casual" VARCHAR,
  "all_trips_v2_day_of_week" VARCHAR,
  "all_trips_v2_ride_length" DOUBLE
);

Counts

@kaggle.emmanueldansoagyei_cyclistic_dataset.counts

3.52 kB
14 rows
3 columns

CREATE TABLE counts (
  "all_trips_v2_member_casual" VARCHAR,
  "all_trips_v2_day_of_week" VARCHAR,
  "all_trips_v2_ride_length" DOUBLE
);

Divvy 2019

@kaggle.emmanueldansoagyei_cyclistic_dataset.divvy_2019

12.1 MB
365,069 rows
12 columns

CREATE TABLE divvy_2019 (
  "trip_id" BIGINT,
  "start_time" TIMESTAMP,
  "end_time" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" DOUBLE,
  "from_station_id" BIGINT,
  "from_station_name" VARCHAR,
  "to_station_id" BIGINT,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR,
  "gender" VARCHAR,
  "birthyear" DOUBLE
);

Divvy 2020

@kaggle.emmanueldansoagyei_cyclistic_dataset.divvy_2020

20.37 MB
426,887 rows
13 columns

CREATE TABLE divvy_2020 (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" BIGINT,
  "end_station_name" VARCHAR,
  "end_station_id" DOUBLE,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

Divvy Trips 2019 Q1

@kaggle.emmanueldansoagyei_cyclistic_dataset.divvy_trips_2019_q1

12.1 MB
365,069 rows
12 columns

CREATE TABLE divvy_trips_2019_q1 (
  "trip_id" BIGINT,
  "start_time" TIMESTAMP,
  "end_time" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" DOUBLE,
  "from_station_id" BIGINT,
  "from_station_name" VARCHAR,
  "to_station_id" BIGINT,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR,
  "gender" VARCHAR,
  "birthyear" DOUBLE
);

Divvy Trips 2020 Q1

@kaggle.emmanueldansoagyei_cyclistic_dataset.divvy_trips_2020_q1

20.37 MB
426,887 rows
13 columns

CREATE TABLE divvy_trips_2020_q1 (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" BIGINT,
  "end_station_name" VARCHAR,
  "end_station_id" DOUBLE,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);