Toronto Bikeshare 2023

Bike trips dataset for Toronto bike share network

@kaggle.roberttarus_toronto_bikeshare_2023

Table List

12 tables(92.44 MB)

Bike Share Ridership 2023–01

Bike Share Ridership 2023–02

Bike Share Ridership 2023–03

Bike Share Ridership 2023–04

Bike Share Ridership 2023–05

Bike Share Ridership 2023–06

Bike Share Ridership 2023–07

Bike Share Ridership 2023–08

Bike Share Ridership 2023–09

Bike Share Ridership 2023–10

Bike Share Ridership 2023–11

Bike Share Ridership 2023–12

Bike Share Ridership 2023–01

@kaggle.roberttarus_toronto_bikeshare_2023.bike_share_ridership_2023_01

3.52 MB
180135 rows
10 columns

trip_id Trip Id	trip_duration Trip Duration	start_station_id Start Station Id	start_time Start Time	start_station_name Start Station Name	end_station_id End Station Id	end_time End Time	end_station_name End Station Name	bike_id Bike Id	user_type User Type
20148784	840	7022	Sun Jan 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Simcoe St / Queen St W	7703	Sun Jan 01 2023 00:14:00 GMT+0000 (Coordinated Universal Time)	nan	1770	Casual Member
20148785	722	7399	Sun Jan 01 2023 00:01:00 GMT+0000 (Coordinated Universal Time)	Lower Jarvis / Queens Quay E	7533	Sun Jan 01 2023 00:13:00 GMT+0000 (Coordinated Universal Time)	Housey St / Dan Leckie Way	6400	Casual Member
20148786	1054	7269	Sun Jan 01 2023 00:02:00 GMT+0000 (Coordinated Universal Time)	Toronto Eaton Centre (Yonge St)	7076	Sun Jan 01 2023 00:20:00 GMT+0000 (Coordinated Universal Time)	York St / Queens Quay W	4068	Annual Member
20148790	1329	7721	Sun Jan 01 2023 00:04:00 GMT+0000 (Coordinated Universal Time)	nan	7685	Sun Jan 01 2023 00:26:00 GMT+0000 (Coordinated Universal Time)	nan	427	Casual Member
20148791	1291	7721	Sun Jan 01 2023 00:04:00 GMT+0000 (Coordinated Universal Time)	nan	7685	Sun Jan 01 2023 00:26:00 GMT+0000 (Coordinated Universal Time)	nan	1840	Casual Member
20148795	65	7076	Sun Jan 01 2023 00:05:00 GMT+0000 (Coordinated Universal Time)	York St / Queens Quay W	7076	Sun Jan 01 2023 00:06:00 GMT+0000 (Coordinated Universal Time)	York St / Queens Quay W	2489	Annual Member
20148796	786	7713	Sun Jan 01 2023 00:06:00 GMT+0000 (Coordinated Universal Time)	nan	7076	Sun Jan 01 2023 00:19:00 GMT+0000 (Coordinated Universal Time)	York St / Queens Quay W	3991	Casual Member
20148797	277	7078	Sun Jan 01 2023 00:06:00 GMT+0000 (Coordinated Universal Time)	College St / Major St	7061	Sun Jan 01 2023 00:11:00 GMT+0000 (Coordinated Universal Time)	Dalton Rd / Bloor St W	938	Annual Member
20148798	270	7078	Sun Jan 01 2023 00:06:00 GMT+0000 (Coordinated Universal Time)	College St / Major St	7061	Sun Jan 01 2023 00:11:00 GMT+0000 (Coordinated Universal Time)	Dalton Rd / Bloor St W	146	Annual Member
20148799	450	7382	Sun Jan 01 2023 00:07:00 GMT+0000 (Coordinated Universal Time)	Simcoe St / Adelaide St W	7033	Sun Jan 01 2023 00:14:00 GMT+0000 (Coordinated Universal Time)	Union Station	249	Casual Member


CREATE TABLE bike_share_ridership_2023_01 (
  "trip_id" BIGINT,
  "trip_duration" BIGINT,
  "start_station_id" BIGINT,
  "start_time" TIMESTAMP,
  "start_station_name" VARCHAR,
  "end_station_id" DOUBLE,
  "end_time" TIMESTAMP,
  "end_station_name" VARCHAR,
  "bike_id" BIGINT,
  "user_type" VARCHAR
);