Google Capstone Project

Navigate Speedy Success For Bike-Share Company "Cyclistic"

@kaggle.haniarthur_google_capstone_project

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

@kaggle.haniarthur_google_capstone_project.n_202207_divvy_tripdata

39.4 MB
823488 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
954144C2F67B1932	classic_bike	Tue Jul 05 2022 08:12:47 GMT+0000 (Coordinated Universal Time)	Tue Jul 05 2022 08:24:32 GMT+0000 (Coordinated Universal Time)	Ashland Ave & Blackhawk St	13224	Kingsbury St & Kinzie St	KA1503000043	41.907066	-87.667252	41.88917683258	-87.6385057718	member
292E027607D218B6	classic_bike	Tue Jul 26 2022 12:53:38 GMT+0000 (Coordinated Universal Time)	Tue Jul 26 2022 12:55:31 GMT+0000 (Coordinated Universal Time)	Buckingham Fountain (Temp)	15541	Michigan Ave & 8th St	623	41.86962074748123	-87.6239812374115	41.872773	-87.623981	casual
57765852588AD6E0	classic_bike	Sun Jul 03 2022 13:58:49 GMT+0000 (Coordinated Universal Time)	Sun Jul 03 2022 14:06:32 GMT+0000 (Coordinated Universal Time)	Buckingham Fountain (Temp)	15541	Michigan Ave & 8th St	623	41.86962074748123	-87.6239812374115	41.872773	-87.623981	casual
B5B6BE44314590E6	classic_bike	Sun Jul 31 2022 17:44:21 GMT+0000 (Coordinated Universal Time)	Sun Jul 31 2022 18:42:50 GMT+0000 (Coordinated Universal Time)	Buckingham Fountain (Temp)	15541	Woodlawn Ave & 55th St	TA1307000164	41.86962074748123	-87.6239812374115	41.795264	-87.596471	casual
A4C331F2A00E79E0	classic_bike	Wed Jul 13 2022 19:49:06 GMT+0000 (Coordinated Universal Time)	Wed Jul 13 2022 20:15:24 GMT+0000 (Coordinated Universal Time)	Wabash Ave & Grand Ave	TA1307000117	Sheffield Ave & Wellington Ave	TA1307000052	41.891466	-87.626761	41.9362534831413	-87.65266209840775	member
579D73BE2ED880B3	electric_bike	Fri Jul 01 2022 17:04:35 GMT+0000 (Coordinated Universal Time)	Fri Jul 01 2022 17:13:18 GMT+0000 (Coordinated Universal Time)	Desplaines St & Randolph St	15535	Clinton St & Roosevelt Rd	WL-008	41.88461411	-87.644563556	41.8671177825	-87.6410879593	member
EFE518CCEE333669	classic_bike	Mon Jul 18 2022 18:11:01 GMT+0000 (Coordinated Universal Time)	Mon Jul 18 2022 18:22:30 GMT+0000 (Coordinated Universal Time)	Marquette Ave & 89th St	20239	East End Ave & 87th St	20231	41.73366879071472	-87.55834221839905	41.73681521440671	-87.58280128240585	member
315FEBB7B3F6D2EA	classic_bike	Thu Jul 28 2022 20:38:18 GMT+0000 (Coordinated Universal Time)	Thu Jul 28 2022 21:09:11 GMT+0000 (Coordinated Universal Time)	Wabash Ave & Grand Ave	TA1307000117	Dearborn Pkwy & Delaware Pl	TA1307000128	41.891466	-87.626761	41.898969	-87.629912	casual
EE3C4A1E66766B56	classic_bike	Sun Jul 10 2022 22:55:59 GMT+0000 (Coordinated Universal Time)	Sun Jul 10 2022 23:01:32 GMT+0000 (Coordinated Universal Time)	Wabash Ave & Grand Ave	TA1307000117	Dearborn Pkwy & Delaware Pl	TA1307000128	41.891466	-87.626761	41.898969	-87.629912	member
1EE6C93A547A187C	electric_bike	Sun Jul 10 2022 09:35:58 GMT+0000 (Coordinated Universal Time)	Sun Jul 10 2022 09:47:25 GMT+0000 (Coordinated Universal Time)	Ashland Ave & Blackhawk St	13224	Orleans St & Merchandise Mart Plaza	TA1305000022	41.907093048	-87.667247295	41.888243	-87.63639	member


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