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

@kaggle.alexandria101_cyclistic_case_study.n_202110_divvy_tripdata

32.2 MB
631226 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
620BC6107255BF4C	electric_bike	Fri Oct 22 2021 12:46:42 GMT+0000 (Coordinated Universal Time)	Fri Oct 22 2021 12:49:50 GMT+0000 (Coordinated Universal Time)	Kingsbury St & Kinzie St	KA1503000043	nan	nan	41.889186333333335	-87.63849533333334	41.89	-87.63	member
4471C70731AB2E45	electric_bike	Thu Oct 21 2021 09:12:37 GMT+0000 (Coordinated Universal Time)	Thu Oct 21 2021 09:14:14 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.93	-87.7	41.93	-87.71	member
26CA69D43D15EE14	electric_bike	Sat Oct 16 2021 16:28:39 GMT+0000 (Coordinated Universal Time)	Sat Oct 16 2021 16:36:26 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.92	-87.7	41.94	-87.72	member
362947F0437E1514	electric_bike	Sat Oct 16 2021 16:17:48 GMT+0000 (Coordinated Universal Time)	Sat Oct 16 2021 16:19:03 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.92	-87.69	41.92	-87.69	member
BB731DE2F2EC51C5	electric_bike	Wed Oct 20 2021 23:17:54 GMT+0000 (Coordinated Universal Time)	Wed Oct 20 2021 23:26:10 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.89	-87.71	41.89	-87.69	member
7176307BBC097313	electric_bike	Thu Oct 21 2021 16:57:37 GMT+0000 (Coordinated Universal Time)	Thu Oct 21 2021 17:11:58 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.89	-87.71	41.93	-87.7	member
E965A041511793A0	electric_bike	Thu Oct 21 2021 17:46:38 GMT+0000 (Coordinated Universal Time)	Thu Oct 21 2021 17:49:19 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.93	-87.7	41.93	-87.7	member
E41D986E83D7B7CC	electric_bike	Wed Oct 20 2021 23:30:13 GMT+0000 (Coordinated Universal Time)	Wed Oct 20 2021 23:38:34 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.89	-87.69	41.89	-87.71	member
E189D96E36E6FDFD	electric_bike	Thu Oct 21 2021 18:17:00 GMT+0000 (Coordinated Universal Time)	Thu Oct 21 2021 18:24:28 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.93	-87.7	41.91	-87.7	member
17019B8A4C753A83	electric_bike	Wed Oct 06 2021 18:47:40 GMT+0000 (Coordinated Universal Time)	Wed Oct 06 2021 18:56:09 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.78	-87.58	41.8	-87.58	member


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