Google Capstone Project

Navigate Speedy Success For Bike-Share Company "Cyclistic"

@kaggle.haniarthur_google_capstone_project

Table List

12 tables(272.12 MB)

N 202201 Divvy Tripdata

N 202202 Divvy Tripdata

N 202203 Divvy Tripdata

N 202204 Divvy Tripdata

N 202205 Divvy Tripdata

N 202206 Divvy Tripdata

N 202207 Divvy Tripdata

N 202208 Divvy Tripdata

N 202209 Divvy Tripdata

N 202210 Divvy Tripdata

N 202211 Divvy Tripdata

N 202212 Divvy Tripdata

N 202206 Divvy Tripdata

@kaggle.haniarthur_google_capstone_project.n_202206_divvy_tripdata

35.78 MB
769204 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
600CFD130D0FD2A4	electric_bike	Thu Jun 30 2022 17:27:53 GMT+0000 (Coordinated Universal Time)	Thu Jun 30 2022 17:35:15 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.89	-87.62	41.91	-87.62	casual
F5E6B5C1682C6464	electric_bike	Thu Jun 30 2022 18:39:52 GMT+0000 (Coordinated Universal Time)	Thu Jun 30 2022 18:47:28 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.91	-87.62	41.93	-87.63	casual
B6EB6D27BAD771D2	electric_bike	Thu Jun 30 2022 11:49:25 GMT+0000 (Coordinated Universal Time)	Thu Jun 30 2022 12:02:54 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.91	-87.65	41.89	-87.61	casual
C9C320375DE1D5C6	electric_bike	Thu Jun 30 2022 11:15:25 GMT+0000 (Coordinated Universal Time)	Thu Jun 30 2022 11:19:43 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.8	-87.66	41.8	-87.65	casual
56C055851023BE98	electric_bike	Wed Jun 29 2022 23:36:50 GMT+0000 (Coordinated Universal Time)	Wed Jun 29 2022 23:45:17 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.91	-87.63	41.93	-87.64	casual
B664188E8163D045	electric_bike	Thu Jun 30 2022 16:42:10 GMT+0000 (Coordinated Universal Time)	Thu Jun 30 2022 16:58:22 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	42.03	-87.71	42.06	-87.73	casual
338C05A3E90D619B	electric_bike	Thu Jun 30 2022 18:39:07 GMT+0000 (Coordinated Universal Time)	Thu Jun 30 2022 19:05:02 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.91	-87.63	41.92	-87.72	casual
C037F5F4107788DE	electric_bike	Thu Jun 30 2022 12:46:14 GMT+0000 (Coordinated Universal Time)	Thu Jun 30 2022 14:12:48 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.89	-87.62	41.98	-87.67	casual
C19B08D794D1C89E	electric_bike	Thu Jun 30 2022 11:09:38 GMT+0000 (Coordinated Universal Time)	Thu Jun 30 2022 11:10:25 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.89	-87.61	41.89	-87.61	casual
6E9E3A041C14E960	electric_bike	Thu Jun 30 2022 11:05:46 GMT+0000 (Coordinated Universal Time)	Thu Jun 30 2022 11:09:11 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.89	-87.61	41.89	-87.61	casual


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