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
A847FADBBC638E45	docked_bike	Sun Apr 26 2020 17:45:14 GMT+0000 (Coordinated Universal Time)	Sun Apr 26 2020 18:12:03 GMT+0000 (Coordinated Universal Time)	Eckhart Park	86	Lincoln Ave & Diversey Pkwy	152.0	41.8964	-87.661	41.9322	-87.6586	member
5405B80E996FF60D	docked_bike	Fri Apr 17 2020 17:08:54 GMT+0000 (Coordinated Universal Time)	Fri Apr 17 2020 17:17:03 GMT+0000 (Coordinated Universal Time)	Drake Ave & Fullerton Ave	503	Kosciuszko Park	499.0	41.9244	-87.7154	41.9306	-87.7238	member
5DD24A79A4E006F4	docked_bike	Wed Apr 01 2020 17:54:13 GMT+0000 (Coordinated Universal Time)	Wed Apr 01 2020 18:08:36 GMT+0000 (Coordinated Universal Time)	McClurg Ct & Erie St	142	Indiana Ave & Roosevelt Rd	255.0	41.8945	-87.6179	41.8679	-87.623	member
2A59BBDF5CDBA725	docked_bike	Tue Apr 07 2020 12:50:19 GMT+0000 (Coordinated Universal Time)	Tue Apr 07 2020 13:02:31 GMT+0000 (Coordinated Universal Time)	California Ave & Division St	216	Wood St & Augusta Blvd	657.0	41.903	-87.6975	41.8992	-87.6722	member
27AD306C119C6158	docked_bike	Sat Apr 18 2020 10:22:59 GMT+0000 (Coordinated Universal Time)	Sat Apr 18 2020 11:15:54 GMT+0000 (Coordinated Universal Time)	Rush St & Hubbard St	125	Sheridan Rd & Lawrence Ave	323.0	41.8902	-87.6262	41.9695	-87.6547	casual
356216E875132F61	docked_bike	Thu Apr 30 2020 17:55:47 GMT+0000 (Coordinated Universal Time)	Thu Apr 30 2020 18:01:11 GMT+0000 (Coordinated Universal Time)	Mies van der Rohe Way & Chicago Ave	173	Streeter Dr & Grand Ave	35.0	41.8969	-87.6217	41.8923	-87.612	member
A2759CB06A81F2BC	docked_bike	Thu Apr 02 2020 14:47:19 GMT+0000 (Coordinated Universal Time)	Thu Apr 02 2020 14:52:32 GMT+0000 (Coordinated Universal Time)	Streeter Dr & Grand Ave	35	Fairbanks St & Superior St	635.0	41.8923	-87.612	41.8957	-87.6201	member
FC8BC2E2D54F35ED	docked_bike	Tue Apr 07 2020 12:22:20 GMT+0000 (Coordinated Universal Time)	Tue Apr 07 2020 13:38:09 GMT+0000 (Coordinated Universal Time)	Ogden Ave & Roosevelt Rd	434	Western Ave & Congress Pkwy	382.0	41.8665	-87.6847	41.8747	-87.6864	casual
9EC5648678DE06E6	docked_bike	Wed Apr 15 2020 10:30:11 GMT+0000 (Coordinated Universal Time)	Wed Apr 15 2020 10:35:55 GMT+0000 (Coordinated Universal Time)	LaSalle Dr & Huron St	627	Larrabee St & Division St	359.0	41.8949	-87.6323	41.9035	-87.6434	casual
A8FFF89140C33017	docked_bike	Sat Apr 04 2020 15:02:28 GMT+0000 (Coordinated Universal Time)	Sat Apr 04 2020 15:19:47 GMT+0000 (Coordinated Universal Time)	Kedzie Ave & Lake St	377	Central Park Ave & North Ave	508.0	41.8846	-87.7063	41.9097	-87.7166	member


CREATE TABLE merged_file (
  "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
);