Dataset: Bike Sharing Datasets

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

N 202201 Divvy Tripdata

@kaggle.damianogalassi_bike_sharing_datasets.n_202201_divvy_tripdata

5.28 MB
103770 rows
13 columns


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

5.83 MB
115609 rows
13 columns


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

13.58 MB
284042 rows
13 columns


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

17.81 MB
371249 rows
13 columns


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

29.88 MB
634858 rows
13 columns


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

35.78 MB
769204 rows
13 columns


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

39.4 MB
823488 rows
13 columns


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

37.96 MB
785932 rows
13 columns


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

33.78 MB
701339 rows
13 columns


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

27.04 MB
558685 rows
13 columns


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

16.68 MB
337735 rows
13 columns


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.11 MB
181806 rows
13 columns


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

Bike Trips Process 2022

@kaggle.damianogalassi_bike_sharing_datasets.bike_trips_process_2022

18.35 MB
434431 rows
11 columns


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