Divvy 2019

The full year for Cyclistic

@kaggle.moazmohamedhassan_divvy_2019

Table List

4 tables(103.23 MB)

Divvy Trips 2019 Q2

@kaggle.moazmohamedhassan_divvy_2019.divvy_trips_2019_q2

29.95 MB
1108163 rows
12 columns

n_01_rental_details_rental_id 01 - Rental Details Rental ID	n_01_rental_details_local_start_time 01 - Rental Details Local Start Time	n_01_rental_details_local_end_time 01 - Rental Details Local End Time	n_01_rental_details_bike_id 01 - Rental Details Bike ID	n_01_rental_details_duration_in_seconds_uncapped 01 - Rental Details Duration In Seconds Uncapped	n_03_rental_start_station_id 03 - Rental Start Station ID	n_03_rental_start_station_name 03 - Rental Start Station Name	n_02_rental_end_station_id 02 - Rental End Station ID	n_02_rental_end_station_name 02 - Rental End Station Name	user_type User Type	member_gender Member Gender	n_05_member_details_member_birthday_year 05 - Member Details Member Birthday Year
22178529	Mon Apr 01 2019 00:02:22 GMT+0000 (Coordinated Universal Time)	Mon Apr 01 2019 00:09:48 GMT+0000 (Coordinated Universal Time)	6251	446	81	Daley Center Plaza	56	Desplaines St & Kinzie St	Subscriber	Male	1975
22178530	Mon Apr 01 2019 00:03:02 GMT+0000 (Coordinated Universal Time)	Mon Apr 01 2019 00:20:30 GMT+0000 (Coordinated Universal Time)	6226	1048	317	Wood St & Taylor St	59	Wabash Ave & Roosevelt Rd	Subscriber	Female	1984
22178531	Mon Apr 01 2019 00:11:07 GMT+0000 (Coordinated Universal Time)	Mon Apr 01 2019 00:15:19 GMT+0000 (Coordinated Universal Time)	5649	252	283	LaSalle St & Jackson Blvd	174	Canal St & Madison St	Subscriber	Male	1990
22178532	Mon Apr 01 2019 00:13:01 GMT+0000 (Coordinated Universal Time)	Mon Apr 01 2019 00:18:58 GMT+0000 (Coordinated Universal Time)	4151	357	26	McClurg Ct & Illinois St	133	Kingsbury St & Kinzie St	Subscriber	Male	1993
22178533	Mon Apr 01 2019 00:19:26 GMT+0000 (Coordinated Universal Time)	Mon Apr 01 2019 00:36:13 GMT+0000 (Coordinated Universal Time)	3270	1007	202	Halsted St & 18th St	129	Blue Island Ave & 18th St	Subscriber	Male	1992
22178534	Mon Apr 01 2019 00:19:39 GMT+0000 (Coordinated Universal Time)	Mon Apr 01 2019 00:23:56 GMT+0000 (Coordinated Universal Time)	3123	257	420	Ellis Ave & 55th St	426	Ellis Ave & 60th St	Subscriber	Male	1999
22178535	Mon Apr 01 2019 00:26:33 GMT+0000 (Coordinated Universal Time)	Mon Apr 01 2019 00:35:41 GMT+0000 (Coordinated Universal Time)	6418	548	503	Drake Ave & Fullerton Ave	500	Central Park Ave & Elbridge Ave	Subscriber	Male	1969
22178536	Mon Apr 01 2019 00:29:48 GMT+0000 (Coordinated Universal Time)	Mon Apr 01 2019 00:36:11 GMT+0000 (Coordinated Universal Time)	4513	383	260	Kedzie Ave & Milwaukee Ave	499	Kosciuszko Park	Subscriber	Male	1991
22178537	Mon Apr 01 2019 00:32:07 GMT+0000 (Coordinated Universal Time)	Mon Apr 01 2019 01:07:44 GMT+0000 (Coordinated Universal Time)	3280	2137	211	St. Clair St & Erie St	211	St. Clair St & Erie St	Customer	nan
22178538	Mon Apr 01 2019 00:32:19 GMT+0000 (Coordinated Universal Time)	Mon Apr 01 2019 01:07:39 GMT+0000 (Coordinated Universal Time)	5534	2120	211	St. Clair St & Erie St	211	St. Clair St & Erie St	Customer	nan


CREATE TABLE divvy_trips_2019_q2 (
  "n_01_rental_details_rental_id" BIGINT,
  "n_01_rental_details_local_start_time" TIMESTAMP,
  "n_01_rental_details_local_end_time" TIMESTAMP,
  "n_01_rental_details_bike_id" BIGINT,
  "n_01_rental_details_duration_in_seconds_uncapped" DOUBLE,
  "n_03_rental_start_station_id" BIGINT,
  "n_03_rental_start_station_name" VARCHAR,
  "n_02_rental_end_station_id" BIGINT,
  "n_02_rental_end_station_name" VARCHAR,
  "user_type" VARCHAR,
  "member_gender" VARCHAR,
  "n_05_member_details_member_birthday_year" DOUBLE
);