Cyclistic 2024 Dataset

Capstone Project for Google Data Analytics Course

@kaggle.jonathanmcilwaine_cyclistic_2024_dataset

Table List

12 tables(268.82 MB)

N 202403 Divvy Tripdata

N 202409 Divvy Tripdata

N 202406 Divvy Tripdata

N 202405 Divvy Tripdata

N 202408 Divvy Tripdata

N 202402 Divvy Tripdata

N 202411 Divvy Tripdata

N 202412 Divvy Tripdata

N 202401 Divvy Tripdata

N 202407 Divvy Tripdata

N 202410 Divvy Tripdata

N 202404 Divvy Tripdata

N 202408 Divvy Tripdata

@kaggle.jonathanmcilwaine_cyclistic_2024_dataset.n_202408_divvy_tripdata

33.16 MB
755639 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
BAA154388A869E64	classic_bike	Fri Aug 02 2024 13:35:14 GMT+0000 (Coordinated Universal Time)	Fri Aug 02 2024 13:48:24 GMT+0000 (Coordinated Universal Time)	State St & Randolph St	TA1305000029	Wabash Ave & 9th St	TA1309000010	41.88462107257936	-87.62783423066139	41.870769	-87.625734	member
8752245932EFF67A	electric_bike	Fri Aug 02 2024 15:33:13 GMT+0000 (Coordinated Universal Time)	Fri Aug 02 2024 15:55:23 GMT+0000 (Coordinated Universal Time)	Franklin St & Monroe St	TA1309000007	Damen Ave & Cortland St	13133	41.880317	-87.635185	41.915983	-87.677335	member
44DDF9F57A9A161F	classic_bike	Fri Aug 16 2024 15:44:06 GMT+0000 (Coordinated Universal Time)	Fri Aug 16 2024 15:57:52 GMT+0000 (Coordinated Universal Time)	Franklin St & Monroe St	TA1309000007	Clark St & Elm St	TA1307000039	41.880317	-87.635185	41.902973	-87.63128	member
44AAAF069B0C78C3	electric_bike	Mon Aug 19 2024 18:47:11 GMT+0000 (Coordinated Universal Time)	Mon Aug 19 2024 18:56:33 GMT+0000 (Coordinated Universal Time)	Clark St & Elm St	TA1307000039	McClurg Ct & Ohio St	TA1306000029	41.902973	-87.63128	41.892592119709725	-87.61728912591934	member
77138D500A6B7B4B	classic_bike	Sat Aug 03 2024 20:34:20 GMT+0000 (Coordinated Universal Time)	Sat Aug 03 2024 20:46:29 GMT+0000 (Coordinated Universal Time)	Western Ave & Leland Ave	TA1307000140	Ashland Ave & Belle Plaine Ave	13249	41.966399801840986	-87.68870428204536	41.956057	-87.668835	casual
F6F581F31A9C9BC2	electric_bike	Sat Aug 03 2024 20:08:09 GMT+0000 (Coordinated Universal Time)	Sat Aug 03 2024 20:44:53 GMT+0000 (Coordinated Universal Time)	Clark St & Elm St	TA1307000039	Stetson Ave & South Water St	TA1308000029	41.902973	-87.63128	41.886835	-87.62232	casual
604663B88BC6DB8A	classic_bike	Wed Aug 28 2024 17:08:13 GMT+0000 (Coordinated Universal Time)	Wed Aug 28 2024 17:34:06 GMT+0000 (Coordinated Universal Time)	Michigan Ave & Jackson Blvd	TA1309000002	Larrabee St & Webster Ave	13193	41.8777679	-87.624164	41.921822	-87.64414	member
26021CDC5238475E	electric_bike	Tue Aug 20 2024 16:04:33 GMT+0000 (Coordinated Universal Time)	Tue Aug 20 2024 16:08:27 GMT+0000 (Coordinated Universal Time)	Franklin St & Monroe St	TA1309000007	Kingsbury St & Kinzie St	KA1503000043	41.880317	-87.635185	41.88917683258	-87.6385057718	member
0512319767100E18	electric_bike	Tue Aug 06 2024 11:28:36 GMT+0000 (Coordinated Universal Time)	Tue Aug 06 2024 11:30:37 GMT+0000 (Coordinated Universal Time)	Franklin St & Monroe St	TA1309000007	nan	nan	41.880317	-87.635185	41.88	-87.64	member
157E93813FE5D732	electric_bike	Tue Aug 06 2024 14:06:01 GMT+0000 (Coordinated Universal Time)	Tue Aug 06 2024 14:10:33 GMT+0000 (Coordinated Universal Time)	Franklin St & Monroe St	TA1309000007	nan	nan	41.880317	-87.635185	41.89	-87.63	member


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