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.
This dataset has the following 21 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Trip ID | trip_id | text | A unique identifier for the trip. | 00000347020fe971901cf046a60f96c0bc9d5bb7 000003627a8300f00d803831db6ebc9eb4f8484d 000004cf479cd29960a2bad5f918887f182cf181 000007c945a23a1a37cec78fba15499f35fed3c4 0000093625f90e660c8275040a7f57e335ae147b view top 100 |
Trip Start Timestamp | trip_start_timestamp | calendar_date | When the trip started, rounded to the nearest 15 minutes. | 00000347020fe971901cf046a60f96c0bc9d5bb7 000003627a8300f00d803831db6ebc9eb4f8484d 000004cf479cd29960a2bad5f918887f182cf181 000007c945a23a1a37cec78fba15499f35fed3c4 0000093625f90e660c8275040a7f57e335ae147b view top 100 |
Trip End Timestamp | trip_end_timestamp | calendar_date | When the trip ended, rounded to the nearest 15 minutes. | 2018-12-07T19:30:00.000 2018-12-07T19:15:00.000 2018-12-14T19:30:00.000 2018-12-07T19:00:00.000 2018-12-07T19:45:00.000 view top 100 |
Trip Seconds | trip_seconds | number | Time of the trip in seconds. | 900 1020 600 660 540 view top 100 |
Trip Miles | trip_miles | number | Distance of the trip in miles. | 0 1.04337922384 1.27268651008 1.29070794992 1.29630081056 view top 100 |
Pickup Census Tract | pickup_census_tract | text | The Census Tract where the trip began.This column often will be blank for locations outside Chicago. | 17031839100 17031980000 17031320100 17031081700 17031833000 view top 100 |
Dropoff Census Tract | dropoff_census_tract | text | The Census Tract where the trip ended. This column often will be blank for locations outside Chicago. | 17031839100 17031980000 17031320100 17031081700 17031833000 view top 100 |
Pickup Community Area | pickup_community_area | number | The Community Area where the trip began. This column will be blank for locations outside Chicago. | 8 32 28 6 24 view top 100 |
Dropoff Community Area | dropoff_community_area | number | The Community Area where the trip ended. This column will be blank for locations outside Chicago. | 8 32 28 6 24 view top 100 |
Fare | fare | number | The fare for the trip, rounded to the nearest $2.50. | 5 7.5 10 12.5 2.5 view top 100 |
Tip | tip | number | The tip for the trip, rounded to the nearest $1.00. Cash tips will not be recorded. | 0 2 1 5 3 view top 100 |
Additional Charges | additional_charges | number | The taxes, fees, and any other charges for the trip. | 2.5 0 7.5 2.8 0.67 view top 100 |
Trip Total | trip_total | number | Total cost of the trip. This is calculated as the total of the previous columns, including rounding. | 7.5 10 12.5 5 15 view top 100 |
Shared Trip Authorized | shared_trip_authorized | checkbox | Whether the customer agreed to a shared trip with another customer, regardless of whether the customer was actually matched for a shared trip. | false true view top 100 |
Trips Pooled | trips_pooled | number | If 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. | 1 2 3 4 5 view top 100 |
Pickup Centroid Latitude | pickup_centroid_latitude | number | The 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. | 41.8809944707 41.9790708201 41.8849871918 41.8920421365 41.8852813201 view top 100 |
Pickup Centroid Longitude | pickup_centroid_longitude | number | The 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. | -87.6327464887 -87.9030396611 -87.6209929134 -87.6318639497 -87.6572331997 view top 100 |
Pickup Centroid Location | pickup_centroid_location | point | The 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. | {"coordinates":[-87.6327464887,41.8809944707],"type":"Point"} {"coordinates":[-87.9030396611,41.9790708201],"type":"Point"} {"coordinates":[-87.6209929134,41.8849871918],"type":"Point"} {"coordinates":[-87.6318639497,41.8920421365],"type":"Point"} {"coordinates":[-87.6572331997,41.8852813201],"type":"Point"} view top 100 |
Dropoff Centroid Latitude | dropoff_centroid_latitude | number | The 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. | 41.8809944707 41.9790708201 41.8849871918 41.8920421365 41.8852813201 view top 100 |
Dropoff Centroid Longitude | dropoff_centroid_longitude | number | The 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. | -87.6327464887 -87.9030396611 -87.6209929134 -87.6318639497 -87.6572331997 view top 100 |
Dropoff Centroid Location | dropoff_centroid_location | point | The 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. | {"coordinates":[-87.6327464887,41.8809944707],"type":"Point"} {"coordinates":[-87.9030396611,41.9790708201],"type":"Point"} {"coordinates":[-87.6209929134,41.8849871918],"type":"Point"} {"coordinates":[-87.6318639497,41.8920421365],"type":"Point"} {"coordinates":[-87.6572331997,41.8852813201],"type":"Point"} view top 100 |