Cyclistic Case Study

Google Data Analytics Capstone Project

@kaggle.alexandria101_cyclistic_case_study

Table List

12 tables(286.55 MB)

N 202109 Divvy Tripdata

N 202110 Divvy Tripdata

N 202111 Divvy Tripdata

N 202112 Divvy Tripdata

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

@kaggle.alexandria101_cyclistic_case_study.n_202112_divvy_tripdata

12.62 MB
247540 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
46F8167220E4431F	electric_bike	Tue Dec 07 2021 15:06:07 GMT+0000 (Coordinated Universal Time)	Tue Dec 07 2021 15:13:42 GMT+0000 (Coordinated Universal Time)	Laflin St & Cullerton St	13307	Morgan St & Polk St	TA1307000130	41.854833	-87.66366033333334	41.8719685	-87.65096533333333	member
73A77762838B32FD	electric_bike	Sat Dec 11 2021 03:43:29 GMT+0000 (Coordinated Universal Time)	Sat Dec 11 2021 04:10:23 GMT+0000 (Coordinated Universal Time)	LaSalle Dr & Huron St	KP1705001026	Clarendon Ave & Leland Ave	TA1307000119	41.894405166666665	-87.632331	41.967968	-87.650001	casual
4CF42452054F59C5	electric_bike	Wed Dec 15 2021 23:10:28 GMT+0000 (Coordinated Universal Time)	Wed Dec 15 2021 23:23:14 GMT+0000 (Coordinated Universal Time)	Halsted St & North Branch St	KA1504000117	Broadway & Barry Ave	13137	41.89935716666667	-87.64852183333333	41.93758231600629	-87.6440978050232	member
3278BA87BF698339	classic_bike	Sun Dec 26 2021 16:16:10 GMT+0000 (Coordinated Universal Time)	Sun Dec 26 2021 16:30:53 GMT+0000 (Coordinated Universal Time)	Halsted St & North Branch St	KA1504000117	LaSalle Dr & Huron St	KP1705001026	41.89939028549696	-87.64854490756989	41.894877	-87.632326	member
6FF54232576A3B73	electric_bike	Thu Dec 30 2021 11:31:05 GMT+0000 (Coordinated Universal Time)	Thu Dec 30 2021 11:51:21 GMT+0000 (Coordinated Universal Time)	Leavitt St & Chicago Ave	18058	Clark St & Drummond Pl	TA1307000142	41.89557883333333	-87.68202383333333	41.931248	-87.644336	member
93E8D79490E3AB11	classic_bike	Wed Dec 01 2021 18:28:36 GMT+0000 (Coordinated Universal Time)	Wed Dec 01 2021 18:38:03 GMT+0000 (Coordinated Universal Time)	Wabash Ave & 16th St	SL-012	Wells St & Polk St	SL-011	41.860384	-87.625813	41.872596	-87.633502	member
135518383C9CACF0	electric_bike	Thu Dec 09 2021 15:49:51 GMT+0000 (Coordinated Universal Time)	Thu Dec 09 2021 15:55:49 GMT+0000 (Coordinated Universal Time)	Laflin St & Cullerton St	13307	Halsted St & Maxwell St	TA1309000001	41.8548755	-87.66365216666667	41.86482733333333	-87.64709983333333	member
CDF93C212EA9B261	classic_bike	Fri Dec 31 2021 13:02:08 GMT+0000 (Coordinated Universal Time)	Fri Dec 31 2021 13:20:59 GMT+0000 (Coordinated Universal Time)	Clark St & Lake St	KA1503000012	Ashland Ave & Lake St	13073	41.88602082773	-87.6308760584	41.88592	-87.66717	casual
0FCA94C5F26535C8	electric_bike	Mon Dec 20 2021 14:25:53 GMT+0000 (Coordinated Universal Time)	Mon Dec 20 2021 14:35:48 GMT+0000 (Coordinated Universal Time)	Clark St & Lake St	KA1503000012	Ogden Ave & Chicago Ave	TA1305000020	41.885915518	-87.631485343	41.896362458	-87.6540612729	member
8E913048B7BCAA47	classic_bike	Sun Dec 19 2021 16:58:32 GMT+0000 (Coordinated Universal Time)	Sun Dec 19 2021 17:15:01 GMT+0000 (Coordinated Universal Time)	Fairbanks St & Superior St	18003	Lincoln Park Conservatory	LP-	41.895748	-87.620104	41.92393131136619	-87.63582453131676	member


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