2024 Yellow Taxi Trip Data
These records are generated from the trip record submissions made by yellow taxi Technology Service Providers (TSPs). Each row represents a single trip in a yellow taxi. The trip records include fields capturing pick-up and drop-off dates/times, pick-up and drop-off taxi zone locations, trip distances, itemized fares, rate types, payment types, and driver-reported passenger counts.
Open in the graph · Relate this dataset · What these columns mean
Freshness
The publisher's promise
How the agency that publishes this data says it keeps the data current.
DormantNo automatic refresh
- Automatic refresh
No scheduled refresh runs for this dataset, and a refresh you ask for on this page is refused.
- This dataset needs a copy method that the automatic queue does not run, such as a bulk export of a very large table. This fence refuses a refresh you ask for on this page.
- This dataset is large enough that an operator must review it before the automatic queue copies it, and that review has not happened yet. This fence does not stop a refresh you ask for on this page.
- Says it updates
- Historical data
- Actually updates about every
- —
- Publisher last updated the data
- Aug 21, 2026
Our mirror
Whether our copy of this data is current with the source.
Not mirrored
- We last synced
- —
- Rows in our copy
- —
- Rows at the source
- —
- Our copy trails the source by
- —
Columns
Each source column, with the name and type we use to store it.
0 of 19 columns carry a concept; 19 carry a description from the publisher. Read the concept column before you join. A column with no concept carries no claim from us, and a name that looks like a key is not one.
| Source field | Display name | What the publisher says it is | Concept | Source type | Stored as | Stored type | Row identifier | Unit |
|---|---|---|---|---|---|---|---|---|
vendorid | VendorID | A code indicating the TPEP provider that provided the record. | Not bound | Number | vendorid | numeric | — | |
tpep_pickup_datetime | tpep_pickup_datetime | The date and time when the meter was engaged. | Not bound | Calendar date | tpep_pickup_datetime | timestamp | — | |
tpep_dropoff_datetime | tpep_dropoff_datetime | The date and time when the meter was disengaged. | Not bound | Calendar date | tpep_dropoff_datetime | timestamp | — | |
passenger_count | passenger_count | The number of passengers in the vehicle. | Not bound | Number | passenger_count | numeric | — | |
trip_distance | trip_distance | The elapsed trip distance in miles reported by the taximeter. | Not bound | Number | trip_distance | numeric | — | |
ratecodeid | RatecodeID | The final rate code in effect at the end of the trip. | Not bound | Number | ratecodeid | numeric | — | |
store_and_fwd_flag | store_and_fwd_flag | This flag indicates whether the trip record was held in vehicle memory before sending to the vendor, aka “store and forward,” because the vehicle did not have a connection to the server. | Not bound | Text | store_and_fwd_flag | text | — | |
pulocationid | PULocationID | TLC Taxi Zone in which the taximeter was engaged | Not bound | Number | pulocationid | numeric | — | |
dolocationid | DOLocationID | TLC Taxi Zone in which the taximeter was disengaged | Not bound | Number | dolocationid | numeric | — | |
payment_type | payment_type | A numeric code signifying how the passenger paid for the trip. | Not bound | Number | payment_type | numeric | — | |
fare_amount | fare_amount | The time-and-distance fare calculated by the meter. For additional information on the following columns, see https://www.nyc.gov/site/tlc/passengers/taxi-fare.page | Not bound | Number | fare_amount | numeric | — | |
extra | extra | Miscellaneous extras and surcharges. | Not bound | Number | extra | numeric | — | |
mta_tax | mta_tax | Tax that is automatically triggered based on the metered rate in use. | Not bound | Number | mta_tax | numeric | — | |
tip_amount | tip_amount | Tip amount – This field is automatically populated for credit card tips. Cash tips are not included. | Not bound | Number | tip_amount | numeric | — | |
tolls_amount | tolls_amount | Total amount of all tolls paid in trip. | Not bound | Number | tolls_amount | numeric | — | |
improvement_surcharge | improvement_surcharge | Improvement surcharge assessed trips at the flag drop. The improvement surcharge began being levied in 2015. | Not bound | Number | improvement_surcharge | numeric | — | |
total_amount | total_amount | The total amount charged to passengers. Does not include cash tips. | Not bound | Number | total_amount | numeric | — | |
congestion_surcharge | congestion_surcharge | Total amount collected in trip for NYS congestion surcharge. | Not bound | Number | congestion_surcharge | numeric | — | |
airport_fee | airport_fee | For pick up only at LaGuardia and John F. Kennedy Airports. | Not bound | Number | airport_fee | numeric | — |
Download
A full Parquet copy of this dataset has not been produced yet. The CSV sample is available now, and the rows API returns the whole mirror.
Use the API
These are the exact calls for this dataset, against the host you are reading this on. Each one answers JSON, needs no key, and is rate-limited.
Canonical metadata, both freshness axes, columns, attribution, lineage.
curl https://citytap-web-citytap-prod.codenow.nyc/api/datasets/rwwi-khbcRanked, dimension-tag-confirmed relatives of one dataset.
curl https://citytap-web-citytap-prod.codenow.nyc/api/datasets/rwwi-khbc/partnersUp to 50 distinct sample values of one named column. Not a raw-rows dump.
curl 'https://citytap-web-citytap-prod.codenow.nyc/api/rows/rwwi-khbc?column=vendorid'A CSV sample of up to 1,000 rows, honest about being a sample.
curl https://citytap-web-citytap-prod.codenow.nyc/api/export/rwwi-khbc/csvRefresh on request
No scheduled refresh runs for this dataset, and a refresh you ask for on this page is refused. See why under Freshness
Source and attribution
Where this data comes from, which version we hold, and what we changed.
- Source
- https://data.cityofnewyork.us/d/rwwi-khbc
- Version
- Snapshot taken:
Aug 21, 2026, 4:39 PM - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- —
Update history
We have not recorded an update run for this dataset yet.