Cyclistic Bike-Share Data Analysis Case Study

Google Data Analytics Capstone: Case Study 1

@kaggle.mregoyau_google_case_study_1

Table List

12 tables(272.12 MB)

N 202201 Divvy Tripdata

N 202202 Divvy Tripdata

N 202203 Divvy Tripdata

N 202204 Divvy Tripdata

N 202205 Divvy Tripdata

N 202206 Divvy Tripdata

N 202207 Divvy Tripdata

N 202208 Divvy Tripdata

N 202209 Divvy Tripdata

N 202210 Divvy Tripdata

N 202211 Divvy Tripdata

N 202212 Divvy Tripdata

N 202205 Divvy Tripdata

@kaggle.mregoyau_google_case_study_1.n_202205_divvy_tripdata

29.88 MB
634858 rows
13 columns

ride_id Ride Id	rideable_type Rideable Type	started_at Started At	ended_at Ended At	start_station_name Start Station Name	start_station_id Start Station Id	end_station_name End Station Name	end_station_id End Station Id	start_lat Start Lat	start_lng Start Lng	end_lat End Lat	end_lng End Lng	member_casual Member Casual
EC2DE40644C6B0F4	classic_bike	Mon May 23 2022 23:06:58 GMT+0000 (Coordinated Universal Time)	Mon May 23 2022 23:40:19 GMT+0000 (Coordinated Universal Time)	Wabash Ave & Grand Ave	TA1307000117	Halsted St & Roscoe St	TA1309000025	41.891466	-87.626761	41.94367	-87.64895	member
1C31AD03897EE385	classic_bike	Wed May 11 2022 08:53:28 GMT+0000 (Coordinated Universal Time)	Wed May 11 2022 09:31:22 GMT+0000 (Coordinated Universal Time)	DuSable Lake Shore Dr & Monroe St	13300	Field Blvd & South Water St	15534	41.880958	-87.616743	41.88634906269	-87.6175165471	member
1542FBEC830415CF	classic_bike	Thu May 26 2022 18:36:28 GMT+0000 (Coordinated Universal Time)	Thu May 26 2022 18:58:18 GMT+0000 (Coordinated Universal Time)	Clinton St & Madison St	TA1305000032	Wood St & Milwaukee Ave	13221	41.882242	-87.641066	41.907655	-87.672552	member
6FF59852924528F8	classic_bike	Tue May 10 2022 07:30:07 GMT+0000 (Coordinated Universal Time)	Tue May 10 2022 07:38:49 GMT+0000 (Coordinated Universal Time)	Clinton St & Madison St	TA1305000032	Clark St & Randolph St	TA1305000030	41.882242	-87.641066	41.884576228	-87.63188991	member
483C52CAAE12E3AC	classic_bike	Tue May 10 2022 17:31:56 GMT+0000 (Coordinated Universal Time)	Tue May 10 2022 17:36:57 GMT+0000 (Coordinated Universal Time)	Clinton St & Madison St	TA1305000032	Morgan St & Lake St	TA1306000015	41.882242	-87.641066	41.88577925240433	-87.65102460980414	member
C0A3AA5A614DCE01	classic_bike	Wed May 04 2022 14:48:55 GMT+0000 (Coordinated Universal Time)	Wed May 04 2022 14:56:04 GMT+0000 (Coordinated Universal Time)	Carpenter St & Huron St	13196	Sangamon St & Washington Blvd	13409	41.894556	-87.653449	41.883165	-87.6511	member
F2AF43A242DF4555	classic_bike	Fri May 27 2022 12:41:48 GMT+0000 (Coordinated Universal Time)	Fri May 27 2022 12:50:41 GMT+0000 (Coordinated Universal Time)	Noble St & Milwaukee Ave	13290	Wood St & Augusta Blvd	657	41.90068	-87.6626	41.899181	-87.6722	member
377BE1F5F0E399CA	docked_bike	Sun May 29 2022 19:19:24 GMT+0000 (Coordinated Universal Time)	Sun May 29 2022 19:31:34 GMT+0000 (Coordinated Universal Time)	Halsted St & Wrightwood Ave	TA1309000061	Southport Ave & Clybourn Ave	TA1309000030	41.929143	-87.649077	41.920771	-87.663712	casual
B136E0C969773F59	classic_bike	Mon May 16 2022 17:48:44 GMT+0000 (Coordinated Universal Time)	Mon May 16 2022 18:05:26 GMT+0000 (Coordinated Universal Time)	Clinton St & Madison St	TA1305000032	Clybourn Ave & Division St	TA1307000115	41.882242	-87.641066	41.904613	-87.640552	member
75F6A50A05E0AA18	electric_bike	Wed May 11 2022 07:29:29 GMT+0000 (Coordinated Universal Time)	Wed May 11 2022 07:30:57 GMT+0000 (Coordinated Universal Time)	Southport Ave & Waveland Ave	13235	N Southport Ave & W Newport Ave	20257.0	41.948067	-87.6640125	41.94	-87.66	member


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
);