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
46F8167220E4431F	electric_bike	Tue Dec 07 2021 15:06:00 GMT+0000 (Coordinated Universal Time)	Tue Dec 07 2021 15:13:00 GMT+0000 (Coordinated Universal Time)	Laflin St & Cullerton St	13307	Morgan St & Polk St	TA1307000130	41.854833	-87.66366033	41.8719685	-87.65096533	member
73A77762838B32FD	electric_bike	Sat Dec 11 2021 03:43:00 GMT+0000 (Coordinated Universal Time)	Sat Dec 11 2021 04:10:00 GMT+0000 (Coordinated Universal Time)	LaSalle Dr & Huron St	KP1705001026	Clarendon Ave & Leland Ave	TA1307000119	41.89440517	-87.632331	41.967968	-87.650001	casual
4CF42452054F59C5	electric_bike	Wed Dec 15 2021 23:10:00 GMT+0000 (Coordinated Universal Time)	Wed Dec 15 2021 23:23:00 GMT+0000 (Coordinated Universal Time)	Halsted St & North Branch St	KA1504000117	Broadway & Barry Ave	13137	41.89935717	-87.64852183	41.93758232	-87.64409781	member
3278BA87BF698339	classic_bike	Sun Dec 26 2021 16:16:00 GMT+0000 (Coordinated Universal Time)	Sun Dec 26 2021 16:30:00 GMT+0000 (Coordinated Universal Time)	Halsted St & North Branch St	KA1504000117	LaSalle Dr & Huron St	KP1705001026	41.89939029	-87.64854491	41.894877	-87.632326	member
6FF54232576A3B73	electric_bike	Thu Dec 30 2021 11:31:00 GMT+0000 (Coordinated Universal Time)	Thu Dec 30 2021 11:51:00 GMT+0000 (Coordinated Universal Time)	Leavitt St & Chicago Ave	18058	Clark St & Drummond Pl	TA1307000142	41.89557883	-87.68202383	41.931248	-87.644336	member
93E8D79490E3AB11	classic_bike	Wed Dec 01 2021 18:28:00 GMT+0000 (Coordinated Universal Time)	Wed Dec 01 2021 18:38:00 GMT+0000 (Coordinated Universal Time)	Wabash Ave & 16th St	SL-012	Wells St & Polk St	SL-011	41.860384	-87.625813	41.872596	-87.633502	member
135518383C9CACF0	electric_bike	Thu Dec 09 2021 15:49:00 GMT+0000 (Coordinated Universal Time)	Thu Dec 09 2021 15:55:00 GMT+0000 (Coordinated Universal Time)	Laflin St & Cullerton St	13307	Halsted St & Maxwell St	TA1309000001	41.8548755	-87.66365217	41.86482733	-87.64709983	member
CDF93C212EA9B261	classic_bike	Fri Dec 31 2021 13:02:00 GMT+0000 (Coordinated Universal Time)	Fri Dec 31 2021 13:20:00 GMT+0000 (Coordinated Universal Time)	Clark St & Lake St	KA1503000012	Ashland Ave & Lake St	13073	41.88602083	-87.63087606	41.88592	-87.66717	casual
0FCA94C5F26535C8	electric_bike	Mon Dec 20 2021 14:25:00 GMT+0000 (Coordinated Universal Time)	Mon Dec 20 2021 14:35:00 GMT+0000 (Coordinated Universal Time)	Clark St & Lake St	KA1503000012	Ogden Ave & Chicago Ave	TA1305000020	41.88591552	-87.63148534	41.89636246	-87.65406127	member
8E913048B7BCAA47	classic_bike	Sun Dec 19 2021 16:58:00 GMT+0000 (Coordinated Universal Time)	Sun Dec 19 2021 17:15:00 GMT+0000 (Coordinated Universal Time)	Fairbanks St & Superior St	18003	Lincoln Park Conservatory	LP-	41.895748	-87.620104	41.92393131	-87.63582453	member


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