Kristina's Bicycle Case Study Data: Google Capsto

Data about Chicago's Divvy Bicycle Sharing Service

@kaggle.kristinacramb_kristinas_bicycle_case_study_data

Table List

12 tables(280.39 MB)

N 202305 Divvy Tripdata

N 202306 Divvy Tripdata

N 202307 Divvy Tripdata

N 202308 Divvy Tripdata

N 202309 Divvy Tripdata

N 202310 Divvy Tripdata

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

@kaggle.kristinacramb_kristinas_bicycle_case_study_data.n_202309_divvy_tripdata

32.43 MB
666371 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
011C1903BF4E2E28	classic_bike	Sat Sep 23 2023 00:27:50 GMT+0000 (Coordinated Universal Time)	Sat Sep 23 2023 00:33:27 GMT+0000 (Coordinated Universal Time)	Halsted St & Wrightwood Ave	TA1309000061	Sheffield Ave & Wellington Ave	TA1307000052	41.929143	-87.649077	41.9362534831413	-87.65266209840775	member
87DB80E048A1BF9F	classic_bike	Sat Sep 02 2023 09:26:43 GMT+0000 (Coordinated Universal Time)	Sat Sep 02 2023 09:38:19 GMT+0000 (Coordinated Universal Time)	Clark St & Drummond Pl	TA1307000142	Racine Ave & Fullerton Ave	TA1306000026	41.931248	-87.644336	41.925566	-87.658416	member
7C2EB7AF669066E3	electric_bike	Mon Sep 25 2023 18:30:11 GMT+0000 (Coordinated Universal Time)	Mon Sep 25 2023 18:41:39 GMT+0000 (Coordinated Universal Time)	Financial Pl & Ida B Wells Dr	SL-010	Racine Ave & 15th St	13304	41.875060833333336	-87.63313533333333	41.861267	-87.656625	member
57D197B010269CE3	classic_bike	Wed Sep 13 2023 15:30:49 GMT+0000 (Coordinated Universal Time)	Wed Sep 13 2023 15:39:18 GMT+0000 (Coordinated Universal Time)	Clark St & Drummond Pl	TA1307000142	Racine Ave & Belmont Ave	TA1308000019	41.931248	-87.644336	41.939743	-87.658865	member
8A2CEA7C8C8074D8	classic_bike	Mon Sep 18 2023 15:58:58 GMT+0000 (Coordinated Universal Time)	Mon Sep 18 2023 16:05:04 GMT+0000 (Coordinated Universal Time)	Halsted St & Wrightwood Ave	TA1309000061	Racine Ave & Fullerton Ave	TA1306000026	41.929143	-87.649077	41.925566	-87.658416	member
03F7044D1304CD58	electric_bike	Fri Sep 15 2023 20:19:25 GMT+0000 (Coordinated Universal Time)	Fri Sep 15 2023 20:30:27 GMT+0000 (Coordinated Universal Time)	Southport Ave & Wrightwood Ave	TA1307000113	nan	nan	41.928835988	-87.663869619	41.9	-87.64	member
672503E0FC0835EC	electric_bike	Wed Sep 27 2023 16:52:18 GMT+0000 (Coordinated Universal Time)	Wed Sep 27 2023 17:03:22 GMT+0000 (Coordinated Universal Time)	Kedzie Ave & Milwaukee Ave	13085	nan	nan	41.9295605	-87.70795733333334	41.93	-87.66	member
1D806492F95973AC	electric_bike	Sun Sep 17 2023 11:07:05 GMT+0000 (Coordinated Universal Time)	Sun Sep 17 2023 11:13:39 GMT+0000 (Coordinated Universal Time)	Jeffery Blvd & 71st St	KA1503000018	nan	nan	41.766586065	-87.576445937	41.77	-87.57	member
40D9EF382CC6C53D	classic_bike	Sun Sep 17 2023 11:58:50 GMT+0000 (Coordinated Universal Time)	Sun Sep 17 2023 12:08:36 GMT+0000 (Coordinated Universal Time)	Kedzie Ave & Milwaukee Ave	13085	California Ave & Milwaukee Ave	13084	41.929567	-87.707857	41.922695	-87.697153	member
C60CE661AF7ECC93	electric_bike	Thu Sep 07 2023 20:52:43 GMT+0000 (Coordinated Universal Time)	Thu Sep 07 2023 21:06:51 GMT+0000 (Coordinated Universal Time)	Southport Ave & Wrightwood Ave	TA1307000113	nan	nan	41.92881583333333	-87.663908	41.9	-87.63	member


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