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 202303 Divvy Tripdata Cleaned

@kaggle.shintarosneath_cyclistic_2023.n_202303_divvy_tripdata_cleaned

7.74 MB
258678 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
6842AA605EE9FBB3	electric_bike	16/3/2023 8:20	16/3/2023 8:22	Clark St & Armitage Ave	13146	Larrabee St & Webster Ave	13193	member	0:02:18	5
F984267A75B99A8C	electric_bike	4/3/2023 14:07	4/3/2023 14:15	Public Rack - Kedzie Ave & Argyle St	491	nan	nan	member	0:08:25	7
FF7CF57CFE026D02	classic_bike	31/3/2023 12:28	31/3/2023 12:38	Orleans St & Chestnut St (NEXT Apts)	620	Clark St & Randolph St	TA1305000030	member	0:10:38	6
6B61B916032CB6D6	classic_bike	22/3/2023 14:09	22/3/2023 14:24	Desplaines St & Kinzie St	TA1306000003	Sheffield Ave & Kingsbury St	13154	member	0:15:43	4
E55E61A5F1260040	electric_bike	9/3/2023 7:15	9/3/2023 7:26	Walsh Park	18067	Sangamon St & Lake St	TA1306000015	member	0:11:00	5
123AAD676850F53C	classic_bike	22/3/2023 17:47	22/3/2023 18:01	Orleans St & Chestnut St (NEXT Apts)	620	Halsted St & Wrightwood Ave	TA1309000061	member	0:14:27	4
5929D3080983AF4F	classic_bike	8/3/2023 19:58	8/3/2023 20:05	Rush St & Hubbard St	KA1503000044	Wells St & Huron St	TA1306000012	member	0:06:55	4
B2624BAEDDDA3FB1	docked_bike	22/3/2023 17:28	22/3/2023 17:50	Adler Planetarium	13431	Michigan Ave & Ida B Wells Dr	TA1305000010	casual	0:22:00	4
979C41EAC356278F	classic_bike	16/3/2023 19:31	16/3/2023 19:41	Broadway & Wilson Ave	13074	Ravenswood Ave & Irving Park Rd	TA1307000149	member	0:09:47	5
6C1DCA9593CA8F5F	classic_bike	16/3/2023 17:33	16/3/2023 17:45	Stetson Ave & South Water St	TA1308000029	Clinton St & Washington Blvd	WL-012	member	0:11:57	5


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