Cyclistic Bike Share Trip Data - 06.2023

Google Data Analytics Capstone Project

@kaggle.rubyphan_bike_share

Table List

12 tables(281.77 MB)

N 202207 Divvy Tripdata

N 202208 Divvy Tripdata

N 202209 Divvy Publictripdata

N 202210 Divvy Tripdata

N 202211 Divvy Tripdata

N 202212 Divvy Tripdata

N 202301 Divvy Tripdata

N 202302 Divvy Tripdata

N 202303 Divvy Tripdata

N 202304 Divvy Tripdata

N 202305 Divvy Tripdata

N 202306 Divvy Tripdata

N 202212 Divvy Tripdata

@kaggle.rubyphan_bike_share.n_202212_divvy_tripdata

9.11 MB
181806 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
65DBD2F447EC51C2	electric_bike	Mon Dec 05 2022 10:47:18 GMT+0000 (Coordinated Universal Time)	Mon Dec 05 2022 10:56:34 GMT+0000 (Coordinated Universal Time)	Clifton Ave & Armitage Ave	TA1307000163	Sedgwick St & Webster Ave	13191	41.9182435	-87.65711466666667	41.922167	-87.638888	member
0C201AA7EA0EA1AD	classic_bike	Sun Dec 18 2022 06:42:33 GMT+0000 (Coordinated Universal Time)	Sun Dec 18 2022 07:08:44 GMT+0000 (Coordinated Universal Time)	Broadway & Belmont Ave	13277	Sedgwick St & Webster Ave	13191	41.940106	-87.645451	41.922167	-87.638888	casual
E0B148CCB358A49D	electric_bike	Tue Dec 13 2022 08:47:45 GMT+0000 (Coordinated Universal Time)	Tue Dec 13 2022 08:59:51 GMT+0000 (Coordinated Universal Time)	Sangamon St & Lake St	TA1306000015	St. Clair St & Erie St	13016	41.885918856	-87.65113318	41.89434513742426	-87.62279838323593	member
54C5775D2B7C9188	classic_bike	Tue Dec 13 2022 18:50:47 GMT+0000 (Coordinated Universal Time)	Tue Dec 13 2022 19:19:48 GMT+0000 (Coordinated Universal Time)	Shields Ave & 31st St	KA1503000038	Damen Ave & Madison St	13134	41.838464	-87.635406	41.88137	-87.67493	member
A4891F78776D35DF	classic_bike	Wed Dec 14 2022 16:13:39 GMT+0000 (Coordinated Universal Time)	Wed Dec 14 2022 16:27:50 GMT+0000 (Coordinated Universal Time)	Ashland Ave & Chicago Ave	13247	Damen Ave & Charleston St	13288	41.89595435734305	-87.6677280664444	41.920082	-87.677855	casual
DB91D9B8DFACA07A	electric_bike	Fri Dec 02 2022 15:24:47 GMT+0000 (Coordinated Universal Time)	Fri Dec 02 2022 15:34:14 GMT+0000 (Coordinated Universal Time)	Wabash Ave & 9th St	TA1309000010	Wacker Dr & Washington St	KA1503000072	41.870683551	-87.625706077	41.88314336439022	-87.63724207878113	member
6AD396C5760CC992	classic_bike	Tue Dec 20 2022 09:02:03 GMT+0000 (Coordinated Universal Time)	Tue Dec 20 2022 09:19:54 GMT+0000 (Coordinated Universal Time)	Leavitt St & Chicago Ave	18058	Wacker Dr & Washington St	KA1503000072	41.895501	-87.682017	41.88314336439022	-87.63724207878113	member
8D736E35E0075504	classic_bike	Tue Dec 13 2022 14:19:49 GMT+0000 (Coordinated Universal Time)	Tue Dec 13 2022 14:28:28 GMT+0000 (Coordinated Universal Time)	Humboldt Blvd & Armitage Ave	15651	Spaulding Ave & Armitage Ave	15650	41.91751339399	-87.7018089555	41.91710803478932	-87.71022096276283	member
DDAB881F96C51DC8	classic_bike	Tue Dec 13 2022 07:38:07 GMT+0000 (Coordinated Universal Time)	Tue Dec 13 2022 07:57:01 GMT+0000 (Coordinated Universal Time)	Canal St & Adams St	13011	St. Clair St & Erie St	13016	41.879255	-87.639904	41.89434513742426	-87.62279838323593	member
8DDBAE51E55DAEEF	classic_bike	Wed Dec 21 2022 08:57:42 GMT+0000 (Coordinated Universal Time)	Wed Dec 21 2022 09:10:59 GMT+0000 (Coordinated Universal Time)	Greenview Ave & Fullerton Ave	TA1307000001	Southport Ave & Waveland Ave	13235	41.92533	-87.6658	41.94815	-87.66394	member


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