Baselight
Sign In

Cyclist Bike Share

Google Data Analytics Capstone Project

@kaggle.sagarmohodkaggle_cyclist_bike_share_dataset_2022_04_2023_07

Loading...
Loading...

About this Dataset

Cyclist Bike Share

These datasets are used for the case study as the capstone project in Google Data Analytics course on Coursera.

The datasets have a different name because Cyclistic is a fictional company. For the purposes of this case study, the datasets are appropriate and will enable you to answer the business questions. The data has been made available by Motivate International Inc. under this licence

This is public data (can be verified from the original dataset) that you can use to explore how different customer types are using Cyclistic bikes. But note that data-privacy issues prohibit you from using riders’ personally identifiable information. This means that you won’t be able to connect pass purchases to credit card numbers to determine if casual riders live in the Cyclistic service area or if they have purchased multiple single passes.

Tables

N 202204 Divvy Tripdata

@kaggle.sagarmohodkaggle_cyclist_bike_share_dataset_2022_04_2023_07.n_202204_divvy_tripdata
  • 18.67 MB
  • 371,249 rows
  • 13 columns
Loading... 
CREATE TABLE n_202204_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 202205 Divvy Tripdata

@kaggle.sagarmohodkaggle_cyclist_bike_share_dataset_2022_04_2023_07.n_202205_divvy_tripdata
  • 31.33 MB
  • 634,858 rows
  • 13 columns
Loading... 
CREATE TABLE n_202205_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 202206 Divvy Tripdata

@kaggle.sagarmohodkaggle_cyclist_bike_share_dataset_2022_04_2023_07.n_202206_divvy_tripdata
  • 37.52 MB
  • 769,204 rows
  • 13 columns
Loading... 
CREATE TABLE n_202206_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 202207 Divvy Tripdata

@kaggle.sagarmohodkaggle_cyclist_bike_share_dataset_2022_04_2023_07.n_202207_divvy_tripdata
  • 41.31 MB
  • 823,488 rows
  • 13 columns
Loading... 
CREATE TABLE n_202207_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 202208 Divvy Tripdata

@kaggle.sagarmohodkaggle_cyclist_bike_share_dataset_2022_04_2023_07.n_202208_divvy_tripdata
  • 39.81 MB
  • 785,932 rows
  • 13 columns
Loading... 
CREATE TABLE n_202208_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 202209 Divvy Tripdata

@kaggle.sagarmohodkaggle_cyclist_bike_share_dataset_2022_04_2023_07.n_202209_divvy_tripdata
  • 35.42 MB
  • 701,339 rows
  • 13 columns
Loading... 
CREATE TABLE n_202209_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 202210 Divvy Tripdata

@kaggle.sagarmohodkaggle_cyclist_bike_share_dataset_2022_04_2023_07.n_202210_divvy_tripdata
  • 28.36 MB
  • 558,685 rows
  • 13 columns
Loading... 
CREATE TABLE n_202210_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 202211 Divvy Tripdata

@kaggle.sagarmohodkaggle_cyclist_bike_share_dataset_2022_04_2023_07.n_202211_divvy_tripdata
  • 17.49 MB
  • 337,735 rows
  • 13 columns
Loading... 
CREATE TABLE n_202211_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 202212 Divvy Tripdata

@kaggle.sagarmohodkaggle_cyclist_bike_share_dataset_2022_04_2023_07.n_202212_divvy_tripdata
  • 9.55 MB
  • 181,806 rows
  • 13 columns
Loading... 
CREATE TABLE n_202212_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 202301 Divvy Tripdata

@kaggle.sagarmohodkaggle_cyclist_bike_share_dataset_2022_04_2023_07.n_202301_divvy_tripdata
  • 9.63 MB
  • 190,301 rows
  • 13 columns
Loading... 
CREATE TABLE n_202301_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 202302 Divvy Tripdata

@kaggle.sagarmohodkaggle_cyclist_bike_share_dataset_2022_04_2023_07.n_202302_divvy_tripdata
  • 9.7 MB
  • 190,445 rows
  • 13 columns
Loading... 
CREATE TABLE n_202302_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 202303 Divvy Tripdata

@kaggle.sagarmohodkaggle_cyclist_bike_share_dataset_2022_04_2023_07.n_202303_divvy_tripdata
  • 13.54 MB
  • 258,678 rows
  • 13 columns
Loading... 
CREATE TABLE n_202303_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 202304 Divvy Tripdata

@kaggle.sagarmohodkaggle_cyclist_bike_share_dataset_2022_04_2023_07.n_202304_divvy_tripdata
  • 22.05 MB
  • 426,590 rows
  • 13 columns
Loading... 
CREATE TABLE n_202304_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 202305 Divvy Tripdata

@kaggle.sagarmohodkaggle_cyclist_bike_share_dataset_2022_04_2023_07.n_202305_divvy_tripdata
  • 31.47 MB
  • 604,827 rows
  • 13 columns
Loading... 
CREATE TABLE n_202305_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 202306 Divvy Tripdata

@kaggle.sagarmohodkaggle_cyclist_bike_share_dataset_2022_04_2023_07.n_202306_divvy_tripdata
  • 37.14 MB
  • 719,618 rows
  • 13 columns
Loading... 
CREATE TABLE n_202306_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 202307 Divvy Tripdata

@kaggle.sagarmohodkaggle_cyclist_bike_share_dataset_2022_04_2023_07.n_202307_divvy_tripdata
  • 39.07 MB
  • 767,650 rows
  • 13 columns
Loading... 
CREATE TABLE n_202307_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.