Cyclistic 2023

Data on bikeshare trips in 2023 in Chicago city

@kaggle.shintarosneath_cyclistic_2023

Table List

12 tables(165.82 MB)

N 202301 Divvy Tripdata Cleaned

N 202302 Divvy Tripdata Cleaned

N 202303 Divvy Tripdata Cleaned

N 202304 Divvy Tripdata Cleaned

N 202305 Divvy Tripdata Cleaned

N 202306 Divvy Tripdata Cleaned

N 202307 Divvy Tripdata Cleaned

N 202308 Divvy Tripdata Cleaned

N 202309 Divvy Tripdata Cleaned

N 202310 Divvy Tripdata Cleaned

N 202311 Divvy Tripdata Cleaned

N 202312 Divvy Tripdata Cleaned

N 202305 Divvy Tripdata Cleaned

@kaggle.shintarosneath_cyclistic_2023.n_202305_divvy_tripdata_cleaned

17.62 MB
604827 rows
11 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	member_casual Member Casual	ride_length Ride Length	day_of_week Day Of Week
0D9FA920C3062031	electric_bike	7/5/2023 19:53	7/5/2023 19:58	Southport Ave & Belmont Ave	13229	nan	nan	member	0:04:44	1
92485E5FB5888ACD	electric_bike	6/5/2023 18:54	6/5/2023 19:03	Southport Ave & Belmont Ave	13229	nan	nan	member	0:09:27	7
FB144B3FC8300187	electric_bike	21/5/2023 0:40	21/5/2023 0:44	Halsted St & 21st St	13162	nan	nan	member	0:04:15	1
DDEB93BC2CE9AA77	classic_bike	10/5/2023 16:47	10/5/2023 16:59	Carpenter St & Huron St	13196	Damen Ave & Cortland St	13133	member	0:12:51	4
C07B70172FC92F59	classic_bike	9/5/2023 18:30	9/5/2023 18:39	Southport Ave & Clark St	TA1308000047	Southport Ave & Belmont Ave	13229	member	0:08:54	3
2BA66385DF8F815A	classic_bike	30/5/2023 15:01	30/5/2023 15:17	Clinton St & Madison St	TA1305000032	McClurg Ct & Ohio St	TA1306000029	member	0:15:39	3
31EFCCB05F12D8EF	docked_bike	9/5/2023 14:13	9/5/2023 14:47	DuSable Lake Shore Dr & Monroe St	13300	Adler Planetarium	13431	casual	0:33:40	3
71DFF834E1D3CE0B	classic_bike	6/5/2023 16:47	6/5/2023 16:52	Shore Dr & 55th St	TA1308000009	Harper Ave & 59th St	KA1503000070	member	0:04:51	7
2117485899B4CEA4	classic_bike	15/5/2023 12:47	15/5/2023 13:00	Clark St & Schiller St	TA1309000024	Franklin St & Lake St	TA1307000111	member	0:12:39	2
811149F69AAE82DD	electric_bike	19/5/2023 5:44	19/5/2023 5:47	Clinton St & Madison St	TA1305000032	Kingsbury St & Kinzie St	KA1503000043	member	0:02:58	6


CREATE TABLE n_202305_divvy_tripdata_cleaned (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" VARCHAR,
  "ended_at" VARCHAR,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "member_casual" VARCHAR,
  "ride_length" VARCHAR,
  "day_of_week" BIGINT
);