Nov23-Oct24-divvy-tripdata

Google Data Analytics Capstone Project Data Set Nov23-Oct24

@kaggle.jacksonbecker13_nov23_oct24_divvy_tripdata

Table List

12 tables(274.69 MB)

N 202311 Divvy Tripdata

N 202312 Divvy Tripdata

N 202401 Divvy Tripdata

N 202402 Divvy Tripdata

N 202403 Divvy Tripdata

N 202404 Divvy Tripdata

N 202405 Divvy Tripdata

N 202406 Divvy Tripdata

N 202407 Divvy Tripdata

N 202408 Divvy Tripdata

N 202409 Divvy Tripdata

N 202410 Divvy Tripdata

N 202312 Divvy Tripdata

@kaggle.jacksonbecker13_nov23_oct24_divvy_tripdata.n_202312_divvy_tripdata

11.16 MB
224073 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
C9BD54F578F57246	electric_bike	Sat Dec 02 2023 18:44:01 GMT+0000 (Coordinated Universal Time)	Sat Dec 02 2023 18:47:51 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.92	-87.66	41.92	-87.66	member
CDBD92F067FA620E	electric_bike	Sat Dec 02 2023 18:48:19 GMT+0000 (Coordinated Universal Time)	Sat Dec 02 2023 18:54:48 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.92	-87.66	41.89	-87.64	member
ABC0858E52CBFC84	electric_bike	Sun Dec 24 2023 01:56:32 GMT+0000 (Coordinated Universal Time)	Sun Dec 24 2023 02:04:09 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.89	-87.62	41.9	-87.64	member
F44B6F0E8F76DC90	electric_bike	Sun Dec 24 2023 10:58:12 GMT+0000 (Coordinated Universal Time)	Sun Dec 24 2023 11:03:04 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.95	-87.65	41.94	-87.65	member
3C876413281A90DF	electric_bike	Sun Dec 24 2023 12:43:16 GMT+0000 (Coordinated Universal Time)	Sun Dec 24 2023 12:44:57 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.92	-87.64	41.93	-87.64	member
28C0D6EFB81E1769	electric_bike	Sun Dec 24 2023 13:59:57 GMT+0000 (Coordinated Universal Time)	Sun Dec 24 2023 14:10:57 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.91	-87.63	41.88	-87.65	member
8A38729DE7B2FAFE	electric_bike	Sun Dec 24 2023 09:01:58 GMT+0000 (Coordinated Universal Time)	Sun Dec 24 2023 09:07:51 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.99	-87.68	42	-87.67	member
19FD7AA9B32E12AD	electric_bike	Sun Dec 24 2023 08:21:38 GMT+0000 (Coordinated Universal Time)	Sun Dec 24 2023 08:27:09 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	42	-87.67	41.99	-87.68	member
055C15FE4A207408	electric_bike	Mon Dec 11 2023 18:17:46 GMT+0000 (Coordinated Universal Time)	Mon Dec 11 2023 18:22:43 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.96	-87.68	41.97	-87.68	member
A73B25A7D94889C9	electric_bike	Sun Dec 03 2023 06:05:56 GMT+0000 (Coordinated Universal Time)	Sun Dec 03 2023 06:06:06 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.9	-87.63	41.9	-87.63	member


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