Google Data Analytics Professional Certification

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
762198876D69004D	docked_bike	Thu Jul 09 2020 15:22:02 GMT+0000 (Coordinated Universal Time)	Thu Jul 09 2020 15:25:52 GMT+0000 (Coordinated Universal Time)	Ritchie Ct & Banks St	180	Wells St & Evergreen Ave	291	41.906866	-87.626217	41.906724	-87.63483	member
BEC9C9FBA0D4CF1B	docked_bike	Fri Jul 24 2020 23:56:30 GMT+0000 (Coordinated Universal Time)	Sat Jul 25 2020 00:20:17 GMT+0000 (Coordinated Universal Time)	Halsted St & Roscoe St	299	Broadway & Ridge Ave	461	41.94367	-87.64895	41.9840446107	-87.6602738295	member
D2FD8EA432C77EC1	docked_bike	Wed Jul 08 2020 19:49:07 GMT+0000 (Coordinated Universal Time)	Wed Jul 08 2020 19:56:22 GMT+0000 (Coordinated Universal Time)	Lake Shore Dr & Diversey Pkwy	329	Clark St & Wellington Ave	156	41.932588	-87.636427	41.9364968219	-87.6475386582	casual
54AE594E20B35881	docked_bike	Fri Jul 17 2020 19:06:42 GMT+0000 (Coordinated Universal Time)	Fri Jul 17 2020 19:27:38 GMT+0000 (Coordinated Universal Time)	LaSalle St & Illinois St	181	Clark St & Armitage Ave	94	41.890762	-87.631697	41.918306	-87.636282	casual
54025FDC7440B56F	docked_bike	Sat Jul 04 2020 10:39:57 GMT+0000 (Coordinated Universal Time)	Sat Jul 04 2020 10:45:05 GMT+0000 (Coordinated Universal Time)	Lake Shore Dr & North Blvd	268	Clark St & Schiller St	301	41.911722	-87.626804	41.907993	-87.631501	member
65636B619E24257F	docked_bike	Tue Jul 28 2020 16:33:03 GMT+0000 (Coordinated Universal Time)	Tue Jul 28 2020 16:49:10 GMT+0000 (Coordinated Universal Time)	Fairbanks St & Superior St	635	Wells St & Concord Ln	289	41.895748	-87.620104	41.912133	-87.634656	casual
22DB94283ECFDBD2	docked_bike	Thu Jul 30 2020 11:58:12 GMT+0000 (Coordinated Universal Time)	Thu Jul 30 2020 12:16:12 GMT+0000 (Coordinated Universal Time)	Bissell St & Armitage Ave	113	Dearborn Pkwy & Delaware Pl	140	41.91844	-87.65222	41.898969	-87.629912	member
C9D789BEF899F4B8	docked_bike	Mon Jul 13 2020 16:48:03 GMT+0000 (Coordinated Universal Time)	Mon Jul 13 2020 16:57:00 GMT+0000 (Coordinated Universal Time)	St. Clair St & Erie St	211	Franklin St & Chicago Ave	31	41.894448	-87.622663	41.896746973093805	-87.63566762208939	member
FBE24D943CDE35A1	docked_bike	Thu Jul 30 2020 11:00:12 GMT+0000 (Coordinated Universal Time)	Thu Jul 30 2020 11:14:48 GMT+0000 (Coordinated Universal Time)	Clark St & Elm St	176	Canal St & Monroe St	191	41.902973	-87.63128	41.88169	-87.63953	member
8A2BBE457325A2E7	docked_bike	Mon Jul 06 2020 18:05:29 GMT+0000 (Coordinated Universal Time)	Mon Jul 06 2020 18:15:38 GMT+0000 (Coordinated Universal Time)	Franklin St & Chicago Ave	31	McClurg Ct & Erie St	142	41.896746	-87.635667	41.894503	-87.617854	member


CREATE TABLE n_202007_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" DOUBLE,
  "end_station_name" VARCHAR,
  "end_station_id" DOUBLE,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);