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 202203 Divvy Tripdata

@kaggle.mregoyau_google_case_study_1.n_202203_divvy_tripdata

13.58 MB
284042 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
47EC0A7F82E65D52	classic_bike	Mon Mar 21 2022 13:45:01 GMT+0000 (Coordinated Universal Time)	Mon Mar 21 2022 13:51:18 GMT+0000 (Coordinated Universal Time)	Wabash Ave & Wacker Pl	TA1307000131	Kingsbury St & Kinzie St	KA1503000043	41.886875	-87.62603	41.88917683258	-87.6385057718	member
8494861979B0F477	electric_bike	Wed Mar 16 2022 09:37:16 GMT+0000 (Coordinated Universal Time)	Wed Mar 16 2022 09:43:34 GMT+0000 (Coordinated Universal Time)	Michigan Ave & Oak St	13042	Orleans St & Chestnut St (NEXT Apts)	620	41.90099766666667	-87.62375166666666	41.898203	-87.637536	member
EFE527AF80B66109	classic_bike	Wed Mar 23 2022 19:52:02 GMT+0000 (Coordinated Universal Time)	Wed Mar 23 2022 19:54:48 GMT+0000 (Coordinated Universal Time)	Broadway & Berwyn Ave	13109	Broadway & Ridge Ave	15578	41.978353	-87.659753	41.9840446107	-87.6602738295	member
9F446FD9DEE3F389	classic_bike	Tue Mar 01 2022 19:12:26 GMT+0000 (Coordinated Universal Time)	Tue Mar 01 2022 19:22:14 GMT+0000 (Coordinated Universal Time)	Wabash Ave & Wacker Pl	TA1307000131	Franklin St & Jackson Blvd	TA1305000025	41.886875	-87.62603	41.8777079559	-87.6353211408	member
431128AD9AFFEDC0	classic_bike	Mon Mar 21 2022 18:37:01 GMT+0000 (Coordinated Universal Time)	Mon Mar 21 2022 19:19:11 GMT+0000 (Coordinated Universal Time)	DuSable Lake Shore Dr & North Blvd	LF-005	Loomis St & Jackson Blvd	13206	41.911722	-87.626804	41.877945	-87.662007	member
9AA8A13AF7A85325	classic_bike	Mon Mar 07 2022 17:10:22 GMT+0000 (Coordinated Universal Time)	Mon Mar 07 2022 17:15:04 GMT+0000 (Coordinated Universal Time)	Bissell St & Armitage Ave	13059	Southport Ave & Clybourn Ave	TA1309000030	41.91801814237187	-87.65218198299408	41.920771	-87.663712	member
28E3387BFE2A5E85	electric_bike	Thu Mar 10 2022 17:21:22 GMT+0000 (Coordinated Universal Time)	Thu Mar 10 2022 17:24:39 GMT+0000 (Coordinated Universal Time)	Bissell St & Armitage Ave	13059	Southport Ave & Clybourn Ave	TA1309000030	41.91791616666666	-87.65206016666667	41.920771	-87.663712	member
74831EB3EA9CF123	classic_bike	Sat Mar 05 2022 12:31:37 GMT+0000 (Coordinated Universal Time)	Sat Mar 05 2022 12:42:54 GMT+0000 (Coordinated Universal Time)	DuSable Lake Shore Dr & North Blvd	LF-005	Stockton Dr & Wrightwood Ave	13276	41.911722	-87.626804	41.93132	-87.638742	member
BD70E7114BC486F1	electric_bike	Thu Mar 17 2022 17:32:44 GMT+0000 (Coordinated Universal Time)	Thu Mar 17 2022 17:43:27 GMT+0000 (Coordinated Universal Time)	Western Ave & Winnebago Ave	13068	Dayton St & North Ave	13058	41.915544152	-87.687069893	41.9105780349	-87.6494219288	casual
482458CD09B6FAF0	classic_bike	Fri Mar 04 2022 19:06:32 GMT+0000 (Coordinated Universal Time)	Fri Mar 04 2022 19:19:46 GMT+0000 (Coordinated Universal Time)	Sheffield Ave & Webster Ave	TA1309000033	Clark St & Newport St	632	41.92154	-87.653818	41.94454	-87.654678	member


CREATE TABLE n_202203_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
);