Cyclistic Capstone Project
Google Analytics Certification
@kaggle.shane3martin_cyclist_capstone_project
Google Analytics Certification
@kaggle.shane3martin_cyclist_capstone_project
CREATE TABLE n_202008_divvy_tripdata (
"ride_id" VARCHAR,
"rideable_type" VARCHAR,
"started_at" TIMESTAMP,
"ended_at" TIMESTAMP,
"start_station_name" VARCHAR,
"start_station_id" DOUBLE,
"end_station_name" VARCHAR,
"end_station_id" DOUBLE,
"start_lat" DOUBLE,
"start_lng" DOUBLE,
"end_lat" DOUBLE,
"end_lng" DOUBLE,
"member_casual" VARCHAR
);
CREATE TABLE n_202009_divvy_tripdata (
"ride_id" VARCHAR,
"rideable_type" VARCHAR,
"started_at" TIMESTAMP,
"ended_at" TIMESTAMP,
"start_station_name" VARCHAR,
"start_station_id" DOUBLE,
"end_station_name" VARCHAR,
"end_station_id" DOUBLE,
"start_lat" DOUBLE,
"start_lng" DOUBLE,
"end_lat" DOUBLE,
"end_lng" DOUBLE,
"member_casual" VARCHAR
);
CREATE TABLE summerbikerides (
"ride_id" VARCHAR,
"rideable_type" VARCHAR,
"started_at" TIMESTAMP,
"ended_at" TIMESTAMP,
"ride_length" VARCHAR,
"weekday" VARCHAR,
"member_casual" VARCHAR,
"date" TIMESTAMP,
"month" BIGINT,
"day" BIGINT,
"year" BIGINT
);
CREATE TABLE winterbikerides (
"ride_id" VARCHAR,
"rideable_type" VARCHAR,
"started_at" TIMESTAMP,
"ended_at" TIMESTAMP,
"ride_length" BIGINT,
"weekday" VARCHAR,
"member_casual" VARCHAR,
"date" TIMESTAMP,
"month" BIGINT,
"day" BIGINT,
"year" BIGINT
);
Anyone who has the link will be able to view this.