Dataset: CyclisticBikeShare

About this Dataset

CyclisticBikeShare

This is Divvy data set for Google cyclistic bikeshare case study, I've uploaded only two files as a sample dataset.
The goal is to design marketing strategies aimed at converting casual riders into annual members. In order to do that, we need to understand how casual riders and annual members use Cyclistic bikes differently.

Tables

N 2021–01

@kaggle.waleedmohamedhassan_cyclisticbikeshare.n_2021_01

5.19 MB
96834 rows
13 columns


CREATE TABLE n_2021_01 (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "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 2021–02

@kaggle.waleedmohamedhassan_cyclisticbikeshare.n_2021_02

2.64 MB
49622 rows
13 columns


CREATE TABLE n_2021_02 (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "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
);