Baselight
Sign In

Cyclistic 2024 Dataset

Capstone Project for Google Data Analytics Course

@kaggle.jonathanmcilwaine_cyclistic_2024_dataset

Loading...
Loading...

About this Dataset

Cyclistic 2024 Dataset

This dataset is twelve months of data made available by Motivate International Inc. under this license. It is used for the capstone project of the Google Data Analytics Certificate course, on Coursera.
The dataset is given the fictional company name of Cyclistic. For the case study, the datasets are appropriate for the use of the capstone project and will enable you to answer the business questions.
This is public data 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 202403 Divvy Tripdata

@kaggle.jonathanmcilwaine_cyclistic_2024_dataset.n_202403_divvy_tripdata
  • 14.82 MB
  • 301687 rows
  • 13 columns
Loading... 

CREATE TABLE n_202403_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 202409 Divvy Tripdata

@kaggle.jonathanmcilwaine_cyclistic_2024_dataset.n_202409_divvy_tripdata
  • 35.6 MB
  • 821276 rows
  • 13 columns
Loading... 

CREATE TABLE n_202409_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 202406 Divvy Tripdata

@kaggle.jonathanmcilwaine_cyclistic_2024_dataset.n_202406_divvy_tripdata
  • 33.75 MB
  • 710721 rows
  • 13 columns
Loading... 

CREATE TABLE n_202406_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 202405 Divvy Tripdata

@kaggle.jonathanmcilwaine_cyclistic_2024_dataset.n_202405_divvy_tripdata
  • 29.5 MB
  • 609493 rows
  • 13 columns
Loading... 

CREATE TABLE n_202405_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 202408 Divvy Tripdata

@kaggle.jonathanmcilwaine_cyclistic_2024_dataset.n_202408_divvy_tripdata
  • 33.16 MB
  • 755639 rows
  • 13 columns
Loading... 

CREATE TABLE n_202408_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 202402 Divvy Tripdata

@kaggle.jonathanmcilwaine_cyclistic_2024_dataset.n_202402_divvy_tripdata
  • 10.76 MB
  • 223164 rows
  • 13 columns
Loading... 

CREATE TABLE n_202402_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 202411 Divvy Tripdata

@kaggle.jonathanmcilwaine_cyclistic_2024_dataset.n_202411_divvy_tripdata
  • 15.09 MB
  • 335075 rows
  • 13 columns
Loading... 

CREATE TABLE n_202411_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 202412 Divvy Tripdata

@kaggle.jonathanmcilwaine_cyclistic_2024_dataset.n_202412_divvy_tripdata
  • 8.05 MB
  • 178372 rows
  • 13 columns
Loading... 

CREATE TABLE n_202412_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 202401 Divvy Tripdata

@kaggle.jonathanmcilwaine_cyclistic_2024_dataset.n_202401_divvy_tripdata
  • 7.22 MB
  • 144873 rows
  • 13 columns
Loading... 

CREATE TABLE n_202401_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 202407 Divvy Tripdata

@kaggle.jonathanmcilwaine_cyclistic_2024_dataset.n_202407_divvy_tripdata
  • 33.84 MB
  • 748962 rows
  • 13 columns
Loading... 

CREATE TABLE n_202407_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 202410 Divvy Tripdata

@kaggle.jonathanmcilwaine_cyclistic_2024_dataset.n_202410_divvy_tripdata
  • 26.67 MB
  • 616281 rows
  • 13 columns
Loading... 

CREATE TABLE n_202410_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 202404 Divvy Tripdata

@kaggle.jonathanmcilwaine_cyclistic_2024_dataset.n_202404_divvy_tripdata
  • 20.36 MB
  • 415025 rows
  • 13 columns
Loading... 

CREATE TABLE n_202404_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.