2022 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. A refresh you ask for on this page runs anyway.
This dataset is large enough that an operator must review it before the automatic queue copies it, and that review has not happened yet.
- Says it updates
- Historical data
- Actually updates about every
- —
- Publisher last updated the data
- Oct 18, 2023
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 |
|---|---|---|---|---|---|---|---|---|
mta_tax | mta_tax | Tax that is automatically triggered based on the metered rate in use. | Not bound | Number | mta_tax | numeric | — | |
ratecodeid | RatecodeID | The final rate code in effect at the end of the trip. | Not bound | Number | ratecodeid | numeric | — | |
vendorid | VendorID | A code indicating the TPEP provider that provided the record. | Not bound | Number | vendorid | numeric | — | |
payment_type | payment_type | A numeric code signifying how the passenger paid for the trip. | Not bound | Number | payment_type | numeric | — | |
dolocationid | DOLocationID | TLC Taxi Zone in which the taximeter was disengaged | Not bound | Number | dolocationid | 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 |
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.
Refresh this dataset
Source and attribution
Where this data comes from, which version we hold, and what we changed.
- Source
- https://data.cityofnewyork.us/d/qp3b-zxtp
- Version
- Snapshot taken:
Oct 18, 2023, 4:16 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.