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

@kaggle.mregoyau_google_case_study_1.n_202201_divvy_tripdata

5.28 MB
103770 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
C2F7DD78E82EC875	electric_bike	Thu Jan 13 2022 11:59:47 GMT+0000 (Coordinated Universal Time)	Thu Jan 13 2022 12:02:44 GMT+0000 (Coordinated Universal Time)	Glenwood Ave & Touhy Ave	525	Clark St & Touhy Ave	RP-007	42.0128005	-87.665906	42.01256011541	-87.6743671152	casual
A6CF8980A652D272	electric_bike	Mon Jan 10 2022 08:41:56 GMT+0000 (Coordinated Universal Time)	Mon Jan 10 2022 08:46:17 GMT+0000 (Coordinated Universal Time)	Glenwood Ave & Touhy Ave	525	Clark St & Touhy Ave	RP-007	42.012763	-87.6659675	42.01256011541	-87.6743671152	casual
BD0F91DFF741C66D	classic_bike	Tue Jan 25 2022 04:53:40 GMT+0000 (Coordinated Universal Time)	Tue Jan 25 2022 04:58:01 GMT+0000 (Coordinated Universal Time)	Sheffield Ave & Fullerton Ave	TA1306000016	Greenview Ave & Fullerton Ave	TA1307000001	41.9256018819	-87.6537080423	41.92533	-87.6658	member
CBB80ED419105406	classic_bike	Tue Jan 04 2022 00:18:04 GMT+0000 (Coordinated Universal Time)	Tue Jan 04 2022 00:33:00 GMT+0000 (Coordinated Universal Time)	Clark St & Bryn Mawr Ave	KA1504000151	Paulina St & Montrose Ave	TA1309000021	41.983593	-87.669154	41.961507	-87.671387	casual
DDC963BFDDA51EEA	classic_bike	Thu Jan 20 2022 01:31:10 GMT+0000 (Coordinated Universal Time)	Thu Jan 20 2022 01:37:12 GMT+0000 (Coordinated Universal Time)	Michigan Ave & Jackson Blvd	TA1309000002	State St & Randolph St	TA1305000029	41.87785	-87.62408	41.88462107257936	-87.62783423066139	member
A39C6F6CC0586C0B	classic_bike	Tue Jan 11 2022 18:48:09 GMT+0000 (Coordinated Universal Time)	Tue Jan 11 2022 18:51:31 GMT+0000 (Coordinated Universal Time)	Wood St & Chicago Ave	637	Honore St & Division St	TA1305000034	41.895634	-87.672069	41.903119	-87.673935	member
BDC4AB637EDF981B	classic_bike	Sun Jan 30 2022 18:32:52 GMT+0000 (Coordinated Universal Time)	Sun Jan 30 2022 18:49:26 GMT+0000 (Coordinated Universal Time)	Oakley Ave & Irving Park Rd	KA1504000158	Broadway & Sheridan Rd	13323	41.95434085219	-87.6860796243	41.952833	-87.649993	member
81751A3186E59A6B	classic_bike	Sat Jan 22 2022 12:20:02 GMT+0000 (Coordinated Universal Time)	Sat Jan 22 2022 12:32:06 GMT+0000 (Coordinated Universal Time)	Sheffield Ave & Fullerton Ave	TA1306000016	Damen Ave & Clybourn Ave	13271	41.9256018819	-87.6537080423	41.931931	-87.677856	member
154222B86A338ABD	electric_bike	Mon Jan 17 2022 07:34:41 GMT+0000 (Coordinated Universal Time)	Mon Jan 17 2022 08:00:08 GMT+0000 (Coordinated Universal Time)	Racine Ave & 15th St	13304	Clinton St & Washington Blvd	WL-012	41.861251333333335	-87.65650016666666	41.88338	-87.64117	member
72DC25B2DD467EEF	classic_bike	Fri Jan 28 2022 15:27:53 GMT+0000 (Coordinated Universal Time)	Fri Jan 28 2022 15:35:16 GMT+0000 (Coordinated Universal Time)	LaSalle St & Jackson Blvd	TA1309000004	Clinton St & Washington Blvd	WL-012	41.878166	-87.631929	41.88338	-87.64117	member


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