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

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.45 MB
96,834 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.77 MB
49,622 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
);