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

@kaggle.shane3martin_cyclist_capstone_project.n_202008_divvy_tripdata

30.02 MB
622361 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
322BD23D287743ED	docked_bike	Thu Aug 20 2020 18:08:14 GMT+0000 (Coordinated Universal Time)	Thu Aug 20 2020 18:17:51 GMT+0000 (Coordinated Universal Time)	Lake Shore Dr & Diversey Pkwy	329	Clark St & Lincoln Ave	141	41.932588	-87.636427	41.915689	-87.6346	member
2A3AEF1AB9054D8B	electric_bike	Thu Aug 27 2020 18:46:04 GMT+0000 (Coordinated Universal Time)	Thu Aug 27 2020 19:54:51 GMT+0000 (Coordinated Universal Time)	Michigan Ave & 14th St	168	Michigan Ave & 14th St	168	41.864379166666666	-87.62368116666667	41.8642215	-87.62343883333334	casual
67DC1D133E8B5816	electric_bike	Wed Aug 26 2020 19:44:14 GMT+0000 (Coordinated Universal Time)	Wed Aug 26 2020 21:53:07 GMT+0000 (Coordinated Universal Time)	Columbus Dr & Randolph St	195	State St & Randolph St	44	41.88464066666667	-87.619549	41.884971166666666	-87.62757366666666	casual
C79FBBD412E578A7	electric_bike	Thu Aug 27 2020 12:05:41 GMT+0000 (Coordinated Universal Time)	Thu Aug 27 2020 12:53:45 GMT+0000 (Coordinated Universal Time)	Daley Center Plaza	81	State St & Kinzie St	47	41.88409283333333	-87.62963933333333	41.8895825	-87.62753966666666	casual
13814D3D661ECADB	electric_bike	Thu Aug 27 2020 16:49:02 GMT+0000 (Coordinated Universal Time)	Thu Aug 27 2020 16:59:49 GMT+0000 (Coordinated Universal Time)	Leavitt St & Division St	658	Leavitt St & Division St	658	41.902989	-87.6837665	41.903001833333335	-87.68384433333334	casual
56349A5A42F0AE51	electric_bike	Thu Aug 27 2020 17:26:23 GMT+0000 (Coordinated Universal Time)	Thu Aug 27 2020 18:07:50 GMT+0000 (Coordinated Universal Time)	Leavitt St & Division St	658	Leavitt St & Division St	658	41.903015	-87.683731	41.90309233333333	-87.6836285	casual
EB6ABC5570C29B22	electric_bike	Wed Aug 26 2020 20:14:02 GMT+0000 (Coordinated Universal Time)	Wed Aug 26 2020 20:34:00 GMT+0000 (Coordinated Universal Time)	Cityfront Plaza Dr & Pioneer Ct	196	Dearborn St & Monroe St	49	41.890325833333335	-87.6217	41.880626166666666	-87.629343	casual
B4ECE389A1DE922D	electric_bike	Wed Aug 26 2020 21:59:50 GMT+0000 (Coordinated Universal Time)	Wed Aug 26 2020 22:12:35 GMT+0000 (Coordinated Universal Time)	Sheffield Ave & Fullerton Ave	67	Southport Ave & Roscoe St	229	41.92554633333334	-87.65369216666667	41.94374466666667	-87.66406483333333	casual
0B355B0FE076D010	electric_bike	Wed Aug 26 2020 19:17:42 GMT+0000 (Coordinated Universal Time)	Wed Aug 26 2020 19:32:14 GMT+0000 (Coordinated Universal Time)	Southport Ave & Wellington Ave	153	Halsted St & Dickens Ave	225	41.93572916666667	-87.66396633333333	41.919987	-87.64898866666667	casual
1ECE04F779E9FDF6	electric_bike	Thu Aug 27 2020 15:13:57 GMT+0000 (Coordinated Universal Time)	Thu Aug 27 2020 15:41:59 GMT+0000 (Coordinated Universal Time)	Theater on the Lake	177	Western Ave & Division St	305	41.92627	-87.63095533333333	41.902911333333336	-87.687201	casual


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