Dataset: Toronto Bikeshare 2023

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.52 MB
180135 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.32 MB
172776 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.16 MB
224545 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.3 MB
380346 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.46 MB
589217 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.47 MB
663691 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.43 MB
735924 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

11.72 MB
760141 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

11.62 MB
754303 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

9.56 MB
601075 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.42 MB
393873 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.45 MB
257115 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
);