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
954144C2F67B1932	classic_bike	Tue Jul 05 2022 08:12:00 GMT+0000 (Coordinated Universal Time)	Tue Jul 05 2022 08:24:00 GMT+0000 (Coordinated Universal Time)	Ashland Ave & Blackhawk St	13224	Kingsbury St & Kinzie St	KA1503000043	41.907066	-87.667252	41.88917683	-87.63850577	member
292E027607D218B6	classic_bike	Tue Jul 26 2022 12:53:00 GMT+0000 (Coordinated Universal Time)	Tue Jul 26 2022 12:55:00 GMT+0000 (Coordinated Universal Time)	Buckingham Fountain (Temp)	15541	Michigan Ave & 8th St	623	41.86962075	-87.62398124	41.872773	-87.623981	casual
57765852588AD6E0	classic_bike	Sun Jul 03 2022 13:58:00 GMT+0000 (Coordinated Universal Time)	Sun Jul 03 2022 14:06:00 GMT+0000 (Coordinated Universal Time)	Buckingham Fountain (Temp)	15541	Michigan Ave & 8th St	623	41.86962075	-87.62398124	41.872773	-87.623981	casual
B5B6BE44314590E6	classic_bike	Sun Jul 31 2022 17:44:00 GMT+0000 (Coordinated Universal Time)	Sun Jul 31 2022 18:42:00 GMT+0000 (Coordinated Universal Time)	Buckingham Fountain (Temp)	15541	Woodlawn Ave & 55th St	TA1307000164	41.86962075	-87.62398124	41.795264	-87.596471	casual
A4C331F2A00E79E0	classic_bike	Wed Jul 13 2022 19:49:00 GMT+0000 (Coordinated Universal Time)	Wed Jul 13 2022 20:15:00 GMT+0000 (Coordinated Universal Time)	Wabash Ave & Grand Ave	TA1307000117	Sheffield Ave & Wellington Ave	TA1307000052	41.891466	-87.626761	41.93625348	-87.6526621	member
579D73BE2ED880B3	electric_bike	Fri Jul 01 2022 17:04:00 GMT+0000 (Coordinated Universal Time)	Fri Jul 01 2022 17:13:00 GMT+0000 (Coordinated Universal Time)	Desplaines St & Randolph St	15535	Clinton St & Roosevelt Rd	WL-008	41.88461411	-87.64456356	41.86711778	-87.64108796	member
EFE518CCEE333669	classic_bike	Mon Jul 18 2022 18:11:00 GMT+0000 (Coordinated Universal Time)	Mon Jul 18 2022 18:22:00 GMT+0000 (Coordinated Universal Time)	Marquette Ave & 89th St	20239	East End Ave & 87th St	20231	41.73366879	-87.55834222	41.73681521	-87.58280128	member
315FEBB7B3F6D2EA	classic_bike	Thu Jul 28 2022 20:38:00 GMT+0000 (Coordinated Universal Time)	Thu Jul 28 2022 21:09:00 GMT+0000 (Coordinated Universal Time)	Wabash Ave & Grand Ave	TA1307000117	Dearborn Pkwy & Delaware Pl	TA1307000128	41.891466	-87.626761	41.898969	-87.629912	casual
EE3C4A1E66766B56	classic_bike	Sun Jul 10 2022 22:55:00 GMT+0000 (Coordinated Universal Time)	Sun Jul 10 2022 23:01:00 GMT+0000 (Coordinated Universal Time)	Wabash Ave & Grand Ave	TA1307000117	Dearborn Pkwy & Delaware Pl	TA1307000128	41.891466	-87.626761	41.898969	-87.629912	member
1EE6C93A547A187C	electric_bike	Sun Jul 10 2022 09:35:00 GMT+0000 (Coordinated Universal Time)	Sun Jul 10 2022 09:47:00 GMT+0000 (Coordinated Universal Time)	Ashland Ave & Blackhawk St	13224	Orleans St & Merchandise Mart Plaza	TA1305000022	41.90709305	-87.6672473	41.888243	-87.63639	member


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