Case Study: Divvy-tripdata

How does a bike-share navigate speedy success?

@kaggle.elenaracila_case_study_divvy_tripdata

Table List

12 tables(279.15 MB)

N 202303 Divvy Tripdata

N 202304 Divvy Tripdata

N 202305 Divvy Tripdata

N 202306 Divvy Tripdata

N 202307 Divvy Tripdata

N 202308 Divvy Tripdata

N 202309 Divvy Tripdata

N 202310 Divvy Tripdata

N 202311 Divvy Tripdata

N 202312 Divvy Tripdata

N 202401 Divvy Tripdata

N 202402 Divvy Tripdata

N 202303 Divvy Tripdata

@kaggle.elenaracila_case_study_divvy_tripdata.n_202303_divvy_tripdata

12.91 MB
258678 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
6842AA605EE9FBB3	electric_bike	Thu Mar 16 2023 08:20:34 GMT+0000 (Coordinated Universal Time)	Thu Mar 16 2023 08:22:52 GMT+0000 (Coordinated Universal Time)	Clark St & Armitage Ave	13146	Larrabee St & Webster Ave	13193	41.91841316666667	-87.63645116666666	41.921822	-87.64414	member
F984267A75B99A8C	electric_bike	Sat Mar 04 2023 14:07:06 GMT+0000 (Coordinated Universal Time)	Sat Mar 04 2023 14:15:31 GMT+0000 (Coordinated Universal Time)	Public Rack - Kedzie Ave & Argyle St	491	nan	nan	41.97	-87.71	41.95	-87.71	member
FF7CF57CFE026D02	classic_bike	Fri Mar 31 2023 12:28:09 GMT+0000 (Coordinated Universal Time)	Fri Mar 31 2023 12:38:47 GMT+0000 (Coordinated Universal Time)	Orleans St & Chestnut St (NEXT Apts)	620	Clark St & Randolph St	TA1305000030	41.898203	-87.637536	41.884576228	-87.63188991	member
6B61B916032CB6D6	classic_bike	Wed Mar 22 2023 14:09:08 GMT+0000 (Coordinated Universal Time)	Wed Mar 22 2023 14:24:51 GMT+0000 (Coordinated Universal Time)	Desplaines St & Kinzie St	TA1306000003	Sheffield Ave & Kingsbury St	13154	41.888716036	-87.6444478533	41.910522	-87.653106	member
E55E61A5F1260040	electric_bike	Thu Mar 09 2023 07:15:00 GMT+0000 (Coordinated Universal Time)	Thu Mar 09 2023 07:26:00 GMT+0000 (Coordinated Universal Time)	Walsh Park	18067	Sangamon St & Lake St	TA1306000015	41.914479733	-87.668013334	41.88577925240433	-87.65102460980414	member
123AAD676850F53C	classic_bike	Wed Mar 22 2023 17:47:02 GMT+0000 (Coordinated Universal Time)	Wed Mar 22 2023 18:01:29 GMT+0000 (Coordinated Universal Time)	Orleans St & Chestnut St (NEXT Apts)	620	Halsted St & Wrightwood Ave	TA1309000061	41.898203	-87.637536	41.929143	-87.649077	member
5929D3080983AF4F	classic_bike	Wed Mar 08 2023 19:58:44 GMT+0000 (Coordinated Universal Time)	Wed Mar 08 2023 20:05:39 GMT+0000 (Coordinated Universal Time)	Rush St & Hubbard St	KA1503000044	Wells St & Huron St	TA1306000012	41.890173	-87.626185	41.894722	-87.634362	member
B2624BAEDDDA3FB1	docked_bike	Wed Mar 22 2023 17:28:24 GMT+0000 (Coordinated Universal Time)	Wed Mar 22 2023 17:50:24 GMT+0000 (Coordinated Universal Time)	Adler Planetarium	13431	Michigan Ave & Ida B Wells Dr	TA1305000010	41.866095	-87.607267	41.876243	-87.624426	casual
979C41EAC356278F	classic_bike	Thu Mar 16 2023 19:31:14 GMT+0000 (Coordinated Universal Time)	Thu Mar 16 2023 19:41:01 GMT+0000 (Coordinated Universal Time)	Broadway & Wilson Ave	13074	Ravenswood Ave & Irving Park Rd	TA1307000149	41.965221	-87.658139	41.95469	-87.67393	member
6C1DCA9593CA8F5F	classic_bike	Thu Mar 16 2023 17:33:50 GMT+0000 (Coordinated Universal Time)	Thu Mar 16 2023 17:45:47 GMT+0000 (Coordinated Universal Time)	Stetson Ave & South Water St	TA1308000029	Clinton St & Washington Blvd	WL-012	41.886835	-87.62232	41.88338	-87.64117	member


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