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 202104 Divvy Tripdata

@kaggle.salamibrahim_cyclistic.n_202104_divvy_tripdata

16.56 MB
337230 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
6C992BD37A98A63F	classic_bike	Mon Apr 12 2021 18:25:36 GMT+0000 (Coordinated Universal Time)	Mon Apr 12 2021 18:56:55 GMT+0000 (Coordinated Universal Time)	State St & Pearson St	TA1307000061	Southport Ave & Waveland Ave	13235	41.897448	-87.628722	41.94815	-87.66394	member
1E0145613A209000	docked_bike	Tue Apr 27 2021 17:27:11 GMT+0000 (Coordinated Universal Time)	Tue Apr 27 2021 18:31:29 GMT+0000 (Coordinated Universal Time)	Dorchester Ave & 49th St	KA1503000069	Dorchester Ave & 49th St	KA1503000069	41.805772	-87.592464	41.805772	-87.592464	casual
E498E15508A80BAD	docked_bike	Sat Apr 03 2021 12:42:45 GMT+0000 (Coordinated Universal Time)	Wed Apr 07 2021 11:40:24 GMT+0000 (Coordinated Universal Time)	Loomis Blvd & 84th St	20121	Loomis Blvd & 84th St	20121	41.741487	-87.65841	41.741487	-87.65841	casual
1887262AD101C604	classic_bike	Sat Apr 17 2021 09:17:42 GMT+0000 (Coordinated Universal Time)	Sat Apr 17 2021 09:42:48 GMT+0000 (Coordinated Universal Time)	Honore St & Division St	TA1305000034	Southport Ave & Waveland Ave	13235	41.903119	-87.673935	41.94815	-87.66394	member
C123548CAB2A32A5	docked_bike	Sat Apr 03 2021 12:42:25 GMT+0000 (Coordinated Universal Time)	Sat Apr 03 2021 14:13:42 GMT+0000 (Coordinated Universal Time)	Loomis Blvd & 84th St	20121	Loomis Blvd & 84th St	20121	41.741487	-87.65841	41.741487	-87.65841	casual
097E76F3651B1AC1	classic_bike	Sun Apr 25 2021 18:43:18 GMT+0000 (Coordinated Universal Time)	Sun Apr 25 2021 18:43:59 GMT+0000 (Coordinated Universal Time)	Clinton St & Polk St	15542	Clinton St & Polk St	15542	41.87146651779	-87.6409491327	41.87146651779	-87.6409491327	casual
53C38EB01E6FA5C4	classic_bike	Sat Apr 03 2021 16:28:21 GMT+0000 (Coordinated Universal Time)	Sat Apr 03 2021 16:29:47 GMT+0000 (Coordinated Universal Time)	Ashland Ave & 63rd St	16948	Ashland Ave & 63rd St	16948	41.779374	-87.664843	41.779374	-87.664843	casual
D53AC014EFD6E2BA	electric_bike	Tue Apr 06 2021 16:35:06 GMT+0000 (Coordinated Universal Time)	Tue Apr 06 2021 17:00:56 GMT+0000 (Coordinated Universal Time)	Dorchester Ave & 49th St	KA1503000069	Dorchester Ave & 49th St	KA1503000069	41.805832333333335	-87.5924785	41.80580283333333	-87.5926615	casual
6E2F7CA1FA9E0AFB	classic_bike	Mon Apr 12 2021 15:22:54 GMT+0000 (Coordinated Universal Time)	Mon Apr 12 2021 16:15:48 GMT+0000 (Coordinated Universal Time)	Ashland Ave & 63rd St	16948	Ashland Ave & 63rd St	16948	41.779374	-87.664843	41.779374	-87.664843	casual
04218447AAC80BD1	classic_bike	Sat Apr 24 2021 15:04:55 GMT+0000 (Coordinated Universal Time)	Sat Apr 24 2021 15:06:16 GMT+0000 (Coordinated Universal Time)	Dorchester Ave & 49th St	KA1503000069	Dorchester Ave & 49th St	KA1503000069	41.805772	-87.592464	41.805772	-87.592464	casual


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