Dataset: Cyclistic Bike Share

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

157.76 MB
3541683 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

269.07 MB
5595063 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

265.34 MB
5667717 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
);