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–01

@kaggle.jolasa_bay_area_bike_sharing_trips.n_2019_01

1.7 MB
192082 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
January	80825	229	Foothill Blvd at 42nd Ave	196	Grand Ave at Perkins St	4861	Subscriber	1989	Male
January	65900	4	Cyril Magnin St at Ellis St	134	Valencia St at 24th St	5506	Subscriber	1989	Male
January	62633	245	Downtown Berkeley BART	157	65th St at Hollis St	2717	Customer	1965	Female
January	44680	85	Church St at Duboce Ave	53	Grove St at Divisadero	4557	Customer	1974	Male
January	60709	16	Steuart St at Market St	28	The Embarcadero at Bryant St	2100	Customer		nan
January	6733	245	Downtown Berkeley BART	266	Parker St at Fulton St	3532	Subscriber	1994	Male
January	1188	34	Father Alfred E Boeddeker Park	146	30th St at San Jose Ave	5114	Subscriber	1984	Male
January	1254	318	San Carlos St at Market St	314	Santa Clara St at Almaden Blvd	3967	Subscriber	1991	Male
January	3153	29	O'Farrell St at Divisadero St	70	Central Ave at Fell St	4813	Subscriber	1979	Male
January	323	223	16th St Mission BART Station 2	129	Harrison St at 20th St	1976	Subscriber	1991	Male


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