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

@kaggle.roberttarus_toronto_bikeshare_2023.bike_share_ridership_2023_02

3.32 MB
172776 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
20354837	175	7457	Wed Feb 01 2023 00:01:00 GMT+0000 (Coordinated Universal Time)	Queen's Park Cres W / Hoskin Ave	7190	Wed Feb 01 2023 00:03:00 GMT+0000 (Coordinated Universal Time)	St. George St / Hoskin Ave	538	Casual Member
20354838	535	7281	Wed Feb 01 2023 00:04:00 GMT+0000 (Coordinated Universal Time)	Charles St W / Balmuto St - SMART	7004	Wed Feb 01 2023 00:13:00 GMT+0000 (Coordinated Universal Time)	University Ave / Elm St	5663	Casual Member
20354839	230	7469	Wed Feb 01 2023 00:05:00 GMT+0000 (Coordinated Universal Time)	Wellington St W / York St	7646	Wed Feb 01 2023 00:08:00 GMT+0000 (Coordinated Universal Time)	University Ave / Richmond St W	5608	Casual Member
20354840	444	7207	Wed Feb 01 2023 00:05:00 GMT+0000 (Coordinated Universal Time)	Dundas St W / Crawford St	7122	Wed Feb 01 2023 00:12:00 GMT+0000 (Coordinated Universal Time)	Niagara St / Tecumseth St	1136	Annual Member
20354842	754	7191	Wed Feb 01 2023 00:06:00 GMT+0000 (Coordinated Universal Time)	Central Tech (Harbord St)	7073	Wed Feb 01 2023 00:19:00 GMT+0000 (Coordinated Universal Time)	Spadina Ave / Fort York Blvd	2812	Casual Member
20354843	410	7066	Wed Feb 01 2023 00:07:00 GMT+0000 (Coordinated Universal Time)	Willcocks St / St. George St	7020	Wed Feb 01 2023 00:14:00 GMT+0000 (Coordinated Universal Time)	Phoebe St / Spadina Ave	2149	Casual Member
20354845	567	7102	Wed Feb 01 2023 00:09:00 GMT+0000 (Coordinated Universal Time)	Nelson St / Duncan St	7037	Wed Feb 01 2023 00:18:00 GMT+0000 (Coordinated Universal Time)	Bathurst St / Dundas St W	6279	Annual Member
20354846	173	7333	Wed Feb 01 2023 00:10:00 GMT+0000 (Coordinated Universal Time)	King St E / Victoria St	7118	Wed Feb 01 2023 00:12:00 GMT+0000 (Coordinated Universal Time)	King St W / Bay St (East Side)	719	Casual Member
20354847	538	7059	Wed Feb 01 2023 00:10:00 GMT+0000 (Coordinated Universal Time)	Front St W / Blue Jays Way	7713	Wed Feb 01 2023 00:19:00 GMT+0000 (Coordinated Universal Time)	nan	3307	Casual Member
20354848	359	7061	Wed Feb 01 2023 00:10:00 GMT+0000 (Coordinated Universal Time)	Dalton Rd / Bloor St W	7251	Wed Feb 01 2023 00:16:00 GMT+0000 (Coordinated Universal Time)	The Royal Ontario Museum (Bloor St Entrance)	1887	Casual Member


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