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
47EC0A7F82E65D52	classic_bike	Mon Mar 21 2022 13:45:00 GMT+0000 (Coordinated Universal Time)	Mon Mar 21 2022 13:51:00 GMT+0000 (Coordinated Universal Time)	Wabash Ave & Wacker Pl	TA1307000131	Kingsbury St & Kinzie St	KA1503000043	41.886875	-87.62603	41.88917683	-87.63850577	member
8494861979B0F477	electric_bike	Wed Mar 16 2022 09:37:00 GMT+0000 (Coordinated Universal Time)	Wed Mar 16 2022 09:43:00 GMT+0000 (Coordinated Universal Time)	Michigan Ave & Oak St	13042	Orleans St & Chestnut St (NEXT Apts)	620	41.90099767	-87.62375167	41.898203	-87.637536	member
EFE527AF80B66109	classic_bike	Wed Mar 23 2022 19:52:00 GMT+0000 (Coordinated Universal Time)	Wed Mar 23 2022 19:54:00 GMT+0000 (Coordinated Universal Time)	Broadway & Berwyn Ave	13109	Broadway & Ridge Ave	15578	41.978353	-87.659753	41.98404461	-87.66027383	member
9F446FD9DEE3F389	classic_bike	Tue Mar 01 2022 19:12:00 GMT+0000 (Coordinated Universal Time)	Tue Mar 01 2022 19:22:00 GMT+0000 (Coordinated Universal Time)	Wabash Ave & Wacker Pl	TA1307000131	Franklin St & Jackson Blvd	TA1305000025	41.886875	-87.62603	41.87770796	-87.63532114	member
431128AD9AFFEDC0	classic_bike	Mon Mar 21 2022 18:37:00 GMT+0000 (Coordinated Universal Time)	Mon Mar 21 2022 19:19:00 GMT+0000 (Coordinated Universal Time)	DuSable Lake Shore Dr & North Blvd	LF-005	Loomis St & Jackson Blvd	13206	41.911722	-87.626804	41.877945	-87.662007	member
9AA8A13AF7A85325	classic_bike	Mon Mar 07 2022 17:10:00 GMT+0000 (Coordinated Universal Time)	Mon Mar 07 2022 17:15:00 GMT+0000 (Coordinated Universal Time)	Bissell St & Armitage Ave	13059	Southport Ave & Clybourn Ave	TA1309000030	41.91801814	-87.65218198	41.920771	-87.663712	member
28E3387BFE2A5E85	electric_bike	Thu Mar 10 2022 17:21:00 GMT+0000 (Coordinated Universal Time)	Thu Mar 10 2022 17:24:00 GMT+0000 (Coordinated Universal Time)	Bissell St & Armitage Ave	13059	Southport Ave & Clybourn Ave	TA1309000030	41.91791617	-87.65206017	41.920771	-87.663712	member
74831EB3EA9CF123	classic_bike	Sat Mar 05 2022 12:31:00 GMT+0000 (Coordinated Universal Time)	Sat Mar 05 2022 12:42:00 GMT+0000 (Coordinated Universal Time)	DuSable Lake Shore Dr & North Blvd	LF-005	Stockton Dr & Wrightwood Ave	13276	41.911722	-87.626804	41.93132	-87.638742	member
BD70E7114BC486F1	electric_bike	Thu Mar 17 2022 17:32:00 GMT+0000 (Coordinated Universal Time)	Thu Mar 17 2022 17:43:00 GMT+0000 (Coordinated Universal Time)	Western Ave & Winnebago Ave	13068	Dayton St & North Ave	13058	41.91554415	-87.68706989	41.91057803	-87.64942193	casual
482458CD09B6FAF0	classic_bike	Fri Mar 04 2022 19:06:00 GMT+0000 (Coordinated Universal Time)	Fri Mar 04 2022 19:19:00 GMT+0000 (Coordinated Universal Time)	Sheffield Ave & Webster Ave	TA1309000033	Clark St & Newport St	632	41.92154	-87.653818	41.94454	-87.654678	member


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