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

@kaggle.shintarosneath_cyclistic_2023.n_202302_divvy_tripdata_cleaned

5.39 MB
190445 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
CBCD0D7777F0E45F	classic_bike	14/2/2023 11:59	14/2/2023 12:13	Southport Ave & Clybourn Ave	TA1309000030	Clark St & Schiller St	TA1309000024	casual	0:13:56	3
F3EC5FCE5FF39DE9	electric_bike	15/2/2023 13:53	15/2/2023 13:59	Clarendon Ave & Gordon Ter	13379	Sheridan Rd & Lawrence Ave	TA1309000041	casual	0:05:20	4
E54C1F27FA9354FF	classic_bike	19/2/2023 11:10	19/2/2023 11:35	Southport Ave & Clybourn Ave	TA1309000030	Aberdeen St & Monroe St	13156	member	0:24:04	1
3D561E04F739CC45	electric_bike	26/2/2023 16:12	26/2/2023 16:39	Southport Ave & Clybourn Ave	TA1309000030	Franklin St & Adams St (Temp)	TA1309000008	member	0:27:50	1
0CB4B4D53B2DBE05	electric_bike	20/2/2023 11:55	20/2/2023 12:05	Prairie Ave & Garfield Blvd	TA1307000160	Cottage Grove Ave & 63rd St	KA1503000054	member	0:10:25	2
C67EB62172C472EB	classic_bike	24/2/2023 18:50	24/2/2023 18:56	Wells St & Concord Ln	TA1308000050	Clybourn Ave & Division St	TA1307000115	member	0:06:24	6
08A1E9326F68ACF7	classic_bike	28/2/2023 12:58	28/2/2023 13:03	Wells St & Concord Ln	TA1308000050	Clybourn Ave & Division St	TA1307000115	member	0:05:30	3
904C61FB3984A60E	classic_bike	27/2/2023 20:26	27/2/2023 20:31	Wells St & Concord Ln	TA1308000050	Clybourn Ave & Division St	TA1307000115	member	0:05:23	2
A96A6DA2D96544E6	classic_bike	8/2/2023 19:56	8/2/2023 20:02	Wells St & Concord Ln	TA1308000050	Clybourn Ave & Division St	TA1307000115	member	0:05:46	4
DA895AE47787D208	classic_bike	21/2/2023 18:52	21/2/2023 18:57	Wells St & Concord Ln	TA1308000050	Clybourn Ave & Division St	TA1307000115	member	0:05:37	3


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