cityofchicago/transportation-network-providers-trips-m6dm-c72p

  • link to article present
  • rideshare
  • tnp
  • transportation
  • transportation network provider
  • + 1

Transportation Network Providers - Trips

Transportation Network Providers - Trips

All trips, starting November 2018, reported by Transportation Network Providers (sometimes called rideshare companies) to the City of Chicago as part of routine reporting required by ordinance.

Census Tracts are suppressed in some cases, and times are rounded to the nearest 15 minutes. Fares are rounded to the nearest $2.50 and tips are rounded to the nearest $1.00.

For a discussion of the approach to privacy in this dataset, please see http://dev.cityofchicago.org/open%20data/data%20portal/2019/04/12/tnp-taxi-privacy.html.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Pickup Centroid Locationpickup_centroid_locationpickup_centroid_locationPointThe location of the center of the pickup census tract or the community area if the census tract has been hidden for privacy. This column often will be blank for locations outside Chicago.
Trip IDtrip_idtrip_idTextA unique identifier for the trip.
Trip Start Timestamptrip_start_timestamptrip_start_timestampCalendar dateWhen the trip started, rounded to the nearest 15 minutes.
Trip End Timestamptrip_end_timestamptrip_end_timestampCalendar dateWhen the trip ended, rounded to the nearest 15 minutes.
Pickup Census Tractpickup_census_tractpickup_census_tractTextThe Census Tract where the trip began.This column often will be blank for locations outside Chicago.
Dropoff Community Areadropoff_community_areadropoff_community_areaNumberThe Community Area where the trip ended. This column will be blank for locations outside Chicago.
FarefarefareNumberThe fare for the trip, rounded to the nearest $2.50.
Shared Trip Authorizedshared_trip_authorizedshared_trip_authorizedCheckboxWhether the customer agreed to a shared trip with another customer, regardless of whether the customer was actually matched for a shared trip.
Trip Milestrip_milestrip_milesNumberDistance of the trip in miles.
Pickup Centroid Latitudepickup_centroid_latitudepickup_centroid_latitudeNumberThe latitude of the center of the pickup census tract or the community area if the census tract has been hidden for privacy. This column often will be blank for locations outside Chicago.
Dropoff Centroid Longitudedropoff_centroid_longitudedropoff_centroid_longitudeNumberThe longitude of the center of the dropoff census tract or the community area if the census tract has been hidden for privacy. This column often will be blank for locations outside Chicago.
Dropoff Census Tractdropoff_census_tractdropoff_census_tractTextThe Census Tract where the trip ended. This column often will be blank for locations outside Chicago.
Additional Chargesadditional_chargesadditional_chargesNumberThe taxes, fees, and any other charges for the trip.
Pickup Community Areapickup_community_areapickup_community_areaNumberThe Community Area where the trip began. This column will be blank for locations outside Chicago.
Trip Secondstrip_secondstrip_secondsNumberTime of the trip in seconds.
Dropoff Centroid Latitudedropoff_centroid_latitudedropoff_centroid_latitudeNumberThe latitude of the center of the dropoff census tract or the community area if the census tract has been hidden for privacy. This column often will be blank for locations outside Chicago.
Trip Totaltrip_totaltrip_totalNumberTotal cost of the trip. This is calculated as the total of the previous columns, including rounding.
Pickup Centroid Longitudepickup_centroid_longitudepickup_centroid_longitudeNumberThe longitude of the center of the pickup census tract or the community area if the census tract has been hidden for privacy. This column often will be blank for locations outside Chicago.
Trips Pooledtrips_pooledtrips_pooledNumberIf customers were matched for a shared trip, how many trips, including this one, were pooled. All customer trips from the time the vehicle was empty until it was empty again contribute to this count, even if some customers were never present in the vehicle at the same time. Each trip making up the overall shared trip will have a separate record in this dataset, with the same value in this column.
TiptiptipNumberThe tip for the trip, rounded to the nearest $1.00. Cash tips will not be recorded.
Dropoff Centroid Locationdropoff_centroid_locationdropoff_centroid_locationPointThe location of the center of the dropoff census tract or the community area if the census tract has been hidden for privacy. This column often will be blank for locations outside Chicago.

Upstream Metadata