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
C2F7DD78E82EC875	electric_bike	Thu Jan 13 2022 11:59:00 GMT+0000 (Coordinated Universal Time)	Thu Jan 13 2022 12:02:00 GMT+0000 (Coordinated Universal Time)	Glenwood Ave & Touhy Ave	525	Clark St & Touhy Ave	RP-007	42.0128005	-87.665906	42.01256012	-87.67436712	casual
A6CF8980A652D272	electric_bike	Mon Jan 10 2022 08:41:00 GMT+0000 (Coordinated Universal Time)	Mon Jan 10 2022 08:46:00 GMT+0000 (Coordinated Universal Time)	Glenwood Ave & Touhy Ave	525	Clark St & Touhy Ave	RP-007	42.012763	-87.6659675	42.01256012	-87.67436712	casual
BD0F91DFF741C66D	classic_bike	Tue Jan 25 2022 04:53:00 GMT+0000 (Coordinated Universal Time)	Tue Jan 25 2022 04:58:00 GMT+0000 (Coordinated Universal Time)	Sheffield Ave & Fullerton Ave	TA1306000016	Greenview Ave & Fullerton Ave	TA1307000001	41.92560188	-87.65370804	41.92533	-87.6658	member
CBB80ED419105406	classic_bike	Tue Jan 04 2022 00:18:00 GMT+0000 (Coordinated Universal Time)	Tue Jan 04 2022 00:33:00 GMT+0000 (Coordinated Universal Time)	Clark St & Bryn Mawr Ave	KA1504000151	Paulina St & Montrose Ave	TA1309000021	41.983593	-87.669154	41.961507	-87.671387	casual
DDC963BFDDA51EEA	classic_bike	Thu Jan 20 2022 01:31:00 GMT+0000 (Coordinated Universal Time)	Thu Jan 20 2022 01:37:00 GMT+0000 (Coordinated Universal Time)	Michigan Ave & Jackson Blvd	TA1309000002	State St & Randolph St	TA1305000029	41.87785	-87.62408	41.88462107	-87.62783423	member
A39C6F6CC0586C0B	classic_bike	Tue Jan 11 2022 18:48:00 GMT+0000 (Coordinated Universal Time)	Tue Jan 11 2022 18:51:00 GMT+0000 (Coordinated Universal Time)	Wood St & Chicago Ave	637	Honore St & Division St	TA1305000034	41.895634	-87.672069	41.903119	-87.673935	member
BDC4AB637EDF981B	classic_bike	Sun Jan 30 2022 18:32:00 GMT+0000 (Coordinated Universal Time)	Sun Jan 30 2022 18:49:00 GMT+0000 (Coordinated Universal Time)	Oakley Ave & Irving Park Rd	KA1504000158	Broadway & Sheridan Rd	13323	41.95434085	-87.68607962	41.952833	-87.649993	member
81751A3186E59A6B	classic_bike	Sat Jan 22 2022 12:20:00 GMT+0000 (Coordinated Universal Time)	Sat Jan 22 2022 12:32:00 GMT+0000 (Coordinated Universal Time)	Sheffield Ave & Fullerton Ave	TA1306000016	Damen Ave & Clybourn Ave	13271	41.92560188	-87.65370804	41.931931	-87.677856	member
154222B86A338ABD	electric_bike	Mon Jan 17 2022 07:34:00 GMT+0000 (Coordinated Universal Time)	Mon Jan 17 2022 08:00:00 GMT+0000 (Coordinated Universal Time)	Racine Ave & 15th St	13304	Clinton St & Washington Blvd	WL-012	41.86125133	-87.65650017	41.88338	-87.64117	member
72DC25B2DD467EEF	classic_bike	Fri Jan 28 2022 15:27:00 GMT+0000 (Coordinated Universal Time)	Fri Jan 28 2022 15:35:00 GMT+0000 (Coordinated Universal Time)	LaSalle St & Jackson Blvd	TA1309000004	Clinton St & Washington Blvd	WL-012	41.878166	-87.631929	41.88338	-87.64117	member


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