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

@kaggle.jolasa_bay_area_bike_sharing_trips.n_2019_04

2.13 MB
239111 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
April	50305	368	Myrtle St at Polk St	324	Union Square (Powell St at Post St)	2749	Subscriber	1989	Female
April	53725	246	Berkeley Civic Center	241	Ashby BART Station	2608	Customer		nan
April	78072	64	5th St at Brannan St	64	5th St at Brannan St	258	Subscriber	1993	Male
April	78969	67	San Francisco Caltrain Station 2 (Townsend St at 4th St)	89	Division St at Potrero Ave	1974	Subscriber	1972	Male
April	1128	124	19th St at Florida St	5	Powell St BART Station (Market St at 5th St)	877	Subscriber	1973	Male
April	1388	243	Bancroft Way at College Ave	247	Fulton St at Bancroft Way	3234	Customer	1997	Male
April	920	202	Washington St at 8th St	220	San Pablo Ave at MLK Jr Way	3262	Subscriber	1976	Male
April	725	44	Civic Center/UN Plaza BART Station (Market St at McAllister St)	121	Mission Playground	2706	Customer	1973	Male
April	488	21	Montgomery St BART Station (Market St at 2nd St)	64	5th St at Brannan St	860	Subscriber	1986	Male
April	792	28	The Embarcadero at Bryant St	126	Esprit Park	896	Subscriber	1995	Male


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