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. | 0000000fb973b32717a335d3b7dd66deca2c5624 00000021fd0092ff8d40499d199da3e323cfe51d 0000006fab8e5c1bba86d7a2cc4d7082ee4fe7e7 0000007fec14e52e670b3c4a845eabb81e3fef9a 0000013c644048b90360ec13aaf068c990ee2997 view top 100 |
Trip Start Timestamp | trip_start_timestamp | calendar_date | When the trip started, rounded to the nearest 15 minutes. | 2019-12-31T21:00:00.000 2019-12-31T21:15:00.000 2019-12-31T20:45:00.000 2019-12-31T21:30:00.000 2019-12-31T20:00:00.000 view top 100 |
Trip End Timestamp | trip_end_timestamp | calendar_date | When the trip ended, rounded to the nearest 15 minutes. | 2019-06-06T00:00:00.000 2019-12-31T21:30:00.000 2019-12-31T21:15:00.000 2019-12-31T20:00:00.000 2019-12-31T21:45:00.000 view top 100 |
Trip Seconds | trip_seconds | number | Time of the trip in seconds. | 900 1020 660 600 540 view top 100 |
Trip Miles | trip_miles | number | Distance of the trip in miles. | 0 1.18 1.28 1.07 1.24 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. | 0000000fb973b32717a335d3b7dd66deca2c5624 00000021fd0092ff8d40499d199da3e323cfe51d 0000006fab8e5c1bba86d7a2cc4d7082ee4fe7e7 0000007fec14e52e670b3c4a845eabb81e3fef9a 0000013c644048b90360ec13aaf068c990ee2997 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 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 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 2 1 3 5 view top 100 |
Additional Charges | additional_charges | number | The taxes, fees, and any other charges for the trip. | 2.55 0 7.55 2.85 0.72 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.55 10.05 12.55 15.05 5.05 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. | 0000000fb973b32717a335d3b7dd66deca2c5624 00000021fd0092ff8d40499d199da3e323cfe51d 0000006fab8e5c1bba86d7a2cc4d7082ee4fe7e7 0000007fec14e52e670b3c4a845eabb81e3fef9a 0000013c644048b90360ec13aaf068c990ee2997 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.8852813201 41.8920421365 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.6572331997 -87.6318639497 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.6572331997,41.8852813201],"type":"Point"} {"coordinates":[-87.6318639497,41.8920421365],"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.8852813201 41.8920421365 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.6572331997 -87.6318639497 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.6572331997,41.8852813201],"type":"Point"} {"coordinates":[-87.6318639497,41.8920421365],"type":"Point"} view top 100 |