Cyclistic

Bike share data cyclistic

@kaggle.salamibrahim_cyclistic

Table List

12 tables(282.45 MB)

N 202104 Divvy Tripdata

N 202105 Divvy Tripdata

N 202106 Divvy Tripdata

N 202107 Divvy Tripdata

N 202108 Divvy Tripdata

N 202109 Divvy Tripdata

N 202110 Divvy Tripdata

N 202111 Divvy Tripdata

N 202112 Divvy Tripdata

N 202201 Divvy Tripdata

N 202202 Divvy Tripdata

N 202203 Divvy Tripdata

N 202107 Divvy Tripdata

@kaggle.salamibrahim_cyclistic.n_202107_divvy_tripdata

39.71 MB
822410 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
0A1B623926EF4E16	docked_bike	Fri Jul 02 2021 14:44:36 GMT+0000 (Coordinated Universal Time)	Fri Jul 02 2021 15:19:58 GMT+0000 (Coordinated Universal Time)	Michigan Ave & Washington St	13001	Halsted St & North Branch St	KA1504000117	41.883984	-87.624684	41.899368	-87.64848	casual
B2D5583A5A5E76EE	classic_bike	Wed Jul 07 2021 16:57:42 GMT+0000 (Coordinated Universal Time)	Wed Jul 07 2021 17:16:09 GMT+0000 (Coordinated Universal Time)	California Ave & Cortez St	17660	Wood St & Hubbard St	13432	41.900363	-87.696704	41.889899	-87.671473	casual
6F264597DDBF427A	classic_bike	Sun Jul 25 2021 11:30:55 GMT+0000 (Coordinated Universal Time)	Sun Jul 25 2021 11:48:45 GMT+0000 (Coordinated Universal Time)	Wabash Ave & 16th St	SL-012	Rush St & Hubbard St	KA1503000044	41.860384	-87.625813	41.890173	-87.626185	member
379B58EAB20E8AA5	classic_bike	Thu Jul 08 2021 22:08:30 GMT+0000 (Coordinated Universal Time)	Thu Jul 08 2021 22:23:32 GMT+0000 (Coordinated Universal Time)	California Ave & Cortez St	17660	Carpenter St & Huron St	13196	41.900363	-87.696704	41.894556	-87.653449	member
6615C1E4EB08E8FB	electric_bike	Wed Jul 28 2021 16:08:06 GMT+0000 (Coordinated Universal Time)	Wed Jul 28 2021 16:27:09 GMT+0000 (Coordinated Universal Time)	California Ave & Cortez St	17660	Elizabeth (May) St & Fulton St	13197	41.90035	-87.69668233333333	41.8865935	-87.658387	casual
62DC2B32872F9BA8	electric_bike	Thu Jul 29 2021 17:09:08 GMT+0000 (Coordinated Universal Time)	Thu Jul 29 2021 17:15:00 GMT+0000 (Coordinated Universal Time)	California Ave & Cortez St	17660	Albany Ave & Bloomingdale Ave	15655	41.90032816666667	-87.696735	41.913886833333336	-87.70512833333333	casual
4BBB6E80E6A2A16D	classic_bike	Wed Jul 28 2021 16:51:47 GMT+0000 (Coordinated Universal Time)	Wed Jul 28 2021 17:03:45 GMT+0000 (Coordinated Universal Time)	California Ave & Cortez St	17660	Albany Ave & Bloomingdale Ave	15655	41.900363	-87.696704	41.91402671273	-87.705126462	casual
22CA03D32C6BB094	classic_bike	Sat Jul 03 2021 12:44:50 GMT+0000 (Coordinated Universal Time)	Sat Jul 03 2021 12:52:55 GMT+0000 (Coordinated Universal Time)	Clark St & North Ave	13128	Clark St & Chicago Ave	13303	41.911974	-87.631942	41.89675	-87.63089	casual
61F0D07D1EEE72EE	classic_bike	Fri Jul 02 2021 18:18:22 GMT+0000 (Coordinated Universal Time)	Fri Jul 02 2021 18:38:21 GMT+0000 (Coordinated Universal Time)	Sheridan Rd & Montrose Ave	TA1307000107	Southport Ave & Clybourn Ave	TA1309000030	41.96167	-87.65464	41.920771	-87.663712	member
09B4551386A8410E	classic_bike	Thu Jul 29 2021 21:54:05 GMT+0000 (Coordinated Universal Time)	Thu Jul 29 2021 22:07:26 GMT+0000 (Coordinated Universal Time)	Sheridan Rd & Montrose Ave	TA1307000107	Lakefront Trail & Bryn Mawr Ave	KA1504000152	41.96167	-87.65464	41.98403669612	-87.6523104689	member


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