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

@kaggle.roberttarus_toronto_bikeshare_2023.bike_share_ridership_2023_04

6.3 MB
380346 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
20809580	726	7041	Sat Apr 01 2023 00:01:00 GMT+0000 (Coordinated Universal Time)	Edward St / Yonge St	7054	Sat Apr 01 2023 00:13:00 GMT+0000 (Coordinated Universal Time)	Navy Wharf Ct. / Bremner Blvd.	6552	Annual Member
20809581	857	7059	Sat Apr 01 2023 00:02:00 GMT+0000 (Coordinated Universal Time)	Front St W / Blue Jays Way	7768	Sat Apr 01 2023 00:16:00 GMT+0000 (Coordinated Universal Time)	nan	2855	Casual Member
20809582	839	7059	Sat Apr 01 2023 00:02:00 GMT+0000 (Coordinated Universal Time)	Front St W / Blue Jays Way	7768	Sat Apr 01 2023 00:16:00 GMT+0000 (Coordinated Universal Time)	nan	5967	Casual Member
20809583	382	7298	Sat Apr 01 2023 00:02:00 GMT+0000 (Coordinated Universal Time)	Bathurst St / Adelaide St W	7148	Sat Apr 01 2023 00:08:00 GMT+0000 (Coordinated Universal Time)	King St W / Joe Shuster Way	5321	Annual Member
20809584	823	7129	Sat Apr 01 2023 00:03:00 GMT+0000 (Coordinated Universal Time)	Davenport Rd / Avenue Rd	7271	Sat Apr 01 2023 00:16:00 GMT+0000 (Coordinated Universal Time)	Yonge St / Alexander St - SMART	4741	Casual Member
20809585	822	7129	Sat Apr 01 2023 00:03:00 GMT+0000 (Coordinated Universal Time)	Davenport Rd / Avenue Rd	7271	Sat Apr 01 2023 00:16:00 GMT+0000 (Coordinated Universal Time)	Yonge St / Alexander St - SMART	6471	Casual Member
20809586	181	7712	Sat Apr 01 2023 00:03:00 GMT+0000 (Coordinated Universal Time)	nan	7473	Sat Apr 01 2023 00:06:00 GMT+0000 (Coordinated Universal Time)	Adelaide St W / Strachan Ave	4388	Casual Member
20809589	146	7712	Sat Apr 01 2023 00:04:00 GMT+0000 (Coordinated Universal Time)	nan	7473	Sat Apr 01 2023 00:06:00 GMT+0000 (Coordinated Universal Time)	Adelaide St W / Strachan Ave	5466	Casual Member
20809590	2069	7682	Sat Apr 01 2023 00:04:00 GMT+0000 (Coordinated Universal Time)	nan	7682	Sat Apr 01 2023 00:38:00 GMT+0000 (Coordinated Universal Time)	nan	7247	Casual Member
20809591	962	7542	Sat Apr 01 2023 00:04:00 GMT+0000 (Coordinated Universal Time)	Queen St W / John St	7210	Sat Apr 01 2023 00:20:00 GMT+0000 (Coordinated Universal Time)	Mary McCormick Rec Centre (Sheridan Ave)	4757	Casual Member


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