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

@kaggle.salamibrahim_cyclistic.n_202105_divvy_tripdata

25.97 MB
531633 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
C809ED75D6160B2A	electric_bike	Sun May 30 2021 11:58:15 GMT+0000 (Coordinated Universal Time)	Sun May 30 2021 12:10:39 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.9	-87.63	41.89	-87.61	casual
DD59FDCE0ACACAF3	electric_bike	Sun May 30 2021 11:29:14 GMT+0000 (Coordinated Universal Time)	Sun May 30 2021 12:14:09 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.88	-87.62	41.79	-87.58	casual
0AB83CB88C43EFC2	electric_bike	Sun May 30 2021 14:24:01 GMT+0000 (Coordinated Universal Time)	Sun May 30 2021 14:25:13 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.92	-87.7	41.92	-87.7	casual
7881AC6D39110C60	electric_bike	Sun May 30 2021 14:25:51 GMT+0000 (Coordinated Universal Time)	Sun May 30 2021 14:41:04 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.92	-87.7	41.94	-87.69	casual
853FA701B4582BAF	electric_bike	Sun May 30 2021 18:15:39 GMT+0000 (Coordinated Universal Time)	Sun May 30 2021 18:22:32 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.94	-87.69	41.94	-87.7	casual
F5E63DFD96B2A737	electric_bike	Sun May 30 2021 11:33:41 GMT+0000 (Coordinated Universal Time)	Sun May 30 2021 11:57:17 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.88	-87.63	41.89	-87.62	casual
C884951E36656727	electric_bike	Sun May 30 2021 10:51:37 GMT+0000 (Coordinated Universal Time)	Sun May 30 2021 11:06:20 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.93	-87.7	41.9	-87.69	casual
48B60B250FE75AF9	electric_bike	Wed May 05 2021 13:57:03 GMT+0000 (Coordinated Universal Time)	Wed May 05 2021 14:14:58 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.78	-87.64	41.78	-87.64	casual
E3D0CC2FE1359880	electric_bike	Wed May 05 2021 11:31:26 GMT+0000 (Coordinated Universal Time)	Wed May 05 2021 11:34:03 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.78	-87.64	41.78	-87.64	casual
4382735758ABF2CE	electric_bike	Tue May 04 2021 19:51:05 GMT+0000 (Coordinated Universal Time)	Tue May 04 2021 20:17:26 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.78	-87.64	41.78	-87.64	casual


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