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

@kaggle.haniarthur_google_capstone_project.n_202208_divvy_tripdata

37.96 MB
785932 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
550CF7EFEAE0C618	electric_bike	Sun Aug 07 2022 21:34:15 GMT+0000 (Coordinated Universal Time)	Sun Aug 07 2022 21:41:46 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.93	-87.69	41.94	-87.72	casual
DAD198F405F9C5F5	electric_bike	Mon Aug 08 2022 14:39:21 GMT+0000 (Coordinated Universal Time)	Mon Aug 08 2022 14:53:23 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.89	-87.64	41.92	-87.64	casual
E6F2BC47B65CB7FD	electric_bike	Mon Aug 08 2022 15:29:50 GMT+0000 (Coordinated Universal Time)	Mon Aug 08 2022 15:40:34 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.97	-87.69	41.97	-87.66	casual
F597830181C2E13C	electric_bike	Mon Aug 08 2022 02:43:50 GMT+0000 (Coordinated Universal Time)	Mon Aug 08 2022 02:58:53 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.94	-87.65	41.97	-87.69	casual
0CE689BB4E313E8D	electric_bike	Sun Aug 07 2022 20:24:06 GMT+0000 (Coordinated Universal Time)	Sun Aug 07 2022 20:29:58 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.85	-87.65	41.84	-87.66	casual
BFA7E7CC69860C20	electric_bike	Mon Aug 08 2022 13:06:08 GMT+0000 (Coordinated Universal Time)	Mon Aug 08 2022 13:19:09 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.79	-87.72	41.82	-87.69	casual
68C474A4E92F24B6	electric_bike	Mon Aug 08 2022 14:02:40 GMT+0000 (Coordinated Universal Time)	Mon Aug 08 2022 14:11:36 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.89	-87.63	41.89	-87.61	casual
14A985A3838AA8CC	electric_bike	Sun Aug 07 2022 20:56:17 GMT+0000 (Coordinated Universal Time)	Sun Aug 07 2022 21:14:14 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.96	-87.68	41.92	-87.68	casual
E724B94BCE2E7E36	electric_bike	Sun Aug 07 2022 21:30:05 GMT+0000 (Coordinated Universal Time)	Sun Aug 07 2022 21:41:28 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.92	-87.68	41.93	-87.72	casual
1AA3756A6F8189DB	electric_bike	Sun Aug 07 2022 23:53:05 GMT+0000 (Coordinated Universal Time)	Mon Aug 08 2022 00:04:14 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.93	-87.72	41.92	-87.68	casual


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