Name: Cyclistic Bike Share
Creator: Kaggle
License: http://opendatacommons.org/licenses/odbl/1.0/

About this Dataset

Cyclistic Bike Share

This dataset is used for the capstone project of the Google Data Analytics Professional Certificate.

Cyclistic’s historical trip data to analyze and identify trends. The data can be accessed from the provider via this link. (Note: 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 license.)

The data included in this dataset correspond to the period between January 1st, 2020, and December 31st, 2022.
The data was aggregated using SQL in BigQuery to create one CSV file per year accordingly.

Tables

Cyclistic Tripdata 2020

@kaggle.yoaquingarcaluna_cyclistic_bike_share.cyclistic_tripdata_2020

165.42 MB
3,541,683 rows
13 columns

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

Cyclistic Tripdata 2021

@kaggle.yoaquingarcaluna_cyclistic_bike_share.cyclistic_tripdata_2021

282.15 MB
5,595,063 rows
13 columns

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

Cyclistic Tripdata 2022

@kaggle.yoaquingarcaluna_cyclistic_bike_share.cyclistic_tripdata_2022

278.23 MB
5,667,717 rows
13 columns

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