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

@kaggle.jolasa_bay_area_bike_sharing_trips.n_2019_05

1.61 MB
182163 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
May	48877	321	5th St at Folsom	60	8th St at Ringold St	1416	Customer	1990	Female
May	47050	246	Berkeley Civic Center	266	Parker St at Fulton St	1797	Subscriber	1994	Male
May	5912	149	Emeryville Town Hall	149	Emeryville Town Hall	3612	Customer	1988	Male
May	2629	186	Lakeside Dr at 14th St	186	Lakeside Dr at 14th St	2333	Customer	1998	Male
May	4235	34	Father Alfred E Boeddeker Park	368	Myrtle St at Polk St	181	Subscriber	1967	Male
May	2954	50	2nd St at Townsend St	6	The Embarcadero at Sansome St	3264	Customer		nan
May	3071	50	2nd St at Townsend St	6	The Embarcadero at Sansome St	1566	Customer		nan
May	924	324	Union Square (Powell St at Post St)	50	2nd St at Townsend St	1649	Subscriber	1999	Male
May	696	22	Howard St at Beale St	81	Berry St at 4th St	2832	Subscriber	1989	Male
May	510	211	Broadway at 40th St	181	Grand Ave at Webster St	81	Subscriber	1966	Male


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