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

@kaggle.jonathanmcilwaine_cyclistic_2024_dataset.n_202403_divvy_tripdata

14.82 MB
301687 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
64FBE3BAED5F29E6	electric_bike	Tue Mar 05 2024 18:33:11 GMT+0000 (Coordinated Universal Time)	Tue Mar 05 2024 18:51:48 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.94	-87.65	41.96	-87.65	member
9991629435C5E20E	electric_bike	Wed Mar 06 2024 17:15:14 GMT+0000 (Coordinated Universal Time)	Wed Mar 06 2024 17:16:04 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.91	-87.64	41.91	-87.64	member
E5C9FECD5B71BEBD	electric_bike	Wed Mar 06 2024 17:16:36 GMT+0000 (Coordinated Universal Time)	Wed Mar 06 2024 17:19:28 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.91	-87.64	41.92	-87.64	member
4CEA3EC8906DAEA8	electric_bike	Sun Mar 03 2024 22:55:54 GMT+0000 (Coordinated Universal Time)	Sun Mar 03 2024 22:58:08 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.9	-87.63	41.89	-87.63	member
77266B408503C55F	electric_bike	Sun Mar 17 2024 11:15:18 GMT+0000 (Coordinated Universal Time)	Sun Mar 17 2024 11:31:18 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.93	-87.7	41.93	-87.72	member
E81C25D251767135	electric_bike	Fri Mar 29 2024 14:40:49 GMT+0000 (Coordinated Universal Time)	Fri Mar 29 2024 14:58:11 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.93	-87.7	41.95	-87.68	member
797881859A9C90EF	electric_bike	Fri Mar 01 2024 17:23:58 GMT+0000 (Coordinated Universal Time)	Fri Mar 01 2024 17:34:01 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.94	-87.64	41.95	-87.65	member
07D8E2E4CF03F1D8	electric_bike	Fri Mar 01 2024 00:15:03 GMT+0000 (Coordinated Universal Time)	Fri Mar 01 2024 00:18:56 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.91	-87.63	41.92	-87.64	member
4AC53C43066B3E66	electric_bike	Mon Mar 25 2024 17:58:35 GMT+0000 (Coordinated Universal Time)	Mon Mar 25 2024 18:02:05 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.84	-87.62	41.85	-87.62	member
1F2418001E121479	electric_bike	Fri Mar 01 2024 09:36:51 GMT+0000 (Coordinated Universal Time)	Fri Mar 01 2024 10:19:48 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.75	-87.67	41.75	-87.67	member


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