Cyclist Capstone Project

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
EC2DE40644C6B0F4	classic_bike	Mon May 23 2022 23:06:00 GMT+0000 (Coordinated Universal Time)	Mon May 23 2022 23:40:00 GMT+0000 (Coordinated Universal Time)	Wabash Ave & Grand Ave	TA1307000117	Halsted St & Roscoe St	TA1309000025	41.891466	-87.626761	41.94367	-87.64895	member
1C31AD03897EE385	classic_bike	Wed May 11 2022 08:53:00 GMT+0000 (Coordinated Universal Time)	Wed May 11 2022 09:31:00 GMT+0000 (Coordinated Universal Time)	DuSable Lake Shore Dr & Monroe St	13300	Field Blvd & South Water St	15534	41.880958	-87.616743	41.88634906	-87.61751655	member
1542FBEC830415CF	classic_bike	Thu May 26 2022 18:36:00 GMT+0000 (Coordinated Universal Time)	Thu May 26 2022 18:58:00 GMT+0000 (Coordinated Universal Time)	Clinton St & Madison St	TA1305000032	Wood St & Milwaukee Ave	13221	41.882242	-87.641066	41.907655	-87.672552	member
6FF59852924528F8	classic_bike	Tue May 10 2022 07:30:00 GMT+0000 (Coordinated Universal Time)	Tue May 10 2022 07:38:00 GMT+0000 (Coordinated Universal Time)	Clinton St & Madison St	TA1305000032	Clark St & Randolph St	TA1305000030	41.882242	-87.641066	41.88457623	-87.63188991	member
483C52CAAE12E3AC	classic_bike	Tue May 10 2022 17:31:00 GMT+0000 (Coordinated Universal Time)	Tue May 10 2022 17:36:00 GMT+0000 (Coordinated Universal Time)	Clinton St & Madison St	TA1305000032	Morgan St & Lake St	TA1306000015	41.882242	-87.641066	41.88577925	-87.65102461	member
C0A3AA5A614DCE01	classic_bike	Wed May 04 2022 14:48:00 GMT+0000 (Coordinated Universal Time)	Wed May 04 2022 14:56:00 GMT+0000 (Coordinated Universal Time)	Carpenter St & Huron St	13196	Sangamon St & Washington Blvd	13409	41.894556	-87.653449	41.883165	-87.6511	member
F2AF43A242DF4555	classic_bike	Fri May 27 2022 12:41:00 GMT+0000 (Coordinated Universal Time)	Fri May 27 2022 12:50:00 GMT+0000 (Coordinated Universal Time)	Noble St & Milwaukee Ave	13290	Wood St & Augusta Blvd	657	41.90068	-87.6626	41.899181	-87.6722	member
377BE1F5F0E399CA	docked_bike	Sun May 29 2022 19:19:00 GMT+0000 (Coordinated Universal Time)	Sun May 29 2022 19:31:00 GMT+0000 (Coordinated Universal Time)	Halsted St & Wrightwood Ave	TA1309000061	Southport Ave & Clybourn Ave	TA1309000030	41.929143	-87.649077	41.920771	-87.663712	casual
B136E0C969773F59	classic_bike	Mon May 16 2022 17:48:00 GMT+0000 (Coordinated Universal Time)	Mon May 16 2022 18:05:00 GMT+0000 (Coordinated Universal Time)	Clinton St & Madison St	TA1305000032	Clybourn Ave & Division St	TA1307000115	41.882242	-87.641066	41.904613	-87.640552	member
75F6A50A05E0AA18	electric_bike	Wed May 11 2022 07:29:00 GMT+0000 (Coordinated Universal Time)	Wed May 11 2022 07:30:00 GMT+0000 (Coordinated Universal Time)	Southport Ave & Waveland Ave	13235	N Southport Ave & W Newport Ave	20257	41.948067	-87.6640125	41.94	-87.66	member


CREATE TABLE may_2022 (
  "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
);