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 202211 Divvy Tripdata

@kaggle.luissanzetenea_cyclist_a_bikeshare_company_2022.n_202211_divvy_tripdata
  • 16.68 MB
  • 337735 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 202210 Divvy Tripdata

@kaggle.luissanzetenea_cyclist_a_bikeshare_company_2022.n_202210_divvy_tripdata
  • 27.04 MB
  • 558685 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 202209 Divvy Tripdata

@kaggle.luissanzetenea_cyclist_a_bikeshare_company_2022.n_202209_divvy_tripdata
  • 33.78 MB
  • 701339 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 202203 Divvy Tripdata

@kaggle.luissanzetenea_cyclist_a_bikeshare_company_2022.n_202203_divvy_tripdata
  • 13.58 MB
  • 284042 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
  • 17.81 MB
  • 371249 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 202202 Divvy Tripdata

@kaggle.luissanzetenea_cyclist_a_bikeshare_company_2022.n_202202_divvy_tripdata
  • 5.83 MB
  • 115609 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 202205 Divvy Tripdata

@kaggle.luissanzetenea_cyclist_a_bikeshare_company_2022.n_202205_divvy_tripdata
  • 29.88 MB
  • 634858 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 202207 Divvy Tripdata

@kaggle.luissanzetenea_cyclist_a_bikeshare_company_2022.n_202207_divvy_tripdata
  • 39.4 MB
  • 823488 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 202206 Divvy Tripdata

@kaggle.luissanzetenea_cyclist_a_bikeshare_company_2022.n_202206_divvy_tripdata
  • 35.78 MB
  • 769204 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 202201 Divvy Tripdata

@kaggle.luissanzetenea_cyclist_a_bikeshare_company_2022.n_202201_divvy_tripdata
  • 5.28 MB
  • 103770 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 202212 Divvy Tripdata

@kaggle.luissanzetenea_cyclist_a_bikeshare_company_2022.n_202212_divvy_tripdata
  • 9.11 MB
  • 181806 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 202208 Divvy Tripdata

@kaggle.luissanzetenea_cyclist_a_bikeshare_company_2022.n_202208_divvy_tripdata
  • 37.96 MB
  • 785932 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
);

Share link

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