Divvy 2019

The full year for Cyclistic

@kaggle.moazmohamedhassan_divvy_2019

Table List

4 tables(103.23 MB)

Divvy Trips 2019 Q3

@kaggle.moazmohamedhassan_divvy_2019.divvy_trips_2019_q3

43.7 MB
1640718 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
23479388	Mon Jul 01 2019 00:00:27 GMT+0000 (Coordinated Universal Time)	Mon Jul 01 2019 00:20:41 GMT+0000 (Coordinated Universal Time)	3591	1214	117	Wilton Ave & Belmont Ave	497	Kimball Ave & Belmont Ave	Subscriber	Male	1992
23479389	Mon Jul 01 2019 00:01:16 GMT+0000 (Coordinated Universal Time)	Mon Jul 01 2019 00:18:44 GMT+0000 (Coordinated Universal Time)	5353	1048	381	Western Ave & Monroe St	203	Western Ave & 21st St	Customer	nan
23479390	Mon Jul 01 2019 00:01:48 GMT+0000 (Coordinated Universal Time)	Mon Jul 01 2019 00:27:42 GMT+0000 (Coordinated Universal Time)	6180	1554	313	Lakeview Ave & Fullerton Pkwy	144	Larrabee St & Webster Ave	Customer	nan
23479391	Mon Jul 01 2019 00:02:07 GMT+0000 (Coordinated Universal Time)	Mon Jul 01 2019 00:27:10 GMT+0000 (Coordinated Universal Time)	5540	1503	313	Lakeview Ave & Fullerton Pkwy	144	Larrabee St & Webster Ave	Customer	nan
23479392	Mon Jul 01 2019 00:02:13 GMT+0000 (Coordinated Universal Time)	Mon Jul 01 2019 00:22:26 GMT+0000 (Coordinated Universal Time)	6014	1213	168	Michigan Ave & 14th St	62	McCormick Place	Customer	nan
23479393	Mon Jul 01 2019 00:02:21 GMT+0000 (Coordinated Universal Time)	Mon Jul 01 2019 00:07:31 GMT+0000 (Coordinated Universal Time)	4941	310	300	Broadway & Barry Ave	232	Pine Grove Ave & Waveland Ave	Subscriber	Male	1990
23479394	Mon Jul 01 2019 00:02:24 GMT+0000 (Coordinated Universal Time)	Mon Jul 01 2019 00:23:12 GMT+0000 (Coordinated Universal Time)	3770	1248	168	Michigan Ave & 14th St	62	McCormick Place	Customer	nan
23479395	Mon Jul 01 2019 00:02:26 GMT+0000 (Coordinated Universal Time)	Mon Jul 01 2019 00:28:16 GMT+0000 (Coordinated Universal Time)	5442	1550	313	Lakeview Ave & Fullerton Pkwy	144	Larrabee St & Webster Ave	Customer	nan
23479396	Mon Jul 01 2019 00:02:34 GMT+0000 (Coordinated Universal Time)	Mon Jul 01 2019 00:28:57 GMT+0000 (Coordinated Universal Time)	2957	1583	43	Michigan Ave & Washington St	195	Columbus Dr & Randolph St	Customer	nan
23479397	Mon Jul 01 2019 00:02:45 GMT+0000 (Coordinated Universal Time)	Mon Jul 01 2019 00:29:14 GMT+0000 (Coordinated Universal Time)	6091	1589	43	Michigan Ave & Washington St	195	Columbus Dr & Randolph St	Customer	nan


CREATE TABLE divvy_trips_2019_q3 (
  "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
);