Cyclistic

Bike share data cyclistic

@kaggle.salamibrahim_cyclistic

Table List

12 tables(282.45 MB)

N 202104 Divvy Tripdata

N 202105 Divvy Tripdata

N 202106 Divvy Tripdata

N 202107 Divvy Tripdata

N 202108 Divvy Tripdata

N 202109 Divvy Tripdata

N 202110 Divvy Tripdata

N 202111 Divvy Tripdata

N 202112 Divvy Tripdata

N 202201 Divvy Tripdata

N 202202 Divvy Tripdata

N 202203 Divvy Tripdata

N 202108 Divvy Tripdata

@kaggle.salamibrahim_cyclistic.n_202108_divvy_tripdata

38.55 MB
804352 rows
13 columns

ride_id Ride Id	rideable_type Rideable Type	started_at Started At	ended_at Ended At	start_station_name Start Station Name	start_station_id Start Station Id	end_station_name End Station Name	end_station_id End Station Id	start_lat Start Lat	start_lng Start Lng	end_lat End Lat	end_lng End Lng	member_casual Member Casual
99103BB87CC6C1BB	electric_bike	Tue Aug 10 2021 17:15:49 GMT+0000 (Coordinated Universal Time)	Tue Aug 10 2021 17:22:44 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.77	-87.68	41.77	-87.68	member
EAFCCCFB0A3FC5A1	electric_bike	Tue Aug 10 2021 17:23:14 GMT+0000 (Coordinated Universal Time)	Tue Aug 10 2021 17:39:24 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.77	-87.68	41.77	-87.63	member
9EF4F46C57AD234D	electric_bike	Sat Aug 21 2021 02:34:23 GMT+0000 (Coordinated Universal Time)	Sat Aug 21 2021 02:50:36 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.95	-87.65	41.97	-87.66	member
5834D3208BFAF1DA	electric_bike	Sat Aug 21 2021 06:52:55 GMT+0000 (Coordinated Universal Time)	Sat Aug 21 2021 07:08:13 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.97	-87.67	41.95	-87.65	member
CD825CB87ED1D096	electric_bike	Thu Aug 19 2021 11:55:29 GMT+0000 (Coordinated Universal Time)	Thu Aug 19 2021 12:04:11 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.79	-87.6	41.77	-87.62	member
612F12C94A964F3E	electric_bike	Thu Aug 19 2021 12:41:12 GMT+0000 (Coordinated Universal Time)	Thu Aug 19 2021 12:47:47 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.81	-87.61	41.8	-87.6	member
C7435946FDFFA9B7	electric_bike	Thu Aug 19 2021 12:21:50 GMT+0000 (Coordinated Universal Time)	Thu Aug 19 2021 12:37:31 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.77	-87.62	41.81	-87.61	member
C67017767EED2251	electric_bike	Fri Aug 13 2021 14:52:35 GMT+0000 (Coordinated Universal Time)	Fri Aug 13 2021 14:58:16 GMT+0000 (Coordinated Universal Time)	nan	nan	Clark St & Grace St	TA1307000127	41.94	-87.64	41.9508745	-87.659146	member
ABC4532F2B4983AB	electric_bike	Tue Aug 17 2021 18:23:55 GMT+0000 (Coordinated Universal Time)	Tue Aug 17 2021 18:24:13 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.92	-87.66	41.92	-87.66	member
82437E52DC3B9A8A	electric_bike	Wed Aug 04 2021 12:50:53 GMT+0000 (Coordinated Universal Time)	Wed Aug 04 2021 13:08:20 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.74	-87.53	41.74	-87.53	member


CREATE TABLE n_202108_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);