Cyclistic 2024 Dataset

Capstone Project for Google Data Analytics Course

@kaggle.jonathanmcilwaine_cyclistic_2024_dataset

Table List

12 tables(268.82 MB)

N 202403 Divvy Tripdata

N 202409 Divvy Tripdata

N 202406 Divvy Tripdata

N 202405 Divvy Tripdata

N 202408 Divvy Tripdata

N 202402 Divvy Tripdata

N 202411 Divvy Tripdata

N 202412 Divvy Tripdata

N 202401 Divvy Tripdata

N 202407 Divvy Tripdata

N 202410 Divvy Tripdata

N 202404 Divvy Tripdata

N 202409 Divvy Tripdata

@kaggle.jonathanmcilwaine_cyclistic_2024_dataset.n_202409_divvy_tripdata

35.6 MB
821276 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
31D38723D5A8665A	electric_bike	Thu Sep 26 2024 15:30:58 GMT+0000 (Coordinated Universal Time)	Thu Sep 26 2024 15:30:59 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.91	-87.63	41.91	-87.63	member
67CB39987F4E895B	electric_bike	Thu Sep 26 2024 15:31:32 GMT+0000 (Coordinated Universal Time)	Thu Sep 26 2024 15:53:13 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.91	-87.63	41.91	-87.63	member
DA61204FD26EC681	electric_bike	Thu Sep 26 2024 15:00:33 GMT+0000 (Coordinated Universal Time)	Thu Sep 26 2024 15:02:25 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.9	-87.62	41.9	-87.63	member
06F160D46AF235DD	electric_bike	Thu Sep 26 2024 18:19:06 GMT+0000 (Coordinated Universal Time)	Thu Sep 26 2024 18:38:53 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.91	-87.63	41.9	-87.62	member
6FCA41D4317601EB	electric_bike	Tue Sep 03 2024 19:49:57 GMT+0000 (Coordinated Universal Time)	Tue Sep 03 2024 20:07:08 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.9	-87.69	41.9	-87.63	member
9F291E82895C45E5	electric_bike	Wed Sep 04 2024 01:45:18 GMT+0000 (Coordinated Universal Time)	Wed Sep 04 2024 02:01:38 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.9	-87.63	41.9	-87.69	member
625D2EA831E1F8AC	electric_bike	Wed Sep 04 2024 16:22:16 GMT+0000 (Coordinated Universal Time)	Wed Sep 04 2024 16:26:20 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.89	-87.63	41.89	-87.63	member
A21DCB6834BCAD0D	electric_bike	Wed Sep 04 2024 16:31:58 GMT+0000 (Coordinated Universal Time)	Wed Sep 04 2024 16:38:52 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.89	-87.63	41.89	-87.63	member
0EEB8A4CF63DA7AE	electric_bike	Sat Sep 28 2024 20:30:28 GMT+0000 (Coordinated Universal Time)	Sat Sep 28 2024 20:33:20 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.9	-87.64	41.9	-87.63	member
6CE10020F5D0D7B8	electric_bike	Sat Sep 28 2024 20:10:48 GMT+0000 (Coordinated Universal Time)	Sat Sep 28 2024 20:24:32 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.92	-87.68	41.9	-87.64	member


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