Cyclistic Bike Share Trip Data - 06.2023

Google Data Analytics Capstone Project

@kaggle.rubyphan_bike_share

Table List

12 tables(281.77 MB)

N 202207 Divvy Tripdata

N 202208 Divvy Tripdata

N 202209 Divvy Publictripdata

N 202210 Divvy Tripdata

N 202211 Divvy Tripdata

N 202212 Divvy Tripdata

N 202301 Divvy Tripdata

N 202302 Divvy Tripdata

N 202303 Divvy Tripdata

N 202304 Divvy Tripdata

N 202305 Divvy Tripdata

N 202306 Divvy Tripdata

N 202209 Divvy Publictripdata

@kaggle.rubyphan_bike_share.n_202209_divvy_publictripdata

33.78 MB
701339 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
5156990AC19CA285	electric_bike	Thu Sep 01 2022 08:36:22 GMT+0000 (Coordinated Universal Time)	Thu Sep 01 2022 08:39:05 GMT+0000 (Coordinated Universal Time)	nan	nan	California Ave & Milwaukee Ave	13084	41.93	-87.69	41.922695	-87.697153	casual
E12D4A16BF51C274	electric_bike	Thu Sep 01 2022 17:11:29 GMT+0000 (Coordinated Universal Time)	Thu Sep 01 2022 17:14:45 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.87	-87.62	41.87	-87.62	casual
A02B53CD7DB72DD7	electric_bike	Thu Sep 01 2022 17:15:50 GMT+0000 (Coordinated Universal Time)	Thu Sep 01 2022 17:16:12 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.87	-87.62	41.87	-87.62	casual
C82E05FEE872DF11	electric_bike	Thu Sep 01 2022 09:00:28 GMT+0000 (Coordinated Universal Time)	Thu Sep 01 2022 09:10:32 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.93	-87.69	41.94	-87.67	casual
4DEEB4550A266AE1	electric_bike	Thu Sep 01 2022 07:30:11 GMT+0000 (Coordinated Universal Time)	Thu Sep 01 2022 07:32:36 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.92	-87.73	41.92	-87.73	casual
B1721F8C7C3AC6BF	electric_bike	Thu Sep 01 2022 12:04:25 GMT+0000 (Coordinated Universal Time)	Thu Sep 01 2022 12:21:08 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.89	-87.65	41.92	-87.67	casual
626FFDF9B539BA93	electric_bike	Thu Sep 01 2022 12:05:51 GMT+0000 (Coordinated Universal Time)	Thu Sep 01 2022 12:13:09 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.93	-87.71	41.92	-87.7	casual
87DD84E6036616E4	electric_bike	Thu Sep 01 2022 06:24:57 GMT+0000 (Coordinated Universal Time)	Thu Sep 01 2022 06:31:14 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.9	-87.63	41.89	-87.62	casual
93EF429B574F2BC3	electric_bike	Thu Sep 01 2022 16:29:28 GMT+0000 (Coordinated Universal Time)	Thu Sep 01 2022 16:40:51 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.92	-87.67	41.9	-87.68	casual
3D318B7D137DDDE7	electric_bike	Thu Sep 01 2022 17:37:35 GMT+0000 (Coordinated Universal Time)	Thu Sep 01 2022 17:52:46 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.94	-87.67	41.93	-87.71	casual


CREATE TABLE n_202209_divvy_publictripdata (
  "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
);