Baselight
Sign In

Bike Sharing Datasets

The dataset contains 14 CSV files, 12 montly datasets and 2 joint.

@kaggle.damianogalassi_bike_sharing_datasets

Loading...
Loading...

About this Dataset

Bike Sharing Datasets

The dataset used in this analysis comprehends internal data (directly collected from the firm itself) from 01/01/2022 to 31/12/2022. The starting datasets are organized in 12 differents datasets (one for each month of the year). Each dataset contains several columns: * ride_id: primary key of the dataset which contains a specific number associated with a given ride * rideable_type: specifies the type of bike which has been used in a given ride * start_station_id: contains the id of the station where a given trip has started * end_station_id: contains the id of the station where a given trip has ended * start_station_name: contains the name of the station where a given trip has started * end_station_name: contains the name of the station where a given trip has ended * start_lat, end_lat, start_lng, end_lng: contain the geolocation of the starting and ending station * member_casual: contains information about the type of rider. It can be either member (has an annual membership) or casual (uses only single or daily passes)

Regarding the data Reliability, Originality, Comprehensiveness, Currency and Context (ROCCC) it is assumed that all these qualities are satisfied. As a fact, we are dealing with primary data directly collected from the firm itself(reliable and original). The data is comprehensive and current since it covers an entire year with more than 5 million of data rows.

Tables

Bike Trips Process 2022

@kaggle.damianogalassi_bike_sharing_datasets.bike_trips_process_2022
  • 19.24 MB
  • 434,431 rows
  • 11 columns
Loading... 
CREATE TABLE bike_trips_process_2022 (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "member_casual" VARCHAR,
  "ride_duration" BIGINT,
  "day_of_week" BIGINT
);

N 202201 Divvy Tripdata

@kaggle.damianogalassi_bike_sharing_datasets.n_202201_divvy_tripdata
  • 5.54 MB
  • 103,770 rows
  • 13 columns
Loading... 
CREATE TABLE n_202201_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202202 Divvy Tripdata

@kaggle.damianogalassi_bike_sharing_datasets.n_202202_divvy_tripdata
  • 6.11 MB
  • 115,609 rows
  • 13 columns
Loading... 
CREATE TABLE n_202202_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202203 Divvy Tripdata

@kaggle.damianogalassi_bike_sharing_datasets.n_202203_divvy_tripdata
  • 14.24 MB
  • 284,042 rows
  • 13 columns
Loading... 
CREATE TABLE n_202203_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202204 Divvy Tripdata

@kaggle.damianogalassi_bike_sharing_datasets.n_202204_divvy_tripdata
  • 18.67 MB
  • 371,249 rows
  • 13 columns
Loading... 
CREATE TABLE n_202204_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202205 Divvy Tripdata

@kaggle.damianogalassi_bike_sharing_datasets.n_202205_divvy_tripdata
  • 31.33 MB
  • 634,858 rows
  • 13 columns
Loading... 
CREATE TABLE n_202205_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202206 Divvy Tripdata

@kaggle.damianogalassi_bike_sharing_datasets.n_202206_divvy_tripdata
  • 37.52 MB
  • 769,204 rows
  • 13 columns
Loading... 
CREATE TABLE n_202206_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202207 Divvy Tripdata

@kaggle.damianogalassi_bike_sharing_datasets.n_202207_divvy_tripdata
  • 41.31 MB
  • 823,488 rows
  • 13 columns
Loading... 
CREATE TABLE n_202207_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202208 Divvy Tripdata

@kaggle.damianogalassi_bike_sharing_datasets.n_202208_divvy_tripdata
  • 39.81 MB
  • 785,932 rows
  • 13 columns
Loading... 
CREATE TABLE n_202208_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202209 Divvy Publictripdata

@kaggle.damianogalassi_bike_sharing_datasets.n_202209_divvy_publictripdata
  • 35.42 MB
  • 701,339 rows
  • 13 columns
Loading... 
CREATE TABLE n_202209_divvy_publictripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202210 Divvy Tripdata

@kaggle.damianogalassi_bike_sharing_datasets.n_202210_divvy_tripdata
  • 28.36 MB
  • 558,685 rows
  • 13 columns
Loading... 
CREATE TABLE n_202210_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202211 Divvy Tripdata

@kaggle.damianogalassi_bike_sharing_datasets.n_202211_divvy_tripdata
  • 17.49 MB
  • 337,735 rows
  • 13 columns
Loading... 
CREATE TABLE n_202211_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202212 Divvy Tripdata

@kaggle.damianogalassi_bike_sharing_datasets.n_202212_divvy_tripdata
  • 9.55 MB
  • 181,806 rows
  • 13 columns
Loading... 
CREATE TABLE n_202212_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

Share link

Anyone who has the link will be able to view this.