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

@kaggle.rubyphan_bike_share.n_202211_divvy_tripdata

16.68 MB
337735 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
BCC66FC6FAB27CC7	electric_bike	Thu Nov 10 2022 06:21:55 GMT+0000 (Coordinated Universal Time)	Thu Nov 10 2022 06:31:27 GMT+0000 (Coordinated Universal Time)	Canal St & Adams St	13011	St. Clair St & Erie St	13016	41.879401207	-87.639847875	41.89434513742426	-87.62279838323593	member
772AB67E902C180F	classic_bike	Fri Nov 04 2022 07:31:55 GMT+0000 (Coordinated Universal Time)	Fri Nov 04 2022 07:46:25 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
585EAD07FDEC0152	classic_bike	Mon Nov 21 2022 17:20:29 GMT+0000 (Coordinated Universal Time)	Mon Nov 21 2022 17:34:36 GMT+0000 (Coordinated Universal Time)	Indiana Ave & Roosevelt Rd	SL-005	St. Clair St & Erie St	13016	41.867888	-87.623041	41.89434513742426	-87.62279838323593	member
91C4E7ED3C262FF9	classic_bike	Fri Nov 25 2022 17:29:34 GMT+0000 (Coordinated Universal Time)	Fri Nov 25 2022 17:45:15 GMT+0000 (Coordinated Universal Time)	Indiana Ave & Roosevelt Rd	SL-005	St. Clair St & Erie St	13016	41.867888	-87.623041	41.89434513742426	-87.62279838323593	member
709206A3104CABC8	classic_bike	Tue Nov 29 2022 17:24:25 GMT+0000 (Coordinated Universal Time)	Tue Nov 29 2022 17:42:51 GMT+0000 (Coordinated Universal Time)	Indiana Ave & Roosevelt Rd	SL-005	St. Clair St & Erie St	13016	41.867888	-87.623041	41.89434513742426	-87.62279838323593	member
11DE62E16D1A6BD1	classic_bike	Fri Nov 04 2022 14:40:47 GMT+0000 (Coordinated Universal Time)	Fri Nov 04 2022 14:52:35 GMT+0000 (Coordinated Universal Time)	Streeter Dr & Grand Ave	13022	Desplaines St & Kinzie St	TA1306000003	41.892278	-87.612043	41.888716036	-87.6444478533	member
0F05C92DE9981154	classic_bike	Sun Nov 06 2022 14:26:29 GMT+0000 (Coordinated Universal Time)	Sun Nov 06 2022 14:36:00 GMT+0000 (Coordinated Universal Time)	Halsted St & Clybourn Ave	331	Desplaines St & Kinzie St	TA1306000003	41.909668	-87.648128	41.888716036	-87.6444478533	member
CBEB7068C91BB672	classic_bike	Tue Nov 08 2022 20:25:34 GMT+0000 (Coordinated Universal Time)	Tue Nov 08 2022 20:34:23 GMT+0000 (Coordinated Universal Time)	Halsted St & Clybourn Ave	331	Orleans St & Chestnut St (NEXT Apts)	620	41.909668	-87.648128	41.898203	-87.637536	member
C79980F697C514FF	electric_bike	Sun Nov 13 2022 21:56:36 GMT+0000 (Coordinated Universal Time)	Sun Nov 13 2022 22:06:07 GMT+0000 (Coordinated Universal Time)	Franklin St & Adams St (Temp)	TA1309000008	Desplaines St & Kinzie St	TA1306000003	41.879141	-87.6360515	41.888716036	-87.6444478533	member
A65691E4D563258E	classic_bike	Tue Nov 01 2022 20:17:51 GMT+0000 (Coordinated Universal Time)	Tue Nov 01 2022 20:24:14 GMT+0000 (Coordinated Universal Time)	Halsted St & Clybourn Ave	331	Orleans St & Chestnut St (NEXT Apts)	620	41.909668	-87.648128	41.898203	-87.637536	member


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