<b>This dataset ends with 2023. Please see the Featured Content link below for the dataset that starts in 2024.</b> Taxi trips from 2013 to 2023 reported to the City of Chicago in its role as a regulatory agency. To protect privacy but allow for aggregate analyses, the Taxi ID is consistent for any given taxi medallion number but does not show the number, Census Tracts are suppressed in some cases, and times are rounded to the nearest 15 minutes. Due to the data reporting process, not all trips are reported but the City believes that most are.
This dataset has the following 23 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Trip ID | trip_id | text | A unique identifier for the trip. | 00000019ef3c0b419a9e6b1843b83530b79627a4 00000023035db9c57ce41840d9b350ada2041145 0000003dfd0ab4ef5555e2ad299a2ba602b1dfa3 0000006062f55c7d703cbb90d2eee416a5a76db2 000000667ce8625dbec259647ff0bd26c40d45ee view top 100 |
Taxi ID | taxi_id | text | A unique identifier for the taxi. | b4ac2893286a7c3a55df851a3732ea65d7fb82e1da7a19f728a71651761babfd88544152301073319650be263fd4e1aabc072601e6f452daf22ceb764f8d70d5 f68eb3233f3e33e98e337a0442bfe5eb660e6f58de5df0bf5950f92efae803e34c430d71038e2d6a0d2472595c305e4f54be0c42f946d3971af121f08734ac08 f19677875bae72f431e9e35abbf3fd29aedd79e11f2f04812f96ae4f7cc4cd260e4902a8d3a03ffff9c4ecbb3db67e51070e5097c1125c0c6c67d42a743b4b35 4f4cae403660ec4c1e2e3b03128bd7a5af139619e3e513246c1a45c19a9d2a04bf8831972ebde690feedb335deba34acfba89ebada6a6101b1c1e32e58ba8e7a 74b9b3ba2f90ab6dfe7352dc2cac4dfebb2fffa053bafe09f7a8068ee65170acb964079c0d87065050ecd7b69d97c3b83c71f76ce9e54d539854ef0a9f4519b0 view top 100 |
Trip Start Timestamp | trip_start_timestamp | calendar_date | When the trip started, rounded to the nearest 15 minutes. | 2014-11-02T01:15:00.000 2014-11-06T19:00:00.000 2015-11-01T01:30:00.000 2015-11-01T01:45:00.000 2014-11-02T01:45:00.000 view top 100 |
Trip End Timestamp | trip_end_timestamp | calendar_date | When the trip ended, rounded to the nearest 15 minutes. | 2014-11-02T01:15:00.000 2014-11-06T19:00:00.000 2014-11-02T01:30:00.000 2015-11-01T01:30:00.000 2014-11-02T01:45:00.000 view top 100 |
Trip Seconds | trip_seconds | number | Time of the trip in seconds. | 0 360 420 300 480 view top 100 |
Trip Miles | trip_miles | number | Distance of the trip in miles. | 0 1 0.8 0.9 1.1 view top 100 |
Pickup Census Tract | pickup_census_tract | text | The Census Tract where the trip began. For privacy, this Census Tract is not shown for some trips. This column often will be blank for locations outside Chicago. | 17031839100 17031320100 17031980000 17031081500 17031081700 view top 100 |
Dropoff Census Tract | dropoff_census_tract | text | The Census Tract where the trip ended. For privacy, this Census Tract is not shown for some trips. This column often will be blank for locations outside Chicago. | 17031839100 17031320100 17031081500 17031081700 17031281900 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 76 6 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 7 view top 100 |
Fare | fare | number | The fare for the trip. | 3.25 6.25 5.25 7.25 8.25 view top 100 |
Tips | tips | number | The tip for the trip. Cash tips generally will not be recorded. | 0 2 3 1 4 view top 100 |
Tolls | tolls | number | The tolls for the trip. | 0.00 1.5 2 1.9 3 view top 100 |
Extras | extras | number | Extra charges for the trip. | 0.00 1 2.00 1.5 4 view top 100 |
Trip Total | trip_total | number | Total cost of the trip, the total of the previous columns. | 3.25 7.25 8.25 6.25 9.25 view top 100 |
Payment Type | payment_type | text | Type of payment for the trip. | Cash Credit Card Mobile Prcard Unknown view top 100 |
Company | company | text | The taxi company. | Taxi Affiliation Services Flash Cab Dispatch Taxi Affiliation Blue Ribbon Taxi Association Inc. Yellow Cab 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.880994471 41.884987192 41.97907082 41.899602111 41.892507781 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.632746489 -87.620992913 -87.903039661 -87.633308037 -87.626214906 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.6209929134,41.8849871918],"type":"Point"} {"coordinates":[-87.9030396611,41.9790708201],"type":"Point"} {"coordinates":[-87.6333080367,41.899602111],"type":"Point"} {"coordinates":[-87.6262149064,41.8925077809],"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.880994471 41.884987192 41.892507781 41.892042136 41.899602111 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.632746489 -87.620992913 -87.626214906 -87.63186395 -87.633308037 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.6209929134,41.8849871918],"type":"Point"} {"coordinates":[-87.6262149064,41.8925077809],"type":"Point"} {"coordinates":[-87.6318639497,41.8920421365],"type":"Point"} {"coordinates":[-87.6333080367,41.899602111],"type":"Point"} view top 100 |