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
600CFD130D0FD2A4	electric_bike	Thu Jun 30 2022 17:27:00 GMT+0000 (Coordinated Universal Time)	Thu Jun 30 2022 17:35:00 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.89	-87.62	41.91	-87.62	casual
F5E6B5C1682C6464	electric_bike	Thu Jun 30 2022 18:39:00 GMT+0000 (Coordinated Universal Time)	Thu Jun 30 2022 18:47:00 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.91	-87.62	41.93	-87.63	casual
B6EB6D27BAD771D2	electric_bike	Thu Jun 30 2022 11:49:00 GMT+0000 (Coordinated Universal Time)	Thu Jun 30 2022 12:02:00 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.91	-87.65	41.89	-87.61	casual
C9C320375DE1D5C6	electric_bike	Thu Jun 30 2022 11:15:00 GMT+0000 (Coordinated Universal Time)	Thu Jun 30 2022 11:19:00 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.8	-87.66	41.8	-87.65	casual
56C055851023BE98	electric_bike	Wed Jun 29 2022 23:36:00 GMT+0000 (Coordinated Universal Time)	Wed Jun 29 2022 23:45:00 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.91	-87.63	41.93	-87.64	casual
B664188E8163D045	electric_bike	Thu Jun 30 2022 16:42:00 GMT+0000 (Coordinated Universal Time)	Thu Jun 30 2022 16:58:00 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	42.03	-87.71	42.06	-87.73	casual
338C05A3E90D619B	electric_bike	Thu Jun 30 2022 18:39:00 GMT+0000 (Coordinated Universal Time)	Thu Jun 30 2022 19:05:00 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.91	-87.63	41.92	-87.72	casual
C037F5F4107788DE	electric_bike	Thu Jun 30 2022 12:46:00 GMT+0000 (Coordinated Universal Time)	Thu Jun 30 2022 14:12:00 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.89	-87.62	41.98	-87.67	casual
C19B08D794D1C89E	electric_bike	Thu Jun 30 2022 11:09:00 GMT+0000 (Coordinated Universal Time)	Thu Jun 30 2022 11:10:00 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.89	-87.61	41.89	-87.61	casual
6E9E3A041C14E960	electric_bike	Thu Jun 30 2022 11:05:00 GMT+0000 (Coordinated Universal Time)	Thu Jun 30 2022 11:09:00 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.89	-87.61	41.89	-87.61	casual


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