Divvy Cyclistic (Dec'2020 - Mar'2021)

Capstone Project - Divvy ride share dataset

@kaggle.mohitsingh8057_cyclistic_data

Table List

1 table(6.29 MB)

Trips Data202012–202103 Cyclistic Data

Trips Data202012–202103 Cyclistic Data

@kaggle.mohitsingh8057_cyclistic_data.trips_data202012_202103_cyclistic_data

6.29 MB
506087 rows
14 columns

rideable_type Rideable Type	users Users	started_day Started Day	started_date Started Date	started_time Started Time	started_hour Started Hour	started_month Started Month	ended_day Ended Day	ended_date Ended Date	ended_time Ended Time	ended_hour Ended Hour	ended_month Ended Month	ride_length Ride Length	average_ride_length Average Ride Length
classic_bike	member	Sunday	Sun Dec 27 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	12:44:29 PM	12	12	Sunday	Sun Dec 27 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	12:55:06 PM	12	12	0:10:37	0:19:47
electric_bike	member	Friday	Fri Dec 18 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	5:37:15 PM	17	12	Friday	Fri Dec 18 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	5:44:19 PM	17	12	0:07:04	nan
electric_bike	member	Tuesday	Tue Dec 15 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	3:04:33 PM	15	12	Tuesday	Tue Dec 15 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	3:11:28 PM	15	12	0:06:55	nan
electric_bike	member	Tuesday	Tue Dec 15 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	3:54:18 PM	15	12	Tuesday	Tue Dec 15 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	4:00:11 PM	16	12	0:05:53	nan
electric_bike	member	Tuesday	Tue Dec 22 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	12:08:17 PM	12	12	Tuesday	Tue Dec 22 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	12:10:59 PM	12	12	0:02:42	nan
electric_bike	member	Tuesday	Tue Dec 22 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1:26:37 PM	13	12	Tuesday	Tue Dec 22 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1:34:50 PM	13	12	0:08:13	nan
electric_bike	member	Thursday	Thu Dec 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	4:23:48 PM	16	12	Thursday	Thu Dec 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	4:33:39 PM	16	12	0:09:51	nan
electric_bike	member	Thursday	Thu Dec 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	3:03:38 PM	15	12	Thursday	Thu Dec 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	3:12:39 PM	15	12	0:09:01	nan
electric_bike	member	Saturday	Sat Dec 12 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	9:26:17 AM	9	12	Saturday	Sat Dec 12 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	9:26:35 AM	9	12	0:00:18	nan
electric_bike	member	Friday	Fri Dec 18 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	12:52:06 PM	12	12	Friday	Fri Dec 18 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	12:52:23 PM	12	12	0:00:17	nan


CREATE TABLE trips_data202012_202103_cyclistic_data (
  "rideable_type" VARCHAR,
  "users" VARCHAR,
  "started_day" VARCHAR,
  "started_date" TIMESTAMP,
  "started_time" VARCHAR,
  "started_hour" BIGINT,
  "started_month" BIGINT,
  "ended_day" VARCHAR,
  "ended_date" TIMESTAMP,
  "ended_time" VARCHAR,
  "ended_hour" BIGINT,
  "ended_month" BIGINT,
  "ride_length" VARCHAR,
  "average_ride_length" VARCHAR
);