Dataset: Bay Area Bike Sharing Trips

About this Dataset

Bay Area Bike Sharing Trips

# Content

This dataset contains anonymized trips data of Lyft bike sharing system(Bay Wheels), in the Bay Area from January 2019 to May 2019.

# Acknowledgements
This data was created with information obtained from Lift Bike Sharing Site
https://www.lyft.com/bikes/bay-wheels

Tables

N 2019–01

@kaggle.jolasa_bay_area_bike_sharing_trips.n_2019_01

1.7 MB
192082 rows
10 columns


CREATE TABLE n_2019_01 (
  "month" VARCHAR,
  "trip_duration_sec" BIGINT,
  "start_station_id" DOUBLE,
  "start_station_name" VARCHAR,
  "end_station_id" DOUBLE,
  "end_station_name" VARCHAR,
  "bike_id" BIGINT,
  "user_type" VARCHAR,
  "member_birth_year" DOUBLE,
  "member_gender" VARCHAR
);

N 2019–02

@kaggle.jolasa_bay_area_bike_sharing_trips.n_2019_02

1.65 MB
183412 rows
10 columns


CREATE TABLE n_2019_02 (
  "month" VARCHAR,
  "trip_duration_sec" BIGINT,
  "start_station_id" DOUBLE,
  "start_station_name" VARCHAR,
  "end_station_id" DOUBLE,
  "end_station_name" VARCHAR,
  "bike_id" BIGINT,
  "user_type" VARCHAR,
  "member_birth_year" DOUBLE,
  "member_gender" VARCHAR
);

N 2019–03

@kaggle.jolasa_bay_area_bike_sharing_trips.n_2019_03

2.29 MB
256299 rows
10 columns


CREATE TABLE n_2019_03 (
  "month" VARCHAR,
  "trip_duration_sec" BIGINT,
  "start_station_id" DOUBLE,
  "start_station_name" VARCHAR,
  "end_station_id" DOUBLE,
  "end_station_name" VARCHAR,
  "bike_id" BIGINT,
  "user_type" VARCHAR,
  "member_birth_year" DOUBLE,
  "member_gender" VARCHAR
);

N 2019–04

@kaggle.jolasa_bay_area_bike_sharing_trips.n_2019_04

2.13 MB
239111 rows
10 columns


CREATE TABLE n_2019_04 (
  "month" VARCHAR,
  "trip_duration_sec" BIGINT,
  "start_station_id" DOUBLE,
  "start_station_name" VARCHAR,
  "end_station_id" DOUBLE,
  "end_station_name" VARCHAR,
  "bike_id" BIGINT,
  "user_type" VARCHAR,
  "member_birth_year" DOUBLE,
  "member_gender" VARCHAR
);

N 2019–05

@kaggle.jolasa_bay_area_bike_sharing_trips.n_2019_05

1.61 MB
182163 rows
10 columns


CREATE TABLE n_2019_05 (
  "month" VARCHAR,
  "trip_duration_sec" BIGINT,
  "start_station_id" DOUBLE,
  "start_station_name" VARCHAR,
  "end_station_id" DOUBLE,
  "end_station_name" VARCHAR,
  "bike_id" BIGINT,
  "user_type" VARCHAR,
  "member_birth_year" DOUBLE,
  "member_gender" VARCHAR
);