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
550CF7EFEAE0C618	electric_bike	Sun Aug 07 2022 21:34:00 GMT+0000 (Coordinated Universal Time)	Sun Aug 07 2022 21:41:00 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.93	-87.69	41.94	-87.72	casual
DAD198F405F9C5F5	electric_bike	Mon Aug 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)	Mon Aug 08 2022 14:53:00 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.89	-87.64	41.92	-87.64	casual
E6F2BC47B65CB7FD	electric_bike	Mon Aug 08 2022 15:29:00 GMT+0000 (Coordinated Universal Time)	Mon Aug 08 2022 15:40:00 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.97	-87.69	41.97	-87.66	casual
F597830181C2E13C	electric_bike	Mon Aug 08 2022 02:43:00 GMT+0000 (Coordinated Universal Time)	Mon Aug 08 2022 02:58:00 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.94	-87.65	41.97	-87.69	casual
0CE689BB4E313E8D	electric_bike	Sun Aug 07 2022 20:24:00 GMT+0000 (Coordinated Universal Time)	Sun Aug 07 2022 20:29:00 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.85	-87.65	41.84	-87.66	casual
BFA7E7CC69860C20	electric_bike	Mon Aug 08 2022 13:06:00 GMT+0000 (Coordinated Universal Time)	Mon Aug 08 2022 13:19:00 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.79	-87.72	41.82	-87.69	casual
68C474A4E92F24B6	electric_bike	Mon Aug 08 2022 14:02:00 GMT+0000 (Coordinated Universal Time)	Mon Aug 08 2022 14:11:00 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.89	-87.63	41.89	-87.61	casual
14A985A3838AA8CC	electric_bike	Sun Aug 07 2022 20:56:00 GMT+0000 (Coordinated Universal Time)	Sun Aug 07 2022 21:14:00 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.96	-87.68	41.92	-87.68	casual
E724B94BCE2E7E36	electric_bike	Sun Aug 07 2022 21:30:00 GMT+0000 (Coordinated Universal Time)	Sun Aug 07 2022 21:41:00 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.92	-87.68	41.93	-87.72	casual
1AA3756A6F8189DB	electric_bike	Sun Aug 07 2022 23:53:00 GMT+0000 (Coordinated Universal Time)	Mon Aug 08 2022 00:04:00 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.93	-87.72	41.92	-87.68	casual


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