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

@kaggle.mregoyau_google_case_study_1.n_202204_divvy_tripdata

17.81 MB
371249 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
3564070EEFD12711	electric_bike	Wed Apr 06 2022 17:42:48 GMT+0000 (Coordinated Universal Time)	Wed Apr 06 2022 17:54:36 GMT+0000 (Coordinated Universal Time)	Paulina St & Howard St	515	University Library (NU)	605	42.019135	-87.67353183333333	42.052939	-87.673447	member
0B820C7FCF22F489	classic_bike	Sun Apr 24 2022 19:23:07 GMT+0000 (Coordinated Universal Time)	Sun Apr 24 2022 19:43:17 GMT+0000 (Coordinated Universal Time)	Wentworth Ave & Cermak Rd	13075	Green St & Madison St	TA1307000120	41.85308455741279	-87.63193130493164	41.881892	-87.648789	member
89EEEE32293F07FF	classic_bike	Wed Apr 20 2022 19:29:08 GMT+0000 (Coordinated Universal Time)	Wed Apr 20 2022 19:35:16 GMT+0000 (Coordinated Universal Time)	Halsted St & Polk St	TA1307000121	Green St & Madison St	TA1307000120	41.87184	-87.64664	41.881892	-87.648789	member
84D4751AEB31888D	classic_bike	Fri Apr 22 2022 21:14:06 GMT+0000 (Coordinated Universal Time)	Fri Apr 22 2022 21:23:29 GMT+0000 (Coordinated Universal Time)	Wentworth Ave & Cermak Rd	13075	Delano Ct & Roosevelt Rd	KA1706005007	41.85308455741279	-87.63193130493164	41.867491	-87.63219	casual
5664BCF0D1DE7A8B	electric_bike	Sat Apr 16 2022 15:56:30 GMT+0000 (Coordinated Universal Time)	Sat Apr 16 2022 16:02:11 GMT+0000 (Coordinated Universal Time)	Halsted St & Polk St	TA1307000121	Clinton St & Madison St	TA1305000032	41.87180829	-87.646574497	41.882242	-87.641066	member
AA9EB7BD2E1FC128	classic_bike	Thu Apr 21 2022 16:52:33 GMT+0000 (Coordinated Universal Time)	Thu Apr 21 2022 16:56:51 GMT+0000 (Coordinated Universal Time)	Desplaines St & Randolph St	15535	Canal St & Adams St	13011	41.88461618962	-87.6445705849	41.879255	-87.639904	member
9E10667D54A73861	classic_bike	Mon Apr 04 2022 17:10:52 GMT+0000 (Coordinated Universal Time)	Mon Apr 04 2022 17:15:30 GMT+0000 (Coordinated Universal Time)	Desplaines St & Randolph St	15535	Canal St & Adams St	13011	41.88461618962	-87.6445705849	41.879255	-87.639904	member
22291F983B344390	classic_bike	Tue Apr 05 2022 08:52:21 GMT+0000 (Coordinated Universal Time)	Tue Apr 05 2022 09:04:45 GMT+0000 (Coordinated Universal Time)	Franklin St & Jackson Blvd	TA1305000025	Morgan St & Lake St	TA1306000015	41.8777079559	-87.6353211408	41.88577925240433	-87.65102460980414	member
7E14444DA4A4B2BC	electric_bike	Fri Apr 29 2022 11:38:20 GMT+0000 (Coordinated Universal Time)	Fri Apr 29 2022 11:38:52 GMT+0000 (Coordinated Universal Time)	Halsted St & Clybourn Ave	331	Halsted St & Clybourn Ave	331	41.909664166666666	-87.64812416666666	41.909668	-87.648128	member
D55A28D2B63A7EA9	electric_bike	Fri Apr 29 2022 23:38:33 GMT+0000 (Coordinated Universal Time)	Fri Apr 29 2022 23:40:02 GMT+0000 (Coordinated Universal Time)	Halsted St & Clybourn Ave	331	Halsted St & Clybourn Ave	331	41.90953066666667	-87.64807583333334	41.909668	-87.648128	member


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