Divvy Trips Sample Dataset
Bike-Share Case Study: Using Customer Data to Guide Business Strategy
@kaggle.odesanyawasiu_divvy_trips_sample_dataset
Bike-Share Case Study: Using Customer Data to Guide Business Strategy
@kaggle.odesanyawasiu_divvy_trips_sample_dataset
CREATE TABLE divvy_trips_2019_q1_version (
"trip_id" BIGINT,
"start_time" TIMESTAMP,
"end_time" TIMESTAMP,
"bikeid" BIGINT,
"tripduration" DOUBLE,
"from_station_id" BIGINT,
"from_station_name" VARCHAR,
"to_station_id" BIGINT,
"to_station_name" VARCHAR,
"usertype" VARCHAR,
"gender" VARCHAR,
"birthyear" DOUBLE,
"ride_length" VARCHAR,
"day_of_week" BIGINT
);
CREATE TABLE divvy_trips_2020_q1_version (
"ride_id" VARCHAR,
"rideable_type" VARCHAR,
"started_at" TIMESTAMP,
"ended_at" TIMESTAMP,
"start_station_name" VARCHAR,
"start_station_id" BIGINT,
"end_station_name" VARCHAR,
"end_station_id" DOUBLE,
"start_lat" DOUBLE,
"start_lng" DOUBLE,
"end_lat" DOUBLE,
"end_lng" DOUBLE,
"member_casual" VARCHAR,
"ride_length" VARCHAR,
"day_of_week" BIGINT
);
Anyone who has the link will be able to view this.