Cyclistic Capstone Project

Google Analytics Certification

@kaggle.shane3martin_cyclist_capstone_project

Table List

4 tables(127.58 MB)

N 202008 Divvy Tripdata

N 202009 Divvy Tripdata

Summerbikerides

Winterbikerides

N 202009 Divvy Tripdata

@kaggle.shane3martin_cyclist_capstone_project.n_202009_divvy_tripdata

27.6 MB
532958 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
2B22BD5F95FB2629	electric_bike	Thu Sep 17 2020 14:27:11 GMT+0000 (Coordinated Universal Time)	Thu Sep 17 2020 14:44:24 GMT+0000 (Coordinated Universal Time)	Michigan Ave & Lake St	52	Green St & Randolph St	112	41.886692333333336	-87.62356066666666	41.8835705	-87.6487315	casual
A7FB70B4AFC6CAF2	electric_bike	Thu Sep 17 2020 15:07:31 GMT+0000 (Coordinated Universal Time)	Thu Sep 17 2020 15:07:45 GMT+0000 (Coordinated Universal Time)	W Oakdale Ave & N Broadway		W Oakdale Ave & N Broadway		41.94	-87.64	41.94	-87.64	casual
86057FA01BAC778E	electric_bike	Thu Sep 17 2020 15:09:04 GMT+0000 (Coordinated Universal Time)	Thu Sep 17 2020 15:09:35 GMT+0000 (Coordinated Universal Time)	W Oakdale Ave & N Broadway		W Oakdale Ave & N Broadway		41.94	-87.64	41.94	-87.64	casual
57F6DC9A153DB98C	electric_bike	Thu Sep 17 2020 18:10:46 GMT+0000 (Coordinated Universal Time)	Thu Sep 17 2020 18:35:49 GMT+0000 (Coordinated Universal Time)	Ashland Ave & Belle Plaine Ave	246	Montrose Harbor	249	41.9560605	-87.6689165	41.963984833333335	-87.6382165	casual
B9C4712F78C1AE68	electric_bike	Thu Sep 17 2020 15:16:13 GMT+0000 (Coordinated Universal Time)	Thu Sep 17 2020 15:52:55 GMT+0000 (Coordinated Universal Time)	Fairbanks Ct & Grand Ave	24	Fairbanks Ct & Grand Ave	24	41.8918595	-87.621008	41.89134633333333	-87.62032483333333	casual
378BBCE1E444EB80	electric_bike	Thu Sep 17 2020 18:37:04 GMT+0000 (Coordinated Universal Time)	Thu Sep 17 2020 19:23:28 GMT+0000 (Coordinated Universal Time)	Clark St & Armitage Ave	94	nan		41.918265	-87.6363605	41.88	-87.62	casual
0CB5E2496B6F1DF8	electric_bike	Wed Sep 16 2020 21:39:57 GMT+0000 (Coordinated Universal Time)	Wed Sep 16 2020 21:53:44 GMT+0000 (Coordinated Universal Time)	Wells St & Evergreen Ave	291	Broadway & Sheridan Rd	256	41.90676283333333	-87.63522166666667	41.95277083333333	-87.6500235	casual
9673F5D39BDBA8BE	electric_bike	Thu Sep 17 2020 12:18:06 GMT+0000 (Coordinated Universal Time)	Thu Sep 17 2020 12:18:19 GMT+0000 (Coordinated Universal Time)	nan		nan		41.76	-87.65	41.76	-87.65	casual
54B91F5C95B20268	electric_bike	Thu Sep 17 2020 17:09:17 GMT+0000 (Coordinated Universal Time)	Thu Sep 17 2020 17:34:20 GMT+0000 (Coordinated Universal Time)	nan		nan		41.75	-87.64	41.78	-87.65	casual
91CEBB66076D4713	electric_bike	Thu Sep 17 2020 12:20:25 GMT+0000 (Coordinated Universal Time)	Thu Sep 17 2020 12:29:47 GMT+0000 (Coordinated Universal Time)	nan		nan		41.76	-87.65	41.75	-87.64	casual


CREATE TABLE n_202009_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" DOUBLE,
  "end_station_name" VARCHAR,
  "end_station_id" DOUBLE,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);