Divvy 2019

The full year for Cyclistic

@kaggle.moazmohamedhassan_divvy_2019

Table List

4 tables(103.23 MB)

Divvy Trips 2019 Q1

@kaggle.moazmohamedhassan_divvy_2019.divvy_trips_2019_q1

10.15 MB
365069 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
21742443	Tue Jan 01 2019 00:04:37 GMT+0000 (Coordinated Universal Time)	Tue Jan 01 2019 00:11:07 GMT+0000 (Coordinated Universal Time)	2167	390	199	Wabash Ave & Grand Ave	84	Milwaukee Ave & Grand Ave	Subscriber	Male	1989
21742444	Tue Jan 01 2019 00:08:13 GMT+0000 (Coordinated Universal Time)	Tue Jan 01 2019 00:15:34 GMT+0000 (Coordinated Universal Time)	4386	441	44	State St & Randolph St	624	Dearborn St & Van Buren St (*)	Subscriber	Female	1990
21742445	Tue Jan 01 2019 00:13:23 GMT+0000 (Coordinated Universal Time)	Tue Jan 01 2019 00:27:12 GMT+0000 (Coordinated Universal Time)	1524	829	15	Racine Ave & 18th St	644	Western Ave & Fillmore St (*)	Subscriber	Female	1994
21742446	Tue Jan 01 2019 00:13:45 GMT+0000 (Coordinated Universal Time)	Tue Jan 01 2019 00:43:28 GMT+0000 (Coordinated Universal Time)	252	1783	123	California Ave & Milwaukee Ave	176	Clark St & Elm St	Subscriber	Male	1993
21742447	Tue Jan 01 2019 00:14:52 GMT+0000 (Coordinated Universal Time)	Tue Jan 01 2019 00:20:56 GMT+0000 (Coordinated Universal Time)	1170	364	173	Mies van der Rohe Way & Chicago Ave	35	Streeter Dr & Grand Ave	Subscriber	Male	1994
21742448	Tue Jan 01 2019 00:15:33 GMT+0000 (Coordinated Universal Time)	Tue Jan 01 2019 00:19:09 GMT+0000 (Coordinated Universal Time)	2437	216	98	LaSalle St & Washington St	49	Dearborn St & Monroe St	Subscriber	Female	1983
21742449	Tue Jan 01 2019 00:16:06 GMT+0000 (Coordinated Universal Time)	Tue Jan 01 2019 00:19:03 GMT+0000 (Coordinated Universal Time)	2708	177	98	LaSalle St & Washington St	49	Dearborn St & Monroe St	Subscriber	Male	1984
21742450	Tue Jan 01 2019 00:18:41 GMT+0000 (Coordinated Universal Time)	Tue Jan 01 2019 00:20:21 GMT+0000 (Coordinated Universal Time)	2796	100	211	St. Clair St & Erie St	142	McClurg Ct & Erie St	Subscriber	Male	1990
21742451	Tue Jan 01 2019 00:18:43 GMT+0000 (Coordinated Universal Time)	Tue Jan 01 2019 00:47:30 GMT+0000 (Coordinated Universal Time)	6205	1727	150	Fort Dearborn Dr & 31st St	148	State St & 33rd St	Subscriber	Male	1995
21742452	Tue Jan 01 2019 00:19:18 GMT+0000 (Coordinated Universal Time)	Tue Jan 01 2019 00:24:54 GMT+0000 (Coordinated Universal Time)	3939	336	268	Lake Shore Dr & North Blvd	141	Clark St & Lincoln Ave	Subscriber	Male	1996


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