Divvy 2019

The full year for Cyclistic

@kaggle.moazmohamedhassan_divvy_2019

Table List

4 tables(103.23 MB)

Divvy Trips 2019 Q4

@kaggle.moazmohamedhassan_divvy_2019.divvy_trips_2019_q4

19.43 MB
704054 rows
12 columns

trip_id Trip Id	start_time Start Time	end_time End Time	bikeid Bikeid	tripduration Tripduration	from_station_id From Station Id	from_station_name From Station Name	to_station_id To Station Id	to_station_name To Station Name	usertype Usertype	gender Gender	birthyear Birthyear
25223640	Tue Oct 01 2019 00:01:39 GMT+0000 (Coordinated Universal Time)	Tue Oct 01 2019 00:17:20 GMT+0000 (Coordinated Universal Time)	2215	940	20	Sheffield Ave & Kingsbury St	309	Leavitt St & Armitage Ave	Subscriber	Male	1987
25223641	Tue Oct 01 2019 00:02:16 GMT+0000 (Coordinated Universal Time)	Tue Oct 01 2019 00:06:34 GMT+0000 (Coordinated Universal Time)	6328	258	19	Throop (Loomis) St & Taylor St	241	Morgan St & Polk St	Subscriber	Male	1998
25223642	Tue Oct 01 2019 00:04:32 GMT+0000 (Coordinated Universal Time)	Tue Oct 01 2019 00:18:43 GMT+0000 (Coordinated Universal Time)	3003	850	84	Milwaukee Ave & Grand Ave	199	Wabash Ave & Grand Ave	Subscriber	Female	1991
25223643	Tue Oct 01 2019 00:04:32 GMT+0000 (Coordinated Universal Time)	Tue Oct 01 2019 00:43:43 GMT+0000 (Coordinated Universal Time)	3275	2350	313	Lakeview Ave & Fullerton Pkwy	290	Kedzie Ave & Palmer Ct	Subscriber	Male	1990
25223644	Tue Oct 01 2019 00:04:34 GMT+0000 (Coordinated Universal Time)	Tue Oct 01 2019 00:35:42 GMT+0000 (Coordinated Universal Time)	5294	1867	210	Ashland Ave & Division St	382	Western Ave & Congress Pkwy	Subscriber	Male	1987
25223645	Tue Oct 01 2019 00:04:38 GMT+0000 (Coordinated Universal Time)	Tue Oct 01 2019 00:10:51 GMT+0000 (Coordinated Universal Time)	1891	373	156	Clark St & Wellington Ave	226	Racine Ave & Belmont Ave	Subscriber	Female	1994
25223646	Tue Oct 01 2019 00:04:52 GMT+0000 (Coordinated Universal Time)	Tue Oct 01 2019 00:22:45 GMT+0000 (Coordinated Universal Time)	1061	1072	84	Milwaukee Ave & Grand Ave	142	McClurg Ct & Erie St	Subscriber	Female	1991
25223647	Tue Oct 01 2019 00:04:57 GMT+0000 (Coordinated Universal Time)	Tue Oct 01 2019 00:29:16 GMT+0000 (Coordinated Universal Time)	1274	1458	156	Clark St & Wellington Ave	463	Clark St & Berwyn Ave	Subscriber	Male	1995
25223648	Tue Oct 01 2019 00:05:20 GMT+0000 (Coordinated Universal Time)	Tue Oct 01 2019 00:29:18 GMT+0000 (Coordinated Universal Time)	6011	1437	156	Clark St & Wellington Ave	463	Clark St & Berwyn Ave	Subscriber	Female	1993
25223649	Tue Oct 01 2019 00:05:20 GMT+0000 (Coordinated Universal Time)	Tue Oct 01 2019 02:23:46 GMT+0000 (Coordinated Universal Time)	2957	8306	336	Cottage Grove Ave & 47th St	336	Cottage Grove Ave & 47th St	Customer	nan


CREATE TABLE divvy_trips_2019_q4 (
  "trip_id" BIGINT,
  "start_time" TIMESTAMP,
  "end_time" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" DOUBLE,
  "from_station_id" BIGINT,
  "from_station_name" VARCHAR,
  "to_station_id" BIGINT,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR,
  "gender" VARCHAR,
  "birthyear" DOUBLE
);