Chicago Taxi Trips

$0 / year

This dataset contains the taxi trips 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.

Categories: ,
Complexity

Chicago residents and visitors took more than 27 million taxi rides in 2015, traveling 83 million miles and spending more than $400 million.

The City of Chicago assures the quality and safety of those rides through its Department of Business Affairs & Consumer Protection (BACP). We have long published the taxi drivers and vehicles licensed by BACP on the Chicago Data Portal.

Taxi trips are not reported in real time. Each trip appears long after the completion of the ride. Therefore, the dataset cannot be used to track trips in motion or even just-completed trips. By the nature of how the data are collected, reported, and processed, a minimum of a few days will pass between completion of a ride and its appearance in the dataset. More typically, the delay will be anywhere from a week to a month.

Each row in the dataset describes a distinct taxi trip and shows:

– Which taxi provided the trip
– What times the trip started and ended
– Length of the trip in both time and distance
– Starting and ending Community Area — plus Census Tract for many trips
– Fare amount and other components of the trip cost
– Type of payment — such as cash or credit card. (As an important note, cash tips are not included in the data because they do not go through the payment systems.)
Taxi company.

Although taxi rides take place on the public streets and can be freely observed, the start that there could be privacy issues in publishing them. Implemented a number of measures to preserve privacy while not unduly hampering use of the data. These measures include the following.

Delay:
Taxi trips are not reported in real time. Each trip appears long after the completion of the ride. Therefore, the dataset cannot be used to track trips in motion or even just-completed trips. By the nature of how the data are collected, reported, and processed, a minimum of a few days will pass between completion of a ride and its appearance in the dataset. More typically, the delay will be anywhere from a week to a month.

Masking of Taxi Medallion Number:
Each licensed Chicago taxi has a license number, indicated by the Illinois license plate number, a painted number on the body of the taxi, and the medallion on the taxi’s hood. The Taxi ID in this dataset is not that license number. It is created specifically for this dataset, with no external meaning, to allow users to determine rides provided by the same taxi but not which taxi.

Masking of Time:
Analysis of taxi trips by time will be a major use of this dataset and significant value will be added for understanding the taxi industry and travel in Chicago. However, there is minimal value and some potential privacy cost in making it possible to find a specific trip that someone knows departed at 10:13 am. To balance these issues, all start and end times to the nearest 15 minutes has been rounded.

Masking of Location:
From where and to where people travel is, of course, the most basic information about taxi trips and expected to be the topic of much analysis. However, as with exact time, exact location down to the street address could affect privacy. Therefore, location is only provided at the Census Tract and Community Area levels.

Since some Census Tracts have relatively infrequent taxi trips, we show the Census Tracts of a trip only if both the starting and ending Census Tracts had at least three trips in the relevant 15-minute time period. Because of this rule, about 1/4 of Census Tracts that would otherwise be shown are blank. (Others are blank because of missing data or falling outside Chicago.)

Date Created

2016-05-28

Last Modified

2019-04-17

Version

2019-04-17

Update Frequency

Quarterly

Temporal Coverage

2013-2019

Spatial Coverage

Chicago

Source

John Snow Labs; Data City of Chicago;

Source License URL

Source License Requirements

N/A

Source Citation

N/A

Keywords

Chicago Taxi Data, Taxi Rides, Chicago Taxi Rides, Taxi Trips, Taxi Industry, Taxi Trips Time, Taxi Pick Up Location, Taxi Drop Off Location, Taxi Census Tract

Other Titles

Taxi Industry and Travel in Chicago, Chicago Transport Authority

NameDescriptionTypeConstraints
Trip_IDA unique identifier for the trip.string-
Taxi_IDA unique identifier for the taxi.string-
Trip_Start_TimestampWhen the trip started, rounded to the nearest 15 minutes.datetime-
Trip_End_TimestampWhen the trip ended, rounded to the nearest 15 minutes.datetime-
Trip_SecondsTime of the trip in seconds.integerlevel : Ratio
Trip_MilesDistance of the trip in miles.numberlevel : Ratio
Pickup_Census_TractThe Census Tract where the trip began. For privacy, this Census Tract is not shown for some trips.integerlevel : Nominal
Dropoff_Census_TractThe Census Tract where the trip ended. For privacy, this Census Tract is not shown for some trips.integerlevel : Nominal
Pickup_Community_AreaThe Community Area where the trip began.integerlevel : Nominal
Dropoff_Community_AreaThe Community Area where the trip ended.integerlevel : Nominal
FareThe fare for the trip.number-
TipsThe tip for the trip. Cash tips generally will not be recorded.number-
TollsThe tolls for the trip.number-
ExtrasExtra charges for the trip.number-
Trip_TotalTotal cost of the trip, the total of the previous columns.number-
Payment_TypeType of payment for the trip.string-
CompanyThe taxi company.string-
Pickup_Centroid_LatitudeThe latitude of the center of the pickup census tract or the community area if the census tract has been hidden for privacy.number-
Pickup_Centroid_LongitudeThe longitude of the center of the pickup census tract or the community area if the census tract has been hidden for privacy.number-
Dropoff_Centroid_LatitudeThe latitude of the center of the dropoff census tract or the community area if the census tract has been hidden for privacy.number-
Dropoff_Centroid_LongitudeThe longitude of the center of the dropoff census tract or the community area if the census tract has been hidden for privacy.number-
Community_AreaIndicates the community area where the trip was requested. Chicago has 77 community areas.integerlevel : Nominal
Trip IDTaxi IDTrip Start TimestampTrip End TimestampTrip SecondsTrip MilesPickup Census TractDropoff Census TractPickup Community AreaDropoff Community AreaFareTipsTollsExtrasTrip TotalPayment TypeCompanyPickup Centroid LatitudePickup Centroid LongitudeDropoff Centroid LatitudeDropoff Centroid Longitude
8f25e5f1fcf8bbe0b694bbf4ede77bc54ba50ced63d6f8cde6f0de8a4cf504adc40f8c49c00358506766a65dba0031887a7a464eccfcc1083c3dde417f97abbc0de38eb0d4b4f2081d83de1301fc1ac0e5f4d43c2015-07-20T17:45:002015-07-20T18:15:0013412.712.650.00.012.65CashYellow Cab
0d7fb79fc0a91e7ce05dd46662f320e54b97c5c0db1bbe74c221d0f9c83d06bf9a0d9108852dbbaf069df72eb67db53f35212f33be4a73f9876e19f415605906dfc53f8508750d2f65eaf1863e6a52e818f69ce12015-07-19T13:45:002015-07-19T13:45:0020.03.250.00.03.25CashYellow Cab
7d58512a47eecde9e3a08df3694f639c6ff42573e529c81d35e4b4aa30c42a0af1475fc909bab69a707c4f88ef70d2b63717946c33958ed98ae0448ab969e17e9a13ec6fa94959a73cfe51f844c724c2acd1999a2015-07-18T11:15:002015-07-18T11:30:004681.824.07.050.01.08.05CashYellow Cab41.90120699-87.67635599
4e4d6bfe9d30308bcc100f3511fdeb4aeea75b7f6d39a85a7e4d9322d57fb1f9cf20a50cfc352d9e8b528e4f14d2140dfef824e8eb488041f9fea77b61316ddc296631d5626a585df27e93687aab36be525c8ad22015-07-19T01:30:002015-07-19T01:45:0010387.719.018.050.02.020.05CashYellow Cab41.92726096-87.76550161
a43fc03f8b77154d3aca1d5afd5c04f0a62583d1d2361c444230b38876a74c70d71b055ad4d69b2e35954dc89b1a28e0e43fbf85c545ed901036c4129f8c7938c2b0adb2a0b24d87170a00bc366e918ae2bf0fe72015-07-20T04:15:002015-07-20T04:45:00176328.676.055.058.934.568.48Credit CardYellow Cab41.98026432-87.91362459999999
ccb362a6a21c6a0c0eabac730ede0e09acfa278be8f673c7d74913eef9b2c58975502e30884a6d7c93a80264c9ef1ee7a3a44652b66f8f74348e5f7b62dc458b19ef474b8c0801463178f03b03bd08f768c42c4e2015-07-09T21:15:002015-07-09T21:30:005812.18.253.00.011.25Credit CardYellow Cab
0e1a100e64f37503c8a35861315b090c48659582e8f673c7d74913eef9b2c58975502e30884a6d7c93a80264c9ef1ee7a3a44652b66f8f74348e5f7b62dc458b19ef474b8c0801463178f03b03bd08f768c42c4e2015-07-17T19:45:002015-07-17T20:15:00163612.427.454.573.035.02Credit CardYellow Cab
7e1c4d6a1ae4c7011de05e126571ca27315f9b36db1bbe74c221d0f9c83d06bf9a0d9108852dbbaf069df72eb67db53f35212f33be4a73f9876e19f415605906dfc53f8508750d2f65eaf1863e6a52e818f69ce12015-07-17T07:45:002015-07-17T08:15:00198413.429.454.722.036.17Credit CardYellow Cab
3d6ae32df7fdc3bcaeaeb69a41ae1cc9fa9a50f8db1bbe74c221d0f9c83d06bf9a0d9108852dbbaf069df72eb67db53f35212f33be4a73f9876e19f415605906dfc53f8508750d2f65eaf1863e6a52e818f69ce12015-07-18T22:00:002015-07-18T22:00:003501.36.052.01.09.05Credit CardYellow Cab
d9ae550a9b05edb34b2e85ee739ee2c063f09248db1bbe74c221d0f9c83d06bf9a0d9108852dbbaf069df72eb67db53f35212f33be4a73f9876e19f415605906dfc53f8508750d2f65eaf1863e6a52e818f69ce12015-07-17T14:00:002015-07-17T15:00:00357617.540.458.693.052.14Credit CardYellow Cab
Related Data Packages