Name: Toronto Bikeshare 2023
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Toronto Bikeshare 2023

The following dataset contain bike trips taken during the year 2023 across more than 600 stations across the City of Toronto. The description of each feature is listed below:

Unique ID code for individual trip taken.
Trip start time.
Trip end time.
Duration of the trip in seconds.
Unique ID code for the start station.
Name of start station.
Unique ID code for the end station.
Name of end station.
Type of user, either Member or Casual.
Unique ID for the individual bike used.

Reference Sources
City of Toronto: Open Data
City of Toronto has an open data catalogue where I obtained Toronto BikeShare trip datasets.

Tables

Bike Share Ridership 2023–01

@kaggle.roberttarus_toronto_bikeshare_2023.bike_share_ridership_2023_01

3.69 MB
180,135 rows
10 columns

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
);

Bike Share Ridership 2023–02

@kaggle.roberttarus_toronto_bikeshare_2023.bike_share_ridership_2023_02

3.48 MB
172,776 rows
10 columns

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
);

Bike Share Ridership 2023–03

@kaggle.roberttarus_toronto_bikeshare_2023.bike_share_ridership_2023_03

4.36 MB
224,545 rows
10 columns

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
);

Bike Share Ridership 2023–04

@kaggle.roberttarus_toronto_bikeshare_2023.bike_share_ridership_2023_04

6.61 MB
380,346 rows
10 columns

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
);

Bike Share Ridership 2023–05

@kaggle.roberttarus_toronto_bikeshare_2023.bike_share_ridership_2023_05

9.92 MB
589,217 rows
10 columns

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
);

Bike Share Ridership 2023–06

@kaggle.roberttarus_toronto_bikeshare_2023.bike_share_ridership_2023_06

10.98 MB
663,691 rows
10 columns

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

Bike Share Ridership 2023–07

@kaggle.roberttarus_toronto_bikeshare_2023.bike_share_ridership_2023_07

11.98 MB
735,924 rows
10 columns

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

Bike Share Ridership 2023–08

@kaggle.roberttarus_toronto_bikeshare_2023.bike_share_ridership_2023_08

12.29 MB
760,141 rows
10 columns

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

Bike Share Ridership 2023–09

@kaggle.roberttarus_toronto_bikeshare_2023.bike_share_ridership_2023_09

12.18 MB
754,303 rows
10 columns

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

Bike Share Ridership 2023–10

@kaggle.roberttarus_toronto_bikeshare_2023.bike_share_ridership_2023_10

10.03 MB
601,075 rows
10 columns

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

Bike Share Ridership 2023–11

@kaggle.roberttarus_toronto_bikeshare_2023.bike_share_ridership_2023_11

6.73 MB
393,873 rows
10 columns

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

Bike Share Ridership 2023–12

@kaggle.roberttarus_toronto_bikeshare_2023.bike_share_ridership_2023_12

4.67 MB
257,115 rows
10 columns

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