Baselight
Sign In

Bay Area Bike Sharing Trips

Anonymized bike trip data from Jan 2019 to May 2019

@kaggle.jolasa_bay_area_bike_sharing_trips

N 2019–03
@kaggle.jolasa_bay_area_bike_sharing_trips.n_2019_03

  • 2.29 MB
  • 256299 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

March53588377Fell St at Stanyan St377Fell St at Stanyan St6803Subscriber1980Other
March74305385Woolsey St at Sacramento St2334th Ave at E 12th St (Temporary Location)6415Subscriber1990Male
March797893Powell St BART Station (Market St at 4th St)345Hubbell St at 16th St2317Customernan
March5931592Mission Bay Kids Park49S Park St at 3rd St6631Customer1996Female
March47886339Jackson St at 11th St18Telegraph Ave at Alcatraz Ave5241Subscriber1974Female
March67439195Bay Pl at Vernon St212Mosswood Park5118Customer1991Male
March7799696Dolores St at 15th St134Valencia St at 24th St2630Customer1984Female
March515223Powell St BART Station (Market St at 4th St)3Powell St BART Station (Market St at 4th St)817Customer1973Female
March4714038120th St at Dolores St22316th St Mission BART Station 24852Customer1997Female
March5846234Father Alfred E Boeddeker Park34Father Alfred E Boeddeker Park5826Subscriber1971Male

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