Baselight
Sign In

Cyclist-a-Bikeshare-Company-2022

This Divvy data leads to the Capstone Project of a Google Data Analytics course

@kaggle.luissanzetenea_cyclist_a_bikeshare_company_2022

Loading...
Loading...

About this Dataset

Cyclist-a-Bikeshare-Company-2022

This is Divvy data to conduct into a single dataset, which will help answer the main question to our stakeholders: "In what ways do annual members and casual riders use Divvy bikes differently?
There are 7 characters, 4 numeric, and 2 timestamp data types.

Tables

N 202201 Divvy Tripdata

@kaggle.luissanzetenea_cyclist_a_bikeshare_company_2022.n_202201_divvy_tripdata
  • 5.54 MB
  • 103,770 rows
  • 13 columns
Loading... 
CREATE TABLE n_202201_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 202202 Divvy Tripdata

@kaggle.luissanzetenea_cyclist_a_bikeshare_company_2022.n_202202_divvy_tripdata
  • 6.11 MB
  • 115,609 rows
  • 13 columns
Loading... 
CREATE TABLE n_202202_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 202203 Divvy Tripdata

@kaggle.luissanzetenea_cyclist_a_bikeshare_company_2022.n_202203_divvy_tripdata
  • 14.24 MB
  • 284,042 rows
  • 13 columns
Loading... 
CREATE TABLE n_202203_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 202204 Divvy Tripdata

@kaggle.luissanzetenea_cyclist_a_bikeshare_company_2022.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.luissanzetenea_cyclist_a_bikeshare_company_2022.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.luissanzetenea_cyclist_a_bikeshare_company_2022.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.luissanzetenea_cyclist_a_bikeshare_company_2022.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.luissanzetenea_cyclist_a_bikeshare_company_2022.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.luissanzetenea_cyclist_a_bikeshare_company_2022.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.luissanzetenea_cyclist_a_bikeshare_company_2022.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.luissanzetenea_cyclist_a_bikeshare_company_2022.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.luissanzetenea_cyclist_a_bikeshare_company_2022.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
);

Share link

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