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
3564070EEFD12711	electric_bike	Wed Apr 06 2022 17:42:00 GMT+0000 (Coordinated Universal Time)	Wed Apr 06 2022 17:54:00 GMT+0000 (Coordinated Universal Time)	Paulina St & Howard St	515	University Library (NU)	605	42.019135	-87.67353183	42.052939	-87.673447	member
0B820C7FCF22F489	classic_bike	Sun Apr 24 2022 19:23:00 GMT+0000 (Coordinated Universal Time)	Sun Apr 24 2022 19:43:00 GMT+0000 (Coordinated Universal Time)	Wentworth Ave & Cermak Rd	13075	Green St & Madison St	TA1307000120	41.85308456	-87.6319313	41.881892	-87.648789	member
89EEEE32293F07FF	classic_bike	Wed Apr 20 2022 19:29:00 GMT+0000 (Coordinated Universal Time)	Wed Apr 20 2022 19:35:00 GMT+0000 (Coordinated Universal Time)	Halsted St & Polk St	TA1307000121	Green St & Madison St	TA1307000120	41.87184	-87.64664	41.881892	-87.648789	member
84D4751AEB31888D	classic_bike	Fri Apr 22 2022 21:14:00 GMT+0000 (Coordinated Universal Time)	Fri Apr 22 2022 21:23:00 GMT+0000 (Coordinated Universal Time)	Wentworth Ave & Cermak Rd	13075	Delano Ct & Roosevelt Rd	KA1706005007	41.85308456	-87.6319313	41.867491	-87.63219	casual
5664BCF0D1DE7A8B	electric_bike	Sat Apr 16 2022 15:56:00 GMT+0000 (Coordinated Universal Time)	Sat Apr 16 2022 16:02:00 GMT+0000 (Coordinated Universal Time)	Halsted St & Polk St	TA1307000121	Clinton St & Madison St	TA1305000032	41.87180829	-87.6465745	41.882242	-87.641066	member
AA9EB7BD2E1FC128	classic_bike	Thu Apr 21 2022 16:52:00 GMT+0000 (Coordinated Universal Time)	Thu Apr 21 2022 16:56:00 GMT+0000 (Coordinated Universal Time)	Desplaines St & Randolph St	15535	Canal St & Adams St	13011	41.88461619	-87.64457058	41.879255	-87.639904	member
9E10667D54A73861	classic_bike	Mon Apr 04 2022 17:10:00 GMT+0000 (Coordinated Universal Time)	Mon Apr 04 2022 17:15:00 GMT+0000 (Coordinated Universal Time)	Desplaines St & Randolph St	15535	Canal St & Adams St	13011	41.88461619	-87.64457058	41.879255	-87.639904	member
22291F983B344390	classic_bike	Tue Apr 05 2022 08:52:00 GMT+0000 (Coordinated Universal Time)	Tue Apr 05 2022 09:04:00 GMT+0000 (Coordinated Universal Time)	Franklin St & Jackson Blvd	TA1305000025	Morgan St & Lake St	TA1306000015	41.87770796	-87.63532114	41.88577925	-87.65102461	member
7E14444DA4A4B2BC	electric_bike	Fri Apr 29 2022 11:38:00 GMT+0000 (Coordinated Universal Time)	Fri Apr 29 2022 11:38:00 GMT+0000 (Coordinated Universal Time)	Halsted St & Clybourn Ave	331	Halsted St & Clybourn Ave	331	41.90966417	-87.64812417	41.909668	-87.648128	member
D55A28D2B63A7EA9	electric_bike	Fri Apr 29 2022 23:38:00 GMT+0000 (Coordinated Universal Time)	Fri Apr 29 2022 23:40:00 GMT+0000 (Coordinated Universal Time)	Halsted St & Clybourn Ave	331	Halsted St & Clybourn Ave	331	41.90953067	-87.64807583	41.909668	-87.648128	member


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