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

@kaggle.jacksonbecker13_nov23_oct24_divvy_tripdata.n_202402_divvy_tripdata

10.76 MB
223164 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
FCB05EB1758F85E8	classic_bike	Sat Feb 03 2024 14:14:18 GMT+0000 (Coordinated Universal Time)	Sat Feb 03 2024 14:21:00 GMT+0000 (Coordinated Universal Time)	Clark St & Newport St	632	Southport Ave & Waveland Ave	13235	41.94454	-87.654678	41.94815	-87.66394	member
7FB986AD5D3DE9D6	classic_bike	Mon Feb 05 2024 21:10:06 GMT+0000 (Coordinated Universal Time)	Mon Feb 05 2024 21:15:44 GMT+0000 (Coordinated Universal Time)	Michigan Ave & Washington St	13001	Wabash Ave & Grand Ave	TA1307000117	41.8839840647265	-87.6246839761734	41.891466	-87.626761	member
40CA13E15B5B470D	electric_bike	Mon Feb 05 2024 15:10:44 GMT+0000 (Coordinated Universal Time)	Mon Feb 05 2024 15:12:32 GMT+0000 (Coordinated Universal Time)	Leavitt St & Armitage Ave	TA1309000029	Milwaukee Ave & Wabansia Ave	13243	41.917604089	-87.682501793	41.912616	-87.681391	member
D47A1660919E8861	classic_bike	Thu Feb 15 2024 12:40:34 GMT+0000 (Coordinated Universal Time)	Thu Feb 15 2024 12:44:24 GMT+0000 (Coordinated Universal Time)	Southport Ave & Waveland Ave	13235	Southport Ave & Belmont Ave	13229	41.94815	-87.66394	41.93947775040509	-87.6637476682663	member
4CD173D11BA019F8	classic_bike	Wed Feb 14 2024 12:28:36 GMT+0000 (Coordinated Universal Time)	Wed Feb 14 2024 12:36:59 GMT+0000 (Coordinated Universal Time)	Wentworth Ave & 35th St	KA1503000005	Shields Ave & 31st St	KA1503000038	41.830777	-87.632504	41.838464	-87.635406	casual
DA5032C0CA737AF5	electric_bike	Fri Feb 16 2024 00:54:48 GMT+0000 (Coordinated Universal Time)	Fri Feb 16 2024 01:01:47 GMT+0000 (Coordinated Universal Time)	Sheridan Rd & Lawrence Ave	TA1309000041	Clark St & Newport St	632	41.969415665	-87.654788256	41.94454	-87.654678	member
0D9B1C84D67C0F5A	classic_bike	Sun Feb 11 2024 21:46:58 GMT+0000 (Coordinated Universal Time)	Sun Feb 11 2024 21:48:26 GMT+0000 (Coordinated Universal Time)	Sheridan Rd & Lawrence Ave	TA1309000041	Sheridan Rd & Argyle St	13059	41.969517	-87.654691	41.97328682025979	-87.65475958585739	member
25985F5BA7C013B2	classic_bike	Thu Feb 22 2024 07:51:12 GMT+0000 (Coordinated Universal Time)	Thu Feb 22 2024 07:55:33 GMT+0000 (Coordinated Universal Time)	Franklin St & Chicago Ave	13017	Orleans St & Merchandise Mart Plaza	TA1305000022	41.896746973093805	-87.63566762208939	41.888243	-87.63639	member
19A002468258A71E	classic_bike	Thu Feb 22 2024 09:01:09 GMT+0000 (Coordinated Universal Time)	Thu Feb 22 2024 09:18:02 GMT+0000 (Coordinated Universal Time)	Clark St & Schiller St	TA1309000024	Canal St & Jackson Blvd	13138	41.907993	-87.631501	41.877245	-87.639366	member
E5C1525C8B78CC65	classic_bike	Mon Feb 19 2024 08:43:44 GMT+0000 (Coordinated Universal Time)	Mon Feb 19 2024 09:01:55 GMT+0000 (Coordinated Universal Time)	Clark St & Schiller St	TA1309000024	Canal St & Jackson Blvd	13138	41.907993	-87.631501	41.877245	-87.639366	member


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