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

@kaggle.roberttarus_toronto_bikeshare_2023.bike_share_ridership_2023_03

4.16 MB
224545 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
20554549	467	7462	Wed Mar 01 2023 00:01:00 GMT+0000 (Coordinated Universal Time)	Richmond St E / Yonge St	7246	Wed Mar 01 2023 00:09:00 GMT+0000 (Coordinated Universal Time)	Yonge St / Bloor St	5163	Casual Member
20554551	1692	7020	Wed Mar 01 2023 00:01:00 GMT+0000 (Coordinated Universal Time)	Phoebe St / Spadina Ave	7020	Wed Mar 01 2023 00:29:00 GMT+0000 (Coordinated Universal Time)	Phoebe St / Spadina Ave	4887	Casual Member
20554554	516	7281	Wed Mar 01 2023 00:03:00 GMT+0000 (Coordinated Universal Time)	Charles St W / Balmuto St - SMART	7004	Wed Mar 01 2023 00:12:00 GMT+0000 (Coordinated Universal Time)	University Ave / Elm St	371	Casual Member
20554555	428	7502	Wed Mar 01 2023 00:03:00 GMT+0000 (Coordinated Universal Time)	University Ave / College St (East)	7599	Wed Mar 01 2023 00:11:00 GMT+0000 (Coordinated Universal Time)	Richmond St W / York St	3749	Casual Member
20554556	423	7502	Wed Mar 01 2023 00:03:00 GMT+0000 (Coordinated Universal Time)	University Ave / College St (East)	7599	Wed Mar 01 2023 00:10:00 GMT+0000 (Coordinated Universal Time)	Richmond St W / York St	5631	Annual Member
20554558	1139	7646	Wed Mar 01 2023 00:04:00 GMT+0000 (Coordinated Universal Time)	University Ave / Richmond St W	7721	Wed Mar 01 2023 00:23:00 GMT+0000 (Coordinated Universal Time)	nan	4643	Casual Member
20554559	415	7058	Wed Mar 01 2023 00:04:00 GMT+0000 (Coordinated Universal Time)	Huron/ Harbord St	7246	Wed Mar 01 2023 00:11:00 GMT+0000 (Coordinated Universal Time)	Yonge St / Bloor St	5632	Casual Member
20554560	544	7063	Wed Mar 01 2023 00:04:00 GMT+0000 (Coordinated Universal Time)	Queen's Park / Bloor St W	7389	Wed Mar 01 2023 00:13:00 GMT+0000 (Coordinated Universal Time)	College Park- Gerrard Entrance	343	Casual Member
20554563	1135	7412	Wed Mar 01 2023 00:05:00 GMT+0000 (Coordinated Universal Time)	King St W / Crawford St	7724	Wed Mar 01 2023 00:24:00 GMT+0000 (Coordinated Universal Time)	nan	7114	Casual Member
20554564	216	7031	Wed Mar 01 2023 00:06:00 GMT+0000 (Coordinated Universal Time)	Jarvis St / Isabella St	7044	Wed Mar 01 2023 00:10:00 GMT+0000 (Coordinated Universal Time)	Church St / Alexander St	2695	Casual Member


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