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. | 0000030e3e346f002ebedf728a698aa3d1400634 00000348d995006cc36dfc83c16127d6befc9ea9 0000034a5d7cf96785051ee9075e5d20c08e5330 0000037af0ce46e0d103d64fbaabf9e0409859a9 000003cfe9910e969e3e1eb706522ecfa43f67c8 view top 100 |
Trip Start Timestamp | trip_start_timestamp | calendar_date | When the trip started, rounded to the nearest 15 minutes. | 2020-01-01T02:00:00.000 2020-01-01T02:15:00.000 2020-01-01T01:45:00.000 2020-01-01T01:15:00.000 2020-01-01T01:30:00.000 view top 100 |
Trip End Timestamp | trip_end_timestamp | calendar_date | When the trip ended, rounded to the nearest 15 minutes. | 2020-01-01T02:15:00.000 2020-01-01T02:00:00.000 2020-01-01T01:45:00.000 2020-01-01T01:30:00.000 2020-02-14T20:00:00.000 view top 100 |
Trip Seconds | trip_seconds | number | Time of the trip in seconds. | 900 873 865 877 869 view top 100 |
Trip Miles | trip_miles | number | Distance of the trip in miles. | 1.5 1.18 1.28 1.39 1.07 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 17031833000 17031081700 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 17031833000 17031081700 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 28 32 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 28 32 6 24 view top 100 |
Fare | fare | number | The fare for the trip, rounded to the nearest $2.50. | 7.5 5 10 12.5 15 view top 100 |
Tip | tip | number | The tip for the trip, rounded to the nearest $1.00. Cash tips will not be recorded. | 0 3 1 2 5 view top 100 |
Additional Charges | additional_charges | number | The taxes, fees, and any other charges for the trip. | 3.08 4.83 3.1 1.23 0 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. | 8.08 10.58 13.08 15.58 9.83 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.899602111 41.9442266014 41.874005383 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.6333080367 -87.6559981815 -87.6635175498 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.6333080367,41.899602111],"type":"Point"} {"coordinates":[-87.6559981815,41.9442266014],"type":"Point"} {"coordinates":[-87.6635175498,41.874005383],"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.899602111 41.874005383 41.9442266014 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.6333080367 -87.6635175498 -87.6559981815 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.6333080367,41.899602111],"type":"Point"} {"coordinates":[-87.6635175498,41.874005383],"type":"Point"} {"coordinates":[-87.6559981815,41.9442266014],"type":"Point"} view top 100 |