Cyclistic Trip Data
Data on trips made between May 2022 through April 2023
@kaggle.josesantibanez_cyclistic_trip_data
Data on trips made between May 2022 through April 2023
@kaggle.josesantibanez_cyclistic_trip_data
These datasets are used for the purpose of analyzing and answering the capstone business questions of the professional data analytics certification through Coursera.
This is public data that was provided by Motivate International Inc.
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
);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
);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
);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
);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
);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
);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
);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
);CREATE TABLE n_202301_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
);CREATE TABLE n_202302_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
);CREATE TABLE n_202303_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
);CREATE TABLE n_202304_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
);Anyone who has the link will be able to view this.