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

@kaggle.shintarosneath_cyclistic_2023.n_202304_divvy_tripdata_cleaned

12.17 MB
426590 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
8FE8F7D9C10E88C7	electric_bike	2/4/2023 8:37	2/4/2023 8:41	nan	nan	nan	nan	member	0:04:09	1
34E4ED3ADF1D821B	electric_bike	19/4/2023 11:29	19/4/2023 11:52	nan	nan	nan	nan	member	0:23:10	4
5296BF07A2F77CB5	electric_bike	19/4/2023 8:41	19/4/2023 8:43	nan	nan	nan	nan	member	0:02:00	4
40759916B76D5D52	electric_bike	19/4/2023 13:31	19/4/2023 13:35	nan	nan	nan	nan	member	0:03:39	4
77A96F460101AC63	electric_bike	19/4/2023 12:05	19/4/2023 12:10	nan	nan	nan	nan	member	0:04:50	4
8D6A2328E19DC168	electric_bike	19/4/2023 12:17	19/4/2023 12:21	nan	nan	nan	nan	member	0:04:04	4
C97BBA66E07889F9	electric_bike	19/4/2023 9:35	19/4/2023 9:45	nan	nan	nan	nan	member	0:09:12	4
6687AD4C575FF734	electric_bike	11/4/2023 16:13	11/4/2023 16:18	nan	nan	nan	nan	member	0:04:58	3
A8FA4F73B22BC11F	electric_bike	11/4/2023 16:29	11/4/2023 16:40	nan	nan	nan	nan	member	0:10:59	3
81E158FE63D99994	electric_bike	19/4/2023 17:35	19/4/2023 17:36	nan	nan	nan	nan	member	0:00:31	4


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