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 202106 Divvy Tripdata

@kaggle.salamibrahim_cyclistic.n_202106_divvy_tripdata

35.93 MB
729595 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
99FEC93BA843FB20	electric_bike	Sun Jun 13 2021 14:31:28 GMT+0000 (Coordinated Universal Time)	Sun Jun 13 2021 14:34:11 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.8	-87.59	41.8	-87.6	member
06048DCFC8520CAF	electric_bike	Fri Jun 04 2021 11:18:02 GMT+0000 (Coordinated Universal Time)	Fri Jun 04 2021 11:24:19 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.79	-87.59	41.8	-87.6	member
9598066F68045DF2	electric_bike	Fri Jun 04 2021 09:49:35 GMT+0000 (Coordinated Universal Time)	Fri Jun 04 2021 09:55:34 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.8	-87.6	41.79	-87.59	member
B03C0FE48C412214	electric_bike	Thu Jun 03 2021 19:56:05 GMT+0000 (Coordinated Universal Time)	Thu Jun 03 2021 20:21:55 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.78	-87.58	41.8	-87.6	member
B9EEA89F8FEE73B7	electric_bike	Fri Jun 04 2021 14:05:51 GMT+0000 (Coordinated Universal Time)	Fri Jun 04 2021 14:09:59 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.8	-87.59	41.79	-87.59	member
62B943CEAAA420BA	electric_bike	Thu Jun 03 2021 19:32:01 GMT+0000 (Coordinated Universal Time)	Thu Jun 03 2021 19:38:46 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.78	-87.58	41.78	-87.58	member
7E2546FBA79C46EE	electric_bike	Thu Jun 10 2021 16:30:10 GMT+0000 (Coordinated Universal Time)	Thu Jun 10 2021 16:36:21 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.79	-87.6	41.79	-87.59	member
3DDF3BBF6C4C3C89	electric_bike	Thu Jun 10 2021 17:00:30 GMT+0000 (Coordinated Universal Time)	Thu Jun 10 2021 17:06:48 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.79	-87.59	41.8	-87.59	member
2608805637155AB6	electric_bike	Thu Jun 10 2021 12:46:16 GMT+0000 (Coordinated Universal Time)	Thu Jun 10 2021 12:55:02 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.93	-87.67	41.94	-87.68	member
AF529C946F28ED42	electric_bike	Wed Jun 23 2021 17:57:29 GMT+0000 (Coordinated Universal Time)	Wed Jun 23 2021 18:06:40 GMT+0000 (Coordinated Universal Time)	nan	nan	Michigan Ave & Oak St	13042	41.88	-87.61	41.901052166666666	-87.623698	member


CREATE TABLE n_202106_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
);