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

@kaggle.jacksonbecker13_nov23_oct24_divvy_tripdata.n_202401_divvy_tripdata

7.22 MB
144873 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
C1D650626C8C899A	electric_bike	Fri Jan 12 2024 15:30:27 GMT+0000 (Coordinated Universal Time)	Fri Jan 12 2024 15:37:59 GMT+0000 (Coordinated Universal Time)	Wells St & Elm St	KA1504000135	Kingsbury St & Kinzie St	KA1503000043	41.903267384	-87.634736776	41.88917683258	-87.6385057718	member
EECD38BDB25BFCB0	electric_bike	Mon Jan 08 2024 15:45:46 GMT+0000 (Coordinated Universal Time)	Mon Jan 08 2024 15:52:59 GMT+0000 (Coordinated Universal Time)	Wells St & Elm St	KA1504000135	Kingsbury St & Kinzie St	KA1503000043	41.9029365	-87.63444016666666	41.88917683258	-87.6385057718	member
F4A9CE78061F17F7	electric_bike	Sat Jan 27 2024 12:27:19 GMT+0000 (Coordinated Universal Time)	Sat Jan 27 2024 12:35:19 GMT+0000 (Coordinated Universal Time)	Wells St & Elm St	KA1504000135	Kingsbury St & Kinzie St	KA1503000043	41.90295133333333	-87.63447033333334	41.88917683258	-87.6385057718	member
0A0D9E15EE50B171	classic_bike	Mon Jan 29 2024 16:26:17 GMT+0000 (Coordinated Universal Time)	Mon Jan 29 2024 16:56:06 GMT+0000 (Coordinated Universal Time)	Wells St & Randolph St	TA1305000030	Larrabee St & Webster Ave	13193	41.884295	-87.633963	41.921822	-87.64414	member
33FFC9805E3EFF9A	classic_bike	Wed Jan 31 2024 05:43:23 GMT+0000 (Coordinated Universal Time)	Wed Jan 31 2024 06:09:35 GMT+0000 (Coordinated Universal Time)	Lincoln Ave & Waveland Ave	13253	Kingsbury St & Kinzie St	KA1503000043	41.948797	-87.675278	41.88917683258	-87.6385057718	member
C96080812CD285C5	classic_bike	Sun Jan 07 2024 11:21:24 GMT+0000 (Coordinated Universal Time)	Sun Jan 07 2024 11:30:03 GMT+0000 (Coordinated Universal Time)	Wells St & Elm St	KA1504000135	Kingsbury St & Kinzie St	KA1503000043	41.903222	-87.634324	41.88917683258	-87.6385057718	member
0EA7CB313D4F456A	classic_bike	Fri Jan 05 2024 14:44:12 GMT+0000 (Coordinated Universal Time)	Fri Jan 05 2024 14:53:06 GMT+0000 (Coordinated Universal Time)	Wells St & Elm St	KA1504000135	Kingsbury St & Kinzie St	KA1503000043	41.903222	-87.634324	41.88917683258	-87.6385057718	member
EE11F3A3B39CFBD8	electric_bike	Thu Jan 04 2024 18:19:53 GMT+0000 (Coordinated Universal Time)	Thu Jan 04 2024 18:28:04 GMT+0000 (Coordinated Universal Time)	Wells St & Elm St	KA1504000135	Kingsbury St & Kinzie St	KA1503000043	41.903368115	-87.63486135	41.88917683258	-87.6385057718	member
63E83DE8E3279F15	classic_bike	Mon Jan 01 2024 14:46:53 GMT+0000 (Coordinated Universal Time)	Mon Jan 01 2024 14:57:02 GMT+0000 (Coordinated Universal Time)	Wells St & Elm St	KA1504000135	Kingsbury St & Kinzie St	KA1503000043	41.903222	-87.634324	41.88917683258	-87.6385057718	member
8005682869122D93	electric_bike	Wed Jan 03 2024 19:31:08 GMT+0000 (Coordinated Universal Time)	Wed Jan 03 2024 19:40:05 GMT+0000 (Coordinated Universal Time)	Clark St & Ida B Wells Dr	TA1305000009	Kingsbury St & Kinzie St	KA1503000043	41.8760335	-87.630866	41.88917683258	-87.6385057718	member


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