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

@kaggle.mregoyau_google_case_study_1.n_202202_divvy_tripdata

5.83 MB
115609 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
E1E065E7ED285C02	classic_bike	Sat Feb 19 2022 18:08:41 GMT+0000 (Coordinated Universal Time)	Sat Feb 19 2022 18:23:56 GMT+0000 (Coordinated Universal Time)	State St & Randolph St	TA1305000029	Clark St & Lincoln Ave	13179	41.88462107257936	-87.62783423066139	41.915689	-87.6346	member
1602DCDC5B30FFE3	classic_bike	Sun Feb 20 2022 17:41:30 GMT+0000 (Coordinated Universal Time)	Sun Feb 20 2022 17:45:56 GMT+0000 (Coordinated Universal Time)	Halsted St & Wrightwood Ave	TA1309000061	Southport Ave & Wrightwood Ave	TA1307000113	41.929143	-87.649077	41.928773	-87.663913	member
BE7DD2AF4B55C4AF	classic_bike	Fri Feb 25 2022 18:55:56 GMT+0000 (Coordinated Universal Time)	Fri Feb 25 2022 19:09:34 GMT+0000 (Coordinated Universal Time)	State St & Randolph St	TA1305000029	Canal St & Adams St	13011	41.88462107257936	-87.62783423066139	41.879255	-87.639904	member
A1789BDF844412BE	classic_bike	Mon Feb 14 2022 11:57:03 GMT+0000 (Coordinated Universal Time)	Mon Feb 14 2022 12:04:00 GMT+0000 (Coordinated Universal Time)	Southport Ave & Waveland Ave	13235	Broadway & Sheridan Rd	13323	41.94815	-87.66394	41.952833	-87.649993	member
07DE78092C62F7B3	classic_bike	Wed Feb 16 2022 05:36:06 GMT+0000 (Coordinated Universal Time)	Wed Feb 16 2022 05:39:00 GMT+0000 (Coordinated Universal Time)	State St & Randolph St	TA1305000029	Franklin St & Lake St	TA1307000111	41.88462107257936	-87.62783423066139	41.885837	-87.6355	member
9A2F204F04AB7E24	classic_bike	Mon Feb 07 2022 09:51:57 GMT+0000 (Coordinated Universal Time)	Mon Feb 07 2022 10:07:53 GMT+0000 (Coordinated Universal Time)	St. Clair St & Erie St	13016	Franklin St & Monroe St	TA1309000007	41.89434513742426	-87.62279838323593	41.880317	-87.635185	member
D1E6BB679BDEDEE4	classic_bike	Mon Feb 14 2022 10:38:54 GMT+0000 (Coordinated Universal Time)	Mon Feb 14 2022 10:42:43 GMT+0000 (Coordinated Universal Time)	Wells St & Elm St	KA1504000135	Clark St & Schiller St	TA1309000024	41.903222	-87.634324	41.907993	-87.631501	member
DE23C1DC29B40237	classic_bike	Tue Feb 08 2022 20:12:33 GMT+0000 (Coordinated Universal Time)	Tue Feb 08 2022 20:21:16 GMT+0000 (Coordinated Universal Time)	State St & Randolph St	TA1305000029	Desplaines St & Randolph St	15535	41.88462107257936	-87.62783423066139	41.88461618962	-87.6445705849	member
3E314B0F46667DE9	electric_bike	Fri Feb 25 2022 13:49:05 GMT+0000 (Coordinated Universal Time)	Fri Feb 25 2022 13:54:43 GMT+0000 (Coordinated Universal Time)	Larrabee St & Armitage Ave	TA1309000006	Cherry Ave & Blackhawk St	18069	41.91813616666666	-87.6437855	41.907221	-87.655618	member
04ED4D3E37D2351C	classic_bike	Sun Feb 06 2022 07:36:15 GMT+0000 (Coordinated Universal Time)	Sun Feb 06 2022 07:42:05 GMT+0000 (Coordinated Universal Time)	Morgan St & 18th St	13163	Halsted St & Maxwell St	TA1309000001	41.858086	-87.651073	41.864883	-87.647071	member


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