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
A50255C1E17942AB	classic_bike	Fri Oct 14 2022 17:13:00 GMT+0000 (Coordinated Universal Time)	Fri Oct 14 2022 17:19:00 GMT+0000 (Coordinated Universal Time)	Noble St & Milwaukee Ave	13290	Larrabee St & Division St	KA1504000079	41.90068	-87.6626	41.90348607	-87.64335349	member
DB692A70BD2DD4E3	electric_bike	Sat Oct 01 2022 16:29:00 GMT+0000 (Coordinated Universal Time)	Sat Oct 01 2022 16:49:00 GMT+0000 (Coordinated Universal Time)	Damen Ave & Charleston St	13288	Damen Ave & Cullerton St	13089	41.920037	-87.67793683	41.85496652	-87.67569959	casual
3C02727AAF60F873	electric_bike	Wed Oct 19 2022 18:55:00 GMT+0000 (Coordinated Universal Time)	Wed Oct 19 2022 19:03:00 GMT+0000 (Coordinated Universal Time)	Hoyne Ave & Balmoral Ave	655	Western Ave & Leland Ave	TA1307000140	41.9798789	-87.68190205	41.9663998	-87.68870428	member
47E653FDC2D99236	electric_bike	Mon Oct 31 2022 07:52:00 GMT+0000 (Coordinated Universal Time)	Mon Oct 31 2022 07:58:00 GMT+0000 (Coordinated Universal Time)	Rush St & Cedar St	KA1504000133	Orleans St & Chestnut St (NEXT Apts)	620	41.90227367	-87.6276925	41.898203	-87.637536	member
8B5407BE535159BF	classic_bike	Thu Oct 13 2022 18:41:00 GMT+0000 (Coordinated Universal Time)	Thu Oct 13 2022 19:26:00 GMT+0000 (Coordinated Universal Time)	900 W Harrison St	13028	Adler Planetarium	13431	41.874754	-87.649807	41.866095	-87.607267	casual
A177C92E9F021B99	electric_bike	Thu Oct 13 2022 15:53:00 GMT+0000 (Coordinated Universal Time)	Thu Oct 13 2022 15:59:00 GMT+0000 (Coordinated Universal Time)	900 W Harrison St	13028	Loomis St & Lexington St	13332	41.874725	-87.64983033	41.872187	-87.661501	casual
DF5EC7678DE3C2B3	electric_bike	Thu Oct 06 2022 15:51:00 GMT+0000 (Coordinated Universal Time)	Thu Oct 06 2022 15:55:00 GMT+0000 (Coordinated Universal Time)	900 W Harrison St	13028	Halsted St & Roosevelt Rd	TA1305000017	41.87471333	-87.649875	41.867324	-87.648625	member
407DE6D80130A297	classic_bike	Wed Oct 26 2022 17:30:00 GMT+0000 (Coordinated Universal Time)	Wed Oct 26 2022 17:37:00 GMT+0000 (Coordinated Universal Time)	Rush St & Cedar St	KA1504000133	Larrabee St & Division St	KA1504000079	41.9023087	-87.62769053	41.90348607	-87.64335349	member
45EEAF68A1A051CA	classic_bike	Sat Oct 22 2022 09:47:00 GMT+0000 (Coordinated Universal Time)	Sat Oct 22 2022 09:57:00 GMT+0000 (Coordinated Universal Time)	Noble St & Milwaukee Ave	13290	Kingsbury St & Kinzie St	KA1503000043	41.90068	-87.6626	41.88917683	-87.63850577	casual
66CD8E4D0C38C0F3	electric_bike	Mon Oct 24 2022 12:39:00 GMT+0000 (Coordinated Universal Time)	Mon Oct 24 2022 12:48:00 GMT+0000 (Coordinated Universal Time)	Noble St & Milwaukee Ave	13290	Damen Ave & Cortland St	13133	41.90070083	-87.66256517	41.915983	-87.677335	member


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