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

@kaggle.alexandria101_cyclistic_case_study.n_202109_divvy_tripdata

36.98 MB
756147 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
9DC7B962304CBFD8	electric_bike	Tue Sep 28 2021 16:07:10 GMT+0000 (Coordinated Universal Time)	Tue Sep 28 2021 16:09:54 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.89	-87.68	41.89	-87.67	casual
F930E2C6872D6B32	electric_bike	Tue Sep 28 2021 14:24:51 GMT+0000 (Coordinated Universal Time)	Tue Sep 28 2021 14:40:05 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.94	-87.64	41.98	-87.67	casual
6EF72137900BB910	electric_bike	Tue Sep 28 2021 00:20:16 GMT+0000 (Coordinated Universal Time)	Tue Sep 28 2021 00:23:57 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.81	-87.72	41.8	-87.72	casual
78D1DE133B3DBF55	electric_bike	Tue Sep 28 2021 14:51:17 GMT+0000 (Coordinated Universal Time)	Tue Sep 28 2021 15:00:06 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.8	-87.72	41.81	-87.72	casual
E03D4ACDCAEF6E00	electric_bike	Tue Sep 28 2021 09:53:12 GMT+0000 (Coordinated Universal Time)	Tue Sep 28 2021 10:03:44 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.88	-87.74	41.88	-87.71	casual
346DE323A2677DC0	electric_bike	Tue Sep 28 2021 01:53:18 GMT+0000 (Coordinated Universal Time)	Tue Sep 28 2021 02:00:02 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.87	-87.75	41.88	-87.74	casual
558CE7087B42D8DB	electric_bike	Tue Sep 28 2021 07:15:56 GMT+0000 (Coordinated Universal Time)	Tue Sep 28 2021 07:38:25 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.74	-87.63	41.74	-87.56	casual
3EF7CB1851930A1F	electric_bike	Tue Sep 28 2021 11:17:00 GMT+0000 (Coordinated Universal Time)	Tue Sep 28 2021 11:40:17 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.74	-87.56	41.75	-87.63	casual
1F9A9A6BA4C2F82E	electric_bike	Mon Sep 27 2021 19:57:09 GMT+0000 (Coordinated Universal Time)	Mon Sep 27 2021 20:09:08 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.95	-87.76	41.95	-87.76	casual
CAA3791DE7300B8E	electric_bike	Tue Sep 28 2021 11:01:26 GMT+0000 (Coordinated Universal Time)	Tue Sep 28 2021 11:22:56 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.93	-87.69	41.95	-87.75	casual


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