Cyclistic Case Study

Google Data Analytics Capstone Project

@kaggle.alexandria101_cyclistic_case_study

Table List

12 tables(286.55 MB)

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

N 202205 Divvy Tripdata

N 202206 Divvy Tripdata

N 202207 Divvy Tripdata

N 202208 Divvy Tripdata

N 202111 Divvy Tripdata

@kaggle.alexandria101_cyclistic_case_study.n_202111_divvy_tripdata

19.25 MB
359978 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
7C00A93E10556E47	electric_bike	Sat Nov 27 2021 13:27:38 GMT+0000 (Coordinated Universal Time)	Sat Nov 27 2021 13:46:38 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.93	-87.72	41.96	-87.73	casual
90854840DFD508BA	electric_bike	Sat Nov 27 2021 13:38:25 GMT+0000 (Coordinated Universal Time)	Sat Nov 27 2021 13:56:10 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.96	-87.7	41.92	-87.7	casual
0A7D10CDD144061C	electric_bike	Fri Nov 26 2021 22:03:34 GMT+0000 (Coordinated Universal Time)	Fri Nov 26 2021 22:05:56 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.96	-87.7	41.96	-87.7	casual
2F3BE33085BCFF02	electric_bike	Sat Nov 27 2021 09:56:49 GMT+0000 (Coordinated Universal Time)	Sat Nov 27 2021 10:01:50 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.94	-87.79	41.93	-87.79	casual
D67B4781A19928D4	electric_bike	Fri Nov 26 2021 19:09:28 GMT+0000 (Coordinated Universal Time)	Fri Nov 26 2021 19:30:41 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.9	-87.63	41.88	-87.62	casual
02F85C2C3C5F7D46	electric_bike	Fri Nov 26 2021 18:34:07 GMT+0000 (Coordinated Universal Time)	Fri Nov 26 2021 18:52:49 GMT+0000 (Coordinated Universal Time)	Michigan Ave & Oak St	13042	nan	nan	41.90086433333333	-87.62379416666667	41.9	-87.63	casual
EF780B807EF7835A	electric_bike	Sat Nov 27 2021 13:31:12 GMT+0000 (Coordinated Universal Time)	Sat Nov 27 2021 13:37:12 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.81	-87.6	41.8	-87.6	casual
17069CC749126036	electric_bike	Sat Nov 27 2021 14:33:56 GMT+0000 (Coordinated Universal Time)	Sat Nov 27 2021 14:34:38 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.95	-87.66	41.95	-87.66	casual
93FC4662BDC5C061	electric_bike	Sat Nov 27 2021 09:14:33 GMT+0000 (Coordinated Universal Time)	Sat Nov 27 2021 09:19:36 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.8	-87.6	41.79	-87.6	casual
B06B064398A360B3	electric_bike	Sat Nov 27 2021 16:13:31 GMT+0000 (Coordinated Universal Time)	Sat Nov 27 2021 16:22:50 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.78	-87.6	41.8	-87.59	casual


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