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

@kaggle.elenaracila_case_study_divvy_tripdata.n_202307_divvy_tripdata

37.26 MB
767650 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
9340B064F0AEE130	electric_bike	Sun Jul 23 2023 20:06:14 GMT+0000 (Coordinated Universal Time)	Sun Jul 23 2023 20:22:44 GMT+0000 (Coordinated Universal Time)	Kedzie Ave & 110th St	20204	Public Rack - Racine Ave & 109th Pl	877	41.692406058	-87.700905323	41.694835	-87.653041	member
D1460EE3CE0D8AF8	classic_bike	Sun Jul 23 2023 17:05:07 GMT+0000 (Coordinated Universal Time)	Sun Jul 23 2023 17:18:37 GMT+0000 (Coordinated Universal Time)	Western Ave & Walton St	KA1504000103	Milwaukee Ave & Grand Ave	13033	41.89841768945	-87.6865960164	41.891578	-87.648384	member
DF41BE31B895A25E	classic_bike	Sun Jul 23 2023 10:14:53 GMT+0000 (Coordinated Universal Time)	Sun Jul 23 2023 10:24:29 GMT+0000 (Coordinated Universal Time)	Western Ave & Walton St	KA1504000103	Damen Ave & Pierce Ave	TA1305000041	41.89841768945	-87.6865960164	41.9093960065	-87.6776919292	member
9624A293749EF703	electric_bike	Fri Jul 21 2023 08:27:44 GMT+0000 (Coordinated Universal Time)	Fri Jul 21 2023 08:32:40 GMT+0000 (Coordinated Universal Time)	Racine Ave & Randolph St	13155	Clinton St & Madison St	TA1305000032	41.88411216666667	-87.6569435	41.882751965685614	-87.64119029045105	member
2F68A6A4CDB4C99A	classic_bike	Sat Jul 08 2023 15:46:42 GMT+0000 (Coordinated Universal Time)	Sat Jul 08 2023 15:58:08 GMT+0000 (Coordinated Universal Time)	Clark St & Leland Ave	TA1309000014	Montrose Harbor	TA1308000012	41.96708783918421	-87.66729086637497	41.963982	-87.638181	member
9AEE973E6B941A9C	classic_bike	Mon Jul 10 2023 08:44:47 GMT+0000 (Coordinated Universal Time)	Mon Jul 10 2023 08:49:41 GMT+0000 (Coordinated Universal Time)	Racine Ave & Randolph St	13155	Sangamon St & Lake St	TA1306000015	41.884069	-87.656853	41.88577925240433	-87.65102460980414	member
E366E997FDA1582B	classic_bike	Tue Jul 25 2023 14:30:44 GMT+0000 (Coordinated Universal Time)	Tue Jul 25 2023 14:37:45 GMT+0000 (Coordinated Universal Time)	Clark St & Leland Ave	TA1309000014	Sheridan Rd & Montrose Ave	TA1307000107	41.96708783918421	-87.66729086637497	41.96167	-87.65464	member
1BB3E73851E6C2C1	classic_bike	Fri Jul 07 2023 10:11:53 GMT+0000 (Coordinated Universal Time)	Fri Jul 07 2023 10:17:55 GMT+0000 (Coordinated Universal Time)	Clark St & Leland Ave	TA1309000014	Ravenswood Ave & Berteau Ave	TA1309000018	41.96708783918421	-87.66729086637497	41.957921	-87.673567	member
DA1E1D0866E6566E	electric_bike	Tue Jul 04 2023 21:57:27 GMT+0000 (Coordinated Universal Time)	Tue Jul 04 2023 22:08:27 GMT+0000 (Coordinated Universal Time)	Clark St & Leland Ave	TA1309000014	Sheffield Ave & Wellington Ave	TA1307000052	41.967091203	-87.667486429	41.9362534831413	-87.65266209840775	member
39BF4A73A704CA85	classic_bike	Sat Jul 29 2023 10:51:17 GMT+0000 (Coordinated Universal Time)	Sat Jul 29 2023 11:03:13 GMT+0000 (Coordinated Universal Time)	Warren Park East	RP-002	Sheridan Rd & Loyola Ave	RP-009	42.00454962194	-87.6806661451	42.00104377979	-87.6611982433	member


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