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–05

@kaggle.roberttarus_toronto_bikeshare_2023.bike_share_ridership_2023_05

9.46 MB
589217 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
21248733	344	7693	Mon May 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	7065	Mon May 01 2023 00:06:00 GMT+0000 (Coordinated Universal Time)	Dundas St E / Parliament St	713	Annual Member
21248734	521	7418	Mon May 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	College Park - Yonge St Entrance	7248	Mon May 01 2023 00:09:00 GMT+0000 (Coordinated Universal Time)	Baldwin Ave / Spadina Ave - SMART	1120	Casual Member
21248735	1143	7027	Mon May 01 2023 00:01:00 GMT+0000 (Coordinated Universal Time)	Beverley St / Dundas St W	7279	Mon May 01 2023 00:20:00 GMT+0000 (Coordinated Universal Time)	Rosehill Ave / Avoca Ave - SMART	2231	Casual Member
21248736	1125	7027	Mon May 01 2023 00:01:00 GMT+0000 (Coordinated Universal Time)	Beverley St / Dundas St W	7279	Mon May 01 2023 00:20:00 GMT+0000 (Coordinated Universal Time)	Rosehill Ave / Avoca Ave - SMART	4832	Casual Member
21248738	688	7256	Mon May 01 2023 00:01:00 GMT+0000 (Coordinated Universal Time)	Vanauley St / Queen St W - SMART	7026	Mon May 01 2023 00:13:00 GMT+0000 (Coordinated Universal Time)	Bay St / St. Joseph St	2262	Casual Member
21248744	396	7223	Mon May 01 2023 00:04:00 GMT+0000 (Coordinated Universal Time)	Parkside Dr / Bloor St W - SMART	7234	Mon May 01 2023 00:10:00 GMT+0000 (Coordinated Universal Time)	Roncesvalles Ave / Marmaduke St	4185	Annual Member
21248748	843	7061	Mon May 01 2023 00:04:00 GMT+0000 (Coordinated Universal Time)	Dalton Rd / Bloor St W	7055	Mon May 01 2023 00:18:00 GMT+0000 (Coordinated Universal Time)	Jarvis St / Carlton St	371	Annual Member
21248750	576	7169	Mon May 01 2023 00:05:00 GMT+0000 (Coordinated Universal Time)	Front St W / Bay St (North Side)	7418	Mon May 01 2023 00:15:00 GMT+0000 (Coordinated Universal Time)	College Park - Yonge St Entrance	4360	Casual Member
21248753	4382	7118	Mon May 01 2023 00:06:00 GMT+0000 (Coordinated Universal Time)	King St W / Bay St (East Side)	7077	Mon May 01 2023 01:19:00 GMT+0000 (Coordinated Universal Time)	College Park South	6846	Casual Member
21248754	485	7005	Mon May 01 2023 00:06:00 GMT+0000 (Coordinated Universal Time)	King St W / York St	7366	Mon May 01 2023 00:14:00 GMT+0000 (Coordinated Universal Time)	Fort York Blvd / Bathurst St SMART	1415	Casual Member


CREATE TABLE bike_share_ridership_2023_05 (
  "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
);