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

@kaggle.jonathanmcilwaine_cyclistic_2024_dataset.n_202406_divvy_tripdata

33.75 MB
710721 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
CDE6023BE6B11D2F	electric_bike	Tue Jun 11 2024 17:20:06 GMT+0000 (Coordinated Universal Time)	Tue Jun 11 2024 17:21:39 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.89	-87.65	41.89	-87.65	casual
462B48CD292B6A18	electric_bike	Tue Jun 11 2024 17:19:21 GMT+0000 (Coordinated Universal Time)	Tue Jun 11 2024 17:19:36 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.89	-87.65	41.89	-87.65	casual
9CFB6A858D23ABF7	electric_bike	Tue Jun 11 2024 17:25:27 GMT+0000 (Coordinated Universal Time)	Tue Jun 11 2024 17:30:13 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.93	-87.65	41.94	-87.65	casual
6365EFEB64231153	electric_bike	Tue Jun 11 2024 11:53:50 GMT+0000 (Coordinated Universal Time)	Tue Jun 11 2024 12:08:13 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.88	-87.64	41.88	-87.64	casual
BA0323C33134CBA8	electric_bike	Tue Jun 11 2024 00:11:08 GMT+0000 (Coordinated Universal Time)	Tue Jun 11 2024 00:11:22 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.94	-87.64	41.94	-87.64	casual
DE26F0D728517B77	electric_bike	Tue Jun 11 2024 00:12:38 GMT+0000 (Coordinated Universal Time)	Tue Jun 11 2024 00:12:57 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.94	-87.64	41.94	-87.64	casual
C806B4280D388CC0	electric_bike	Tue Jun 11 2024 00:14:00 GMT+0000 (Coordinated Universal Time)	Tue Jun 11 2024 00:20:35 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.94	-87.64	41.93	-87.64	casual
45CBD564C461DBE9	electric_bike	Tue Jun 11 2024 18:22:23 GMT+0000 (Coordinated Universal Time)	Tue Jun 11 2024 19:26:41 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.91	-87.63	41.87	-87.61	casual
D943D9C4841D9A60	electric_bike	Tue Jun 11 2024 12:51:10 GMT+0000 (Coordinated Universal Time)	Tue Jun 11 2024 12:51:28 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.91	-87.74	41.91	-87.74	casual
2C9D2B7821354BFF	electric_bike	Tue Jun 11 2024 12:49:24 GMT+0000 (Coordinated Universal Time)	Tue Jun 11 2024 12:49:45 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.91	-87.74	41.91	-87.74	casual


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