Cyclistic Trip Data

Four files concerning the Cyclistic data set.

@kaggle.matthewjamesnoble_cyclistic_trip_data

Table List

1 table(29.5 MB)

N 202405 Divvy Tripdata

@kaggle.matthewjamesnoble_cyclistic_trip_data.n_202405_divvy_tripdata

29.5 MB
609493 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
7D9F0CE9EC2A1297	classic_bike	Sat May 25 2024 15:52:42 GMT+0000 (Coordinated Universal Time)	Sat May 25 2024 16:11:50 GMT+0000 (Coordinated Universal Time)	Streeter Dr & Grand Ave	13022	Clark St & Elm St	TA1307000039	41.892278	-87.612043	41.902973	-87.63128	casual
02EC47687411416F	classic_bike	Tue May 14 2024 15:11:51 GMT+0000 (Coordinated Universal Time)	Tue May 14 2024 15:22:00 GMT+0000 (Coordinated Universal Time)	Sheridan Rd & Greenleaf Ave	KA1504000159	Sheridan Rd & Loyola Ave	RP-009	42.01058656284	-87.6624120948	42.00104377979	-87.6611982433	casual
101370FB2D3402BE	classic_bike	Thu May 30 2024 17:46:04 GMT+0000 (Coordinated Universal Time)	Thu May 30 2024 18:09:16 GMT+0000 (Coordinated Universal Time)	Streeter Dr & Grand Ave	13022	Wabash Ave & 9th St	TA1309000010	41.892278	-87.612043	41.870769	-87.625734	member
E97E396331ED6913	electric_bike	Fri May 17 2024 20:21:54 GMT+0000 (Coordinated Universal Time)	Fri May 17 2024 20:40:32 GMT+0000 (Coordinated Universal Time)	Streeter Dr & Grand Ave	13022	Sheffield Ave & Wellington Ave	TA1307000052	41.892270088	-87.611946106	41.9362534831413	-87.65266209840775	member
674EDE311C543165	classic_bike	Wed May 22 2024 18:52:20 GMT+0000 (Coordinated Universal Time)	Wed May 22 2024 18:59:04 GMT+0000 (Coordinated Universal Time)	Larrabee St & Division St	KA1504000079	Clark St & Elm St	TA1307000039	41.90348607004	-87.6433534936	41.902973	-87.63128	casual
2E3EA4C19F0341A6	electric_bike	Sat May 25 2024 19:32:12 GMT+0000 (Coordinated Universal Time)	Sat May 25 2024 19:36:17 GMT+0000 (Coordinated Universal Time)	Sheridan Rd & Greenleaf Ave	KA1504000159	Sheridan Rd & Loyola Ave	RP-009	42.01057148	-87.662455559	42.00104377979	-87.6611982433	casual
162E08B659EF039B	classic_bike	Fri May 17 2024 08:39:54 GMT+0000 (Coordinated Universal Time)	Fri May 17 2024 08:49:35 GMT+0000 (Coordinated Universal Time)	Damen Ave & Wellington Ave	13268	Sheffield Ave & Wellington Ave	TA1307000052	41.93588	-87.67842	41.9362534831413	-87.65266209840775	casual
473CC6544D5876F2	classic_bike	Sun May 19 2024 17:21:18 GMT+0000 (Coordinated Universal Time)	Sun May 19 2024 17:51:29 GMT+0000 (Coordinated Universal Time)	Aberdeen St & Monroe St	13156	Clinton St & Roosevelt Rd	WL-008	41.880419	-87.655519	41.8671177825	-87.6410879593	casual
980FF5F45459C20C	classic_bike	Sun May 19 2024 17:20:40 GMT+0000 (Coordinated Universal Time)	Sun May 19 2024 17:51:26 GMT+0000 (Coordinated Universal Time)	Aberdeen St & Monroe St	13156	Clinton St & Roosevelt Rd	WL-008	41.880419	-87.655519	41.8671177825	-87.6410879593	casual
72D2806130155F29	classic_bike	Mon May 20 2024 21:01:35 GMT+0000 (Coordinated Universal Time)	Mon May 20 2024 21:27:15 GMT+0000 (Coordinated Universal Time)	Streeter Dr & Grand Ave	13022	Clark St & Elm St	TA1307000039	41.892278	-87.612043	41.902973	-87.63128	casual


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