Bay Area Bike Sharing Trips

Anonymized bike trip data from Jan 2019 to May 2019

@kaggle.jolasa_bay_area_bike_sharing_trips

Table List

5 tables(9.37 MB)

N 2019–02

@kaggle.jolasa_bay_area_bike_sharing_trips.n_2019_02

1.65 MB
183412 rows
10 columns

month Month	trip_duration_sec Trip Duration Sec	start_station_id Start Station Id	start_station_name Start Station Name	end_station_id End Station Id	end_station_name End Station Name	bike_id Bike Id	user_type User Type	member_birth_year Member Birth Year	member_gender Member Gender
Februrary	52185	21	Montgomery St BART Station (Market St at 2nd St)	13	Commercial St at Montgomery St	4902	Customer	1984	Male
Februrary	42521	23	The Embarcadero at Steuart St	81	Berry St at 4th St	2535	Customer		nan
Februrary	61854	86	Market St at Dolores St	3	Powell St BART Station (Market St at 4th St)	5905	Customer	1972	Male
Februrary	36490	375	Grove St at Masonic Ave	70	Central Ave at Fell St	6638	Subscriber	1989	Other
Februrary	1585	7	Frank H Ogawa Plaza	222	10th Ave at E 15th St	4898	Subscriber	1974	Male
Februrary	1793	93	4th St at Mission Bay Blvd S	323	Broadway at Kearny	5200	Subscriber	1959	Male
Februrary	1147	300	Palm St at Willow St	312	San Jose Diridon Station	3803	Subscriber	1983	Female
Februrary	1615	10	Washington St at Kearny St	127	Valencia St at 21st St	6329	Subscriber	1989	Male
Februrary	1570	10	Washington St at Kearny St	127	Valencia St at 21st St	6548	Subscriber	1988	Other
Februrary	1049	19	Post St at Kearny St	121	Mission Playground	6488	Subscriber	1992	Male


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