cityofchicago/divvy-trips-fg6s-gzvg

  • bike sharing
  • divvy
  • link to article present
  • transportation

Divvy Trips

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://www.divvybikes.com/data.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
TO STATION NAMEto_station_nameto_station_nameText
STOP TIMEstop_timestop_timeCalendar date
FROM STATION NAMEfrom_station_namefrom_station_nameText
USER TYPEuser_typeuser_typeText
TO LATITUDEto_latitudeto_latitudeNumber
BIRTH YEARbirth_yearbirth_yearNumber
TO LONGITUDEto_longitudeto_longitudeNumber
START TIMEstart_timestart_timeCalendar date
FROM LATITUDEfrom_latitudefrom_latitudeNumber
FROM LONGITUDEfrom_longitudefrom_longitudeNumber
FROM STATION IDfrom_station_idfrom_station_idText
TRIP IDtrip_idtrip_idNumber
TO LOCATIONto_locationto_locationPoint
GENDERgendergenderText
TRIP DURATIONtrip_durationtrip_durationNumberDuration of the trip in seconds.
FROM LOCATIONfrom_locationfrom_locationPoint
TO STATION IDto_station_idto_station_idText
BIKE IDbike_idbike_idText
Boundaries - ZIP Codes:@computed_region_rpca_8um6:@computed_region_rpca_8um6Number
Wards:@computed_region_43wa_7qmu:@computed_region_43wa_7qmuNumber
Community Areas:@computed_region_vrxf_vc4k:@computed_region_vrxf_vc4kNumber
Zip Codes:@computed_region_6mkv_f3dw:@computed_region_6mkv_f3dwNumber

Upstream Metadata