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

@kaggle.shintarosneath_cyclistic_2023.n_202301_divvy_tripdata_cleaned

5.33 MB
190301 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
F96D5A74A3E41399	electric_bike	21/1/2023 20:05	21/1/2023 20:16	Lincoln Ave & Fullerton Ave	TA1309000058	Hampden Ct & Diversey Ave	202480	member	0:11:00	7
13CB7EB698CEDB88	classic_bike	10/1/2023 15:37	10/1/2023 15:46	Kimbark Ave & 53rd St	TA1309000037	Greenwood Ave & 47th St	TA1308000002	member	0:09:00	3
BD88A2E670661CE5	electric_bike	2/1/2023 7:51	2/1/2023 8:05	Western Ave & Lunt Ave	RP-005	Valli Produce - Evanston Plaza	599	casual	0:14:00	2
C90792D034FED968	classic_bike	22/1/2023 10:52	22/1/2023 11:01	Kimbark Ave & 53rd St	TA1309000037	Greenwood Ave & 47th St	TA1308000002	member	0:09:00	1
3397017529188E8A	classic_bike	12/1/2023 13:58	12/1/2023 14:13	Kimbark Ave & 53rd St	TA1309000037	Greenwood Ave & 47th St	TA1308000002	member	0:15:00	5
58E68156DAE3E311	electric_bike	31/1/2023 7:18	31/1/2023 7:21	Lakeview Ave & Fullerton Pkwy	TA1309000019	Hampden Ct & Diversey Ave	202480	member	0:03:00	3
2F7194B6012A98D4	electric_bike	15/1/2023 21:18	15/1/2023 21:32	Kimbark Ave & 53rd St	TA1309000037	Greenwood Ave & 47th St	TA1308000002	member	0:14:00	1
DB1CF84154D6A049	classic_bike	25/1/2023 10:49	25/1/2023 10:58	Kimbark Ave & 53rd St	TA1309000037	Greenwood Ave & 47th St	TA1308000002	member	0:09:00	4
34EAB943F88C4C5D	electric_bike	25/1/2023 20:49	25/1/2023 21:02	Kimbark Ave & 53rd St	TA1309000037	Greenwood Ave & 47th St	TA1308000002	member	0:13:00	4
BC8AB1AA51DA9115	classic_bike	6/1/2023 16:37	6/1/2023 16:49	Kimbark Ave & 53rd St	TA1309000037	Greenwood Ave & 47th St	TA1308000002	member	0:12:00	6


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