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
02668AD35674B983	docked_bike	Wed May 27 2020 10:03:52 GMT+0000 (Coordinated Universal Time)	Wed May 27 2020 10:16:49 GMT+0000 (Coordinated Universal Time)	Franklin St & Jackson Blvd	36	Wabash Ave & Grand Ave	199	41.8777	-87.6353	41.8915	-87.6268	member
7A50CCAF1EDDB28F	docked_bike	Mon May 25 2020 10:47:11 GMT+0000 (Coordinated Universal Time)	Mon May 25 2020 11:05:40 GMT+0000 (Coordinated Universal Time)	Clark St & Wrightwood Ave	340	Clark St & Leland Ave	326	41.9295	-87.6431	41.9671	-87.6674	casual
2FFCDFDB91FE9A52	docked_bike	Sat May 02 2020 14:11:03 GMT+0000 (Coordinated Universal Time)	Sat May 02 2020 15:48:21 GMT+0000 (Coordinated Universal Time)	Kedzie Ave & Milwaukee Ave	260	Kedzie Ave & Milwaukee Ave	260	41.9296	-87.7079	41.9296	-87.7079	casual
58991CF1DB75BA84	docked_bike	Sat May 02 2020 16:25:36 GMT+0000 (Coordinated Universal Time)	Sat May 02 2020 16:39:28 GMT+0000 (Coordinated Universal Time)	Clarendon Ave & Leland Ave	251	Lake Shore Dr & Wellington Ave	157	41.968	-87.65	41.9367	-87.6368	casual
A79651EFECC268CD	docked_bike	Fri May 29 2020 12:49:54 GMT+0000 (Coordinated Universal Time)	Fri May 29 2020 13:27:11 GMT+0000 (Coordinated Universal Time)	Hermitage Ave & Polk St	261	Halsted St & Archer Ave	206	41.8715	-87.6699	41.8472	-87.6468	member
1466C5B39F68F746	docked_bike	Fri May 29 2020 13:27:24 GMT+0000 (Coordinated Universal Time)	Fri May 29 2020 14:14:45 GMT+0000 (Coordinated Universal Time)	Halsted St & Archer Ave	206	May St & Taylor St	22	41.8472	-87.6468	41.8695	-87.6555	member
2500D7957D4D0A34	docked_bike	Wed May 20 2020 12:51:41 GMT+0000 (Coordinated Universal Time)	Wed May 20 2020 13:46:47 GMT+0000 (Coordinated Universal Time)	Hermitage Ave & Polk St	261	Hermitage Ave & Polk St	261	41.8715	-87.6699	41.8715	-87.6699	member
ED42D3E06AFB2F26	docked_bike	Wed May 06 2020 18:21:42 GMT+0000 (Coordinated Universal Time)	Wed May 06 2020 19:07:07 GMT+0000 (Coordinated Universal Time)	Ritchie Ct & Banks St	180	Ritchie Ct & Banks St	180	41.9069	-87.6262	41.9069	-87.6262	casual
23AFBD962F9C8F14	docked_bike	Sat May 30 2020 17:00:58 GMT+0000 (Coordinated Universal Time)	Sat May 30 2020 17:19:52 GMT+0000 (Coordinated Universal Time)	Halsted St & Clybourn Ave	331	Broadway & Barry Ave	300	41.9097	-87.6481	41.9377	-87.6441	casual
52C0D13F6B81C5F8	docked_bike	Sat May 23 2020 10:22:02 GMT+0000 (Coordinated Universal Time)	Sat May 23 2020 10:52:02 GMT+0000 (Coordinated Universal Time)	Damen Ave & Cortland St	219	Western Ave & Division St	305	41.916	-87.6773	41.9029	-87.6873	casual


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