Cyclistic Bike Share Trip Data - 06.2023

Google Data Analytics Capstone Project

@kaggle.rubyphan_bike_share

Table List

12 tables(281.77 MB)

N 202207 Divvy Tripdata

N 202208 Divvy Tripdata

N 202209 Divvy Publictripdata

N 202210 Divvy Tripdata

N 202211 Divvy Tripdata

N 202212 Divvy Tripdata

N 202301 Divvy Tripdata

N 202302 Divvy Tripdata

N 202303 Divvy Tripdata

N 202304 Divvy Tripdata

N 202305 Divvy Tripdata

N 202306 Divvy Tripdata

N 202302 Divvy Tripdata

@kaggle.rubyphan_bike_share.n_202302_divvy_tripdata

9.25 MB
190445 rows
13 columns

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
CBCD0D7777F0E45F	classic_bike	Tue Feb 14 2023 11:59:42 GMT+0000 (Coordinated Universal Time)	Tue Feb 14 2023 12:13:38 GMT+0000 (Coordinated Universal Time)	Southport Ave & Clybourn Ave	TA1309000030	Clark St & Schiller St	TA1309000024	41.920771	-87.663712	41.907993	-87.631501	casual
F3EC5FCE5FF39DE9	electric_bike	Wed Feb 15 2023 13:53:48 GMT+0000 (Coordinated Universal Time)	Wed Feb 15 2023 13:59:08 GMT+0000 (Coordinated Universal Time)	Clarendon Ave & Gordon Ter	13379	Sheridan Rd & Lawrence Ave	TA1309000041	41.957879424	-87.649583697	41.969517	-87.654691	casual
E54C1F27FA9354FF	classic_bike	Sun Feb 19 2023 11:10:57 GMT+0000 (Coordinated Universal Time)	Sun Feb 19 2023 11:35:01 GMT+0000 (Coordinated Universal Time)	Southport Ave & Clybourn Ave	TA1309000030	Aberdeen St & Monroe St	13156	41.920771	-87.663712	41.880419	-87.655519	member
3D561E04F739CC45	electric_bike	Sun Feb 26 2023 16:12:05 GMT+0000 (Coordinated Universal Time)	Sun Feb 26 2023 16:39:55 GMT+0000 (Coordinated Universal Time)	Southport Ave & Clybourn Ave	TA1309000030	Franklin St & Adams St (Temp)	TA1309000008	41.920872808	-87.663732648	41.87943409140013	-87.63550400733948	member
0CB4B4D53B2DBE05	electric_bike	Mon Feb 20 2023 11:55:23 GMT+0000 (Coordinated Universal Time)	Mon Feb 20 2023 12:05:48 GMT+0000 (Coordinated Universal Time)	Prairie Ave & Garfield Blvd	TA1307000160	Cottage Grove Ave & 63rd St	KA1503000054	41.794827223	-87.618794918	41.78053094070882	-87.6059702038765	member
C67EB62172C472EB	classic_bike	Fri Feb 24 2023 18:50:16 GMT+0000 (Coordinated Universal Time)	Fri Feb 24 2023 18:56:40 GMT+0000 (Coordinated Universal Time)	Wells St & Concord Ln	TA1308000050	Clybourn Ave & Division St	TA1307000115	41.912133	-87.634656	41.904613	-87.640552	member
08A1E9326F68ACF7	classic_bike	Tue Feb 28 2023 12:58:03 GMT+0000 (Coordinated Universal Time)	Tue Feb 28 2023 13:03:33 GMT+0000 (Coordinated Universal Time)	Wells St & Concord Ln	TA1308000050	Clybourn Ave & Division St	TA1307000115	41.912133	-87.634656	41.904613	-87.640552	member
904C61FB3984A60E	classic_bike	Mon Feb 27 2023 20:26:01 GMT+0000 (Coordinated Universal Time)	Mon Feb 27 2023 20:31:24 GMT+0000 (Coordinated Universal Time)	Wells St & Concord Ln	TA1308000050	Clybourn Ave & Division St	TA1307000115	41.912133	-87.634656	41.904613	-87.640552	member
A96A6DA2D96544E6	classic_bike	Wed Feb 08 2023 19:56:36 GMT+0000 (Coordinated Universal Time)	Wed Feb 08 2023 20:02:22 GMT+0000 (Coordinated Universal Time)	Wells St & Concord Ln	TA1308000050	Clybourn Ave & Division St	TA1307000115	41.912133	-87.634656	41.904613	-87.640552	member
DA895AE47787D208	classic_bike	Tue Feb 21 2023 18:52:20 GMT+0000 (Coordinated Universal Time)	Tue Feb 21 2023 18:57:57 GMT+0000 (Coordinated Universal Time)	Wells St & Concord Ln	TA1308000050	Clybourn Ave & Division St	TA1307000115	41.912133	-87.634656	41.904613	-87.640552	member


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