Cycle Ride Share

Behavorial data for bike trips by members/casual riders

@kaggle.hannizaher_cycle_ride_share

Table List

1 table(118.54 MB)

Year To Date Finished

@kaggle.hannizaher_cycle_ride_share.year_to_date_finished

118.54 MB
2602256 rows
13 columns

unnamed_0 Unnamed: 0	ride_id Ride Id	rideable_type Rideable Type	started_at Started At	ended_at Ended At	start_station_name Start Station Name	member_casual Member Casual	ride_length Ride Length	day_of_week Day Of Week	date Date	month Month	day Day	year Year
1	59E2D9773E015472	classic_bike	Mon Jan 01 2024 01:47:58 GMT+0000 (Coordinated Universal Time)	Tue Jan 02 2024 02:47:55 GMT+0000 (Coordinated Universal Time)	Ashland Ave & Wellington Ave	casual	89997	Monday	Mon Jan 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	1	1	2024
2	32B0CE9A4BCDF4C0	classic_bike	Mon Jan 08 2024 17:31:29 GMT+0000 (Coordinated Universal Time)	Tue Jan 09 2024 18:31:26 GMT+0000 (Coordinated Universal Time)	DuSable Lake Shore Dr & Monroe St	member	89997	Monday	Mon Jan 08 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	1	8	2024
3	22C4719DF942B760	classic_bike	Fri Jan 26 2024 07:57:21 GMT+0000 (Coordinated Universal Time)	Sat Jan 27 2024 08:57:18 GMT+0000 (Coordinated Universal Time)	Cottage Grove Ave & 111th Pl	casual	89997	Friday	Fri Jan 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	1	26	2024
4	395F67B461B54C8D	classic_bike	Mon Jan 29 2024 16:29:36 GMT+0000 (Coordinated Universal Time)	Tue Jan 30 2024 17:29:32 GMT+0000 (Coordinated Universal Time)	Stockton Dr & Wrightwood Ave	casual	89996	Monday	Mon Jan 29 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	1	29	2024
5	AEAABBAE3E21CEF6	classic_bike	Wed Jan 17 2024 14:30:44 GMT+0000 (Coordinated Universal Time)	Thu Jan 18 2024 15:30:40 GMT+0000 (Coordinated Universal Time)	Kedzie Ave & 66th Pl	casual	89996	Wednesday	Wed Jan 17 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	1	17	2024
6	BFB8C2A9F70B60CE	classic_bike	Tue Jan 09 2024 19:35:09 GMT+0000 (Coordinated Universal Time)	Wed Jan 10 2024 20:35:05 GMT+0000 (Coordinated Universal Time)	Orleans St & Merchandise Mart Plaza	casual	89996	Tuesday	Tue Jan 09 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	1	9	2024
7	C171070D5FCF44C0	classic_bike	Wed Jan 03 2024 14:43:41 GMT+0000 (Coordinated Universal Time)	Thu Jan 04 2024 15:43:37 GMT+0000 (Coordinated Universal Time)	Greenwood Ave & 97th St	casual	89996	Wednesday	Wed Jan 03 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	1	3	2024
8	1A3C7CC0DDE14A9A	classic_bike	Thu Jan 18 2024 19:30:33 GMT+0000 (Coordinated Universal Time)	Fri Jan 19 2024 20:30:29 GMT+0000 (Coordinated Universal Time)	Greenwood Ave & 47th St	casual	89996	Thursday	Thu Jan 18 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	1	18	2024
9	29267FB319C4551B	classic_bike	Mon Jan 08 2024 15:27:58 GMT+0000 (Coordinated Universal Time)	Tue Jan 09 2024 16:27:54 GMT+0000 (Coordinated Universal Time)	Millennium Park	casual	89996	Monday	Mon Jan 08 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	1	8	2024
10	3C1501D50ABBAB4D	classic_bike	Wed Jan 31 2024 08:56:01 GMT+0000 (Coordinated Universal Time)	Thu Feb 01 2024 09:55:57 GMT+0000 (Coordinated Universal Time)	Halsted St & Dickens Ave	member	89996	Wednesday	Wed Jan 31 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	1	31	2024


CREATE TABLE year_to_date_finished (
  "unnamed_0" BIGINT,
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "member_casual" VARCHAR,
  "ride_length" DOUBLE,
  "day_of_week" VARCHAR,
  "date" TIMESTAMP,
  "month" BIGINT,
  "day" BIGINT,
  "year" BIGINT
);