About this Dataset

Divvy Trips

This lists individual Divvy bike sharing trips, including the origin, destination, and timestamps for each trip. Trips are included when there is an starting and end date. Trips using a subscriber pass will include some basic demographic data (gender and age) that is associated with the account. For more information see https://divvybikes.com/system-data.
Organization: City of Chicago
Last updated: 2020-11-10T16:54:53.160224
Tags: bike-sharing, divvy, link-to-article-present, transportation

Tables

Table 1

@usgov.city_of_chicago_divvy_trips.table_1

582.98 MB
21,242,740 rows
18 columns

CREATE TABLE table_1 (
  "trip_id" BIGINT,
  "start_time" VARCHAR,
  "stop_time" VARCHAR,
  "bike_id" BIGINT,
  "trip_duration" BIGINT,
  "from_station_id" BIGINT,
  "from_station_name" VARCHAR,
  "to_station_id" BIGINT,
  "to_station_name" VARCHAR,
  "user_type" VARCHAR,
  "gender" VARCHAR,
  "birth_year" DOUBLE,
  "from_latitude" DOUBLE,
  "from_longitude" DOUBLE,
  "from_location" VARCHAR,
  "to_latitude" DOUBLE,
  "to_longitude" DOUBLE,
  "to_location" VARCHAR
);