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

@kaggle.kristinacramb_kristinas_bicycle_case_study_data.n_202308_divvy_tripdata

37.37 MB
771693 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
903C30C2D810A53B	electric_bike	Sat Aug 19 2023 15:41:53 GMT+0000 (Coordinated Universal Time)	Sat Aug 19 2023 15:53:36 GMT+0000 (Coordinated Universal Time)	LaSalle St & Illinois St	13430	Clark St & Elm St	TA1307000039	41.89072133333333	-87.63147666666667	41.902973	-87.63128	member
F2FB18A98E110A2B	electric_bike	Fri Aug 18 2023 15:30:18 GMT+0000 (Coordinated Universal Time)	Fri Aug 18 2023 15:45:25 GMT+0000 (Coordinated Universal Time)	Clark St & Randolph St	TA1305000030	nan	nan	41.884511333333336	-87.63155033333334	41.93	-87.64	member
D0DEC7C94E4663DA	electric_bike	Wed Aug 30 2023 16:15:08 GMT+0000 (Coordinated Universal Time)	Wed Aug 30 2023 16:27:37 GMT+0000 (Coordinated Universal Time)	Clark St & Randolph St	TA1305000030	nan	nan	41.88498083333333	-87.63079266666666	41.91	-87.63	member
E0DDDC5F84747ED9	electric_bike	Wed Aug 30 2023 16:24:07 GMT+0000 (Coordinated Universal Time)	Wed Aug 30 2023 16:33:34 GMT+0000 (Coordinated Universal Time)	Wells St & Elm St	KA1504000135	nan	nan	41.90310483333333	-87.63466683333333	41.9	-87.62	member
7797A4874BA260CA	electric_bike	Tue Aug 22 2023 15:59:44 GMT+0000 (Coordinated Universal Time)	Tue Aug 22 2023 16:20:38 GMT+0000 (Coordinated Universal Time)	Clark St & Randolph St	TA1305000030	nan	nan	41.885547996	-87.632019401	41.89	-87.68	member
DF4DE734EBC4DF66	electric_bike	Thu Aug 24 2023 12:27:24 GMT+0000 (Coordinated Universal Time)	Thu Aug 24 2023 12:54:59 GMT+0000 (Coordinated Universal Time)	Milwaukee Ave & Fullerton Ave	428	nan	nan	41.924669862	-87.700599074	41.91	-87.72	member
EE60FB066E69AFAC	electric_bike	Thu Aug 31 2023 20:42:14 GMT+0000 (Coordinated Universal Time)	Thu Aug 31 2023 20:54:38 GMT+0000 (Coordinated Universal Time)	Milwaukee Ave & Fullerton Ave	428	nan	nan	41.924705505	-87.700618982	41.91	-87.72	member
A115DA6AA13DE5EF	electric_bike	Thu Aug 17 2023 15:15:51 GMT+0000 (Coordinated Universal Time)	Thu Aug 17 2023 15:22:27 GMT+0000 (Coordinated Universal Time)	Orleans St & Merchandise Mart Plaza	TA1305000022	nan	nan	41.887794166666666	-87.6368815	41.9	-87.63	member
86DBB19374245893	electric_bike	Thu Aug 24 2023 21:37:19 GMT+0000 (Coordinated Universal Time)	Thu Aug 24 2023 21:47:22 GMT+0000 (Coordinated Universal Time)	Milwaukee Ave & Fullerton Ave	428	nan	nan	41.924740166666666	-87.7006075	41.91	-87.67	member
2905CBC8B8EE392C	electric_bike	Mon Aug 28 2023 14:53:38 GMT+0000 (Coordinated Universal Time)	Mon Aug 28 2023 14:59:35 GMT+0000 (Coordinated Universal Time)	Orleans St & Merchandise Mart Plaza	TA1305000022	nan	nan	41.8879865	-87.63703933333333	41.89	-87.62	member


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