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

@kaggle.elenaracila_case_study_divvy_tripdata.n_202305_divvy_tripdata

30.02 MB
604827 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
0D9FA920C3062031	electric_bike	Sun May 07 2023 19:53:48 GMT+0000 (Coordinated Universal Time)	Sun May 07 2023 19:58:32 GMT+0000 (Coordinated Universal Time)	Southport Ave & Belmont Ave	13229	nan	nan	41.9394075	-87.6638305	41.93	-87.65	member
92485E5FB5888ACD	electric_bike	Sat May 06 2023 18:54:08 GMT+0000 (Coordinated Universal Time)	Sat May 06 2023 19:03:35 GMT+0000 (Coordinated Universal Time)	Southport Ave & Belmont Ave	13229	nan	nan	41.939481854	-87.6638484	41.94	-87.69	member
FB144B3FC8300187	electric_bike	Sun May 21 2023 00:40:21 GMT+0000 (Coordinated Universal Time)	Sun May 21 2023 00:44:36 GMT+0000 (Coordinated Universal Time)	Halsted St & 21st St	13162	nan	nan	41.853793144	-87.646719337	41.86	-87.65	member
DDEB93BC2CE9AA77	classic_bike	Wed May 10 2023 16:47:01 GMT+0000 (Coordinated Universal Time)	Wed May 10 2023 16:59:52 GMT+0000 (Coordinated Universal Time)	Carpenter St & Huron St	13196	Damen Ave & Cortland St	13133	41.894556	-87.653449	41.915983	-87.677335	member
C07B70172FC92F59	classic_bike	Tue May 09 2023 18:30:34 GMT+0000 (Coordinated Universal Time)	Tue May 09 2023 18:39:28 GMT+0000 (Coordinated Universal Time)	Southport Ave & Clark St	TA1308000047	Southport Ave & Belmont Ave	13229	41.957081	-87.664199	41.93947775040509	-87.6637476682663	member
2BA66385DF8F815A	classic_bike	Tue May 30 2023 15:01:21 GMT+0000 (Coordinated Universal Time)	Tue May 30 2023 15:17:00 GMT+0000 (Coordinated Universal Time)	Clinton St & Madison St	TA1305000032	McClurg Ct & Ohio St	TA1306000029	41.882751965685614	-87.64119029045105	41.892592119709725	-87.61728912591934	member
31EFCCB05F12D8EF	docked_bike	Tue May 09 2023 14:13:40 GMT+0000 (Coordinated Universal Time)	Tue May 09 2023 14:47:20 GMT+0000 (Coordinated Universal Time)	DuSable Lake Shore Dr & Monroe St	13300	Adler Planetarium	13431	41.880958	-87.616743	41.866095	-87.607267	casual
71DFF834E1D3CE0B	classic_bike	Sat May 06 2023 16:47:22 GMT+0000 (Coordinated Universal Time)	Sat May 06 2023 16:52:13 GMT+0000 (Coordinated Universal Time)	Shore Dr & 55th St	TA1308000009	Harper Ave & 59th St	KA1503000070	41.795212	-87.580715	41.78794281287	-87.5883151702	member
2117485899B4CEA4	classic_bike	Mon May 15 2023 12:47:26 GMT+0000 (Coordinated Universal Time)	Mon May 15 2023 13:00:05 GMT+0000 (Coordinated Universal Time)	Clark St & Schiller St	TA1309000024	Franklin St & Lake St	TA1307000111	41.907993	-87.631501	41.885837	-87.6355	member
811149F69AAE82DD	electric_bike	Fri May 19 2023 05:44:26 GMT+0000 (Coordinated Universal Time)	Fri May 19 2023 05:47:24 GMT+0000 (Coordinated Universal Time)	Clinton St & Madison St	TA1305000032	Kingsbury St & Kinzie St	KA1503000043	41.882650971	-87.64144206	41.88917683258	-87.6385057718	member


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