Cyclist Bike Share
Google Data Analytics Capstone Project
@kaggle.sagarmohodkaggle_cyclist_bike_share_dataset_2022_04_2023_07
Google Data Analytics Capstone Project
@kaggle.sagarmohodkaggle_cyclist_bike_share_dataset_2022_04_2023_07
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_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_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_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_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
);
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_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
);
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_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_202306_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_202307_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_202305_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_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
);
Anyone who has the link will be able to view this.