Baselight
Sign In

Google Cyclistics Dataset (Jan To Dec 2021 )

Google Capstone project - Divvy ride share data set

@kaggle.shadymehany_google_cyclistics_dataset_jan_to_dec_2021

Loading...
Loading...

About this Dataset

Google Cyclistics Dataset (Jan To Dec 2021 )

Context

This data set is a part of Google data analytics course capstone project, aiming to study the difference in behavior between casual and member riders of a bike ride share company (Cyclistic) in order to help the marketing team achieve their goal of converting casual riders to members.

Content

The data set contains data about every ride between January 2021 till December 2021 .

Tables

N 202101 Divvy Tripdata

@kaggle.shadymehany_google_cyclistics_dataset_jan_to_dec_2021.n_202101_divvy_tripdata
  • 5.19 MB
  • 96834 rows
  • 13 columns
Loading... 

CREATE TABLE n_202101_divvy_tripdata (
  "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 202102 Divvy Tripdata

@kaggle.shadymehany_google_cyclistics_dataset_jan_to_dec_2021.n_202102_divvy_tripdata
  • 2.64 MB
  • 49622 rows
  • 13 columns
Loading... 

CREATE TABLE n_202102_divvy_tripdata (
  "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 202103 Divvy Tripdata

@kaggle.shadymehany_google_cyclistics_dataset_jan_to_dec_2021.n_202103_divvy_tripdata
  • 11.05 MB
  • 228496 rows
  • 13 columns
Loading... 

CREATE TABLE n_202103_divvy_tripdata (
  "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 202104 Divvy Tripdata

@kaggle.shadymehany_google_cyclistics_dataset_jan_to_dec_2021.n_202104_divvy_tripdata
  • 16.56 MB
  • 337230 rows
  • 13 columns
Loading... 

CREATE TABLE n_202104_divvy_tripdata (
  "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 202105 Divvy Tripdata

@kaggle.shadymehany_google_cyclistics_dataset_jan_to_dec_2021.n_202105_divvy_tripdata
  • 25.97 MB
  • 531633 rows
  • 13 columns
Loading... 

CREATE TABLE n_202105_divvy_tripdata (
  "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 202106 Divvy Tripdata

@kaggle.shadymehany_google_cyclistics_dataset_jan_to_dec_2021.n_202106_divvy_tripdata
  • 35.93 MB
  • 729595 rows
  • 13 columns
Loading... 

CREATE TABLE n_202106_divvy_tripdata (
  "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 202107 Divvy Tripdata

@kaggle.shadymehany_google_cyclistics_dataset_jan_to_dec_2021.n_202107_divvy_tripdata
  • 39.71 MB
  • 822410 rows
  • 13 columns
Loading... 

CREATE TABLE n_202107_divvy_tripdata (
  "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 202108 Divvy Tripdata

@kaggle.shadymehany_google_cyclistics_dataset_jan_to_dec_2021.n_202108_divvy_tripdata
  • 38.55 MB
  • 804352 rows
  • 13 columns
Loading... 

CREATE TABLE n_202108_divvy_tripdata (
  "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 202109 Divvy Tripdata

@kaggle.shadymehany_google_cyclistics_dataset_jan_to_dec_2021.n_202109_divvy_tripdata
  • 36.98 MB
  • 756147 rows
  • 13 columns
Loading... 

CREATE TABLE n_202109_divvy_tripdata (
  "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 202110 Divvy Tripdata

@kaggle.shadymehany_google_cyclistics_dataset_jan_to_dec_2021.n_202110_divvy_tripdata
  • 32.2 MB
  • 631226 rows
  • 13 columns
Loading... 

CREATE TABLE n_202110_divvy_tripdata (
  "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 202111 Divvy Tripdata

@kaggle.shadymehany_google_cyclistics_dataset_jan_to_dec_2021.n_202111_divvy_tripdata
  • 19.25 MB
  • 359978 rows
  • 13 columns
Loading... 

CREATE TABLE n_202111_divvy_tripdata (
  "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 202112 Divvy Tripdata

@kaggle.shadymehany_google_cyclistics_dataset_jan_to_dec_2021.n_202112_divvy_tripdata
  • 12.62 MB
  • 247540 rows
  • 13 columns
Loading... 

CREATE TABLE n_202112_divvy_tripdata (
  "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
);

Share link

Anyone who has the link will be able to view this.