Daily Cycle Service Usage Dataset

Do you like cycling ?

@kaggle.durgeshrao9993_trip_dataset

Table List

1 table(6.98 MB)

Trip

@kaggle.durgeshrao9993_trip_dataset.trip

6.98 MB
236065 rows
12 columns

trip_id Trip Id	starttime Starttime	stoptime Stoptime	bikeid Bikeid	tripduration Tripduration	from_station_name From Station Name	to_station_name To Station Name	from_station_id From Station Id	to_station_id To Station Id	usertype Usertype	gender Gender	birthyear Birthyear
431	Mon Oct 13 2014 10:31:00 GMT+0000 (Coordinated Universal Time)	Mon Oct 13 2014 10:48:00 GMT+0000 (Coordinated Universal Time)	SEA00298	985.935	2nd Ave & Spring St	Occidental Park / Occidental Ave S & S Washington St	CBD-06	PS-04	Member	Male	1960
432	Mon Oct 13 2014 10:32:00 GMT+0000 (Coordinated Universal Time)	Mon Oct 13 2014 10:48:00 GMT+0000 (Coordinated Universal Time)	SEA00195	926.375	2nd Ave & Spring St	Occidental Park / Occidental Ave S & S Washington St	CBD-06	PS-04	Member	Male	1970
433	Mon Oct 13 2014 10:33:00 GMT+0000 (Coordinated Universal Time)	Mon Oct 13 2014 10:48:00 GMT+0000 (Coordinated Universal Time)	SEA00486	883.831	2nd Ave & Spring St	Occidental Park / Occidental Ave S & S Washington St	CBD-06	PS-04	Member	Female	1988
434	Mon Oct 13 2014 10:34:00 GMT+0000 (Coordinated Universal Time)	Mon Oct 13 2014 10:48:00 GMT+0000 (Coordinated Universal Time)	SEA00333	865.937	2nd Ave & Spring St	Occidental Park / Occidental Ave S & S Washington St	CBD-06	PS-04	Member	Female	1977
435	Mon Oct 13 2014 10:34:00 GMT+0000 (Coordinated Universal Time)	Mon Oct 13 2014 10:49:00 GMT+0000 (Coordinated Universal Time)	SEA00202	923.923	2nd Ave & Spring St	Occidental Park / Occidental Ave S & S Washington St	CBD-06	PS-04	Member	Male	1971
436	Mon Oct 13 2014 10:34:00 GMT+0000 (Coordinated Universal Time)	Mon Oct 13 2014 10:47:00 GMT+0000 (Coordinated Universal Time)	SEA00337	808.805	2nd Ave & Spring St	Occidental Park / Occidental Ave S & S Washington St	CBD-06	PS-04	Member	Male	1974
437	Mon Oct 13 2014 11:35:00 GMT+0000 (Coordinated Universal Time)	Mon Oct 13 2014 11:45:00 GMT+0000 (Coordinated Universal Time)	SEA00202	596.715	Occidental Park / Occidental Ave S & S Washington St	King Street Station Plaza / 2nd Ave Extension S & S Jackson St	PS-04	PS-05	Member	Male	1978
438	Mon Oct 13 2014 11:35:00 GMT+0000 (Coordinated Universal Time)	Mon Oct 13 2014 11:45:00 GMT+0000 (Coordinated Universal Time)	SEA00311	592.131	Occidental Park / Occidental Ave S & S Washington St	King Street Station Plaza / 2nd Ave Extension S & S Jackson St	PS-04	PS-05	Member	Male	1983
439	Mon Oct 13 2014 11:35:00 GMT+0000 (Coordinated Universal Time)	Mon Oct 13 2014 11:45:00 GMT+0000 (Coordinated Universal Time)	SEA00486	586.347	Occidental Park / Occidental Ave S & S Washington St	King Street Station Plaza / 2nd Ave Extension S & S Jackson St	PS-04	PS-05	Member	Female	1974
440	Mon Oct 13 2014 11:35:00 GMT+0000 (Coordinated Universal Time)	Mon Oct 13 2014 11:45:00 GMT+0000 (Coordinated Universal Time)	SEA00434	587.634	Occidental Park / Occidental Ave S & S Washington St	King Street Station Plaza / 2nd Ave Extension S & S Jackson St	PS-04	PS-05	Member	Male	1958


CREATE TABLE trip (
  "trip_id" BIGINT,
  "starttime" TIMESTAMP,
  "stoptime" TIMESTAMP,
  "bikeid" VARCHAR,
  "tripduration" DOUBLE,
  "from_station_name" VARCHAR,
  "to_station_name" VARCHAR,
  "from_station_id" VARCHAR,
  "to_station_id" VARCHAR,
  "usertype" VARCHAR,
  "gender" VARCHAR,
  "birthyear" DOUBLE
);