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
8CD5DE2C2B6C4CFC	docked_bike	Sat Jun 13 2020 23:24:48 GMT+0000 (Coordinated Universal Time)	Sat Jun 13 2020 23:36:55 GMT+0000 (Coordinated Universal Time)	Wilton Ave & Belmont Ave	117	Damen Ave & Clybourn Ave	163	41.94018	-87.65304	41.931931	-87.677856	casual
9A191EB2C751D85D	docked_bike	Fri Jun 26 2020 07:26:10 GMT+0000 (Coordinated Universal Time)	Fri Jun 26 2020 07:31:58 GMT+0000 (Coordinated Universal Time)	Federal St & Polk St	41	Daley Center Plaza	81	41.872077	-87.629543	41.884241	-87.629634	member
F37D14B0B5659BCF	docked_bike	Tue Jun 23 2020 17:12:41 GMT+0000 (Coordinated Universal Time)	Tue Jun 23 2020 17:21:14 GMT+0000 (Coordinated Universal Time)	Daley Center Plaza	81	State St & Harrison St	5	41.884241	-87.629634	41.874053	-87.627716	member
C41237B506E85FA1	docked_bike	Sat Jun 20 2020 01:09:35 GMT+0000 (Coordinated Universal Time)	Sat Jun 20 2020 01:28:24 GMT+0000 (Coordinated Universal Time)	Broadway & Cornelia Ave	303	Broadway & Berwyn Ave	294	41.945529	-87.646439	41.978353	-87.659753	casual
4B51B3B0BDA7787C	docked_bike	Thu Jun 25 2020 16:59:25 GMT+0000 (Coordinated Universal Time)	Thu Jun 25 2020 17:08:48 GMT+0000 (Coordinated Universal Time)	Sheffield Ave & Webster Ave	327	Wilton Ave & Belmont Ave	117	41.92154	-87.653818	41.94018	-87.65304	casual
D50DF288196B53BE	docked_bike	Wed Jun 17 2020 18:07:18 GMT+0000 (Coordinated Universal Time)	Wed Jun 17 2020 18:18:14 GMT+0000 (Coordinated Universal Time)	Sheffield Ave & Webster Ave	327	Wilton Ave & Belmont Ave	117	41.92154	-87.653818	41.94018	-87.65304	casual
165FA6D223E58600	docked_bike	Thu Jun 25 2020 07:24:33 GMT+0000 (Coordinated Universal Time)	Thu Jun 25 2020 07:31:11 GMT+0000 (Coordinated Universal Time)	Federal St & Polk St	41	Daley Center Plaza	81	41.872077	-87.629543	41.884241	-87.629634	member
D8236CFC050E591C	docked_bike	Fri Jun 19 2020 00:00:56 GMT+0000 (Coordinated Universal Time)	Fri Jun 19 2020 00:09:15 GMT+0000 (Coordinated Universal Time)	Sheffield Ave & Wellington Ave	115	Broadway & Cornelia Ave	303	41.936266	-87.652662	41.945529	-87.646439	casual
9D82B9B53C37C55C	docked_bike	Tue Jun 30 2020 12:11:36 GMT+0000 (Coordinated Universal Time)	Tue Jun 30 2020 12:32:43 GMT+0000 (Coordinated Universal Time)	Calumet Ave & 18th St	338	Franklin St & Lake St	164	41.857611	-87.619407	41.885837	-87.6355	member
3DFF4AB10A6895A3	docked_bike	Sun Jun 28 2020 14:17:09 GMT+0000 (Coordinated Universal Time)	Sun Jun 28 2020 14:27:51 GMT+0000 (Coordinated Universal Time)	Milwaukee Ave & Grand Ave	84	Wells St & Huron St	53	41.891578	-87.648384	41.894722	-87.634362	member


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