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

2020-05-07

Version

2020-05-07

Update Frequency

Quarterly

Temporal Coverage

2013-2020

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-
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
36ed00176217c2d58cd7989e72bc09a75afa067a86b44661584b9869c822d267a43f47b84ccaf76bfc402afea0028990b0e8329b4d79763b0d148412f5eafaf59bd8aa4c2c73f501efac831794acdf90cefe0a0f2015-07-04T22:00:002015-07-04T22:15:004200.017031080300.017031081700.0886.45101.08.45Credit CardTaxi Affiliation Services41.90749193-87.6357600941.89204214-87.63186395
7f9c6f34467f6a6def506998db6c91601e6174bc2ae0d74cb64197804de4a7e450c016d967dbeb37d3e0f2e6be2500a402a97f568224946ec1542deef2c66e1b013ecca44325342e9ecd93dcf5b5747c721cbf182015-06-25T11:30:002015-06-25T11:45:006001.617031833100.017031081700.02887.85100.08.85Credit CardTaxi Affiliation Services41.87906699-87.6570050341.89204214-87.63186395
32fbc01556c16015d5c3bb6090f8da6dc834bdf850be6cf4ab75fdcee27fbd06555e0058f9d5a6269f6515f7754c289bcdd21a46504e236b97e51065cea42040e8d100ec5a60b7520a36fd8860b8bcc86c2396482015-09-19T11:30:002015-09-19T11:45:006001.317031320400.017031330100.032337.45201.010.45Credit CardTaxi Affiliation Services41.87740612-87.6219716541.85934972-87.61735801
b2b8b69ab230ade9440f0f59433e3cba572f338fc38a211cb84a44a24e959493d5842a48dd150b1e947b30656a4507d235418d33b3390cd664a32a0199c9611b87914f8a1d1e53756983b725ace2e8df20e490a02015-07-05T00:00:002015-07-05T00:15:004800.117031062000.017031071200.0677.25000.07.25CashTaxi Affiliation Services41.94257719-87.6470785141.92185491-87.64621098
53df255a8c1ff7e4b3501b815dd0ce3980275097278332b67974a1fcbc5fa4c37343844df45520be57eb69d8fafdad010c31c25fa1b7fb3ea22b533e0c3dc7b6e90633116952a68aa394aced6aaa6b66a768ef142015-07-05T04:00:002015-07-05T04:00:006001.517031081800.017031081100.0887.65001.59.15CashTaxi Affiliation Services41.89321636-87.6378442141.9002213-87.62910519
0740df861bb6e5b8898a26f7eff6b081c0f098462f4a8c0bf7ab4ebc25137b8a73a4d3541fe9652f9bffe62c0c45cf6cba360772fdd54536737f90c307562776aa6c35eedf4dd09ebb4506ae7a6e932a56214a3d2015-09-20T00:00:002015-09-20T00:15:005401.417031081700.017031080300.0887.05001.08.05CashTaxi Affiliation Services41.89204214-87.6318639541.90749193-87.63576009
94065e2a80e1d3218b404ceef1f7b2ab2c2248d83d9dd89a8834ee77185d4498336e2ec0bdc68a4db05cb0f0bb8bfeec249fee601267a0eceecce001811e964c04aa16bf81669e0d6191c5cebca2d3edd79f99432015-09-20T00:00:002015-09-20T00:15:004200.017031839100.017031833100.032286.65002.08.65CashTaxi Affiliation Services41.88099447-87.6327464941.87906699-87.65700503
5e0c23e39fc0d4941b92c4af0d968fff2d49f37d5bcc0f5ee02c3b51f171f746ab645c73aae12e910b3a06e10c0ab9d0da3064d4fa77d8f0425f608b8106dbc385f8f321454617acdac35da0d906a3f0e3c8a3e32015-09-20T05:45:002015-09-20T05:45:001800.2884.25000.04.25CashDispatch Taxi Affiliation41.89960211-87.6333080441.89960211-87.63330804
5cf247755bada1ecdbec9a6ecfd82747400fb5027c099e06fc83409ec83a80b7817164db2067166f949ceb0538b4fe60b9d1b152138be185ab14b0286e968508819e88962ae6cda923f409b754bfcd75bc3861842015-06-26T18:30:002015-06-26T18:45:0010802.617031063000.017031830700.06310.45000.010.45CashTaxi Affiliation Services41.93631013-87.6515625941.95805593-87.66038946
aa5dfd1adf40e3c12c389e459255e2f976d7fc4700aeef49089b36ed668920fac1119a26fb25d1b48102a4dc6bf45f047cefc5c1e87a28305bd2da49582cda238fbb08da8babca9683b416ead9e43e8bf958ce542015-07-04T22:00:002015-07-04T22:30:0012000.217031281900.017031070102.028713.85002.015.85CashTaxi Affiliation Services41.87925508-87.64264941.93057857-87.64220631
Related Data Packages